|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Fixed Asset Depreciation Areas - History
Table Name: ADPA
Table Description: Fixed Asset Depreciation Areas - History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | nVarChar | 15 | - | Â | Â | Â |
| Descr | Description | nVarChar | 100 | - | Â | Â | Â |
| DirectDpr | Direct Depreciation | VarChar | 1 | - | D | D | Direct Posting |
| Â | Â | Â | Â | Â | Â | I | Indirect Posting |
| RetMeth | Retirement Method | VarChar | 1 | - | G | G | Gross |
| Â | Â | Â | Â | Â | Â | N | Net |
| AreaType | Area Type | VarChar | 1 | - | O | L | Posting to G/L |
| Â | Â | Â | Â | Â | Â | O | Additional Area |
| Â | Â | Â | Â | Â | Â | D | Derived Area |
| DrvdArea | Derived Area | nVarChar | 15 | ODPA | Â | Â | Â |
| 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 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| MainArea | Main Booking Area | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CreditCtrl | Tax Credit Control | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TaxType | Tax Type | Int | 11 | OSTT | Â | Â | Â |
| DirRevPost | Direct Revenue Posting | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SnapshotId | Snapshot ID | Int | 11 | - | 0 | Â | Â |
| BpTaxCorr | BP for Tax Correction | nVarChar | 15 | OCRD | Â | Â | Â |
| ItmTaxCorr | Item for Tax Correction | nVarChar | 50 | OITM | Â | Â | Â |
| UsgTaxCorr | Usage for Tax Correction | Int | 11 | OUSG | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |
| Â | Â | LogInstanc |