biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Revaluation
DTW Inventory / Inventory Transactions / Inventory Revaluation
API OMRV / Material Revaluation
OMRV - Inventory Revaluation Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocNum KEYDocument NumberInt
11
NUMNo
DocDatePosting DateDate
8
Ref1Reference 1nVarChar
11
Ref2Reference 2nVarChar
11
CommentsRemarksnVarChar
127
JrnlMemoJournal RemarksnVarChar
50
TransIdTransaction NumberInt
11OJDT
Journal Entry
DocTimeGeneration TimeInt
6
RevalTypeInventory Valuation TypeVarChar
P) Price Change
M) Inventory Debit/Credit
1
P
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
Series KEYSeriesInt
6NNM1
Documents Numbering - Series		SERIESNo
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
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
StationIDWorkstation IDInt
11CSTN
Workstation ID
RIncmAcctInvent. Reval. Expense AccountnVarChar
15
RExpnAcctInvent. Reval. Expense AccountnVarChar
15
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20
162
SeqCodeSequence CodeInt
6
SerialSerial NumberInt
11
SeriesStrSeries StringnVarChar
3
SubStrSubseries StringnVarChar
3
VersionNumVersion NumbernVarChar
11
InflaRevalInflation-Based RevaluationVarChar
Y) Yes
N) No
1
N
SupplCodeSupplementary CodenVarChar
127
CardCodeCustomer/Vendor CodenVarChar
15OCRD
Business Partner
CardNameCustomer/Vendor NamenVarChar
100
CreatedByEntry Creation OriginVarChar
M) Created Manually by User
W) Created by Product Cost Recalculation Wizard
1
M

Table relationship map

SELECT statement

SELECT OMRV.DocEntry AS 'Internal Number', OMRV.DocNum AS 'Document Number', OMRV.DocDate AS 'Posting Date', OMRV.Ref1 AS 'Reference 1', OMRV.Ref2 AS 'Reference 2', OMRV.Comments AS 'Remarks', OMRV.JrnlMemo AS 'Journal Remarks', OMRV.TransId AS 'Transaction Number', OMRV.DocTime AS 'Generation Time', OMRV.RevalType AS 'Inventory Valuation Type', OMRV.UpdateDate AS 'Date of Update', OMRV.CreateDate AS 'Creation Date', OMRV.Series AS 'Series', OMRV.TaxDate AS 'Document Date', OMRV.DataSource AS 'Data Source', OMRV.UserSign AS 'User Signature', OMRV.UserSign2 AS 'Updating User', OMRV.StationID AS 'Workstation ID', OMRV.RIncmAcct AS 'Invent. Reval. Expense Account', OMRV.RExpnAcct AS 'Invent. Reval. Expense Account', OMRV.LogInstanc AS 'Log Instance', OMRV.ObjType AS 'Object Type', OMRV.SeqCode AS 'Sequence Code', OMRV.Serial AS 'Serial Number', OMRV.SeriesStr AS 'Series String', OMRV.SubStr AS 'Subseries String', OMRV.VersionNum AS 'Version Number', OMRV.InflaReval AS 'Inflation-Based Revaluation', OMRV.SupplCode AS 'Supplementary Code', OMRV.CardCode AS 'Customer/Vendor Code', OMRV.CardName AS 'Customer/Vendor Name', OMRV.CreatedBy AS 'Entry Creation Origin' FROM OMRV AS OMRV

Related information


Material Revaluation MaterialRevaluation Object· Table: OMRV
MaterialRevaluation is a business object that enables you to update the items' price (average price or standard price only), revaluate the stock, and create journal entries accordingly. This object applies only to companies that manage their...

OMRV SQL Table

Business Partner OCRD SQL Table

Documents Numbering - Series NNM1 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates