NC_Statement_Document_TEMP (NCABR035)

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

Product: Advanced Bank Reconciliation (2440)
Series: Financial

Display Name: NC_Statement_Document_TEMP
Physical Name: NCABR035
Technical Name: NC_Statement_Document_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['NC_Statement_Document_TEMP'].USERID AS 'NC_Statement_Document_TEMP-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['NC_Statement_Document_TEMP'].USERID = ['Users Master'].USERID
2SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
3MKDTOPST SearchMarked To PostCBBoolean20
4DOCTYPE SearchDocument TypeDDL_Document_TypeInteger20
5ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_Statement_Document_TEMP'].ACTINDX AS 'NC_Statement_Document_TEMP-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Statement_Document_TEMP'].ACTINDX = ['Account Index Master'].ACTINDX
6CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['NC_Statement_Document_TEMP'].CUSTNMBR AS 'NC_Statement_Document_TEMP-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['NC_Statement_Document_TEMP'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
7VENDORID SearchVendor IDSTR_15_Vendor_IDString1615
Key to the PM Vendor Master File (PM00200).

Click to show/hide

SELECT
       ['NC_Statement_Document_TEMP'].VENDORID AS 'NC_Statement_Document_TEMP-Vendor ID'
       ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       PM00200 AS ['PM Vendor Master File']
              ON
                     ['NC_Statement_Document_TEMP'].VENDORID = ['PM Vendor Master File'].VENDORID
8REFRENCE SearchReferenceSTR30String3230
9CHEKNMBR SearchCheck NumberSTR20_Document_NumberString2220
10DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency1019
11TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString1615
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC_Statement_Document_TEMP'].TAXDTLID AS 'NC_Statement_Document_TEMP-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCABR035 AS ['NC_Statement_Document_TEMP']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_Statement_Document_TEMP'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
12TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
13PSTGSTUS SearchPosting StatusINTInteger20
14DOCNUMBR SearchDocument NumberSTR20_Document_NumberString2220
15BANKID SearchBank IDSTR15_Bank_IDString1615
16NC_Trx_Date SearchNC_Trx_DateDATEDate46
17NC_Trx_Type SearchNC_Trx_TypeSTR9String109
18NC_Reference SearchNC_ReferenceSTR30String3230
19NC_BL_Amount SearchNC_BL_AmountNC_BL_AmountCurrency1015
20NCCHQNUM SearchNC_Cheque_NumberSTR20_Document_NumberString2220
21LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
22NC_Statement_Number SearchNC_Statement_NumberLong IntLong Integer48

Leave a Reply

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