Table DCLEECVATBED
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
DCLEECVATBED | DLEBD | EU VAT statement (detail) | Financials | KBE |
Key | Description | Duplicates | Activity code |
---|---|---|---|
DLEBD0 | CPY+NUMRPT+BPR+EECNUM+OPECOD+TYP+NUM+LIN | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCDAT | Accounting date | D | ||||||
AMTNOT | Amount - tax | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BPR | BP | BPR | [BPR]BPR0=[DLEBD]BPR | Block | ||||
CPY | Company | CPY | [CPY]CPY0=[DLEBD]CPY | Block | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[DLEBD]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[DLEBD]CUR | Block | ||||
EECNUM | EU VAT no. | A | 20 | DEB | ||||
LIN | Line number | C | 3 | |||||
NUM | Document no. | VCR | ||||||
NUMRPT | Query no. | L | 8 | |||||
OPECOD | Operation code | ADI | [ADI]CODE=369;OPECOD | Block | ||||
TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[DLEBD]UPDUSR | Other | ||||
VAT | VAT code | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
VATRAT | VAT rate | DCB | 3.6 |