Table DCLVATBOXDBD
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
DCLVATBOXDBD | DLVBD | VAT detail | Financials | DCL |
Key | Description | Duplicates | Activity code |
---|---|---|---|
DLVBD0 | CPY+FCY+STRDAT+ACC+VATBOX+NUMRPT+TYP+NUM+LIN | No | |
DLVBD1 | CPY+NUMRPT | Yes | |
DLVBD2 | VATENTNUM+CPY+FCY+NUMRPT+ACC+VATBOX+VAT+TYP+NUM+LIN+PSTSTA | Yes | |
DLVBD3 | CPY+NUMRPT+TYP+NUM+FCY+STRDAT+ACC+VATBOX+LIN | No | KAU |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACC | Account | GAC | [GAC]GAC0=COA;ACC | Block | ||||
ACCDAT | Accounting date | D | ||||||
AMT | Amount | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
COA | Chart code | COA | [COA]COA0=[DLVBD]COA | Block | ||||
CODVATGRP | VAT entity | VATGRP | [VATGH]VATGH0=[DLVBD]CODVATGRP | BSRA | ||||
CPY | Company | CPY | [CPY]CPY0=[DLVBD]CPY | Block | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[DLVBD]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[DLVBD]CUR | Block | ||||
ENDDAT | Declaration date | D | ||||||
FCY | Site | FCY | [FCY]FCY0=[DLVBD]FCY | Block | ||||
FLGVAT | Tax management | M | 15 | 608 | ||||
LIN | Line | C | 3 | |||||
NUM | Document no. | VCR | ||||||
NUMRPT | Query no. | L | 8 | |||||
OPTDAT | Date option | M | 15 | 687 | ||||
ORIMOD | Source module | M | 10 | 14 | ||||
PSTSTA | Posting status | M | 15 | 3742 | ||||
SIM | Simulation | M | 4 | 1 | ||||
STRDAT | Declaration date | D | ||||||
TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
TYPAMT | Amount type | M | 15 | 686 | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[DLVBD]UPDUSR | Other | ||||
VAT | VAT code | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
VATBOX | VAT box | A | 5 | |||||
VATENTNUM | Declaration number | VCR | ||||||
VATFRM | VAT form | A | 15 | |||||
VATIPT | Tax allocation | M | 15 | 609 | ||||
VATRAT | VAT rate | DCB | 3.6 | |||||
VTDSNS | Sign | C | 2 |