Table TMPSITU
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPSITU | TSI | Temp. table Report DEPSITU | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TDE0 | EDTNUM+CPY+FCY+AASREF | No | |
| TDE1 | EDTNUM+AASREF | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AASDES1 | Description | DCO | ||||||
| AASREF | Asset | VC9 | ||||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=GVML_COGIMMO;ACCCOD;[V]GSUPCLE | Other | ||||
| ACCDES | Accounting code title | DCO | ||||||
| ACGGRP | Family | FAM | [FAM]FAM0=ACGGRP | Other | ||||
| ACGGRPDES | Family title | DCO | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CCE1 | Analytical dimension 1 | CCE | [CCE]CCE0=[TSI]CCE1 | BSRA | ||||
| CCE1DES | Description | DCO | ||||||
| CCE2 | Analytical dimension 2 | CCE | [CCE]CCE0=[TSI]CCE2 | BSRA | ||||
| CCE2DES | Description | DCO | ||||||
| CCE3 | Analytical dimension 3 | CCE | [CCE]CCE0=[TSI]CCE3 | BSRA | ||||
| CCE3DES | Description | DCO | ||||||
| CCE4 | Analytical dimension 4 | CCE | [CCE]CCE0=[TSI]CCE4 | BSRA | ||||
| CCE4DES | Description | DCO | ||||||
| CCE5 | Analytical dimension 5 | CCE | [CCE]CCE0=[TSI]CCE5 | BSRA | ||||
| CCE5DES | Description | DCO | ||||||
| CCE6 | Analytical dimension 6 | CCE | [CCE]CCE0=[TSI]CCE6 | BSRA | ||||
| CCE6DES | Description | DCO | ||||||
| CCE7 | Analytical dimension 7 | CCE | [CCE]CCE0=[TSI]CCE7 | BSRA | ||||
| CCE7DES | Description | DCO | ||||||
| CCE8 | Analytical dimension 8 | CCE | [CCE]CCE0=[TSI]CCE8 | BSRA | ||||
| CCE8DES | Description | DCO | ||||||
| CCE9 | Analytical dimension 9 | CCE | [CCE]CCE0=[TSI]CCE9 | BSRA | ||||
| CCE9DES | Description | DCO | ||||||
| CNX | Context | M | 25 | 3100 | ||||
| COA | Chart code | COA | [COA]COA0=[TSI]COA | Other | ||||
| CPY | Company | CPY | [CPY]CPY0=[TSI]CPY | Delete | ||||
| CPYNAM | Company name | NAM | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[TSI]CREUSR | Other | ||||
| DATISSPST | Issue date | D4 | ||||||
| DIE | Dimension type code | 9 | DIE | [DIE]DIE0=[TSI]DIE | Other | |||
| DPM | Depreciation method | DPM | ||||||
| DPRBAS | Reval. BS value | MD1 | ||||||
| DPRCUM | FY depre total | MD1 | ||||||
| DPRDUR | Depre. durn | DUR | ||||||
| DPRPLN | Depreciation plan | M | 25 | 3101 | ||||
| DPRRAT | Depreciation rate | RA1 | ||||||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Other | ||||
| DSPDES | Description | DCO | ||||||
| EDTNUM | Processing number | L | 8 | |||||
| ENDDPE | Fiscal Year charge | MD1 | ||||||
| ENDDPRDAT | Deprec end date | D4 | ||||||
| EXCDPR | FYR except deprec | MD1 | ||||||
| EXEIMLCUM | Cumulated exp. Y-1 | MD1 | ||||||
| EXETRFCUM | Depr rec transf FYR-1 | MD1 | ||||||
| EXTISSFLG | Provisional disposal | M | 4 | 1 | ||||
| FCY | Financial site | FCY | [FCY]FCY0=[TSI]FCY | Delete | ||||
| FCYNAM | Name | NAM | ||||||
| FIYENDDAT | Fiscal year end date | D4 | ||||||
| FIYSTRDAT | Fiscal year start date | D4 | ||||||
| FLGUPDISS | Disposal modification | M | 4 | 1 | ||||
| GAC | General account | GAC | [GAC]GAC0="";GAC | Other | ||||
| GACACN | CoA nature | M | 15 | 2628 | ||||
| GACDES | Account heading | DCO | ||||||
| IASACC | IFRS allocation | GAC | [GAC]GAC0="";IASACC | Other | ||||
| IASACCDES | Account heading | DCO | ||||||
| IASACN | IFRS nature | M | 15 | 2628 | ||||
| IASCGU | UGT | ADI | [ADI]CODE=613;IASCGU | Delete | ||||
| IASCGUDES | Description | DCO | ||||||
| IML | P impairment loss | MD1 | ||||||
| IMLBLC | Impairment loss balance | MD1 | ||||||
| IMLRVE | Impair. loss reversal P | MD1 | ||||||
| IMLRVETRF | Impair. rev. - exc depr. | MD1 | ||||||
| ISSDAT | Issue date | D4 | ||||||
| NBV | Net value | MD1 | ||||||
| OWNTYP | Holding type | M | 15 | 3171 | ||||
| PERCLOCUM | Periodic total P-1 | MD1 | ||||||
| PERCLOEXC | Office P-1 amt excep. | MD1 | ||||||
| PERENDDPE | Period P charge | MD1 | ||||||
| PEREXCDPR | Exceptional amortization | MD1 | ||||||
| PERIMLCUM | Depre total P-1 | MD1 | ||||||
| PERRVACUM | Acc. closed ps reval amt | MD1 | ||||||
| PERRVECUM | Acc. impair. rev. P-1 | MD1 | ||||||
| PERTRFCUM | Impair. loss rev. transf P-1 | MD1 | ||||||
| RSDVAL | Residual value | MD1 | ||||||
| RVAAMT | Revaluation amount | MD1 | ||||||
| STRDPRDAT | Depre start date | D4 | ||||||
| TCUMENDEXE | Depr. total FY end | MD1 | ||||||
| TCUMENDPER | Per end depr total | MD1 | ||||||
| TCUMSTREXE | Dep. merging FY start | MD1 | ||||||
| TCUMSTRPER | Per st dep total | MD1 | ||||||
| TDPEEXCEXE | Except charge | MD1 | ||||||
| TDPEEXCPER | Except charge | MD1 | ||||||
| TDPEEXE | Fiscal Year charge | MD1 | ||||||
| TDPEPER | Charge period | MD1 | ||||||
| TIMLBLCEXE | Impair. balance | MD1 | ||||||
| TIMLBLCPER | Impair. balance | MD1 | ||||||
| TIMLEXE | Impairment | MD1 | ||||||
| TIMLPER | Impairment | MD1 | ||||||
| TIMLRVEEXE | Depr. reversal | MD1 | ||||||
| TIMLRVEISS | Impair. rev./disposal | 15 | MD1 | |||||
| TIMLRVEPER | Depr. reversal | MD1 | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[TSI]UPDUSR | Other |