Table FXDLIFL
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| FXDLIFL | FLU | Track funds | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| FLU0 | AASREF+DPRPLN+TYP+FIYSTRDAT+PERSTRDAT+TXSCAT+FCY | No | |
| FLU1 | CODTXS+TXSCAT | Yes | |
| FLU2 | CPY+CNX+FLGSTATXS+FIYSTRDAT | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AASREF | Asset | VC9 | ||||||
| AASTYPEND | Type | M | 15 | 3151 | ||||
| AASTYPSTR | Type | M | 15 | 3151 | ||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=[V]GVML_COGIMMO;ACCCOD;COA | Other | ||||
| ACGGRP | Family | FAM | [FAM]FAM0=ACGGRP | Other | ||||
| ACNEND | Accounting nature | M | 15 | 2628 | ||||
| ACNSTR | Accounting nature | M | 15 | 2628 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BSEVALEND | End FY srce val | MD1 | ||||||
| BSEVALSTR | Init bal sht value | MD1 | ||||||
| CNX | Context | M | 25 | 3100 | ||||
| COA | Chart of accounts | COA | [COA]COA0=[FLU]COA | Block | ||||
| CODTXS | Funds code | A | 5 | |||||
| CPY | Company | CPY | [CPY]CPY0=[FLU]CPY | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[FLU]CREUSR | Other | ||||
| DCRDPEOUT | Disposal decrease | MD1 | ||||||
| DCRDPERVA | Revaluation | MD1 | ||||||
| DCRDPRFCY | Reduce transfer site | MD1 | ||||||
| DCRDPRTRF | Transfer decrease | MD1 | ||||||
| DCRFCY | Reduce transfer site | MD1 | ||||||
| DCRSAL | Sale decrease | MD1 | ||||||
| DCRTRF | Transfer decrease | MD1 | ||||||
| DERDPR | Book vs Tax expense | MD1 | ||||||
| DERFLGDF | Degressive method | M | 4 | 1 | ||||
| DERFLGEXC | Exceptional depreciations | M | 4 | 1 | ||||
| DERISS | Book vs Tax reversal | MD1 | ||||||
| DERRVE | Book vs Tax reversal | MD1 | ||||||
| DPE | Charges | MD1 | ||||||
| DPRBASEND | Gross end val | MD1 | ||||||
| DPRBASRVA | Depreciation base | MD1 | ||||||
| DPRBASSTR | Gross start val | MD1 | ||||||
| DPRCUMEND | Depreciations end | MD1 | ||||||
| DPRCUMSTR | Depreciations start | MD1 | ||||||
| DPRDEG | Decreasing deprec | MD1 | ||||||
| DPRLIN | Linear deprec. | MD1 | ||||||
| DPROTH | Other deprec. | MD1 | ||||||
| DPRPLN | Depreciation plan | M | 25 | 3101 | ||||
| DPRRAT | Depreciation rate | RA1 | ||||||
| DPRRAT2 | Depreciation rate | RA1 | ||||||
| ETRNAT | Recpt nature | M | 15 | 3157 | ||||
| EXCDPR | Exceptl deprn | MD1 | ||||||
| FCY | Site | FCY | [FCY]FCY0=[FLU]FCY | Delete | ||||
| FCYORI | Original site | FCY | [FCY]FCY0=[FLU]FCYORI | Block | ||||
| FIYENDDAT | Fiscal year end date | D4 | ||||||
| FIYSTRDAT | Fiscal year start date | D4 | ||||||
| FLGSTATXS | Funds status | M | 30 | 3266 | ||||
| GAC | General/IFRS acct. | GAC | [GAC]GAC0=COA;GAC | Other | ||||
| GAL | +/- value | MD1 | ||||||
| GRACUMEND | Subsidy amount | MD1 | ||||||
| GRACUMSTR | Subsidy amount | MD1 | ||||||
| IML | P impairment loss | MD1 | ||||||
| IMLCUMEND | Accumulated impairment loss | MD1 | ||||||
| IMLCUMSTR | Accumulated impairment loss | MD1 | ||||||
| IMLRVE | Impair. loss reversal P | MD1 | ||||||
| IMLRVEISS | Impair. rev./disposal | 15 | MD1 | |||||
| IMLRVETRF | Impair. rev. - exc depr. | MD1 | ||||||
| INCBUY | FY acquisition | MD1 | ||||||
| INCDPRFCY | Increase site transfer | MD1 | ||||||
| INCDPRTRF | Transfer increase | MD1 | ||||||
| INCFCY | Increase site transfer | MD1 | ||||||
| INCTRF | Transfer increase | MD1 | ||||||
| ISSAMT | Disposal amount | MD1 | ||||||
| ISSTYP | Disposal reason | M | 15 | 3159 | ||||
| NBVEND | Net value | MD1 | ||||||
| NBVSTR | Net value | MD1 | ||||||
| NSPVALEND | Market value | MD1 | ||||||
| NSPVALSTR | Market value | MD1 | ||||||
| NSPVALVAR | Market value | MD1 | ||||||
| OWNTYP | Holding type | M | 15 | 3171 | ||||
| PERENDDAT | Period end date | D4 | ||||||
| PERSTRDAT | Period start date | D4 | ||||||
| PURDAT | Purchase date | D4 | ||||||
| PURNAT | Purch nature | M | 15 | 3152 | ||||
| RVAAMT | Revaluation amount | MD1 | ||||||
| RVACUMEND | Revaluation | MD1 | ||||||
| RVACUMSTR | Revaluation | MD1 | ||||||
| RVARVEDPE | Revaluation | MD1 | ||||||
| RVARVEIML | Revaluation | MD1 | ||||||
| RVARVEISS | Revaluation | MD1 | ||||||
| SALCLSDATEND | Asset date for sale | D4 | ||||||
| SALCLSDATSTR | Asset date for sale | D4 | ||||||
| SALCLSVAR | Transfer | MD1 | ||||||
| STRDPRDAT | Depre start date | D4 | ||||||
| TXSCAT | Batch category | A | 15 | |||||
| TXSCATORI | File cat FYR st | A | 15 | |||||
| TXSCLA | Funds class | A | 2 | |||||
| TYP | Funds tracking type | M | 15 | 3127 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[FLU]UPDUSR | Other |