EDCEI002 - Intrastat Setup
Dynamics GP table EDCEI002 (Intrastat Setup) contains 27 columns including CMPADRSCODE, LOCNCODE, LOCATNNM....
SQL Query Builder
27 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| CMPADRSCODE | CompAddrCode | String | 16 | |
| LOCNCODE | Location Code | String | 12 | |
| LOCATNNM | Location Name | String | 32 | |
| RGN | Region | String | 8 | |
| CCode | Country Code | String | 8 | |
| TXRGNNUM | Tax Registration Number | String | 26 | |
| BRNCHNMBR | Branch Number | String | 22 | |
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | |
| ISAGENT | IsAgent | Boolean | 2 | |
| AGENTID | Agent ID | String | 8 | |
| OCCDECL | OccasionalDeclarant | Boolean | 2 | |
| UPDINTRA | UpdateIntrastat | Integer | 2 | |
| TRANSNATURE | Transaction Nature | String | 8 | |
| 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 |
Related Tables
Tables that share columns with EDCEI002. Click "Join" to add to your query.