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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ODRN
Depreciation Run
PRIMARYYes
AcctDtnAccount DeterminationnVarChar
15OADT
Fixed Assets Account Determination
TransIdTransaction NumberInt
11OJDT
Journal Entry
OrdDprActOrdinary Depreciation AccountnVarChar
15OACT
G/L Accounts
SpDprActSpecial Depreciation AccountnVarChar
15OACT
G/L Accounts
SpBalActSpecial Balance AccountnVarChar
15OACT
G/L Accounts
OrdBalActOrdinary Balance AccountnVarChar
15OACT
G/L Accounts
OrdDprAmtOrdinary Depreciation AmountNum
20
SpDprAmtSpecial Depreciation AmountNum
20
RevResActRevaluation Reserve AccountnVarChar
15OACT
G/L Accounts
RevResClrRevaluation Reserve ClearingnVarChar
15OACT
G/L Accounts
RevReserveRevaluation Reserve AmountNum
20
AssetClassAsset ClassnVarChar
20OACS
Asset Classes
CancelIdCancelation Transaction No.Int
11

Table relationship map

SELECT statement

SELECT DRN1.DocEntry AS 'Document Internal ID', DRN1.AcctDtn AS 'Account Determination', DRN1.TransId AS 'Transaction Number', DRN1.OrdDprAct AS 'Ordinary Depreciation Account', DRN1.SpDprAct AS 'Special Depreciation Account', DRN1.SpBalAct AS 'Special Balance Account', DRN1.OrdBalAct AS 'Ordinary Balance Account', DRN1.OrdDprAmt AS 'Ordinary Depreciation Amount', DRN1.SpDprAmt AS 'Special Depreciation Amount', DRN1.RevResAct AS 'Revaluation Reserve Account', DRN1.RevResClr AS 'Revaluation Reserve Clearing', DRN1.RevReserve AS 'Revaluation Reserve Amount', DRN1.AssetClass AS 'Asset Class', DRN1.CancelId AS 'Cancelation Transaction No.' FROM DRN1 AS DRN1

Related information


Fixed Assets Account Determination OADT SQL Table

Asset Classes OACS SQL Table

Depreciation Run ODRN SQL Table

G/L Accounts OACT SQL Table

Journal Entry OJDT 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