|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Depreciation Run
Table Name: ODRN
Table Description: Depreciation Run
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| DocNum | Document Number | Int | 11 | - | Â | Â | Â |
| Series | Series | Int | 11 | NNM1 | Â | Â | Â |
| DprArea | Depreciation Area ID | nVarChar | 15 | ODPA | Â | Â | Â |
| Status | Status | VarChar | 1 | - | D | S | Depreciation Posted |
| Â | Â | Â | Â | Â | Â | N | No Depreciation Posted |
| Â | Â | Â | Â | Â | Â | C | Canceled |
| Â | Â | Â | Â | Â | Â | F | Failed |
| Â | Â | Â | Â | Â | Â | D | Â |
| Canceled | Canceled | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| RefDate | Posting Date | Date | 8 | - | Â | Â | Â |
| PeriodCat | Period Category ID | nVarChar | 10 | - | Â | Â | Â |
| PostPeriod | Posting Subperiod | Int | 11 | - | Â | Â | Â |
| KeyDate | Key Date | Date | 8 | - | Â | Â | Â |
| Remarks | Remarks | nVarChar | 32 | - | Â | Â | Â |
| NumOfJEs | No. of Journal Entries | Int | 11 | - | Â | Â | Â |
| SumOfDpr | Sum of Depreciation | Num | 19.6 | - | Â | Â | Â |
| SumByPro | Summarize by Project | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SumByDistr | Summarize by Distribution Rule | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TransType | Generate Document | nVarChar | 20 | - | -1 | -1 | None |
| Â | Â | Â | Â | Â | Â | 18 | A/P Invoice |
| TransAbs | Generate Doc. Abs. Entry | Int | 11 | - | Â | Â | Â |
| Handwrtten | Manual Numbering | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| BPLId | Branch | Int | 11 | - | Â | Â | Â |
| BPLName | Branch Name | nVarChar | 200 | - | Â | Â | Â |
| VatRegNum | VAT Reg. Number | nVarChar | 32 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Upgrade |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Auto Summary |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year of Transfer |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| NUM | No | DocNum |