biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Inventory Revaluation Log File
API IVLG
IVLG - Inventory Revaluation Log File Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal Unique KeyInt
11
PRIMARYYes
UtilVerInventory Revaluation UtilityInt
11
B1VerB1 VersionInt
11
SrcDBVerSource Database VersionInt
11
DestDBNameDestination Database NamenVarChar
127
DestDBPathDestination Database PathText
16
FromDocDocument FromInt
11OINM
FromSysDatSystem Date FromDate
8
ToDocLast calculated documentInt
11OINM
ToSysDateTo System DateDate
8
CustDbUpdCustomer DB was updatedVarChar
Y)
N)
1
N
HistTblCrtHistory tables createdVarChar
Y)
N)
1
N
SuccRecalcSuccessful recalculationVarChar
Y)
N)
1
N
CommentRecalculation CommentnVarChar
100
EnblFromToEnabling From-To FunctionVarChar
1
N
StrFldGeneral String FieldnVarChar
50
NumFldInclude Custom from OIPFInt
11
LoadCustLoad Customs on Item ValueVarChar
Y) "Load Customs on Item Value" is selected
N) "Load Customs on Item Value" is not selected
1
Y

SELECT statement

SELECT IVLG.AbsEntry AS 'Internal Unique Key', IVLG.UtilVer AS 'Inventory Revaluation Utility', IVLG.B1Ver AS 'B1 Version', IVLG.SrcDBVer AS 'Source Database Version', IVLG.DestDBName AS 'Destination Database Name', IVLG.DestDBPath AS 'Destination Database Path', IVLG.FromDoc AS 'Document From', IVLG.FromSysDat AS 'System Date From', IVLG.ToDoc AS 'Last calculated document', IVLG.ToSysDate AS 'To System Date', IVLG.CustDbUpd AS 'Customer DB was updated', IVLG.HistTblCrt AS 'History tables created', IVLG.SuccRecalc AS 'Successful recalculation', IVLG.Comment AS 'Recalculation Comment', IVLG.EnblFromTo AS 'Enabling From-To Function', IVLG.StrFld AS 'General String Field', IVLG.NumFld AS 'Include Custom from OIPF', IVLG.LoadCust AS 'Load Customs on Item Value' FROM IVLG AS IVLG

Related information


IVLG 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