activityusageperiod

Defines the expected usage against this activity of the specified class and between the specified dates.

Syntax:

[ DynamicComponentDependency ] activityusageperiod ActivityUsagePeriodName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_id String(32) The identifier of the (repeatable) activity.
start_date Date The date from which this usage level applies.
usage_class_id String(32) The identifier for the class of usage.
end_date Date The date until which this usage level applies.
usage_per_day Double The usage per day during this period. 


            activityusageperiod ActivityUsagePeriod {{SelectName}} {
               SELECT
                     ..                  activity_id,
                     ..                  start_date,
                     ..                  usage_class_id,
                     ..                  end_date,
                     ..                  usage_per_day
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityUsagePeriodName

Syntax:

<Identifier>

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