travelpenalty

This details the penalties that are linked to a given travel cost model. See 'Travel Cost Model' for details.

Syntax:

[ DynamicComponentDependency ] travelpenalty TravelPenaltyName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
threshold_value Number (minutes by default) Specifies the threshold time from which the penalty is applied.
travel_cost_model_id String(32) Defines the id of the travel cost model this penalty relates to.
travel_penalty_type_id String(32) Specifies the type of the travel penalty

Optional columns

Column Name Data Type Description Default Value
additional_cost_km Double Specifies the additional cost per km to apply once the threshold value is exceeded.
penalty Double Defines a one off penalty to apply for exceeding the threshold value. 


            travelpenalty TravelPenalty {{SelectName}} {
               SELECT
                     ..                  threshold_value,
                     ..                  travel_cost_model_id,
                     ..                  travel_penalty_type_id,
                  -- optional columns
                     ..                  additional_cost_km,
                     ..                  penalty
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

TravelPenaltyName

Syntax:

<Identifier>

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