biuan SAP® BUSINESS ONE SDK
SQL Finance / Fixed Asset Depreciation Areas / Fixed Asset Depreciation Areas
DTW Administration / Setup / Financials / Fixed Assets / Depreciation Areas / Fixed Asset Depreciation Areas
API Depreciation Areas Service / Depreciation Area
ODPA - Fixed Asset Depreciation Areas Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
15
PRIMARYYes
DescrDescriptionnVarChar
100
DirectDprDirect DepreciationVarChar
D) Direct Posting
I) Indirect Posting
1
D
RetMethRetirement MethodVarChar
G) Gross
N) Net
1
G
AreaTypeArea TypeVarChar
L) Posting to G/L
O) Additional Area
D) Derived Area
1
O
DrvdAreaDerived AreanVarChar
15ODPA
Fixed Asset Depreciation Areas
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
MainAreaMain Booking AreaVarChar
Y) Yes
N) No
1
N
CreditCtrlTax Credit ControlVarChar
Y) Yes
N) No
1
N
TaxTypeTax TypeInt
11OSTT
Sales Tax Authorities Type
DirRevPostDirect Revenue PostingVarChar
Y) Yes
N) No
1
N
SnapshotIdSnapshot IDInt
11
0
BpTaxCorrBP for Tax CorrectionnVarChar
15OCRD
Business Partner
ItmTaxCorrItem for Tax CorrectionnVarChar
20OITM
Items
UsgTaxCorrUsage for Tax CorrectionInt
11OUSG
Usage of Nota Fiscal

Table relationship map

SELECT statement

SELECT ODPA.Code AS 'Code', ODPA.Descr AS 'Description', ODPA.DirectDpr AS 'Direct Depreciation', ODPA.RetMeth AS 'Retirement Method', ODPA.AreaType AS 'Area Type', ODPA.DrvdArea AS 'Derived Area', ODPA.DataSource AS 'Data Source', ODPA.UserSign AS 'User Signature', ODPA.LogInstanc AS 'Log Instance', ODPA.CreateDate AS 'Creation Date', ODPA.UserSign2 AS 'Updating User', ODPA.UpdateDate AS 'Date of Update', ODPA.MainArea AS 'Main Booking Area', ODPA.CreditCtrl AS 'Tax Credit Control', ODPA.TaxType AS 'Tax Type', ODPA.DirRevPost AS 'Direct Revenue Posting', ODPA.SnapshotId AS 'Snapshot ID', ODPA.BpTaxCorr AS 'BP for Tax Correction', ODPA.ItmTaxCorr AS 'Item for Tax Correction', ODPA.UsgTaxCorr AS 'Usage for Tax Correction' FROM ODPA AS ODPA

Related information


Depreciation Area DepreciationArea Object· Table: ODPA
In SAP Business One, you can use different depreciation areas for showing the value of fixed assets for a specific purpose. Source table: ODPA.
   Parent: Depreciation Areas Service DepreciationAreasService Service· Table: ODPA

Depreciation Areas Service DepreciationAreasService Service· Table: ODPA
The DepreciationAreasService service enables you to create, update, and view depreciation areas. Source table: ODPA.

Fixed Asset Depreciation Areas ODPA SQL Table

Business Partner OCRD SQL Table

Items OITM SQL Table

Sales Tax Authorities Type OSTT SQL Table

Users OUSR SQL Table

Usage of Nota Fiscal OUSG SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates