ramtravelpenalty

The travel penalties that relate to a particular travel cost model. See 'Travel Cost Model' in the

Syntax:

[ DynamicComponentDependency ] ramtravelpenalty RAMTravelPenaltyName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

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

Optional columns

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


            ramtravelpenalty RAMTravelPenalty {{SelectName}} {
               SELECT
                     ..                  ram_travel_cost_model_id,
                     ..                  ram_travel_penalty_type_id,
                     ..                  threshold_value,
                  -- optional columns
                     ..                  additional_cost_km,
                     ..                  penalty
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMTravelPenaltyName

Syntax:

<Identifier>

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