Table TABVATEXE
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
TABVATEXE | TEX | Tax exemption table | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
TEX0 | BPCNUM+NUMORD | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
BPCNUM | Customer | BPR | [BPR]BPR0=[TEX]BPCNUM | Delete | ||||
CPY | Company | CPY | [CPY]CPY0=[TEX]CPY | Delete | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
ENDDAT | End date | D | ||||||
EXERAT | Exemption rate | DCB | 3.6 | |||||
EXEREN | Exemption reason | ADI | [ADI]CODE=365;EXEREN | Block | ||||
FLGUSE | Usage flag | M | 4 | 1 | ||||
NUMORD | Order no. | C | 2 | |||||
SPPNUM | Not justifying | A | 30 | |||||
STRDAT | Start date | D | ||||||
TSDMAX | Maximum threshold | DCB | 9.2 | |||||
TSDMIN | Minimum threshold | DCB | 9.2 | |||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
VAT | Tax | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
VATTYP | Tax type | M | 15 | 232 |