Table DCLVATPAY
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
DCLVATPAY | DVP | Tax declaration / collection | Financials |
Key | Description | Duplicates | Activity code |
---|---|---|---|
DVP0 | CPY+FCY+STRDAT+ACC+BPR+MTC+VATRAT+ACCNUM | Yes | |
DVP1 | ACC+BPR+MTC+VATRAT+ACCNUM+NUMRPT | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACC | Accounts | GAC | [GAC]GAC0=COA;ACC | Block | ||||
ACCNUM | Internal number | UNQ | ||||||
AMTVATPAY | Tax amount on collection | MD1 | ||||||
AMTVCR | Payment amount | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BASVATPAY | Tax base on collection | MD1 | ||||||
BPR | BP | BPR | [BPR]BPR0=[DVP]BPR | Block | ||||
COA | Chart code | COA | [COA]COA0=[DVP]COA | Block | ||||
CPY | Company | CPY | [CPY]CPY0=[DVP]CPY | Block | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[DVP]CREUSR | Other | ||||
DATMAX | Journal date | D | ||||||
ENDDAT | End date | D | ||||||
FCY | Site | FCY | [FCY]FCY0=[DVP]FCY | Block | ||||
MTC | Matching | A | 5 | |||||
MTCDAT | Matching date | D | ||||||
NUMRPT | Query no. | L | 8 | |||||
OPT | Option | M | 25 | 688 | ||||
SIM | Simulation | M | 4 | 1 | ||||
STRDAT | Start date | D | ||||||
TOTAMTATI | Total including tax | MD1 | ||||||
TOTAMTVAT | Tax total | MD1 | ||||||
TYPREC | Record type | C | 1 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[DVP]UPDUSR | Other | ||||
VAT | Tax | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
VATIPT | Tax allocation | M | 15 | 609 | ||||
VATRAT | Tax | A | 15 |