Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00301
Product: VAT Daybook (3096)
Series:
Display Name: taxReturnException
Physical Name: TX00301
Technical Name: taxReturnExceptionSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID String STR20_LBAU 20 2 Exception Exception Integer INT 0 3 SERIES Series Integer DDL_Series 0 4 DOCTYPE Document Type Integer DDL_Document_Type 0 5 DOCDESCR Document Description String STR30 30 6 DOCNUMBR Document Number String STR20_Document_Number 20 7 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['taxReturnException'].CUSTNMBR AS 'taxReturnException-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
TX00301 AS ['taxReturnException']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['taxReturnException'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR8 CUSTNAME Customer Name String STR64_Customer_Name 64 9 TAXDTLID Tax Detail ID String STR15_Tax_Detail_ID 15 Key to the Sales/Purchases Tax Master (TX00201).
Click to show/hide
SELECT
['taxReturnException'].TAXDTLID AS 'taxReturnException-Tax Detail ID'
,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
TX00301 AS ['taxReturnException']
INNER JOIN
TX00201 AS ['Sales/Purchases Tax Master']
ON
['taxReturnException'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID10 Tax_Date Tax Date Date DT 8 11 PSTGDATE Posting Date Date DT 8 12 SLSAMNT Sales Amount Currency DLR19_RBSO_UTR$ 19 13 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 14 EU_Purchases_Tax EU Purchases Tax Currency DLR19_RBSO_UTR$ 19 15 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.16 VOIDSTTS Void Status Integer INT 0