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 |