biuan SAP® BUSINESS ONE SDK
API ODRN
ODRN - Depreciation Run Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNumDocument NumberInt
11
SeriesSeriesInt
6NNM1
Documents Numbering - Series
DprAreaDepreciation Area IDnVarChar
15ODPA
Fixed Asset Depreciation Areas
StatusStatusVarChar
S) Depreciation Posted
N) No Depreciation Posted
C) Canceled
F) Failed
D)
1
D
CanceledCanceledVarChar
Y) Yes
N) No
1
N
RefDatePosting DateDate
8
PeriodCatPeriod Category IDnVarChar
10
PostPeriodPosting SubperiodInt
11
KeyDateKey DateDate
8
RemarksRemarksnVarChar
32
NumOfJEsNo. of Journal EntriesInt
11
SumOfDprSum of DepreciationNum
20
SumByProSummarize by ProjectVarChar
Y) Yes
N) No
1
N
SumByDistrSummarize by Distribution RuleVarChar
Y) Yes
N) No
1
N
TransTypeGenerate DocumentnVarChar
-1) None
18) A/P Invoice
20
-1
TransAbsGenerate Doc. Abs. EntryInt
11

Table relationship map

SELECT statement

SELECT ODRN.DocEntry AS 'Internal Number', ODRN.DocNum AS 'Document Number', ODRN.Series AS 'Series', ODRN.DprArea AS 'Depreciation Area ID', ODRN.Status AS 'Status', ODRN.Canceled AS 'Canceled', ODRN.RefDate AS 'Posting Date', ODRN.PeriodCat AS 'Period Category ID', ODRN.PostPeriod AS 'Posting Subperiod', ODRN.KeyDate AS 'Key Date', ODRN.Remarks AS 'Remarks', ODRN.NumOfJEs AS 'No. of Journal Entries', ODRN.SumOfDpr AS 'Sum of Depreciation', ODRN.SumByPro AS 'Summarize by Project', ODRN.SumByDistr AS 'Summarize by Distribution Rule', ODRN.TransType AS 'Generate Document', ODRN.TransAbs AS 'Generate Doc. Abs. Entry' FROM ODRN AS ODRN

Related information


ODRN SQL Table

Fixed Asset Depreciation Areas ODPA SQL Table

Documents Numbering - Series NNM1 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