biuan SAP® BUSINESS ONE SDK
DTW Fixed Assets Depreciation Types
API Depreciation Types Service / Depreciation Type
ODTP - Fixed Assets Depreciation Types Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
15
PRIMARYYes
DescrDescriptionnVarChar
100
DprMethDepreciation MethodnVarChar
NO) No Depreciation
SL) Straight Line
SP) Straight Line Period Control
DB) Declining Balance
ML) Multilevel
WO) Immediate Write-Off
SD) Special Depreciation
MD) Manual Depreciation
CF) Accelerated
2
NO
DprToMinimum Depreciated ValueNum
20
RoundingRound Year End Book ValueVarChar
Y) Yes
N) No
1
Y
InclSalvInclude Salvage Value in Depr.VarChar
Y) Yes
N) No
1
N
SalvPercPercentage for Salvage ValueNum
20
PerAcqPeriod Control for AcquisitionnVarChar
PR) Pro Rata Temporis
HY) First Year Convention
6M) Half Year
FY) Full Year
2
PR
PerSubAcqPeriod Control SubacquisitionnVarChar
PR) Pro Rata Temporis
YR) Half Year Convention
FY) Full Year
2
PR
PerRetPeriod Control for RetirementnVarChar
PR) Pro Rata Temporis
YR) Half Year Convention
EL) After End of Useful Life
2
PR
AcqPRTypType of PRT for AcquisitionnVarChar
EDB) Exact Daily Base
FCP) First Day of Current Period
FNP) First Day of Next Period
3
EDB
SubPRTypType of PR for SubacquisitionnVarChar
EDB) Exact Daily Base
FCP) First Day of Current Period
FNP) First Day of Next Period
3
EDB
RetPRTypType of PR for RetirementnVarChar
EDB) Exact Daily Base
LPP) Last Day of Prior Period
LCP) Last Day of Current Period
3
EDB
PerDpRevDepreciation to Be Reversed %Num
20
ValidFromValid FromDate
8
19000101
ValidToValid ToDate
8
20991231
sCalcMethCalc. Method for Straight LinenVarChar
APC) Acquisition Value/Total Useful Life
PRC) Percentage of Acquisition Value
NBV) Net Book Value/Remaining Life
3
APC
sPercentPercentage for Straight LineNum
20
dBaseBase for Declining BalancenVarChar
NBV) Net Book Value
3
NBV
dPercentPercentage for Decl. BalanceNum
20
dFactorFactor for Declining BalanceNum
20
1
dAltDprTypAuto. Change Depreciation TypenVarChar
15ODTP
Fixed Assets Depreciation Types
maDecBaseReduce Depreciation BaseVarChar
Y) Yes
N) No
1
Y
spMethCalc. Method for Special Depr.VarChar
D) Additional
A) Alternative
1
D
spConcPerConcession Period in YearsInt
11
spMaxPercMaximum PercentageNum
20
spAdDprNormal DepreciationnVarChar
15ODTP
Fixed Assets Depreciation Types
spAlDprAlternative DepreciationnVarChar
15ODTP
Fixed Assets Depreciation Types
PoolIDDepreciation Type Pool IDnVarChar
2ODPP
Depreciation Type Pools
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
CreateDateCreate DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
DprPerDepreciation PeriodsVarChar
S) Standard
I) Individual
1
S
PerFactorPeriod FactorNum
20
1
spMaxAmntMaximum AmountNum
20
spMaxFlagMax. [Percentage\Amount]VarChar
P) Percentage
A) Amount
1
P
CalcBaseCalculation BaseVarChar
Y) Yearly
M) Monthly
1
Y
DeprEndLFYDepr. End at Last Full YearVarChar
Y) Yes
N) No
1
N
AccuPriorPAccu. Depr. of Prior PeriodsVarChar
Y) Yes
N) No
1
N
DeltaCoeffDelta CoefficientInt
11
0
MaxDeprMaximum Depreciable ValueNum
20
FactorFFYFactor Only Relevant to FFYVarChar
Y) Yes
N) No
1
N
SnapshotIdSnapshot IDInt
11
0
PerTranSouPeriod Control Transfer SourcenVarChar
PR) Pro Rata Temporis
2
PR
PerTranTarPeriod Control Transfer TargetnVarChar
PR) Pro Rata Temporis
2
PR
TranSPRTypType of PR for Transfer SourcenVarChar
EDB) Exact Daily Base
LPP) Last Day of Prior Period
LCP) Last Day of Current Period
3
EDB
TranTPRTypType of PR for Transfer TargetnVarChar
EDB) Exact Daily Base
FCP) First Day of Current Period
FNP) First Day of Next Period
3
EDB

