biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Valuation Utility
API IVRU
IVRU - Inventory Valuation Utility Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUESuccessive No.Int
11
PRIMARYYes
SourceDBSource DatabasenVarChar
127
UtilityDBUtility DBnVarChar
127
IVLGEntryIVLG EntryInt
11IVLG
Inventory Revaluation Log File
UpdDateUpdate Date and TimeDate
8
TblHINMHINM NamenVarChar
30
TblHITMHITM NamenVarChar
30
TblHITWHITW NamenVarChar
30
TblFINMFINM NamenVarChar
30
TblFITMFITM NamenVarChar
30
TblFITWFITW NamenVarChar
30
TrSeqHINMLast HINM Trans. Seq. No.Int
11
TrSeqOINMLast OINM Trans. Seq. No.Int
11
TrIdUtilLast OJDT Trans. No. UtilityInt
11
TrIdProdLast OJDT Trans. No. ProductivInt
11
CommentCommentnVarChar
100
StrFldGeneral String FieldnVarChar
50
NumFldGeneral Number FieldInt
11

SELECT statement

SELECT IVRU.AbsEntry AS 'Successive No.', IVRU.SourceDB AS 'Source Database', IVRU.UtilityDB AS 'Utility DB', IVRU.IVLGEntry AS 'IVLG Entry', IVRU.UpdDate AS 'Update Date and Time', IVRU.TblHINM AS 'HINM Name', IVRU.TblHITM AS 'HITM Name', IVRU.TblHITW AS 'HITW Name', IVRU.TblFINM AS 'FINM Name', IVRU.TblFITM AS 'FITM Name', IVRU.TblFITW AS 'FITW Name', IVRU.TrSeqHINM AS 'Last HINM Trans. Seq. No.', IVRU.TrSeqOINM AS 'Last OINM Trans. Seq. No.', IVRU.TrIdUtil AS 'Last OJDT Trans. No. Utility', IVRU.TrIdProd AS 'Last OJDT Trans. No. Productiv', IVRU.Comment AS 'Comment', IVRU.StrFld AS 'General String Field', IVRU.NumFld AS 'General Number Field' FROM IVRU AS IVRU

Related information


Inventory Revaluation Log File IVLG 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