EDCEI012 - Intrastat Inventory Default Site
Dynamics GP table EDCEI012 (Intrastat Inventory Default Site) contains 19 columns including IVDOCTYP, IVDOCNBR, LOCNCODE....
SQL Query Builder
19 Columns
| Column | Description | Type | Length | |
|---|---|---|---|---|
| IVDOCTYP | IV Document Type | Integer | 2 | |
| IVDOCNBR | IV Document Number | String | 18 | |
| LOCNCODE | Location Code | String | 12 | |
| TXRGNNUM | Tax Registration Number | String | 26 | |
| CCode | Country Code | String | 8 | |
| TMCODE | Transport Mode Code | String | 8 | |
| TRANSNATURE | Transaction Nature | String | 8 | |
| PRCDRRGM | Procedure/Regime | String | 8 | |
| INCTRMS | Incoterms | String | 8 | |
| PRT | Port | String | 8 | |
| RGN | Region | String | 8 | |
| CNTRYORGN | Country Origin | String | 8 | |
| TCC | Tax Commodity Code | String | 32 | |
| TRADREF | Traders Reference | String | 22 | |
| PRINTDOC | PrintDoc | Boolean | 2 | |
| COMMNTID | Comment ID | String | 16 | |
| ECTRX | EC Transaction | Boolean | 2 | |
| PRINTED | Printed | Boolean | 2 | |
| NOTEINDX | Note Index | Currency | 10 |
Related Tables
Tables that share columns with EDCEI012. Click "Join" to add to your query.