|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Fixed Assets Account Determination
Table Name: OADT
Table Description: Fixed Assets Account Determination
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | nVarChar | 15 | - | Â | Â | Â |
| Descr | Description | nVarChar | 100 | - | Â | Â | Â |
| BalanceAct | Asset Balance Sheet Account | nVarChar | 15 | OACT | Â | Â | Â |
| ClrAcqAct | Acquisition Clearing Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevResvAct | Revaluation Reserve | nVarChar | 15 | OACT | Â | Â | Â |
| OrdDprAct | Ordinary Depreciation | nVarChar | 15 | OACT | Â | Â | Â |
| OrdDprAcc | Accumulated Ordinary Depr. | nVarChar | 15 | OACT | Â | Â | Â |
| UnpDprAct | Unplanned Depreciation | nVarChar | 15 | OACT | Â | Â | Â |
| UnpDprAcc | Accumulated Unplanned Depr. | nVarChar | 15 | OACT | Â | Â | Â |
| SpDprAct | Special Depreciation | nVarChar | 15 | OACT | Â | Â | Â |
| SpDprAcc | Accumulated Special Depr. | nVarChar | 15 | OACT | Â | Â | Â |
| SaRevNAct | Revenue from Asset Sales (Net) | nVarChar | 15 | OACT | Â | Â | Â |
| ReExpNAct | Retirement with Expense (Net) | nVarChar | 15 | OACT | Â | Â | Â |
| ReRevNAct | Retirement with Revenue (Net) | nVarChar | 15 | OACT | Â | Â | Â |
| ReNBVeAct | NBV Retirement Expense (Gross) | nVarChar | 15 | OACT | Â | Â | Â |
| ReNBVrAct | NBV Retirement Revenue (Gross) | nVarChar | 15 | OACT | Â | Â | Â |
| ClrDscAct | Cash Discount Clearing Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevReAct | Revenue Account for Retirement | nVarChar | 15 | OACT | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| ClearAccRe | Revenue Clearing Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevResvClr | Revaluation Reserve Clearing | nVarChar | 15 | OACT | Â | Â | Â |
| SnapshotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| RevAct | Revaluation Account | nVarChar | 15 | OACT | Â | Â | Â |
| RevLossAct | Revaluation Loss | nVarChar | 15 | OACT | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |