biuan SAP® BUSINESS ONE SDK
API DRN2
DRN2 - Depreciation Run - Posting - Asset Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ODRN
Depreciation Run
PRIMARYYes
AcctDtnAccount DeterminationnVarChar
15OADT
Fixed Assets Account Determination
ItemCodeItem CodenVarChar
20OITM
Items
OrdDprAmtOrdinary Depreciation AmountNum
20
SpDprAmtSpecial Depreciation AmountNum
20
RevReserveRevaluation Reserve AmountNum
20
AssetClassAsset ClassnVarChar
20OACS
Asset Classes

Table relationship map

SELECT statement

SELECT DRN2.DocEntry AS 'Document Internal ID', DRN2.AcctDtn AS 'Account Determination', DRN2.ItemCode AS 'Item Code', DRN2.OrdDprAmt AS 'Ordinary Depreciation Amount', DRN2.SpDprAmt AS 'Special Depreciation Amount', DRN2.RevReserve AS 'Revaluation Reserve Amount', DRN2.AssetClass AS 'Asset Class' FROM DRN2 AS DRN2

Related information


Fixed Assets Account Determination OADT SQL Table

Asset Classes OACS SQL Table

Depreciation Run ODRN SQL Table

Items OITM SQL Table



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