NC_Bank_Details_OLD (NCABR001)

azurecurve Products Advanced Bank Reconciliation (2440)FinancialNC_Bank_Details_OLD (NCABR001)

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_11003k

Seq 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'].CURNCYID
9	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'].NOTEINDX
24	NC_Statement_Currency_ID	NC_Statement_Currency_ID	STR15_Currency_ID	String	15
25	NC_AutoExtractOptions	NC Auto Extract Options	INT1	Integer	1

azurecurve Products Advanced Bank Reconciliation (2440)FinancialNC_Bank_Details_OLD (NCABR001)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply