LIVI - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Inventory and Production / IVI Log File

API LIVI

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
LogEntry ^KEY ^UNIQUE	Internal Number	Int		11		PRIMARY	Yes
Version	B1 Main Version	Int		11
PatchLevel	B1 PL Version	nVarChar		50
Comment	Recalculation Comment	nVarChar		100
LoadCustom	Load customs from OIPF	VarChar	N) No Y) Yes	1	Y
LastMsgID	Last OILM Message ID	Int		11
UpdateDate	Date of Update	Date		8
InitMap	Initialize MAP Items	VarChar		1
InitStd	Initialize STD Items	VarChar		1

SELECT statement

SELECT
   LIVI.LogEntry AS 'Internal Number', 
   LIVI.Version AS 'B1 Main Version', 
   LIVI.PatchLevel AS 'B1 PL Version', 
   LIVI.Comment AS 'Recalculation Comment', 
   LIVI.LoadCustom AS 'Load customs from OIPF', 
   LIVI.LastMsgID AS 'Last OILM Message ID', 
   LIVI.UpdateDate AS 'Date of Update', 
   LIVI.InitMap AS 'Initialize MAP Items', 
   LIVI.InitStd AS 'Initialize STD Items'
FROM LIVI AS LIVI

Related information

LIVI SQL Table

biuan SAP® BUSINESS ONE

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