A single period of time within a time pattern template.
Syntax:
[ DynamicComponentDependency ] ramtimepatterntempitem RAMTimePatternTempItemName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
ram_time_pattern_template_id | String(32) | The template this period belongs to. | |
sequence | Number | The sequence of this item within the template. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
day_increment | Number | The day offset at which this item starts. | |
day_pattern | String(7) | Used to specify that certain days are not valid for the period. | |
duration | Number (minutes by default) | The duration of this period. | |
month_increment | Number | The month offset at which this item starts. | |
move_rule | Number | How to move the period if it falls on an invalid day. 0= nearest valid day, 1 = forwards, 2 = backwards, 3 = Ignore. | |
time_increment | Number (minutes by default) | The time offset at which this period starts. |
ramtimepatterntempitem RAMTimePatternTempItem {{SelectName}} { SELECT .. ram_time_pattern_template_id, .. sequence, -- optional columns .. day_increment, .. day_pattern, .. duration, .. month_increment, .. move_rule, .. time_increment FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMTimePatternTempItem.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.