| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Internal Number | int | 11 | 0 | OFIX | | | Allow NULL? |
| 2 | LineNum | Row Number | int | 11 | 0 | | | | Allow NULL? |
| 3 | ItemCode | Item Code | nvarchar | 50 | 0 | OITM | | | Allow NULL? |
| 4 | DprArea | Depreciation Area ID | nvarchar | 15 | 0 | ODPA | | | Allow NULL? |
| 5 | PeriodCat | Period Category ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | PostPeriod | Posting Subperiod | int | 11 | 0 | | | | Allow NULL? |
| 7 | RefDate | Posting Date | date | 8 | 0 | | | | |
| 8 | APC | APC | num | 19 | 6 | | | | Allow NULL? |
| 9 | OrdDpr | Ordinary Depreciation | num | 19 | 6 | | | | Allow NULL? |
| 10 | UnpDpr | Unplanned Depreciation | num | 19 | 6 | | | | Allow NULL? |
| 11 | SpDprKey1 | Special Depreciation Key 01 | nvarchar | 2 | 0 | ODPP | | | Allow NULL? |
| 12 | SpDpr1 | Special Depreciation 01 | num | 19 | 6 | | | | Allow NULL? |
| 13 | Qty | Quantity | num | 19 | 6 | | | | Allow NULL? |
| 14 | DprType | New Depreciation Type | nvarchar | 15 | 0 | ODTP | | | Allow NULL? |
| 15 | DprDate | New Depreciation Start Date | date | 8 | 0 | | | | |
| 16 | RemLife | New Remaining Life | int | 11 | 0 | | | | Allow NULL? |
| 17 | SalvageVal | New Salvage Value | num | 19 | 6 | | | | Allow NULL? |
| 18 | RecvAsst | Receiving Item Code | nvarchar | 50 | 0 | OITM | | | Allow NULL? |
| 19 | RetirDate | Retirement Date | date | 8 | 0 | | | | |
| 20 | SpDprKey2 | Special Depreciation Key 02 | nvarchar | 2 | 0 | ODPP | | | Allow NULL? |
| 21 | SpDpr2 | Special Depreciation 02 | num | 19 | 6 | | | | Allow NULL? |
| 22 | SpDprKey3 | Special Depreciation Key 03 | nvarchar | 2 | 0 | ODPP | | | Allow NULL? |
| 23 | TransType | Transaction Type | nvarchar | 4 | 0 | | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 260=Low Value Asset Full Retirement, 270=Low Value Asset Full Scrapping, 310=Full Transfer, 320=Partial Transfer, 330=Asset Class Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unp | Allow NULL? |
| 24 | UsefulLife | New Useful Life | int | 11 | 0 | | | | Allow NULL? |
| 25 | Appr | Appreciation | num | 19 | 6 | | | | Allow NULL? |
| 26 | WriteUp | Write-Up | num | 19 | 6 | | | | Allow NULL? |
| 27 | DeltaDays | Delta Remaining Life in Days | int | 11 | 0 | | | | Allow NULL? |
| 28 | NewAstCls | New Asset Class | nvarchar | 20 | 0 | OACS | | | Allow NULL? |
| 29 | HistOrdDpr | Historical Ordinary Depr. | num | 19 | 6 | | | | Allow NULL? |
| 30 | SpDpr3 | Special Depreciation 03 | num | 19 | 6 | | | | Allow NULL? |
| 31 | TransAmnt | Transaction Amount | num | 19 | 6 | | | | Allow NULL? |
| 32 | Remark | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 33 | ReTranType | Receiving Transaction Type | nvarchar | 4 | 0 | | 0 | 0=Unknown, 110=Acquisition, 115=Subacquisition | Allow NULL? |
| 34 | NewTtlUnit | New Total Unit | int | 11 | 0 | | | | Allow NULL? |
