Table DCLVATBOXPYD
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
DCLVATBOXPYD | DLVBP | VAT detail | Financials | DCL |
Key | Description | Duplicates | Activity code |
---|---|---|---|
DLVBP0 | CPY+FCY+STRDAT+ACC+BPR+MTC+VATBOX+VAT+VATIPT+NUMRPT+TYP+NUM+LIN | No | |
DLVBP1 | VATENTNUM+CPY+FCY+NUMRPT+ACC+VATBOX+VAT+TYP+NUM+LIN+PSTSTA | Yes | |
DLVBP2 | CPY+NUMRPT | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACC | Accounts | GAC | [GAC]GAC0=COA;ACC | Block | ||||
ACCBPR | Control | SAC | ||||||
ACCDAT | Accounting date | D | ||||||
ACCNUM | Internal number | UNQ | ||||||
AMT | Amount | MD1 | ||||||
AMTVCR | Payment amount | MD1 | ||||||
ATIVCR | Amount + tax | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BASNOTLIN | Base before tax | MD1 | ||||||
BASVATLIN | Tax base | MD1 | ||||||
BPR | BP | BPR | [BPR]BPR0=[DLVBP]BPR | Block | ||||
COA | Chart code | COA | [COA]COA0=[DLVBP]COA | Block | ||||
CODVATGRP | VAT entity | VATGRP | [VATGH]VATGH0=[DLVBP]CODVATGRP | BSRA | ||||
CPY | Company | CPY | [CPY]CPY0=[DLVBP]CPY | Block | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[DLVBP]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[DLVBP]CUR | Block | ||||
DATMAX | Journal date | D | ||||||
ENDDAT | End date | D | ||||||
FCY | Site | FCY | [FCY]FCY0=[DLVBP]FCY | Block | ||||
FLGVAT | Tax management | M | 15 | 608 | ||||
FLGVATPAI | Tax on debit | M | 4 | 1 | ||||
LIN | Line number | C | 3 | |||||
MTC | Matching | A | 5 | |||||
MTCACC | Account | GAC | [GAC]GAC0=COA;MTCACC | Block | ||||
MTCBPR | Control | SAC | ||||||
MTCDAT | Matching date | D | ||||||
NUM | Document no. | VCR | ||||||
NUMRPT | Query no. | L | 8 | |||||
OPT | Option | M | 25 | 688 | ||||
PSTSTA | Posting status | M | 15 | 3742 | ||||
SIM | Simulation | M | 4 | 1 | ||||
STRDAT | Start date | D | ||||||
TYP | Entry type | GTE | [GTE]GTE0=TYP;[V]GSUPCLE | Block | ||||
TYPAMT | Amount type | M | 15 | 686 | ||||
TYPREC | Record type | C | 1 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[DLVBP]UPDUSR | Other | ||||
VAT | Tax | 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 | Tax | DCB | 3.6 | |||||
VTDSNS | Sign | C | 2 |