EDCEI016 - Intrastat Work | Prospr - Dynamics GP Table Reference

EDCEI016 - Intrastat Work

Query Builder

Select * from EDCEI016

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
DOCTYPE	Document Type	Integer	2	View
DOCNUMBR	Document Number	String	22	View
SQNCLINE	Sequence Line	Currency	10	View
CUSTNMBR	Customer Number	String	16	View
CCode	Country Code	String	8	View
TXRGNNUM	Tax Registration Number	String	26	View
TCC	Tax Commodity Code	String	32	View
NUMASS	Net Unit Mass	Currency	10	View
QUANTITY	QTY	Currency	10	View
LMASS	Line Mass	Currency	10	View
TMCODE	Transport Mode Code	String	8	View
TRANSNATURE	Transaction Nature	String	8	View
SUPPUNITS	Supplementary Units	Currency	10	View
TRADREF	Traders Reference	String	22	View
GOODSVALUE	Goods Value	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
DOCDATE	Document Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
Reference_Date	Reference Date	Date	4	View
POSTED	Posted	Boolean	2	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
ORGDSVAL	Originating Goods Value	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
PRT	Port	String	8	View
RGN	Region	String	8	View
CNTRYORGN	Country Origin	String	8	View
PRCDRRGM	Procedure/Regime	String	8	View
INCTRMS	Incoterms	String	8	View
STTSTCLVL	Statistical Value	Currency	10	View
ORGNTNGSTTSTCLVL	Originating Statistical Value	Currency	10	View
DCLGDSVAL	Declarant Goods Value	Currency	10	View
DCLTXAMT	Declarant Tax Amount	Currency	10	View
DCLSTVAL	Declarant Statistical Value	Currency	10	View
DECLID	Declarant ID	String	16	View
LOCNCODE	Location Code	String	12	View
ARRDISP	Arrival/Despatch	String	2	View
Included_On_Return	Included On Return	Boolean	2	View
INTRSTTRTRNID	Intrastat Return ID	String	22	View
PERIOD	Period	String	6	View
AUDITTRAIL	Audit Trail Code	String	14	View

EDCEI016 - Intrastat Work

Query Builder

Customer Service

Information

My Account

Contact Us