NC Tax Return Detail (NCVAT600)

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

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

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	DOCNUMBR	Document Number	STR20_Document_Number	String	20
2	DOCTYPE	Document Type	DDL_Document_Type	Integer	0
3	SERIES	Series	DDL_Series	Integer	0
4	RCTRXSEQ	Recurring TRX Sequence	DLR19_$S2	Currency	19
5	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
6	Tax_Return_ID	Tax Return ID	STR20_LBAU	String	20
7	TAXDTLID	Tax Detail ID	STR15_Tax_Detail_ID	String	15
	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
8	Tax_Date	Tax Date	DT	Date	8
9	PSTGDATE	Posting Date	DT	Date	8
10	TAXAMNT	Tax Amount	DLR17_RBS0_UTR$	Currency	17
11	Taxable_Amount	Taxable Amount	DLR19_RBS0_UTR$	Currency	19
12	DOCAMNT	Document Amount	DLR19_RBSO_UTR$	Currency	19
13	EU_Purchases_Tax	EU Purchases Tax	DLR19_RBSO_UTR$	Currency	19
14	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. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
15	VOIDSTTS	Void Status	INT	Integer	0
16	CustomerVendor_ID	Customer/Vendor ID	STR15	String	15
17	DOCDESCR	Document Description	STR30	String	30
18	NC_Original_Series	NC Original Series	INT	Integer	0