|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Intrastat Configuration
Table Name: ODCI
Table Description: Intrastat Configuration
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Configuration Entry ID | Int | 11 | - | Â | Â | Â |
| ConfType | Configuration Type | VarChar | 1 | - | Â | M | Additional Measurement Unit |
| Â | Â | Â | Â | Â | Â | C | Commodity Codes |
| Â | Â | Â | Â | Â | Â | P | Custom Procedures |
| Â | Â | Â | Â | Â | Â | I | Incoterms |
| Â | Â | Â | Â | Â | Â | N | Nature of Transactions |
| Â | Â | Â | Â | Â | Â | E | Ports of Entry and Exit |
| Â | Â | Â | Â | Â | Â | R | Service Codes |
| Â | Â | Â | Â | Â | Â | S | Statistical Procedures |
| Â | Â | Â | Â | Â | Â | T | Transport Modes |
| Â | Â | Â | Â | Â | Â | G | Regions |
| Code | Code | nVarChar | 50 | - | Â | Â | Â |
| Descr | Description | nVarChar | 254 | - | Â | Â | Â |
| PrcstVal | Percentage Value | Num | 19.6 | - | Â | Â | Â |
| SuppUnit | Supplementary Unit | Int | 11 | ODCI | Â | Â | Â |
| Export | Valid for Export | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Import | Valid for Import | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| StatCode | Statistical Code | nVarChar | 2 | - | Â | Â | Â |
| DateFrom | Valid From | Date | 8 | - | Â | Â | Â |
| DateTo | Valid To | Date | 8 | - | Â | Â | Â |
| TextVal | Text Value | nVarChar | 12 | - | Â | Â | Â |
| ConfID | Configuration ID | nVarChar | 254 | - | Â | Â | Â |
| TriangDeal | Triangular Deal Type | nVarChar | 2 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | 11 | Acquisitions intra-communautaires |
|  |  |  |  |  |  | 21 | Livraison exon�r�e |
|  |  |  |  |  |  | 31 | Facturations dans le cadre d�op�rations triangulaires |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| CONF_ID | No | ConfID |