|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Fixed Asset Transaction - Rows
Table Name: FIX1
Table Description: Fixed Asset Transaction - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OFIX | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| DprArea | Depreciation Area ID | nVarChar | 15 | ODPA | Â | Â | Â |
| PeriodCat | Period Category ID | nVarChar | 10 | - | Â | Â | Â |
| PostPeriod | Posting Subperiod | Int | 11 | - | Â | Â | Â |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| APC | APC | Num | 19.6 | - | Â | Â | Â |
| OrdDpr | Ordinary Depreciation | Num | 19.6 | - | Â | Â | Â |
| UnpDpr | Unplanned Depreciation | Num | 19.6 | - | Â | Â | Â |
| SpDprKey1 | Special Depreciation Key 01 | nVarChar | 2 | ODPP | Â | Â | Â |
| SpDpr1 | Special Depreciation 01 | Num | 19.6 | - | Â | Â | Â |
| Qty | Quantity | Num | 19.6 | - | Â | Â | Â |
| DprType | New Depreciation Type | nVarChar | 15 | ODTP | Â | Â | Â |
| DprDate | New Depreciation Start Date | Date | 8 | - | Â | Â | Â |
| RemLife | New Remaining Life | Int | 11 | - | Â | Â | Â |
| SalvageVal | New Salvage Value | Num | 19.6 | - | Â | Â | Â |
| RecvAsst | Receiving Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| RetirDate | Retirement Date | Date | 8 | - | Â | Â | Â |
| SpDprKey2 | Special Depreciation Key 02 | nVarChar | 2 | ODPP | Â | Â | Â |
| SpDpr2 | Special Depreciation 02 | Num | 19.6 | - | Â | Â | Â |
| SpDprKey3 | Special Depreciation Key 03 | nVarChar | 2 | ODPP | Â | Â | Â |
| TransType | Transaction Type | nVarChar | 4 | - | Â | 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 Unplanned Depreciation |
| Â | Â | Â | Â | Â | Â | 430 | Manual Special Depreciation |
| Â | Â | Â | Â | Â | Â | 440 | Appreciation |
| Â | Â | Â | Â | Â | Â | 550 | Revaluation |
| Â | Â | Â | Â | Â | Â | 510 | Change of Depreciation Type |
| Â | Â | Â | Â | Â | Â | 520 | Change of Useful Life |
| Â | Â | Â | Â | Â | Â | 530 | Change of Depreciation Start Date |
| Â | Â | Â | Â | Â | Â | 540 | Change of Salvage Value |
| Â | Â | Â | Â | Â | Â | 560 | Change of Period Control |
| Â | Â | Â | Â | Â | Â | 570 | Change of Total Units |
| UsefulLife | New Useful Life | Int | 11 | - | Â | Â | Â |
| Appr | Appreciation | Num | 19.6 | - | Â | Â | Â |
| WriteUp | Write-Up | Num | 19.6 | - | Â | Â | Â |
| DeltaDays | Delta Remaining Life in Days | Int | 11 | - | Â | Â | Â |
| NewAstCls | New Asset Class | nVarChar | 20 | OACS | Â | Â | Â |
| HistOrdDpr | Historical Ordinary Depr. | Num | 19.6 | - | Â | Â | Â |
| SpDpr3 | Special Depreciation 03 | Num | 19.6 | - | Â | Â | Â |
| TransAmnt | Transaction Amount | Num | 19.6 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 254 | - | Â | Â | Â |
| ReTranType | Receiving Transaction Type | nVarChar | 4 | - | 0 | 0 | Unknown |
| Â | Â | Â | Â | Â | Â | 110 | Acquisition |
| Â | Â | Â | Â | Â | Â | 115 | Subacquisition |
| NewTtlUnit | New Total Unit | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineNum |
| SECONDARY | No | DprArea |
| Â | Â | PeriodCat |
| Â | Â | ItemCode |