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 |