rampartstock

Defines the amount of stock for parts to be carried by resources or resource types. This can be used to specify parts against a resource or resource type which can be time dependent. If no available_datetime is specified then the part is assumed to be available to the resource or resource type from the start of the schedule, otherwise the part is only available from the specified time. Theoverride_existing states whether this part is in addition to any parts currently held by the resource or resource type (set to false), or whether it replaces any existing parts (set to true). The stock level can be set to recur using recurrence_interval and day_pattern. See examples below.

Syntax:

[ DynamicComponentDependency ] rampartstock RAMPartStockName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Part stock identity.
ram_part_id String(32) The id of the part.
stock Number The quantity of stock.

Optional columns

Column Name Data Type Description Default Value
override_existing Number (0 = False, 1 = True) Should this stock replace any existing stock, rather than being added to it. True
available_datetime Date The date and time the stock becomes available.
day_pattern String(7) If specified ,the part stock recurrence is only applied on the applicable days.
ram_resource_id String(32) The resource id carrying the stock.
ram_resource_type_id String(32) The resource type id carrying the stock.
recurrence_interval Number (minutes by default) If specified, the part stock recurs with this frequency starting from the available datetime. 


            rampartstock RAMPartStock {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  ram_part_id,
                     ..                  stock,
                  -- optional columns
                     ..                  override_existing,
                     ..                  available_datetime,
                     ..                  day_pattern,
                     ..                  ram_resource_id,
                     ..                  ram_resource_type_id,
                     ..                  recurrence_interval
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMPartStockName

Syntax:

<Identifier>

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