Table DEB
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DEB | DEB | EU exchange declaration | Common Data | DEB |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DEB0 | CPY+DEBDAT+FLO+VCRTYP+VCRNUM+VCRLIN | No | |
| DEB1 | CPY+VCRTYP+VCRNUM+VCRLIN+FLO | Yes | |
| DEB2 | CPY+DEBDAT+FLO+DEBLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[DEB]BPRNUM | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[DEB]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[DEB]CREUSR | Other | ||||
| CRYFCY | Site country | CRY | [TCY]TCY0=[DEB]CRYFCY | Block | ||||
| CUR | Currency | CUR | [TCU]TCU0=[DEB]CUR | Block | ||||
| CUSREF | Customs reference | A | 12 | |||||
| DAT | Document date | D | ||||||
| DEBDAT | Intrastat date | D | ||||||
| DEBLIN | Line no. | L | 8 | |||||
| DESCRY | Receiving/issuing country | A | 3 | |||||
| DESPRO | Destination province | A | 2 | KIT | ||||
| EECICT | Incoterm | ICT | [ICTH]ICT0=[DEB]EECICT | Block | ||||
| EECLOC | Intrastat transport location | M | 15 | 236 | ||||
| EECNAT | Transaction nature | TEC | [TEC]TEC0=EECNAT;[V]GSUPCLE | Block | ||||
| EECNUM | EU identification | A | 20 | |||||
| EECNUMDEB | EU Intrastat | C | 4 | |||||
| EECSCH | Intrastat rule | TSC | [TSC]TSC0=EECSCH;[V]GSUPCLE | Block | ||||
| EECTRN | Intrastat transp. mode | M | 15 | 237 | ||||
| EECUNT | Intrastat additional units | DCB | 13 | |||||
| EECUSU | Additional unit | A | 12 | KIT | ||||
| EXPNUM | Export number | L | 8 | |||||
| FISAMT | EU fiscal value | DCB | 10.2 | |||||
| FLO | Automatic flows | M | 15 | 205 | ||||
| ITMDES1 | Description | DES | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[DEB]ITMREF | Block | ||||
| LINVALOFLG | Valuated line | M | 4 | 1 | ||||
| MON | Months | C | 2 | KIT | ||||
| NBDEC | Number | C | 2 | EDIDB | ||||
| NETMAS | EU net weight | DCB | 12.3 | |||||
| NIV | EU declaration level | C | 1 | |||||
| ORICRY | Country of origin | A | 3 | |||||
| PORT | Port | ADI | [ADI]CODE=951;PORT | Block | DEBP | |||
| REG | Department | A | 2 | |||||
| REGION | Region | ADI | [ADI]CODE=950;REGION | Block | KPO | |||
| SIGN | Sign | A | 1 | KIT | ||||
| STAAMT | Statistic value | DCB | 10.2 | |||||
| STAFED | Region/State | A | 40 | DEBR | ||||
| STOFCY | Storage site | FCY | [FCY]FCY0=[DEB]STOFCY | Block | ||||
| TRIM | Quarter | C | 2 | KIT | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DEB]UPDUSR | Other | ||||
| VALAMT | Value in currency | DCB | 10.2 | KIT | ||||
| VCRLIN | Entry line no. | L | 8 | |||||
| VCRLINVALO | Journal line | 15 | L | 8 | ||||
| VCRNUM | Order no. | VCR | ||||||
| VCRNUMVALO | Inv/credits | 15 | VCR | |||||
| VCRTYP | Entry type | M | 15 | 701 | ||||
| YEA | Year | C | 4 | KIT |