taxReturn (TX00300)

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: taxReturn

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Tax_Return_ID SearchTax Return IDStringSTR20_LBAU20
2STRTDATE SearchStart DateDateDT8
3ENDDATE SearchEnd DateDateDT8
4Tax_Return_Description SearchTax Return DescriptionStringSTR5050
5Total_Sales_Tax SearchTotal Sales TaxCurrencyDLR19_RBSO_UTR$19
6EU_Purchases_Tax SearchEU Purchases TaxCurrencyDLR19_RBSO_UTR$19
7Total_Tax SearchTotal TaxCurrencyDLR19_RBSO_UTR$19
8Total_Purchases_Tax SearchTotal Purchases TaxCurrencyDLR19_RBSO_UTR$19
9Total_Tax_Due SearchTotal Tax DueCurrencyDLR19_RBSO_UTR$19
10Total_Sales SearchTotal SalesCurrencyDLR19_RBSO_UTR$19
11TOTPURCH SearchTotal PurchasesCurrencyDLR19_RBS0_UTR$19
12Total_EU_Sales SearchTotal EU SalesCurrencyDLR19_RBSO_UTR$19
13Total_EU_Purchases SearchTotal EU PurchasesCurrencyDLR19_RBSO_UTR$19
14NOTEINDX SearchNote IndexCurrencyDLR1414
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'].NOTEINDX
15Final_Return SearchFinal_ReturnBooleanBoolean0
16Resubmission SearchResubmissionBooleanBoolean0
17Submission_Number SearchSubmission_NumberStringSubmission_Number17
18VATReturn_FileName SearchVATReturn_FileNameStringSTR255255
19YEAR1 SearchYearIntegerYear4
20VAT_Period SearchVatReturnPeriodIntegerVatReturnPeriod0
21PeriodKey SearchPeriod KeyStringSTR44
22DUEDATE SearchDue DateDateDT8
23DATERECD SearchDate ReceivedDateDATE6
24ObligationStatus SearchObligation StatusStringSTR11
25GroupVAT SearchGroup VATBooleanCB_Group VAT0

Leave a Reply

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