biuan SAP® BUSINESS ONE SDK
API Depreciation Level Collection / Depreciation Level
DTP1 - Depreciation Types - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodenVarChar
15ODTP
Fixed Assets Depreciation Types
PRIMARYYes
LevelLevelInt
11
BaseBasenVarChar
APC) Acquisition Value
NBV) Net Book Value
3
APC
YearsNumber of YearsInt
11
PercentagePercentageNum
20
LogInstancLog InstanceInt
11
0
AmountAmountNum
20
SnapshotIdSnapshot IDInt
11
0

SELECT statement

SELECT DTP1.Code AS 'Code', DTP1.Level AS 'Level', DTP1.Base AS 'Base', DTP1.Years AS 'Number of Years', DTP1.Percentage AS 'Percentage', DTP1.LogInstanc AS 'Log Instance', DTP1.Amount AS 'Amount', DTP1.SnapshotId AS 'Snapshot ID' FROM DTP1 AS DTP1

Related information


Depreciation Level DepreciationLevel Object· Table: DTP1
DepreciationLevel is a child object of DepreciationType object. You can view an asset's useful life as several phases and depreciate the asset by a defined rate for each phase. This way, the asset can have a course of depreciation that changes...
   Parent: Depreciation Level Collection DepreciationLevelCollection Collection
Fixed Assets Depreciation Types ODTP 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