ramcapacitypart

This defines an override for the maximum quantity of stock that can be carried for aparticular part. If the maximum quantity is null then there is no maximum. Ifexclusivity required is set to true then the resource must carry only this partfor this capacity requirement.

Syntax:

[ DynamicComponentDependency ] ramcapacitypart RAMCapacityPartName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_capacity_id String(32) Unique identifier for the capacity.
ram_part_id String(32) Unique identifier for the part the capacity applies too.

Optional columns

Column Name Data Type Description Default Value
exclusivity_required Number (0 = False, 1 = True) Indicates if the part must be carried for the capacity requirement. False
maximum_quantity Number Maximum quantity of stock to be carried.


            ramcapacitypart RAMCapacityPart {{SelectName}} {
               SELECT
                     ..                  ram_capacity_id,
                     ..                  ram_part_id,
                  -- optional columns
                     ..                  exclusivity_required,
                     ..                  maximum_quantity
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMCapacityPartName

Syntax:

<Identifier>


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