Dictionary >  Module Fixed Assets >  Table Track funds  

Display all Hide all

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