Table DEPREC
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DEPREC | DEP | Charge | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DEP0 | AASREF+DPRPLN+FIYENDDAT+PERENDDAT | No | |
| DEP2 | DPM+CPY | Yes | |
| DEP3 | CPY+DPRPLN+AASREF+FIYENDDAT+PERENDDAT | No | |
| DEP5 | AASREF+DPRPLN+FIYENDDAT+PERSTRDAT | No | |
| DEP6 | DEPSTA+CPY+CNX+FIYENDDAT+PERENDDAT | Yes | |
| DEP7 | FLGDEV+CPY+CNX+FIYENDDAT+PERENDDAT+DPRPLN | Yes | |
| DEP8 | CPY+FLGLNKDEV+CNX+FIYENDDAT+PERENDDAT | Yes | LNK |
| DEP9 | CPY+DPRPLN+FLGPSTLNK+FIYENDDAT+PERENDDAT | Yes | LNK |
| DEPA | CPY+DPRPLN+PERSTRDAT+PERENDDAT+FLGDEV | Yes |
| 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=[DEP]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=[DEP]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 | |||||
| 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=[DEP]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 | ||||
| KBIRDAT | Anniversary date | D4 | ||||||
| KBIRNBV | Anniv. net value | MD1 | ||||||
| KBIRNBVI | Anniv I net value | MD1 | ||||||
| KBIRNBVT | Anniv T net value | MD1 | ||||||
| KFIYNBMSTP | Depreciation stop | C | 4 | |||||
| KMDRDAT | Improvement date | D4 | KPL | |||||
| KMDRDEV | Improvement value | MD1 | KPL | |||||
| KNBMSTPDEP | Number of months of stop | C | 4 | |||||
| KSTPDEPSTA | Depreciation stop | M | 4 | 3289 | ||||
| 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 | ||||||
| NEWDUR | New duration | C | 4 | KPO | ||||
| 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 | ||||||
| TRFCADCUM | Amortization fund | MD1 | CCN | |||||
| UOM | Unit | UOM | [TUN]TUN0=[DEP]UOM | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DEP]UPDUSR | Other |