biuan SAP® BUSINESS ONE SDK
DTW Administration / System Initialization / User Languages
API ODAR
ODAR - Data Archiving Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUENumeratorInt
11
PRIMARYYes
PeriodDatePeriod DateDate
8
UserSignUser SignatureInt
6
CreateDateArchive DateDate
8
CreateTimeArchive TimeInt
6
VersionNumVersion NumberInt
11
JEPerLenJournal Entry Period LengthVarChar
A) Period
S) Sub-period
M) Month
1
A
JERef1Journal Entry Reference 1nVarChar
100
JERef2Journal Entry Reference 2nVarChar
100
JEMemoJournal Entry RemarksnVarChar
50
JEByProjJournal Entry By ProjectVarChar
Y) Yes
N) No
1
N
JEByProfJournal Entry By Dist. RuleVarChar
Y) Yes
N) No
1
N
INPerLenInventory Period LengthVarChar
A) Period
S) Sub-period
M) Month
1
A
INPriceSrcInventory Price SourceInt
6OPLN
Price Lists
INRef1Inventory Reference 1nVarChar
11
INRef2Inventory Reference 2nVarChar
11
INMemoInventory RemarksnVarChar
127
JEByCurrJournal Entry by CurrencyVarChar
Y) Yes
N) No
1
N
JEByDIM2Journal Entry by Dimension 2VarChar
Y) Yes
N) No
1
N
JEByDIM3Journal Entry by Dimension 3VarChar
Y) Yes
N) No
1
N
JEByDIM4Journal Entry by Dimension 4VarChar
Y) Yes
N) No
1
N
JEByDIM5Journal Entry by Dimension 5VarChar
Y) Yes
N) No
1
N
DBReducDB Reduction (MB)Num
20
DBReducPerDB Reduction (%)Num
20
TrandReducTransaction ReductionInt
11
TranReducPTransaction Reduction (%)Num
20
INZeroPrcInventory Zero PriceVarChar
Y) Yes
N) No
1
N
TranRedArPTrans. Reduc. Archived (%)Num
20
DelNonRecoDelete nonreconciled OBNK lnsVarChar
Y) Yes
N) No
1
N
RunNameData Archive Run NamenVarChar
50
RODBGUIDReadonly DB GUID for ArchivingnVarChar
32
ArchMethodArchive MethodVarChar
F) By Financial Period
B) By Business Partner
1
F

SELECT statement

SELECT ODAR.AbsEntry AS 'Numerator', ODAR.PeriodDate AS 'Period Date', ODAR.UserSign AS 'User Signature', ODAR.CreateDate AS 'Archive Date', ODAR.CreateTime AS 'Archive Time', ODAR.VersionNum AS 'Version Number', ODAR.JEPerLen AS 'Journal Entry Period Length', ODAR.JERef1 AS 'Journal Entry Reference 1', ODAR.JERef2 AS 'Journal Entry Reference 2', ODAR.JEMemo AS 'Journal Entry Remarks', ODAR.JEByProj AS 'Journal Entry By Project', ODAR.JEByProf AS 'Journal Entry By Dist. Rule', ODAR.INPerLen AS 'Inventory Period Length', ODAR.INPriceSrc AS 'Inventory Price Source', ODAR.INRef1 AS 'Inventory Reference 1', ODAR.INRef2 AS 'Inventory Reference 2', ODAR.INMemo AS 'Inventory Remarks', ODAR.JEByCurr AS 'Journal Entry by Currency', ODAR.JEByDIM2 AS 'Journal Entry by Dimension 2', ODAR.JEByDIM3 AS 'Journal Entry by Dimension 3', ODAR.JEByDIM4 AS 'Journal Entry by Dimension 4', ODAR.JEByDIM5 AS 'Journal Entry by Dimension 5', ODAR.DBReduc AS 'DB Reduction (MB)', ODAR.DBReducPer AS 'DB Reduction (%)', ODAR.TrandReduc AS 'Transaction Reduction', ODAR.TranReducP AS 'Transaction Reduction (%)', ODAR.INZeroPrc AS 'Inventory Zero Price', ODAR.TranRedArP AS 'Trans. Reduc. Archived (%)', ODAR.DelNonReco AS 'Delete nonreconciled OBNK lns', ODAR.RunName AS 'Data Archive Run Name', ODAR.RODBGUID AS 'Readonly DB GUID for Archiving', ODAR.ArchMethod AS 'Archive Method' FROM ODAR AS ODAR

Related information


Price Lists OPLN 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