Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR307
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_CB_Report_HDR_HIST
Physical Name: NCABR307
Technical Name: NC_CB_Report_HDR_HISTSeq 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'].CURRNIDX11 NC_GL_Balance NC_GL_Balance NC_Amount Currency 15 12 NC_Previous_Closeing NC_Previous_Closeing NC_Amount Currency 15