partstock

Defines the amount of stock for parts carried by resources or resource types and/or available from depot activities. Also used to specify global part stock.

Syntax:

[ DynamicComponentDependency ] partstock PartStockName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Defines a unique id for the part stock.
part_id String(32) Defines the unique id of the part.
stock Number Defines the quantity of stock.

Optional columns

Column Name Data Type Description Default Value
override_existing Number (0 = False, 1 = True) Defines whether this stock replace any existing stock, rather than being added to it. True
activity_id String(32) Provides the activity id of the depot requiring a stock update.
available_datetime Date Specifies the date and time the stock becomes available.
resource_id String(32) Specifies the id of the resource carrying the stock.
resource_type_id String(32) Specifies the id of the type of the resource carrying the stock. 


            partstock PartStock {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  part_id,
                     ..                  stock,
                  -- optional columns
                     ..                  override_existing,
                     ..                  activity_id,
                     ..                  available_datetime,
                     ..                  resource_id,
                     ..                  resource_type_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

PartStockName

Syntax:

<Identifier>

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