NC_CB_Report_LINE_HIST (NCABR308)

azurecurve Products Advanced Bank Reconciliation (2440)FinancialNC_CB_Report_LINE_HIST (NCABR308)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_CB_Report_LINE_HIST_8003zo
Physical Name: NCABR308
Technical Name: NC_CB_Report_LINE_HIST_8003zo

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	LNSEQNBR	Line SEQ Number	Sequence_Number	Currency	19
5	Date8	Date8	DATE_LONG	Date	8
6	REFRENCE	Reference	STR30	String	30
7	BL_Cheque_Number	BL_Cheque Number	STR20_Document_Number	String	20
8	NC_Amount	NC Amount	NC_Amount	Currency	15
9	Change_Flag	Change Flag	boolean	Boolean	0
10	Running_Total	Running Total	NC_Amount	Currency	15
11	CURRNIDX	Currency Index	INT3	Integer	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['NC_CB_Report_LINE_HIST_8003zo'].CURRNIDX AS 'NC_CB_Report_LINE_HIST_8003zo-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM NCABR308 AS ['NC_CB_Report_LINE_HIST_8003zo'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['NC_CB_Report_LINE_HIST_8003zo'].CURRNIDX = ['Currency Setup'].CURRNIDX
12	ACTINDX	Account Index	LI_14	Long Integer	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['NC_CB_Report_LINE_HIST_8003zo'].ACTINDX AS 'NC_CB_Report_LINE_HIST_8003zo-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM NCABR308 AS ['NC_CB_Report_LINE_HIST_8003zo'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['NC_CB_Report_LINE_HIST_8003zo'].ACTINDX = ['Account Index Master'].ACTINDX
13	ACTNUMBR_1	Account Number:Account_Segment_Pool1	Account_Segment_Pool1	String	6
14	ACTNUMBR_2	Account Number:Account_Segment_Pool2	Account_Segment_Pool2	String	6
15	ACTNUMBR_3	Account Number:Account_Segment_Pool3	Account_Segment_Pool3	String	6
16	ACTNUMBR_4	Account Number:Account_Segment_Pool4	Account_Segment_Pool4	String	6
17	ACTNUMBR_5	Account Number:Account_Segment_Pool5	Account_Segment_Pool5	String	6
18	ACTNUMBR_6	Account Number:Account_Segment_Pool6	Account_Segment_Pool6	String	6
19	ACTNUMBR_7	Account Number:Account_Segment_Pool7	Account_Segment_Pool7	String	6
20	ACTNUMBR_8	Account Number:Account_Segment_Pool8	Account_Segment_Pool8	String	6
21	ACTNUMBR_9	Account Number:Account_Segment_Pool9	Account_Segment_Pool9	String	6
22	ACTNUMBR_10	Account Number:Account_Segment_Pool10	Account_Segment_Pool10	String	6
23	NC_Credit	NC Credit	Boolean	Boolean	0
24	ORGNTSRC	Originating Source	STR15	String	15
25	ORGNATYP	Originating Type	INT	Integer	0
26	QKOFSET	Quick Offset	INT	Integer	0
27	SERIES	Series	DDL_Series	Integer	0
28	ORTRXTYP	Originating TRX Type	INT	Integer	0
29	ORCTRNUM	Originating Control Number	STR20	String	20
30	ORMSTRID	Originating Master ID	STR30	String	30
31	ORMSTRNM	Originating Master Name	STR64	String	64
32	ORDOCNUM	Originating Document Number	STR20	String	20
33	NC_Sequence_Number	NC_Sequence_Number	NC_Sequence_Number	Long Integer	10

azurecurve Products Advanced Bank Reconciliation (2440)FinancialNC_CB_Report_LINE_HIST (NCABR308)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply