Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00304
Display Name: Tax Return Detail DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.
Physical Name: TX00304
Technical Name: taxReturnDetail
Seq 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 SERIES Series DDL_Series Integer 0 5 TAXDTLID Tax Detail ID STR15_Tax_Detail_ID String 15 Key to the Sales/Purchases Tax Master (TX00201).
6 Tax_Date Tax Date DT Date 8 7 PSTGDATE Posting Date DT Date 8 8 TAXAMNT Tax Amount DLR17_RBS0_UTR$ Currency 17 9 Taxable_Amount Taxable Amount DLR19_RBS0_UTR$ Currency 19 10 DOCAMNT Document Amount DLR19_RBSO_UTR$ Currency 19 11 EU_Purchases_Tax EU Purchases Tax DLR19_RBSO_UTR$ Currency 19 12 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.
13 VOIDSTTS Void Status INT Integer 0 14 CustomerVendor_ID Customer/Vendor ID STR15 String 15 15 DOCDESCR Document Description STR30 String 30 16 DEX_ROW_ID int int 10
Display Name: Tax Return Detail
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.