Table relationship map

SELECT statement

SELECT ODTP.Code AS 'Code', ODTP.Descr AS 'Description', ODTP.DprMeth AS 'Depreciation Method', ODTP.DprTo AS 'Minimum Depreciated Value', ODTP.Rounding AS 'Round Year End Book Value', ODTP.InclSalv AS 'Include Salvage Value in Depr.', ODTP.SalvPerc AS 'Percentage for Salvage Value', ODTP.PerAcq AS 'Period Control for Acquisition', ODTP.PerSubAcq AS 'Period Control Subacquisition', ODTP.PerRet AS 'Period Control for Retirement', ODTP.AcqPRTyp AS 'Type of PRT for Acquisition', ODTP.SubPRTyp AS 'Type of PR for Subacquisition', ODTP.RetPRTyp AS 'Type of PR for Retirement', ODTP.PerDpRev AS 'Depreciation to Be Reversed %', ODTP.ValidFrom AS 'Valid From', ODTP.ValidTo AS 'Valid To', ODTP.sCalcMeth AS 'Calc. Method for Straight Line', ODTP.sPercent AS 'Percentage for Straight Line', ODTP.dBase AS 'Base for Declining Balance', ODTP.dPercent AS 'Percentage for Decl. Balance', ODTP.dFactor AS 'Factor for Declining Balance', ODTP.dAltDprTyp AS 'Auto. Change Depreciation Type', ODTP.maDecBase AS 'Reduce Depreciation Base', ODTP.spMeth AS 'Calc. Method for Special Depr.', ODTP.spConcPer AS 'Concession Period in Years', ODTP.spMaxPerc AS 'Maximum Percentage', ODTP.spAdDpr AS 'Normal Depreciation', ODTP.spAlDpr AS 'Alternative Depreciation', ODTP.PoolID AS 'Depreciation Type Pool ID', ODTP.DataSource AS 'Data Source', ODTP.UserSign AS 'User Signature', ODTP.LogInstanc AS 'Log Instance', ODTP.CreateDate AS 'Create Date', ODTP.UserSign2 AS 'Updating User', ODTP.UpdateDate AS 'Date of Update', ODTP.DprPer AS 'Depreciation Periods', ODTP.PerFactor AS 'Period Factor', ODTP.spMaxAmnt AS 'Maximum Amount', ODTP.spMaxFlag AS 'Max. [Percentage\Amount]', ODTP.CalcBase AS 'Calculation Base', ODTP.DeprEndLFY AS 'Depr. End at Last Full Year', ODTP.AccuPriorP AS 'Accu. Depr. of Prior Periods', ODTP.DeltaCoeff AS 'Delta Coefficient', ODTP.MaxDepr AS 'Maximum Depreciable Value', ODTP.FactorFFY AS 'Factor Only Relevant to FFY', ODTP.SnapshotId AS 'Snapshot ID', ODTP.PerTranSou AS 'Period Control Transfer Source', ODTP.PerTranTar AS 'Period Control Transfer Target', ODTP.TranSPRTyp AS 'Type of PR for Transfer Source', ODTP.TranTPRTyp AS 'Type of PR for Transfer Target' FROM ODTP AS ODTP

Related information


Depreciation Type DepreciationType Object· Table: ODTP
In SAP Business One, you can use depreciation types to define different depreciation calculation methods for your fixed assets. After you create a depreciation type, you can assign it to a specific depreciation area of an asset class. Then, by...
   Parent: Depreciation Types Service DepreciationTypesService Service· Table: ODTP

Depreciation Types Service DepreciationTypesService Service· Table: ODTP
The DepreciationTypesService service enables you to create, update, and view depreciation types. Source table: ODTP.

Fixed Assets Depreciation Types ODTP SQL Table

Depreciation Type Pools ODPP SQL Table

Users OUSR 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