Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/TX00300
Product: VAT Daybook (3096)
Series:
Display Name: taxReturn
Physical Name: TX00300
Technical Name: taxReturnSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Tax_Return_ID 
Tax Return ID String STR20_LBAU 20 2 STRTDATE Start Date Date DT 8 3 ENDDATE End Date Date DT 8 4 Tax_Return_Description Tax Return Description String STR50 50 5 Total_Sales_Tax Total Sales Tax Currency DLR19_RBSO_UTR$ 19 6 EU_Purchases_Tax EU Purchases Tax Currency DLR19_RBSO_UTR$ 19 7 Total_Tax Total Tax Currency DLR19_RBSO_UTR$ 19 8 Total_Purchases_Tax Total Purchases Tax Currency DLR19_RBSO_UTR$ 19 9 Total_Tax_Due Total Tax Due Currency DLR19_RBSO_UTR$ 19 10 Total_Sales Total Sales Currency DLR19_RBSO_UTR$ 19 11 TOTPURCH Total Purchases Currency DLR19_RBS0_UTR$ 19 12 Total_EU_Sales Total EU Sales Currency DLR19_RBSO_UTR$ 19 13 Total_EU_Purchases Total EU Purchases Currency DLR19_RBSO_UTR$ 19 14 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['taxReturn'].NOTEINDX AS 'taxReturn-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
TX00300 AS ['taxReturn']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['taxReturn'].NOTEINDX = ['Record Notes Master'].NOTEINDX15 Final_Return Final_Return Boolean Boolean 0 16 Resubmission Resubmission Boolean Boolean 0 17 Submission_Number Submission_Number String Submission_Number 17 18 VATReturn_FileName VATReturn_FileName String STR255 255 19 YEAR1 Year Integer Year 4 20 VAT_Period VatReturnPeriod Integer VatReturnPeriod 0 21 PeriodKey Period Key String STR4 4 22 DUEDATE Due Date Date DT 8 23 DATERECD Date Received Date DATE 6 24 ObligationStatus Obligation Status String STR1 1 25 GroupVAT Group VAT Boolean CB_Group VAT 0