Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT602
Product: Advanced VAT (2474)
Series: Financial
Display Name: NC_TaxReturnDetail_DetailDoc
Physical Name: NCVAT602
Technical Name: NC_TaxReturnDetail_DetailDocSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID STR20_LBAU String 20 2 DOCNUMBR Document Number STR20_Document_Number String 20 3 DOCTYPE Document Type DDL_Document_Type Integer 0 4 NC_Original_Series NC Original Series INT Integer 0 5 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 6 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['NC_TaxReturnDetail_DetailDoc'].TAXDTLID AS 'NC_TaxReturnDetail_DetailDoc-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
NCVAT602 AS ['NC_TaxReturnDetail_DetailDoc']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['NC_TaxReturnDetail_DetailDoc'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID7 VOIDSTTS Void Status INT Integer 0 8 SERIES Series DDL_Series Integer 0 9 Tax_Date Tax Date DT Date 8 10 PSTGDATE Posting Date DT Date 8 11 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 12 Taxable_Amount Taxable Amount DLR19_RBS0_UTR$ Currency 19 13 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 14 EU_Purchases_Tax EU Purchases Tax DLR19_RBSO_UTR$ Currency 19 15 ECTRX EC Transaction CB_EC_Transaction Boolean 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.16 CustomerVendor_ID Customer/Vendor ID STR15 String 15 17 DOCDESCR Document Description STR30 String 30