biuan SAP® BUSINESS ONE SDK
SQL Administration / Workflow - Task Details
API Workflow Task Collection / Workflow Task
OWLS - Workflow - Task Details Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WFInstIDWorkflow Instance IDInt
11OWFI
Workflow - Instances
TaskID KEY UNIQUETask IDInt
11
PRIMARYYes
WFIDWorkflow IDnVarChar
64
WFNameWorkflow NamenVarChar
100
TaskDescTask DescriptionnVarChar
100
ObjTypeObject TypenVarChar
20
OperationOperationVarChar
A) Add
U) Update
D) Delete
1
ObjKeyObject KeynVarChar
100
EnterDateEnter DateDate
8
EnterTimeEnter TimeInt
6
TaskTypeTask TypeVarChar
1
DueDateDue DateDate
8
DueTimeDue TimeInt
6
UpdateDateUpdate Date - HistoryDate
8
UpdateTimeUpdate Time - HistoryInt
6
OwnerOwnernVarChar
8
PriorityPriorityInt
1) High
2) Medium
3) Low
6
2
UserSignUser SignatureInt
6
StatusStatusVarChar
S) Setup
W) To Be Picked
P) Picking
G) In Progress
D) Completing
F) Completed
N) Suspended
C) Cancelling
Q) Canceled
O) Forwarding
E) Error
1
W
LogInsLog Instance - HistoryInt
11
UserSign2Updating User - HistoryInt
6
DeletedDeleted - HistoryVarChar
1
DuraDaysDuration DaysInt
11
DuraHoursDuration HoursInt
6
TaskNameTask NamenVarChar
100
isPickedIs PickedVarChar
1
N
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
WorkListIdWorklist IDInt
11
ObjSubTypeObject SubtypenVarChar
64
ForwardToUser to ForwardnVarChar
8
WasReadLine ReadVarChar
1
N
TrigParamsTrigger ParametersText
16

Table relationship map

SELECT statement

SELECT OWLS.WFInstID AS 'Workflow Instance ID', OWLS.TaskID AS 'Task ID', OWLS.WFID AS 'Workflow ID', OWLS.WFName AS 'Workflow Name', OWLS.TaskDesc AS 'Task Description', OWLS.ObjType AS 'Object Type', OWLS.Operation AS 'Operation', OWLS.ObjKey AS 'Object Key', OWLS.EnterDate AS 'Enter Date', OWLS.EnterTime AS 'Enter Time', OWLS.TaskType AS 'Task Type', OWLS.DueDate AS 'Due Date', OWLS.DueTime AS 'Due Time', OWLS.UpdateDate AS 'Update Date - History', OWLS.UpdateTime AS 'Update Time - History', OWLS.Owner AS 'Owner', OWLS.Priority AS 'Priority', OWLS.UserSign AS 'User Signature', OWLS.Status AS 'Status', OWLS.LogIns AS 'Log Instance - History', OWLS.UserSign2 AS 'Updating User - History', OWLS.Deleted AS 'Deleted - History', OWLS.DuraDays AS 'Duration Days', OWLS.DuraHours AS 'Duration Hours', OWLS.TaskName AS 'Task Name', OWLS.isPicked AS 'Is Picked', OWLS.Attachment AS 'Attachment', OWLS.AtcEntry AS 'Attachment Entry', OWLS.WorkListId AS 'Worklist ID', OWLS.ObjSubType AS 'Object Subtype', OWLS.ForwardTo AS 'User to Forward', OWLS.WasRead AS 'Line Read', OWLS.TrigParams AS 'Trigger Parameters' FROM OWLS AS OWLS

Related information


Workflow Task WorkflowTask Object· Table: OWLS
WorkflowTask is a data object holding properties for workflow tasks. Source table: OWLS.
   Parent: Workflow Task Collection WorkflowTaskCollection Collection

Workflow Task Service WorkflowTaskService Service· Table: OWLS
WorkflowTaskService is a business object that manages the tasks of the SAP Business One Workflow component. This object enables you to do the following: Get workflow tasks owned by the current user and filter tasks by status. Complete a...

OWLS SQL Table

Workflow - Instances OWFI 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