NC Tax Return Detail (NCVAT600)

azurecurveProductsAdvanced VAT (2474)FinancialNC Tax Return Detail (NCVAT600)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT600

Product: Advanced VAT (2474)
Series: Financial

Display Name: NC Tax Return Detail
Physical Name: NCVAT600
Technical Name: xNC_TaxReturnDetail

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DOCNUMBR SearchDocument NumberSTR20_Document_NumberString20
2DOCTYPE SearchDocument TypeDDL_Document_TypeInteger0
3SERIES SearchSeriesDDL_SeriesInteger0
4RCTRXSEQ SearchRecurring TRX SequenceDLR19_$S2Currency19
5SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer10
6Tax_Return_ID SearchTax Return IDSTR20_LBAUString20
7TAXDTLID SearchTax Detail IDSTR15_Tax_Detail_IDString15
Key to the Sales/Purchases Tax Master (TX00201).

Click to show/hide

SELECT
       ['NC Tax Return Detail'].TAXDTLID AS 'NC Tax Return Detail-Tax Detail ID'
       ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID'
FROM
       NCVAT600 AS ['NC Tax Return Detail']
INNER JOIN
       TX00201 AS ['Sales/Purchases Tax Master']
              ON
                     ['NC Tax Return Detail'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
8Tax_Date SearchTax DateDTDate8
9PSTGDATE SearchPosting DateDTDate8
10TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
11Taxable_Amount SearchTaxable AmountDLR19_RBS0_UTR$Currency19
12DOCAMNT SearchDocument AmountDLR19_RBSO_UTR$Currency19
13EU_Purchases_Tax SearchEU Purchases TaxDLR19_RBSO_UTR$Currency19
14ECTRX SearchEC TransactionCB_EC_TransactionBoolean0
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.
15VOIDSTTS SearchVoid StatusINTInteger0
16CustomerVendor_ID SearchCustomer/Vendor IDSTR15String15
17DOCDESCR SearchDocument DescriptionSTR30String30
18NC_Original_Series SearchNC Original SeriesINTInteger0
azurecurveProductsAdvanced VAT (2474)FinancialNC Tax Return Detail (NCVAT600)

Leave a Reply

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