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 |