ramusagemodelitem

Sets usage limits for the specified class of usage within a usage model.

Syntax:

[ DynamicComponentDependency ] ramusagemodelitem RAMUsageModelItemName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
ram_usage_class_id String(32) The identifier for the class of usage.
ram_usage_model_id String(32) The identifier for the usage model this relates to.
maximum_usage Double The maximum usage allowed for this type of usage.

Optional columns

Column Name Data Type Description Default Value
leeway_always_applies Number (0 = False, 1 = True) Determines whether the leeway still applies if the operation is carried out before the leeway window. True
leeway_usage Double Defines a 'fixed interval' window during which the operation can be performed and the next required time will not be brought forward. 0 


            ramusagemodelitem RAMUsageModelItem {{SelectName}} {
               SELECT
                     ..                  ram_usage_class_id,
                     ..                  ram_usage_model_id,
                     ..                  maximum_usage,
                  -- optional columns
                     ..                  leeway_always_applies,
                     ..                  leeway_usage
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMUsageModelItemName

Syntax:

<Identifier>

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