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 TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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 Integer10
3MKDTOPST SearchMarked To PostCBBoolean0
4DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
5ACTINDX SearchAccount IndexLI_14Long Integer14
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_NumberString15
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_IDString15
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 SearchReferenceSTR30String30
9CHEKNMBR SearchCheck NumberSTR20_Document_NumberString20
10DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
11TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
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$Currency17
13PSTGSTUS SearchPosting StatusINTInteger0
14DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
15BANKID SearchBank IDSTR15_Bank_IDString15
16NC_Trx_Date SearchNC_Trx_DateDATEDate6
17NC_Trx_Type SearchNC_Trx_TypeSTR9String9
18NC_Reference SearchNC_ReferenceSTR30String30
19NC_BL_Amount SearchNC_BL_AmountNC_BL_AmountCurrency15
20NCCHQNUM SearchNC_Cheque_NumberSTR20_Document_NumberString20
21LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
22NC_Statement_Number SearchNC_Statement_NumberLong IntLong Integer8

Leave a Reply

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