ramtravelcostmodel

Defines a travel cost model to be used when scheduling a resource. See

Syntax:

[ DynamicComponentDependency ] ramtravelcostmodel RAMTravelCostModelName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique identifier.

Optional columns

Column Name Data Type Description Default Value
cost_km Double The default cost to apply for each kilometre travelled. 0.25
description String(2000) A description for this travel cost model.
maximum_journey_time Number (minutes by default) The maximum allowed length of any single journey.
maximum_shift_travel_time Number (minutes by default) The maximum total travel allowed in a shift.
maximum_travel_home_time Number (minutes by default) The maximum distance from home that a resource is allowed to travel to.
travel_from_charge_proportion Double The proportion of the usual travel cost that should be applied during the 'travel from' period.
travel_to_charge_proportion Double The proportion of the usual travel cost that should be applied during the 'travel to' period. 


            ramtravelcostmodel RAMTravelCostModel {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  cost_km,
                     ..                  description,
                     ..                  maximum_journey_time,
                     ..                  maximum_shift_travel_time,
                     ..                  maximum_travel_home_time,
                     ..                  travel_from_charge_proportion,
                     ..                  travel_to_charge_proportion
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTravelCostModelName

Syntax:

<Identifier>

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