|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Fixed Asset Revaluation - Rows
Table Name: AFAR1
Table Description: Fixed Asset Revaluation - Rows
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | OFAR | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| NBV | NBV | Num | 19.6 | - | Â | Â | Â |
| New_NBV | New NBV | Num | 19.6 | - | Â | Â | Â |
| Remarks | Remarks | nVarChar | 100 | - | Â | Â | Â |
| RevalPerc | Revaluation Percentage % | Num | 19.6 | - | Â | Â | Â |
| OrdDprDur | Ordinary Depr. During Period | Num | 19.6 | - | Â | Â | Â |
| UnDpDur | Unplanned Depr. During Period | Num | 19.6 | - | Â | Â | Â |
| SpDprDur | Special Depr. During Period | Num | 19.6 | - | Â | Â | Â |
| WriteUpDur | Write-Up During Period | Num | 19.6 | - | Â | Â | Â |
| RevLossDur | Revaluation Loss During Period | Num | 19.6 | - | Â | Â | Â |
| ReserveDur | Reserve During Period | Num | 19.6 | - | Â | Â | Â |
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode2 | Distribution Rule 2 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode3 | Distribution Rule 3 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode4 | Distribution Rule 4 | nVarChar | 8 | OOCR | Â | Â | Â |
| OcrCode5 | Distribution Rule 5 | nVarChar | 8 | OOCR | Â | Â | Â |
| Project | Project Code | nVarChar | 20 | OPRJ | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |
| Â | Â | LogInstanc |