Intrastat Inventory Default Site (EDCEI012)

azurecurve Products Enhanced Intrastat (2788)InventoryIntrastat Inventory Default Site (EDCEI012)

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

Product: Enhanced Intrastat (2788)
Series:

Display Name: Intrastat Inventory Default Site
Physical Name: EDCEI012
Technical Name: ivIntrastatDefSite

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	IVDOCTYP	IV Document Type	Integer	DDL_IV_Document_Type	0
2	IVDOCNBR	IV Document Number	String	STR17_IV_Document_Number	17
3	LOCNCODE	Location Code	String	STR10_Location_Code	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Intrastat Inventory Default Site'].LOCNCODE AS 'Intrastat Inventory Default Site-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM EDCEI012 AS ['Intrastat Inventory Default Site'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Intrastat Inventory Default Site'].LOCNCODE = ['Site Setup'].LOCNCODE
4	TXRGNNUM	Tax Registration Number	String	STR25	25
5	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['Intrastat Inventory Default Site'].CCode AS 'Intrastat Inventory Default Site-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM EDCEI012 AS ['Intrastat Inventory Default Site'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['Intrastat Inventory Default Site'].CCode = ['VAT Country Code MSTR'].CCode
6	TMCODE	Transport Mode Code	String	STR6_VAT	6
7	TRANSNATURE	Transaction Nature	String	STR6_VAT	6
8	PRCDRRGM	Procedure/Regime	String	STR6_VAT	6
9	INCTRMS	Incoterms	String	STR6_VAT	6
10	PRT	Port	String	STR6_VAT	6
11	RGN	Region	String	STR6_VAT	6
12	CNTRYORGN	Country Origin	String	STR6_VAT	6
13	TCC	Tax Commodity Code	String	STR30_VAT	30
14	TRADREF	Traders Reference	String	STR20	20
15	PRINTDOC	PrintDoc	Boolean	CB_PrintDoc	0
16	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Intrastat Inventory Default Site'].COMMNTID AS 'Intrastat Inventory Default Site-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM EDCEI012 AS ['Intrastat Inventory Default Site'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Intrastat Inventory Default Site'].COMMNTID = ['Comment Master'].COMMNTID
17	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.
18	PRINTED	Printed	Boolean	CB	0
	Click to show/hide Printed flag 0 Record has not been printed. 1 Record has been printed.
19	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Intrastat Inventory Default Site'].NOTEINDX AS 'Intrastat Inventory Default Site-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM EDCEI012 AS ['Intrastat Inventory Default Site'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Intrastat Inventory Default Site'].NOTEINDX = ['Record Notes Master'].NOTEINDX

azurecurve Products Enhanced Intrastat (2788)InventoryIntrastat Inventory Default Site (EDCEI012)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide Document Printed flag

Click to show/hide Printed flag

Click to show/hide

Leave a Reply Cancel reply