Table DCLVATSPA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DCLVATSPA | DVS | Tax working table (SPA) | Financials | KSP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DVS0 | TAXTYP+TYP+NUM+VAT+REGTYP | No | |
| DVS1 | CRN | Yes | |
| DVS2 | EECNUM | Yes | |
| DVS3 | TAXTYP+DCLDAT | Yes | |
| DVS4 | INDLNK | Yes | |
| DVS5 | TAXTYP+CRN+TYP+NUM | Yes | |
| DVS6 | COD347+CRN | Yes | |
| DVS7 | ACCNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Internal number | L | 8 | |||||
| AMTATI | Amount + tax | MD1 | ||||||
| AMTATIL | Invoice amt. + tax (co) | MD1 | ||||||
| AMTNOT | Amount - tax | MD1 | ||||||
| AMTNOTL | Amount - tax (co) | MD1 | ||||||
| AMTTAX | Tax amount | MD1 | ||||||
| AMTTAXL | Tax amount (company) | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BIDNUM | Bank account number | A | 32 | |||||
| BOOKFLG | Include in book | M | 4 | 1 | ||||
| BPRDAT | Source date | D | ||||||
| BPRNAM | Company name | 2 | NAM | |||||
| BPRNUM | BP code | BPR | [BPR]BPR0=BPRNUM | Block | ||||
| BPRVCR | Source document | A | 20 | |||||
| BUILOC | Location | M | 12 | 3611 | ||||
| CDRREF | Cadastre | A | 25 | |||||
| CEEFLG | EU invoice | M | 4 | 1 | ||||
| COD347 | Code 347 | A | 3 | |||||
| CODOPE | Operation code | ADI | [ADI]CODE=393;CODOPE | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[DVS]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[DVS]CREUSR | Other | ||||
| CRN | Site tax ID no. | CRN | ||||||
| CRY | Country | CRY | [TCY]TCY0=[DVS]CRY | Block | ||||
| CSHVAT | Cash VAT tax rule | M | 4 | 1 | ||||
| CUR | Currency | CUR | [TCU]TCU0=[DVS]CUR | Block | ||||
| D347FLG | Declaration 347 | M | 4 | 1 | ||||
| D349FLG | Declaration 349 | M | 4 | 1 | ||||
| DCLDAT | Declaration date | D | ||||||
| DECCUR | Declared tax | DCB | 9.2 | |||||
| DEDAMT | Deductible amount | MD1 | ||||||
| DEDAMTL | Deductible amt local | MD1 | ||||||
| DEDRAT | Deductible % | DCB | 3.6 | |||||
| DOCTYP | Document type | M | 4 | 2004 | ||||
| EECNUM | EU identification | EEC | ||||||
| ENFDAT | Enforceability date | D | ||||||
| EURSRV | Services | M | 4 | 1 | ||||
| FCY | Site | FCY | [FCY]FCY0=[DVS]FCY | Block | ||||
| FIY | Fiscal year | C | 2 | |||||
| IGICFLG | IGIC | M | 4 | 1 | ||||
| IMPORT | Import | M | 4 | 1 | ||||
| INDLNK | Index link | A | 50 | |||||
| INR | Interest | M | 4 | 1 | ||||
| INVFLG | Invoice | M | 4 | 1 | ||||
| INVNUM | Invoice number | VCR | ||||||
| INVNUMDAT | Source date | D | ||||||
| INVTYP | Invoice category | M | 4 | 645 | ||||
| INVUPDFLG | Modif flag | M | 4 | 1 | ||||
| NRS | Nonresident | M | 4 | 1 | ||||
| NUM | Document no. | VCR | ||||||
| ORIMOD | Source module | M | 4 | 14 | ||||
| PAM | Tax rule type | ADI | [ADI]CODE=990;PAM | Block | ||||
| PAYCUR | Paid amount | DCB | 9.2 | |||||
| PER | Period | C | 2 | |||||
| POSCOD | Postal code | POS | ||||||
| PROFLG | Processing flag | M | 4 | 1 | ||||
| QUARTER | Quarter | C | 2 | |||||
| REGTYP | Tax rule type | C | 2 | |||||
| REVSAL | Sales reverse charge | M | 4 | 1 | ||||
| RNT | Rental | M | 4 | 1 | ||||
| SCDREF | SCD reference | A | 40 | |||||
| SNS | Sign | C | 2 | |||||
| SPADERNUM | DER code | A | 60 | |||||
| TAG | Purchase travel agency | M | 4 | 1 | ||||
| TAXTYP | Tax type | A | 4 | |||||
| TCKEND | End ticket | A | 15 | |||||
| TCKINI | Initial ticket | A | 15 | |||||
| TCKNUM | Number of tickets | L | 8 | |||||
| TOTALPAY | Paid | M | 4 | 1 | ||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP;LEG | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DVS]UPDUSR | Other | ||||
| VAC | Tax rule | TVB | [TVB]TVB0=VAC;[V]GSUPCLE | Block | ||||
| VACAGR | Agrarian tax rule | M | 4 | 1 | ||||
| VAT | Tax | VAT | [TVT]TVT0=VAT;LEG | Block | ||||
| VATRAT | Rate | DCB | 3.2 | |||||
| VATTYP | VAT type | M | 4 | 232 |