EDCEI002 - Intrastat Setup | Prospr - Dynamics GP Table Reference

EDCEI002 - Intrastat Setup

Query Builder

Select * from EDCEI002

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMPADRSCODE	CompAddrCode	String	16	View
LOCNCODE	Location Code	String	12	View
LOCATNNM	Location Name	String	32	View
RGN	Region	String	8	View
CCode	Country Code	String	8	View
TXRGNNUM	Tax Registration Number	String	26	View
BRNCHNMBR	Branch Number	String	22	View
CURNCYID	Currency ID	String	16	View
ISAGENT	IsAgent	Boolean	2	View
AGENTID	Agent ID	String	8	View
OCCDECL	OccasionalDeclarant	Boolean	2	View
UPDINTRA	UpdateIntrastat	Integer	2	View
TRANSNATURE	Transaction Nature	String	8	View
ARVLSTD	ArrivalsStd	Currency	10	View
DEPARTSTD	DispatchesStd	Currency	10	View
ARVLEXT	ArrivalsExt	Currency	10	View
DEPARTEXT	DispatchesExt	Currency	10	View
DCLRSUBMSN	DeclarationSubmission	Integer	2	View
SUBMSNDAY	SubmissionDay	Integer	2	View
DISPSINGLE	DispatchesSingle	Currency	10	View
ARRSINGLE	ArrivalsSingle	Currency	10	View
ALLOWINTNONIV	AllowIntrastatNONIV	Boolean	2	View
SINGLEDECL	SingleDeclarant	Boolean	2	View
SUMMNOTEDIT	Summary Not Editable	Boolean	2	View
DECLNUM	Declarant Number	Integer	2	View
BASETHRSLDON	BaseThresholdOn	Integer	2	View
NETMSCALC	Net Mass Calculation	Integer	2	View