Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR001
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Bank_Details_11003k
Physical Name: NCABR001
Technical Name: NC_Bank_Details_11003kSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BANKID 
Bank ID STR15_Bank_ID String 15 2 BNKACTNM Bank Account Number STR15 String 15 3 TRNSTNBR Transit Number STR9 String 9 4 NC_Sort_Code NC Sort Code STR20 String 20 5 BANKNAME Bank Name STR30 String 30 6 BANKNMBR Bank Number STR15 String 15 7 NC_Description NC_Description STR30 String 30 8 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Bank_Details_11003k'].CURNCYID AS 'NC_Bank_Details_11003k-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR001 AS ['NC_Bank_Details_11003k']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Bank_Details_11003k'].CURNCYID = ['Currency Setup'].CURNCYID9 NC_Account_Holder NC_Account_Holder STR30 String 30 10 ADDRESS1 Address 1 STR60 String 60 11 ADDRESS2 Address 2 STR60 String 60 12 CITY City STR35 String 35 13 STATE State STR30_State String 29 14 ZIPCODE Zip Code STR10 String 10 15 NC_Related_Checkbook_ID NC_Related_Checkbook_ID STR15_Checkbook_ID String 15 16 NC_Last_Statement_Number NC_Last_Statement_Number Long Int Long Integer 8 17 NC_Last_Statement_Date NC_Last_Statement_Date DATE Date 6 18 NC_Last_Statement_Balanc NC_Last_Statement_Balance NC_Balance Currency 15 19 NC_Last_Reconciled_Date NC_Last_Reconciled_Date DATE Date 6 20 NC_Last_Reconciled_Balan NC_Last_Reconciled_Balance NC_Balance Currency 15 21 NC_GL_Account_Index NC_GL_Account_Index LI_14 Long Integer 14 22 NC_Reconciled_Account_In NC_Reconciled_Account_Index LI_14 Long Integer 14 23 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Bank_Details_11003k'].NOTEINDX AS 'NC_Bank_Details_11003k-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR001 AS ['NC_Bank_Details_11003k']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Bank_Details_11003k'].NOTEINDX = ['Record Notes Master'].NOTEINDX24 NC_Statement_Currency_ID NC_Statement_Currency_ID STR15_Currency_ID String 15 25 NC_AutoExtractOptions NC Auto Extract Options INT1 Integer 1