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_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo2 VCHRNMBR Voucher Number STR20_LBAU String 20 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'].DOCTYPE3 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 4 DSTINDX Distribution Account Index LI_14 Long Integer 14 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'].ACTINDX5 DistRef Distribution Reference STR30 String 30 6 TRXAMNT TRX Amount DLR19_$S2 Currency 19 7 Originating_TRX_Amount Originating TRX Amount DLR17_RBSO_UTR$ Currency 17 8 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 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'].TAXDTLID9 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 10 ORTAXAMT Originating Tax Amount DLR17_RBS0_UTR$ Currency 17 11 NC_Change_Code NC Change Code STR20 String 20 12 NC_Transaction_Status NC Transaction Status INT Integer 0 13 NC_VAT_Treatment NC VAT Treatment NC_VAT_Treatment Integer 0 14 NC_Recoverable_Rate NC Recoverable Rate NC Recoverable Currency 8 15 PSTGDATE Posting Date DT Date 8 16 NC_Tax_Base_Amount NC Tax Base Amount DLR19_RBSO_UTR$ Currency 19 17 NC_Originating_Tax_Base_ NC Originating Tax Base Amount DLR19_RBSO_UTR$ Currency 19 18 NC_Rec_Tax_Amount NC Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 19 NC_Originating_Rec_Tax_A NC Originating Rec Tax Amount DLR19_RBSO_UTR$ Currency 19 20 DISAMTAV Discount Amount Available DLR17_RBS0_UTR$ Currency 17 21 ODISAMTAV Originating Discount Amount Available DLR17_RBS0_UTR$ Currency 17