biuan SAP® BUSINESS ONE SDK
API ADT1
ADT1 - Depreciation Types - Rows - History 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 ADT1.Code AS 'Code', ADT1.Level AS 'Level', ADT1.Base AS 'Base', ADT1.Years AS 'Number of Years', ADT1.Percentage AS 'Percentage', ADT1.LogInstanc AS 'Log Instance', ADT1.Amount AS 'Amount', ADT1.SnapshotId AS 'Snapshot ID' FROM ADT1 AS ADT1

Related information


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