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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Id KEY UNIQUEIDInt
11
PRIMARYYes
OwnerOwnernVarChar
127
OutputParOutput Param.Text
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 Date and TimenVarChar
50
KeyTask ID in XMLnVarChar
127

SELECT statement

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

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