locationregion

This links each location with a region entity. A location can belong to more thanone region.

Syntax:

[ DynamicComponentDependency ] locationregion LocationRegionName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
location_id String(32) Defines the unique id of the location.
region_id String(32) Defines the unique id of the region.


            locationregion LocationRegion {{SelectName}} {
               SELECT
                     ..                  location_id,
                     ..                  region_id
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

LocationRegionName

Syntax:

<Identifier>


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