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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
LogEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TaskTypeType of TasknVarChar
20
RunIDSimulation RunInt
11
VersionB1 Main Release VersionInt
11
PatchLevelB1 Patch Level VersionnVarChar
50
LastMsgIDLast OILM Message IDInt
11
FinishDateFinish DateDate
8
FinishTimeFinish TimeInt
6
UserCodeUser CodenVarChar
8
StatusStatusVarChar
R) In Progress
F) Failed
S) Successful
1
InitMapInitialize MAP ItemsVarChar
1
InitStdInitialize STD ItemsVarChar
1

SELECT statement

SELECT OISL.LogEntry AS 'Internal Number', OISL.TaskType AS 'Type of Task', OISL.RunID AS 'Simulation Run', OISL.Version AS 'B1 Main Release Version', OISL.PatchLevel AS 'B1 Patch Level Version', OISL.LastMsgID AS 'Last OILM Message ID', OISL.FinishDate AS 'Finish Date', OISL.FinishTime AS 'Finish Time', OISL.UserCode AS 'User Code', OISL.Status AS 'Status', OISL.InitMap AS 'Initialize MAP Items', OISL.InitStd AS 'Initialize STD Items' FROM OISL AS OISL

Related information
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