biuan SAP® BUSINESS ONE SDK
SQL Administration / Workflow Engine Task Table
API AWTS
AWTS - Workflow Engine Task Table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Id KEY UNIQUEIDInt
11
PRIMARYYes
OwnerOwnernVarChar
127
OutputParOutput ParameterText
16
EndTimeEnd TimenVarChar
50
StartTimeStart TimenVarChar
50
ProcDefIdProcess Definition IDnVarChar
127
NameNamenVarChar
127
ExeIdExecution IDnVarChar
127
ProcInsIdProcess Instance IDnVarChar
127
DescDescriptionnVarChar
127
InputParInput ParameterText
16
DelReasonDelete ReasonnVarChar
127
AssigneeAssigneenVarChar
127
LogInstLog InstanceInt
11
LastUpdateLast Update DatenVarChar
50
KeyTask ID in XMLnVarChar
127

SELECT statement

SELECT AWTS.Id AS 'ID', AWTS.Owner AS 'Owner', AWTS.OutputPar AS 'Output Parameter', AWTS.EndTime AS 'End Time', AWTS.StartTime AS 'Start Time', AWTS.ProcDefId AS 'Process Definition ID', AWTS.Name AS 'Name', AWTS.ExeId AS 'Execution ID', AWTS.ProcInsId AS 'Process Instance ID', AWTS.Desc AS 'Description', AWTS.InputPar AS 'Input Parameter', AWTS.DelReason AS 'Delete Reason', AWTS.Assignee AS 'Assignee', AWTS.LogInst AS 'Log Instance', AWTS.LastUpdate AS 'Last Update Date', AWTS.Key AS 'Task ID in XML' FROM AWTS AS AWTS

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