Table DCLVATPORL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DCLVATPORL | DVPL | VAT declaration lines | Financials | KPO |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DVPL0 | DCLNUM+LINTYP+LSTLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTBAS | Base | DCB | 11.2 | |||||
| AMTVAT | VAT amount | DCB | 11.2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPRNUM | BP code | BPR | [BPR]BPR0=[DVPL]BPRNUM | Other | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[DVPL]CREUSR | Other | ||||
| CRY | Country | CRY | [TCY]TCY0=[DVPL]CRY | Block | ||||
| DCLNUM | Declaration | VCR | ||||||
| EECNUM | EU identification | EEC | ||||||
| FLD40REN | Field 40 - reason | ADI | [ADI]CODE=8300;FLD40REN | Block | ||||
| FLD41REN | Field 41 - reason | ADI | [ADI]CODE=8301;FLD41REN | Block | ||||
| LINTYP | Line type | C | 4 | |||||
| LSTLIN | Line | C | 4 | |||||
| MON | Month | C | 2 | |||||
| OPETYP | Operation type | M | 15 | 638 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[DVPL]UPDUSR | Other | ||||
| VCRNUM | Document | A | 30 | |||||
| YEA | Year | C | 4 |