Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00304
Product: VAT Daybook (3096)
Series:
Display Name: Tax Return Detail
Physical Name: TX00304
Technical Name: taxReturnDetailSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID String STR20_LBAU 20 2 DOCNUMBR Document Number String STR20_Document_Number 20 3 DOCTYPE Document Type Integer DDL_Document_Type 0 4 SERIES Series Integer DDL_Series 0 5 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['Tax Return Detail'].TAXDTLID AS 'Tax Return Detail-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX00304 AS ['Tax Return Detail']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['Tax Return Detail'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID6 Tax_Date Tax Date Date DT 8 7 PSTGDATE Posting Date Date DT 8 8 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 9 Taxable_Amount Taxable Amount Currency DLR19_RBS0_UTR$ 19 10 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 11 EU_Purchases_Tax EU Purchases Tax Currency DLR19_RBSO_UTR$ 19 12 ECTRX EC Transaction Boolean CB_EC_Transaction 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.13 VOIDSTTS Void Status Integer INT 0 14 CustomerVendor_ID Customer/Vendor ID String STR15 15 15 DOCDESCR Document Description String STR30 30