Table DCLCUSVATBED
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DCLCUSVATBED | DLCBD | Annual customer listing | Financials | KBE |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DLCBD0 | CPY+NUMRPT+BPR+EECNUM+TYP+NUM+LIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| AMTNOT | Amount - tax | MD1 | ||||||
| AMTVAT | Tax amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | BP | BPR | [BPR]BPR0=[DLCBD]BPR | Block | ||||
| BPRNAM | Company name | 2 | NAM | |||||
| CPY | Company | CPY | [CPY]CPY0=[DLCBD]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[DLCBD]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[DLCBD]CUR | Block | ||||
| EECNUM | EU VAT no. | A | 20 | DEB | ||||
| LIN | Line number | C | 3 | |||||
| NUM | Document no. | VCR | ||||||
| NUMRPT | Query no. | L | 8 | |||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DLCBD]UPDUSR | Other | ||||
| VAT | VAT code | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
| VATRAT | VAT rate | DCB | 3.6 |