NC_CB_Report_HDR_HIST_OLD (NCABR307)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR307

Display Name: NC_CB_Report_HDR_HIST
Physical Name: NCABR307
Technical Name: NC_CB_Report_HDR_HIST

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BANKID	Bank ID	STR15_Bank_ID	String	15
2	RECONUM	Reconcile Number	DLR_Document_Number	Currency	19
3	NC_Reconciled_Date	NC_Reconciled_Date	DATE	Date	6
4	BNKACTNM	Bank Account Number	STR15	String	15
5	NC_Sort_Code	NC Sort Code	STR20	String	20
6	TRNSTNBR	Transit Number	STR9	String	9
7	Statement_Ending_Balance	Statement Ending Balance	NC_Balance	Currency	15
8	Net_Ending_Balance	Net Ending Balance	NC_Balance	Currency	15
9	Overall_Book_Balance	Overall Book Balance	NC_Balance	Currency	15
10	CURRNIDX	Currency Index	INT3	Integer	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['NC_CB_Report_HDR_HIST'].CURRNIDX AS 'NC_CB_Report_HDR_HIST-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM NCABR307 AS ['NC_CB_Report_HDR_HIST'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['NC_CB_Report_HDR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
11	NC_GL_Balance	NC_GL_Balance	NC_Amount	Currency	15
12	NC_Previous_Closeing	NC_Previous_Closeing	NC_Amount	Currency	15