ramtransferruletmpitem

Defines a rule for transferring a part from a parent depot to a child depot.Specifies a day pattern and expiry time, which together provide a deadline for when the rule stops being applicable. Also specifies a delay until the part will be available, using available_delay_days and available_time_of_day.For example, a rule may be applicable on Fridays, expiring at 15:00, with 3 delays days and an available time of 9:00. Provided it is a Friday before 15:00, the rule can be used, with the part arriving at 9:00 on Monday (3 days later).

Syntax:

[ DynamicComponentDependency ] ramtransferruletmpitem RAMTransferRuleTmpItemName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
day_pattern String(7) Specifies the days of the week the rule applies to.
delivery_level String(32) The delivery level this rule belongs to.
expiry_time_of_day Number (minutes by default) Specifies the time of day at which the rule expires.
ram_transfer_rule_template_id String(32) Unique id for the transfer template the rule belongs to.
available_delay_days Number The number of days after the current day when the part will arrive at the child depot.
available_time_of_day Number (minutes by default) The time of day at which the part will arrive at the child depot. 


            ramtransferruletmpitem RAMTransferRuleTmpItem {{SelectName}} {
               SELECT
                     ..                  day_pattern,
                     ..                  delivery_level,
                     ..                  expiry_time_of_day,
                     ..                  ram_transfer_rule_template_id,
                     ..                  available_delay_days,
                     ..                  available_time_of_day
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTransferRuleTmpItemName

Syntax:

<Identifier>

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