Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR321
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Closing_Balance_Summary_HIST
Physical Name: NCABR321
Technical Name: NC_Closing_Balance_Summary_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 NC_Balance_Date NC Balance Date DT Date 8 5 NC_GL_Balance NC_GL_Balance NC_Amount Currency 15 6 NC_Statement_Ending_Bala NC_Statement_Ending_Balance NC_Balance Currency 15 7 NC_Monthly_Start_Balance NC_Monthly_Start_Balance NC_Amount Currency 15 8 NC_GL_Checks NC GL Checks NC_Balance Currency 15 9 NC_Start_Of_Month NC_Start_Of_Month DATE Date 6 10 NC_End_Of_Month NC_End_Of_Month DATE Date 6 11 NC_Month_Checks NC_Month_Checks NC_Amount Currency 15 12 NCMonthDeposits NC_Month_Deposits NC_Amount Currency 15 13 NC_#_Of_Cheques NC # Of Cheques INT Integer 0 14 NC_#_Of_Deposits NC # Of Deposits INT Integer 0 15 NC_GL_Deposits NC GL Deposits NC_Balance Currency 15 16 NC_Bank_Deposits NC Bank Deposits NC_Balance Currency 15 17 NC_Bank_Checks NC Bank Checks NC_Balance Currency 15 18 NC_#_of_Bank_Checks NC # of Bank Checks INT4 Integer 4 19 NC_#_of_Bank_Deposits NC # of Bank Deposits INT4 Integer 4 20 NC_#_of_GL_Checks NC # of GL Checks INT4 Integer 4 21 NC_#_of_GL_Deposits NC # of GL Deposits INT4 Integer 4 22 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Closing_Balance_Summary_HIST'].CURRNIDX AS 'NC_Closing_Balance_Summary_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR321 AS ['NC_Closing_Balance_Summary_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Closing_Balance_Summary_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX