orgscheduleexcepttype

This provides the list of supported exceptions which can be reported and the settings for each organization . Exception types of 1-999 are reserved for internal use only.

Syntax:

[ DynamicComponentDependency ] orgscheduleexcepttype OrgScheduleExceptTypeName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
schedule_exception_type_id Number The type of the exception.
active Number (0 = False, 1 = True) Set to true if exception is to be used.
attention_value Number The number of exceptions of this type at when the exception type will be highlighted in red.

Optional columns

Column Name Data Type Description Default Value
profile_id String(32) The profile id the exception details relates to. DEFAULT
activation_setting Number The value at which the exception becomes true and is reported.
description String(100) A description for this schedule exception type, if it is a custom exception type. 


            orgscheduleexcepttype OrgScheduleExceptType {{SelectName}} {
               SELECT
                     ..                  schedule_exception_type_id,
                     ..                  active,
                     ..                  attention_value,
                  -- optional columns
                     ..                  profile_id,
                     ..                  activation_setting,
                     ..                  description
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling OrgScheduleExceptType.

OrgScheduleExceptTypeName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.