Table Abbreviation Description Module Activity code
DEPRECARC DEA Charge archive Fixed Assets  

Key Description Duplicates Activity code
DEP0 AASREF+DPRPLN+EVT+TIMSTP+FIYENDDAT+PERENDDAT No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AASREF Asset   VC9          
ACLCOE Acceleration coeff.   RA1          
ALWAMT Spc FYR rule amt   MD1          
ALWAMTFLG Forc spc FYR rule amt   MZS 4        
ALWCOD Spec rule type   M 15 3168      
ALWCUM Spc FYR rule tot   MD1          
ALWCUMFLG Forced spc rule tot   MZS 4        
APLDUR Applied duration   DUR          
AUUID Single identifier   AUUID          
BSEVAL Init bal sht value   MD1          
CADCRBDEV Cad. fund decr. to be posted   MD1         CCN
CNX Context   M 25 3100      
CPY Company   CPY     [CPY]CPY0=[DEA]CPY Delete  
CRBAMT Reintegrtd amount   MD1          
CRBCUM Reintegrtd total   MD1          
CRBCUMFLG Cumul réint forced   MZS 4        
CRBVEHCOD Vehicle reint cap   ADI     [ADI]CODE=531;CRBVEHCOD Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DEA]CREUSR Other  
DEPSTA Detailed status   M 15 3110      
DERDEV B. vs T. to post   MD1          
DERRVEDEV B. vs T. rev. to post   MD1          
DFD Deferred deprec   MD1          
DFDBLC Deferred deprec balance   MD1          
DFDLIM Differable amt.   MD1          
DFDRVE Deferred reversal   MD1          
DPEDEV Charge to post   MD1          
DPEI PAC charge   MD1          
DPET Theo charge   MD1          
DPM Depreciation method   DPM          
DPMI Initial method used   DPM          
DPMT Theoretical method used   DPM          
DPRBAS Reval. BS value   MD1          
DPRCUM FY depre total   MD1          
DPRCUMFLG FYR forc deprec tot   MZS 4        
DPRDUR Depre. durn   DUR          
DPRPLN Depreciation plan   M 25 3101      
DPRRAT Depreciation rate   RA1          
DPRRAT2 Depreciation rate   RA1          
DPRRATFLG Forced deprec rate   MZS 4        
ENDDPE Fiscal Year charge   MD1          
ENDDPEFLG Forced FY charge   M 4 1      
ENDDPEI Yearly deprec. init.   MD1          
ENDDPET Yearly deprec. theo   MD1          
ENDDPRDAT Deprec end date   D4          
ENDDPRFLG Forced deprec. amt   M 4 1      
ETRPNT Entry point   C 1        
EVT Event type   ADI     [ADI]CODE=962;EVT Delete  
EXCCUM Total excep. amt   MD1          
EXCCUMI Acc excep deprec I   MD1          
EXCCUMT Exc FY-1 theo   MD1          
EXCDEV FY to post   MD1          
EXCDPR FYR except deprec   MD1          
EXCDPRI I FY exc deprec   MD1          
EXCDPRT T FY exc deprec   MD1          
EXECLOCUMI Init cuml clos FY   MD1          
EXECLOCUMT Theo cumul clos FY   MD1          
EXEIMLCUM Cumulated exp. Y-1   MD1          
EXERVADEV Closed FY total reval. surpl.   MD1          
EXERVECUM Acc. impair. rev. FY-1   MD1          
EXETRFCUM Depr rec transf FYR-1   MD1          
EXTIMLTYP External reason depr   ADI     [ADI]CODE=516;EXTIMLTYP Block  
FCY Financial site   FCY     [FCY]FCY0=[DEA]FCY Delete  
FIYENDDAT Fiscal year end date   D4          
FIYQTY FY units   QTY          
FIYSTRDAT Fiscal year start date   D4          
FLGDEV To post   M 4 1      
FLGLNKDEV To post   M 4 1      
FLGMIG Migrated   M 4 1      
FLGPST Posted   M 4 1      
FLGPSTLNK Posted   M 4 1      
FLGUPDISS Disposal modification   M 4 1      
IML P impairment loss   MD1          
IMLBLC Impairment loss balance   MD1          
IMLFLG Forced impairment loss   MZS 4        
IMLRVE Impair. loss reversal P   MD1          
IMLRVEFLG Reversal of forced impairment loss   MZS 4        
IMLRVELIM Reversal cap   MD1          
IMLRVETRF Impair. rev. - exc depr.   MD1          
IMLTYP Impairment loss type   M 15 3280      
INTIMLTYP Internal reason depr   ADI     [ADI]CODE=519;INTIMLTYP Block  
KBIRNBV Anniv. net value   DCB 19.8       KRU
KFIYNBMSTP Depreciation stop   C 4       KRU
LEG Legal link amt   MD1          
LEGCUM Plan E-1 llegal link total   MD1          
LEGRVE Legal link recovery   MD1          
LEGRVECUM Plan E-1 legal link rec.tot   MD1          
LNK Amount plan link   MD1          
LNKCUM Plan E-1 link total   MD1          
LNKDEV Variance to post   MD1          
LSTCLODAT Closing date   D4          
MTCDEVADJ Rec. meth chge var   M 15 3169      
MTCDPEDAT Methd chge date   D4          
MTCDPEDEV Meth chge depr var   MD1          
MTCDPEDEVI Meth chge depr var   MD1          
MTCDPEDEVT Meth chge depr var   MD1          
MTCTIADAT Chge effective date   D4          
MTCTIATYP Chg effective start   M 15 3268      
NBV Net value   MD1          
NBVI Init net value   MD1          
NBVT Theor net value   MD1          
NSPVAL Market value   MD1          
PERCADCRB Amort. fund decrease   MD1         CCN
PERCLOCUM Periodic total P-1   MD1          
PERCLOCUMI Init cumul per clos   MD1          
PERCLOCUMT Theo cumul clos per   MD1          
PERCLOEXC Office P-1 amt excep.   MD1          
PERCLOEXCI Acc P-1 exc depr I   MD1          
PERCLOEXCT Acc P-1 exc depr T   MD1          
PERDPEFLG Per forced charge   M 4 1      
PERENDDAT Period end date   D4          
PERENDDPE Period P charge   MD1          
PEREXCDPR Exceptional amortization   MD1          
PEREXCDPRI Excep per deprec I   MD1          
PEREXCDPRT Excep per deprec T   MD1          
PERIMLCUM Depre total P-1   MD1          
PERLEGCUM Plan P-1 legal link total   MD1          
PERLEGRVE Plan P-1 legal link rec.tot   MD1          
PERLNKCUM Plan P-1 link total   MD1          
PERQTY Period unit   QTY          
PERQTYCUM Total period P-1 OPE   QTY          
PERREFCLC Calculation period   D4          
PERREFCLCI Per. for I calculation   D4          
PERREFCLCT Per. for T calculation   D4          
PERRVACUM Acc. closed ps reval amt   MD1          
PERRVADEV Closed P total reval. surpl.   MD1          
PERRVECUM Acc. impair. rev. P-1   MD1          
PERSTRDAT Period start date   D4          
PERTRFCUM Impair. loss rev. transf P-1   MD1          
PRATYP Prorata   M 15 3105      
PSTCADCRB Cad. fund decr. posted   MD1         CCN
PSTDER B. vs T. posted   MD1          
PSTDERRVE Book vs tax rev. posted   MD1          
PSTDPE Posted charge   MD1          
PSTEXC FYR posted   MD1          
PSTLNK Posted variance   MD1          
PSTRVACRB Re-ev. rec. posted   MD1          
PSTRVETRF Posted rec trf   MD1          
P_1CADCRB Decr. tot. P-1   MD1         CCN
RATCUR Currency rate   RCU          
RSDDUR Residual duration   DUR          
RSDQTY Start period residual duratn OPE   QTY          
RSDVAL Residual value   MD1          
RVAAMT Revaluation amount   MD1          
RVACOE Revaluation coef   COE          
RVACOEREF Table reference   A 20        
RVACRB Revaluation reversal   MD1          
RVACRBDEV Re-eval rec. to be posted   MD1          
RVADAT Revaluation date   D4          
RVATIADAT Reval. effective start   M 15 3273      
RVATYP Revaluation type   M 15 3253      
RVETRFDEV Depr rec trf to be posted   MD1          
STRDPRDAT Depre start date   D4          
TIMSTP Time stamp   A 20        
TRFCADCUM Amortization fund   MD1         CCN
UOM Unit   UOM     [TUN]TUN0=[DEA]UOM Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DEA]UPDUSR Other