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_8003zoSeq 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'].CURRNIDX12 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'].ACTINDX13 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