Tax Return Detail (TX00304)

Easily find this page again using the shortlink:

Product: VAT Daybook (3096)

Display Name: Tax Return Detail
Physical Name: TX00304
Technical Name: taxReturnDetail

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Tax_Return_ID SearchTax Return IDStringSTR20_LBAU20
2DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
3DOCTYPE SearchDocument TypeIntegerDDL_Document_Type0
4SERIES SearchSeriesIntegerDDL_Series0
5TAXDTLID SearchTax Detail IDStringSTR15_Tax_Detail_ID15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

       ['Tax Return Detail'].TAXDTLID AS 'Tax Return Detail-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
       TX00304 AS ['Tax Return Detail']
       TX00201 AS ['Sales/Purchases Tax Master']
                     ['Tax Return Detail'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
6Tax_Date SearchTax DateDateDT8
7PSTGDATE SearchPosting DateDateDT8
8TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
9Taxable_Amount SearchTaxable AmountCurrencyDLR19_RBS0_UTR$19
10DOCAMNT SearchDocument AmountCurrencyDLR19_RBSO_UTR$19
11EU_Purchases_Tax SearchEU Purchases TaxCurrencyDLR19_RBSO_UTR$19
12ECTRX SearchEC TransactionBooleanCB_EC_Transaction0
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.
13VOIDSTTS SearchVoid StatusIntegerINT0
14CustomerVendor_ID SearchCustomer/Vendor IDStringSTR1515
15DOCDESCR SearchDocument DescriptionStringSTR3030

Leave a Reply

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