EDCEI002 - Intrastat Setup

Dynamics GP table EDCEI002 (Intrastat Setup) contains 27 columns including CMPADRSCODE, LOCNCODE, LOCATNNM....

SQL Query Builder

SELECT * FROM EDCEI002

Select all

Column	Description	Type	Length	Shared With
CMPADRSCODE	CompAddrCode	String	16	-
LOCNCODE	Location Code	String	12	37 tables
LOCATNNM	Location Name	String	32	1 tables
RGN	Region	String	8	3 tables
CCode	Country Code	String	8	25 tables
TXRGNNUM	Tax Registration Number	String	26	29 tables
BRNCHNMBR	Branch Number	String	22	1 tables
CURNCYID	Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions.	String	16	101 tables
ISAGENT	IsAgent	Boolean	2	-
AGENTID	Agent ID	String	8	-
OCCDECL	OccasionalDeclarant	Boolean	2	-
UPDINTRA	UpdateIntrastat	Integer	2	-
TRANSNATURE	Transaction Nature	String	8	3 tables
ARVLSTD	ArrivalsStd	Currency	10	-
DEPARTSTD	DispatchesStd	Currency	10	-
ARVLEXT	ArrivalsExt	Currency	10	-
DEPARTEXT	DispatchesExt	Currency	10	-
DCLRSUBMSN	DeclarationSubmission	Integer	2	-
SUBMSNDAY	SubmissionDay	Integer	2	-
DISPSINGLE	DispatchesSingle	Currency	10	-
ARRSINGLE	ArrivalsSingle	Currency	10	-
ALLOWINTNONIV	AllowIntrastatNONIV	Boolean	2	-
SINGLEDECL	SingleDeclarant	Boolean	2	-
SUMMNOTEDIT	Summary Not Editable	Boolean	2	-
DECLNUM	Declarant Number	Integer	2	-
BASETHRSLDON	BaseThresholdOn	Integer	2	-
NETMSCALC	Net Mass Calculation	Integer	2	-

Tables that share columns with EDCEI002. Click "Join" to add to your query.

CURNCYID

RGN

TRANSNATURE

LOCATNNM

BRNCHNMBR