Table SALESTAX
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SALESTAX | STB | Sales tax report | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STB0 | PID+VAT | Yes | |
| STB1 | VCRNUM+VCRTYP+VAT+PID | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| AMTEXE | Exemption amount | MD1 | ||||||
| AMTNON | Non-taxable | MD1 | ||||||
| AMTTAX | Taxable amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CPY | Company | CPY | [CPY]CPY0=[STB]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[STB]CUR | Block | ||||
| FPER | Periods | C | 5 | |||||
| FRTNON | Non taxable freight | MD1 | ||||||
| FRTTAX | Taxable freight | MD1 | ||||||
| FYEAR | Fiscal year | C | 5 | |||||
| GTE | Entry type | GTE | [GTE]GTE0=GTE;[V]GSUPCLE | Block | ||||
| NUM | Invoice number | SIH | [SIV]SIV0=[STB]NUM | Other | ||||
| PID | Processes | A | 20 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VAT | Tax | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
| VATCOLL | Output VAT | MD1 | ||||||
| VATDES | Description | DES | ||||||
| VATEXN | Exemption no. | A | 15 | |||||
| VATGRO | Gross basis | MD1 | ||||||
| VATRAT | Rate | DCB | 3.6 | |||||
| VATSUPAMT | Extra tax amount | MD1 | ||||||
| VATTAX | Tax amount | MD1 | ||||||
| VATTYP | Tax type | M | 15 | 232 | ||||
| VCRDAT | Invoice date | D | ||||||
| VCRLIN | Line | L | 8 | |||||
| VCRNUM | Entry | VCR | ||||||
| VCRTYP | Entry type | M | 15 | 476 |