activitytypepart

Records the part(s) requirement for an activity type.

Syntax:

[ DynamicComponentDependency ] activitytypepart ActivityTypePartName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
activity_type_id String(32) Specifies the id of the activity type this relates to.
part_id String(32) Specifies the id of the part this relates to.

Optional columns

Column Name Data Type Description Default Value
part_usage Number Specifies the quantity of part needed for an activity type. 1
refill_to_capacity Number (0 = False, 1 = True) Specifies whether this activity when visited will refill a resource to capacity. False 


            activitytypepart ActivityTypePart {{SelectName}} {
               SELECT
                     ..                  activity_type_id,
                     ..                  part_id,
                  -- optional columns
                     ..                  part_usage,
                     ..                  refill_to_capacity
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

ActivityTypePartName

Syntax:

<Identifier>

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