biuan SAP® BUSINESS ONE SDK
SQL Administration / Input data for tasks
DTW Inventory / Inventory Transactions / Inventory Transfer
API Workflow Task Input Object Collection / Workflow Task Input Object
WLS2 - Input data for tasks Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WFInstIDWorkflow Instance IDInt
11
TaskID KEY UNIQUETask IDInt
11OWLS
Workflow - Task Details		PRIMARYYes
LineIDLine IDInt
11
ObjectTypeObject TypenVarChar
20
ObjKeyObject KeynVarChar
100
CommandCommandVarChar
B) Based On
M) Field Mapping
1
B
LogInsLog InstanceInt
11
ObjSubTypeObject SubtypenVarChar
64
ObjDetailObject DetailText
16

SELECT statement

SELECT WLS2.WFInstID AS 'Workflow Instance ID', WLS2.TaskID AS 'Task ID', WLS2.LineID AS 'Line ID', WLS2.ObjectType AS 'Object Type', WLS2.ObjKey AS 'Object Key', WLS2.Command AS 'Command', WLS2.LogIns AS 'Log Instance', WLS2.ObjSubType AS 'Object Subtype', WLS2.ObjDetail AS 'Object Detail' FROM WLS2 AS WLS2

Related information


Workflow Task Input Object WorkflowTaskInputObject Object· Table: WLS2
WorkflowTaskInputObject is a data object holding properties for workflow task input data objects. Source table: WLS2
   Parent: Workflow Task Input Object Collection WorkflowTaskInputObjectCollection Collection
Workflow - Task Details OWLS 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