NC_Closing_Balance_Summary_HIST (NCABR321)

azurecurveProductsAdvanced Bank Reconciliation (2440)FinancialNC_Closing_Balance_Summary_HIST (NCABR321)

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_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BANKID SearchBank IDSTR15_Bank_IDString1615
2RECONUM SearchReconcile NumberDLR_Document_NumberCurrency1019
3NC_Reconciled_Date SearchNC_Reconciled_DateDATEDate46
4NC_Balance_Date SearchNC Balance DateDTDate48
5NC_GL_Balance SearchNC_GL_BalanceNC_AmountCurrency1015
6NC_Statement_Ending_Bala SearchNC_Statement_Ending_BalanceNC_BalanceCurrency1015
7NC_Monthly_Start_Balance SearchNC_Monthly_Start_BalanceNC_AmountCurrency1015
8NC_GL_Checks SearchNC GL ChecksNC_BalanceCurrency1015
9NC_Start_Of_Month SearchNC_Start_Of_MonthDATEDate46
10NC_End_Of_Month SearchNC_End_Of_MonthDATEDate46
11NC_Month_Checks SearchNC_Month_ChecksNC_AmountCurrency1015
12NCMonthDeposits SearchNC_Month_DepositsNC_AmountCurrency1015
13NC_#_Of_Cheques SearchNC # Of ChequesINTInteger20
14NC_#_Of_Deposits SearchNC # Of DepositsINTInteger20
15NC_GL_Deposits SearchNC GL DepositsNC_BalanceCurrency1015
16NC_Bank_Deposits SearchNC Bank DepositsNC_BalanceCurrency1015
17NC_Bank_Checks SearchNC Bank ChecksNC_BalanceCurrency1015
18NC_#_of_Bank_Checks SearchNC # of Bank ChecksINT4Integer24
19NC_#_of_Bank_Deposits SearchNC # of Bank DepositsINT4Integer24
20NC_#_of_GL_Checks SearchNC # of GL ChecksINT4Integer24
21NC_#_of_GL_Deposits SearchNC # of GL DepositsINT4Integer24
22CURRNIDX SearchCurrency IndexINT3Integer23
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
azurecurveProductsAdvanced Bank Reconciliation (2440)FinancialNC_Closing_Balance_Summary_HIST (NCABR321)

Leave a Reply

Your email address will not be published. Required fields are marked *