biuan SAP® BUSINESS ONE SDK
API AWLS
AWLS - 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
1
ObjKeyObject KeynVarChar
A) Add
U) Update
D) Delete
100
EnterDateEnter DateDate
8
EnterTimeEnter TimeInt
6
TaskTypeTask TypeVarChar
U) User Task
M) Manual Task
1
DueDateDue DateDate
8
DueTimeDue TimeInt
6
UpdateDateUpdate Date - HistoryDate
8
UpdateTimeUpdate Time - HistoryInt
6
OwnerOwnernVarChar
8
PriorityPriorityInt
6
UserSignUser SignatureInt
1) High
2) Medium
3) Low
6
2
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
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
WorkListIdWorklist IDInt
11
ObjSubTypeObject SubtypenVarChar
64
ForwardToUser to ForwardnVarChar
8
WasReadLine ReadVarChar
1
N
TrigParamsTrigger ParametersText
16

SELECT statement

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

Related information


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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates