SAP Business One SDK 10.0 - Database Tables Reference
-
Table Name: ODPA
Table Description: Fixed Asset Depreciation Areas
| 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 |
OUSR |
|
|
|
| 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 |