NC_Payable_Line (NCVAT004)

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

Product: Advanced VAT (2474)
Series: Purchasing

Display Name: NC_Payable_Line
Physical Name: NCVAT004
Technical Name: NC_Payable_LINE

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_Line'].VCHRNMBR AS 'NC_Payable_Line-Voucher Number'
       ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
       NCVAT004 AS ['NC_Payable_Line']
INNER JOIN
       PM00400 AS ['PM Key Master File']
              ON
                     ['NC_Payable_Line'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
              AND
                     ['NC_Payable_Line'].DOCTYPE = ['PM Key Master File'].DOCTYPE
3SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
4DSTINDX SearchDistribution Account IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['NC_Payable_Line'].DSTINDX AS 'NC_Payable_Line-Distribution Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       NCVAT004 AS ['NC_Payable_Line']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['NC_Payable_Line'].DSTINDX = ['Account Index Master'].ACTINDX
5DistRef SearchDistribution ReferenceSTR30String30
6TRXAMNT SearchTRX AmountDLR19_$S2Currency19
7Originating_TRX_Amount SearchOriginating TRX AmountDLR17_RBSO_UTR$Currency17
8TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC_Payable_Line'].TAXDTLID AS 'NC_Payable_Line-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCVAT004 AS ['NC_Payable_Line']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC_Payable_Line'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
9TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
10ORTAXAMT SearchOriginating Tax AmountDLR17_RBS0_UTR$Currency17
11NC_Change_Code SearchNC Change CodeSTR20String20
12NC_Transaction_Status SearchNC Transaction StatusINTInteger0
13NC_VAT_Treatment SearchNC VAT TreatmentNC_VAT_TreatmentInteger0
14NC_Recoverable_Rate SearchNC Recoverable RateNC RecoverableCurrency8
15PSTGDATE SearchPosting DateDTDate8
16NC_Tax_Base_Amount SearchNC Tax Base AmountDLR19_RBSO_UTR$Currency19
17NC_Originating_Tax_Base_ SearchNC Originating Tax Base AmountDLR19_RBSO_UTR$Currency19
18NC_Rec_Tax_Amount SearchNC Rec Tax AmountDLR19_RBSO_UTR$Currency19
19NC_Originating_Rec_Tax_A SearchNC Originating Rec Tax AmountDLR19_RBSO_UTR$Currency19
20DISAMTAV SearchDiscount Amount AvailableDLR17_RBS0_UTR$Currency17
21ODISAMTAV SearchOriginating Discount Amount AvailableDLR17_RBS0_UTR$Currency17

Leave a Reply

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