NC_Payable_HDR (NCVAT006)

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

Product: Advanced VAT (2474)
Series: Purchasing

Display Name: NC_Payable_HDR
Physical Name: NCVAT006
Technical Name: NC_Payable_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0

Click to show/hide Document Types


1	Invoice
2	Finance Charge
3	Miscellaneous Charges
4	Return
5	Credit Memo
2VCHRNMBR SearchVoucher NumberSTR20_LBAUString20
Partial key to the PM Key Master File (PM00400).

Click to show/hide

SELECT
       ['NC_Payable_HDR'].VCHRNMBR AS 'NC_Payable_HDR-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['NC_Payable_HDR'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['NC_Payable_HDR'].DOCTYPE = ['PM Key Master File'].DOCTYPE
3PMTDSCIX SearchPM Trade Discount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_Payable_HDR'].PMTDSCIX AS 'NC_Payable_HDR-PM Trade Discount Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Payable_HDR'].PMTDSCIX = ['Account Index Master'].ACTINDX
4PMFRTIDX SearchPM Freight IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_Payable_HDR'].PMFRTIDX AS 'NC_Payable_HDR-PM Freight Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Payable_HDR'].PMFRTIDX = ['Account Index Master'].ACTINDX
5PMMSCHIX SearchPM Misc Charges IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_Payable_HDR'].PMMSCHIX AS 'NC_Payable_HDR-PM Misc Charges Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Payable_HDR'].PMMSCHIX = ['Account Index Master'].ACTINDX
6NC_Recalc_VAT SearchNC Recalc VATCBBoolean0

Leave a Reply

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