biuan SAP® BUSINESS ONE SDK
API OMRL
OMRL - Advanced Inventory Revaluation Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEY UNIQUEDocument NumberInt
11
NUMYes
Series KEYSeriesInt
6
0SERIESNo
DocDatePosting DateDate
8
RevalTypeInventory Valuation TypeVarChar
P) Price Change
M) Inventory Debit/Credit
1
P
HandwrttenManual NumberingVarChar
1
N
PrintedPrintedVarChar
Y) Copy
N) Original
1
N
TransferedYear TransferVarChar
Y) Yes
N) No
1
N
DocCurDocument CurrencynVarChar
3
DocRateDocument RateNum
20
Ref2Reference 2nVarChar
11
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
DocTimeGeneration TimeInt
6
ConfirmedConfirmedVarChar
Y) Yes
N) No
1
Y
InstanceInstanceInt
6
0
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
TaxDateDocument DateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
StampNumStamp No.nVarChar
16
FinncPriodPosting PeriodInt
11OFPR
Posting Period
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
StationIDWorkstation IDInt
11CSTN
Workstation ID
RoundingRoundingVarChar
Y) Yes
N) No
1
N
SegmentSegmentInt
6
0
ReqDateRequired DateDate
8
CancelDateCancelation DateDate
8
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT OMRL.DocEntry AS 'Internal Number', OMRL.DocNum AS 'Document Number', OMRL.Series AS 'Series', OMRL.DocDate AS 'Posting Date', OMRL.RevalType AS 'Inventory Valuation Type', OMRL.Handwrtten AS 'Manual Numbering', OMRL.Printed AS 'Printed', OMRL.Transfered AS 'Year Transfer', OMRL.DocCur AS 'Document Currency', OMRL.DocRate AS 'Document Rate', OMRL.Ref2 AS 'Reference 2', OMRL.Comments AS 'Remarks', OMRL.JrnlMemo AS 'Journal Remarks', OMRL.TransId AS 'Transaction Number', OMRL.DocTime AS 'Generation Time', OMRL.Confirmed AS 'Confirmed', OMRL.Instance AS 'Instance', OMRL.UpdateDate AS 'Date of Update', OMRL.CreateDate AS 'Creation Date', OMRL.TaxDate AS 'Document Date', OMRL.DataSource AS 'Data Source', OMRL.StampNum AS 'Stamp No.', OMRL.FinncPriod AS 'Posting Period', OMRL.UserSign AS 'User Signature', OMRL.UserSign2 AS 'Updating User', OMRL.LogInstanc AS 'Log Instance', OMRL.StationID AS 'Workstation ID', OMRL.Rounding AS 'Rounding', OMRL.Segment AS 'Segment', OMRL.ReqDate AS 'Required Date', OMRL.CancelDate AS 'Cancelation Date', OMRL.Project AS 'Project Code' FROM OMRL AS OMRL

Related information


Posting Period OFPR SQL Table

Project Codes OPRJ SQL Table

Workstation ID CSTN SQL Table

Journal Entry OJDT SQL Table

Users OUSR 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