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 TypeSQL DB LengthKeyable Length
1BANKID SearchBank IDSTR15_Bank_IDString1615
2depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
3NC_Sequence_Number SearchNC_Sequence_NumberNC_Sequence_NumberLong Integer410
4DepAmt SearchDeposit AmountDLR19_RBS0_STR$Currency1019
5Origiantdepamnt SearchNC_Originating_Deposit_AmountDLR19_RBSO_STR$Currency1019
6Originating_Deposit_Amou SearchOriginating Deposit AmountDLR19_RBSO_STR$Currency1019
7TRXDATE SearchTRX DateDT_DateDate46
8RECONFLG SearchReconcileFlagBooleanBoolean20
9NOTEINDX SearchNote IndexDLR14Currency1014
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_IDString1615
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 IndexINT3Integer23
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$Currency1019
13CHKCOUNT SearchCheck CountINT4_U0Integer24
14CRCRDAMT SearchCredit Card AmountDLR19_RBS0_UTR$Currency1019
15CCARDCNT SearchCredit Card CountINT4_U0Integer24
16CASHAMNT SearchCash AmountDLR19_RBS0_UTR$Currency1019
17CASHCOUNT SearchCash CountINT4_U0Integer24
18CnAmt SearchCoin AmountDLR19_RBS0_STR$Currency1019

Leave a Reply

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