Table VATHIS
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
VATHIS | VAT | Tax - history | Fixed Assets |
Key | Description | Duplicates | Activity code |
---|---|---|---|
VAT0 | AASREF+DPRPLN+DATVATREG+TIMSTP | No | |
VAT1 | AASREF+DPRPLN+VATREGTYP+DATVATREG+TIMSTP | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AASBUS | Activity | VC9 | ||||||
AASBUSO | Activity | VC9 | ||||||
AASREF | Asset | VC9 | ||||||
ACGETRNOT | Receipt value ex-tax | MD1 | ||||||
ADMCOE | Admission coef. | RAT | ||||||
ADMCOEF | Admission coef. | RAT | ||||||
ADMCOEFO | Admission coef. | RAT | ||||||
ADMCOEO | Admission coef. | RAT | ||||||
ADMCOER | Admission coef. | RAT | ||||||
ADMCOERO | Admission coef. | RAT | ||||||
ASJCOE | Liability coef. | RAT | ||||||
ASJCOEF | Liability coef. | RAT | ||||||
ASJCOEFO | Liability coef. | RAT | ||||||
ASJCOEO | Liability coef. | RAT | ||||||
ASJCOER | Liability coef. | RAT | ||||||
ASJCOERO | Liability coef. | RAT | ||||||
AUUID | Single identifier | AUUID | ||||||
BASDEV | Bal sheet val vari | MD1 | ||||||
CPY | Company | CPY | [CPY]CPY0=[VAT]CPY | Delete | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[VAT]CREUSR | Other | ||||
DATVATREG | Date | D4 | ||||||
DEDCOE | Deduction coef | RAT | ||||||
DEDCOEF | Deduction coef | RAT | ||||||
DEDCOEFO | Deduction coef | RAT | ||||||
DEDCOEO | Deduction coef | RAT | ||||||
DEDCOER | Deduction coef | RAT | ||||||
DEDCOERO | Deduction coef | RAT | ||||||
DEDVATAMT | VAT recovered | MD1 | ||||||
DEDVATAMTO | VAT recovered | MD1 | ||||||
DEDVATFLG | Forced rec VAT | M | 4 | 1 | ||||
DPRBAS | Basis after update | MD1 | ||||||
DPRBASO | Basis before adj. | MD1 | ||||||
DPRPLN | Depreciation plan | M | 25 | 3101 | ||||
FCY | Financial site | FCY | [FCY]FCY0=[VAT]FCY | Block | ||||
FORMULE | Formula | A | 50 | |||||
ISSVATAMT | VAT due on disposal | MD1 | ||||||
ISSVATFLG | Forced disposal VAT | MZS | 4 | |||||
IVCVATAMT | VAT invoiced | MD1 | ||||||
IVCVATAMTO | VAT invoiced | MD1 | ||||||
IVCVATFLG | Invoiced VAT forced | MZS | 4 | |||||
IVCVATRAT | Invd VAT rate | RAT | ||||||
PYBVATTYP | VAT repayment | M | 15 | 3160 | ||||
TAXCOE | Taxation coeff | RAT | ||||||
TAXCOEF | Taxation coeff | RAT | ||||||
TAXCOEFLG | Forced taxation coef | M | 4 | 1 | ||||
TAXCOEFLGO | Forced taxation coef | M | 4 | 1 | ||||
TAXCOEFO | Taxation coeff | RAT | ||||||
TAXCOEO | Taxation coeff | RAT | ||||||
TAXCOER | Taxation coeff | RAT | ||||||
TAXCOERO | Taxation coeff | RAT | ||||||
THESLI | Adujst period | DUR | ||||||
TIMSTP | Time stamp | A | 20 | |||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[VAT]UPDUSR | Other | ||||
VATREGAMT | VAT repay adj. | MD1 | ||||||
VATREGCUM | VAT adj total | MD1 | ||||||
VATREGDATO | Reference date | D4 | ||||||
VATREGDED | VAT ded adj. | MD1 | ||||||
VATREGTYP | Tax adjust type | M | 25 | 3269 | ||||
VATRSD | Residual duration | DUR | ||||||
VATYEAFLG | Yearly adjust. index | M | 4 | 1 |