biuan SAP® BUSINESS ONE SDK
SQL Administration / Workflow Timer Definition
API OWTI
OWTI - Workflow Timer Definition Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Id KEY UNIQUEIDInt
11
PRIMARYYes
NameNamenVarChar
50
TemplateIdWorkflow Template IDInt
11
StartDateStart DateDate
8
StartTimeStart TimeInt
11
RepeatCntRepeat Event CountInt
11
DurationDurationnVarChar
127
LastUpdateLast Update Date and TimenVarChar
50
UnScheStDtStart Date of Next ScheduleDate
8
UnScheStTiStart Time of Next ScheduleInt
11
UnScheReCtUnschedule Repeat CountInt
11
IsCompleteIs This Timer CompletedVarChar
Y) Yes
N) No
1
N
JobHanTypeJob Handler TypenVarChar
50
JobHanConfJob Handler ConfigurationText
16
IsActiveIs This an Active TimerVarChar
1

SELECT statement

SELECT OWTI.Id AS 'ID', OWTI.Name AS 'Name', OWTI.TemplateId AS 'Workflow Template ID', OWTI.StartDate AS 'Start Date', OWTI.StartTime AS 'Start Time', OWTI.RepeatCnt AS 'Repeat Event Count', OWTI.Duration AS 'Duration', OWTI.LastUpdate AS 'Last Update Date and Time', OWTI.UnScheStDt AS 'Start Date of Next Schedule', OWTI.UnScheStTi AS 'Start Time of Next Schedule', OWTI.UnScheReCt AS 'Unschedule Repeat Count', OWTI.IsComplete AS 'Is This Timer Completed', OWTI.JobHanType AS 'Job Handler Type', OWTI.JobHanConf AS 'Job Handler Configuration', OWTI.IsActive AS 'Is This an Active Timer' FROM OWTI AS OWTI

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