Defines the part information for an activity type.
Syntax:
[ DynamicComponentDependency ] ramactivitytypepart RAMActivityTypePartName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}
Column Name | Data Type | Description | Default Value |
---|---|---|---|
ram_activity_type_id | String(32) | The activity type this applies to. | |
ram_part_id | String(32) | The part this applies to. |
Column Name | Data Type | Description | Default Value |
---|---|---|---|
refill_to_capacity | Number (0 = False, 1 = True) | Determines if this should only supply parts up to the capacity limit. | False |
maximum_restock | Number | For restocking, the maximum amount that can be restocked in a visit. | |
minimum_restock | Number | For restocking, the minimum amount that can be restocked in a visit. | |
part_usage | Number | The number of parts required - can be negative if stock is supplied by the activity. |
ramactivitytypepart RAMActivityTypePart {{SelectName}} { SELECT .. ram_activity_type_id, .. ram_part_id, -- optional columns .. refill_to_capacity, .. maximum_restock, .. minimum_restock, .. part_usage FROM {{sourceTableName}} WHERE ...; }
Note: All selected columns must have correct aliases that match a IFS Scheduling RAMActivityTypePart.
Syntax:
<Identifier>
This page is generated from IFS Developer Studio at 2021-08-13 08:49.