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 |