NC_Deposit_HDR_750g (NCABR207)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_Deposit_HDR
Physical Name: NCABR207
Technical Name: NC_Deposit_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BANKID SearchBank IDSTR15_Bank_IDString15
2depositnumber SearchDeposit NumberSTR20_Document_NumberString20
3NC_Sequence_Number SearchNC_Sequence_NumberNC_Sequence_NumberLong Integer10
4DepAmt SearchDeposit AmountDLR19_RBS0_STR$Currency19
5Origiantdepamnt SearchNC_Originating_Deposit_AmountDLR19_RBSO_STR$Currency19
6Originating_Deposit_Amou SearchOriginating Deposit AmountDLR19_RBSO_STR$Currency19
7TRXDATE SearchTRX DateDT_DateDate6
8RECONFLG SearchReconcileFlagBooleanBoolean0
9NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['NC_Deposit_HDR'].NOTEINDX AS 'NC_Deposit_HDR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['NC_Deposit_HDR'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10CURNCYID SearchCurrency IDSTR15_Currency_IDString15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['NC_Deposit_HDR'].CURNCYID AS 'NC_Deposit_HDR-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['NC_Deposit_HDR'].CURNCYID = ['Currency Setup'].CURNCYID
11CURRNIDX SearchCurrency IndexINT3Integer3
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['NC_Deposit_HDR'].CURRNIDX AS 'NC_Deposit_HDR-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       NCABR207 AS ['NC_Deposit_HDR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['NC_Deposit_HDR'].CURRNIDX = ['Currency Setup'].CURRNIDX
12CHKSTOT SearchChecks TotalDLR19_RBSO_STR$Currency19
13CHKCOUNT SearchCheck CountINT4_U0Integer4
14CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency19
15CCARDCNT SearchCredit Card CountINT4_U0Integer4
16CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency19
17CASHCOUNT SearchCash CountINT4_U0Integer4
18CnAmt SearchCoin AmountDLR19_RBS0_STR$Currency19

Leave a Reply

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