ramlocation

A location for a resource or activity.

Syntax:

[ DynamicComponentDependency ] ramlocation RAMLocationName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id.
latitude Double The latitude of this location.
longitude Double The longitude of this location.

Optional columns

Column Name Data Type Description Default Value
add_time Number (minutes by default) The add time to use for this location.
address_line1 String(128) The first address line for this location.
address_line2 String(128) The second address line for this location.
address_line3 String(128) The third address line for this location.
address_line4 String(128) The fourth address line for this location.
address_line5 String(128) The fifth address line for this location.
address_line6 String(128) The sixth address line for this location.
city String(64) The city of this location.
description String(2000) A description for this location.
duration_overhead Number (minutes by default) The amount of time to be added to the expected duration of the first activity at a location or locality.
lack_of_coverage Number (0 = False, 1 = True) Whether the location should be considered to have lack of GPS coverage.
locality String(32) The locality of this location.
name String(64) The name of this location.
post_code_zip String(50) The post code or zip of this location.
ram_location_type_id String(32) The type of this location.
ram_time_pattern_id String(32) The time pattern defining availabilities for the location.
start_based_availability Number (0 = False, 1 = True) If the availabilities for this location apply only to visit start times.
state String(64) The state (county etc) of this location. 


            ramlocation RAMLocation {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  latitude,
                     ..                  longitude,
                  -- optional columns
                     ..                  add_time,
                     ..                  address_line1,
                     ..                  address_line2,
                     ..                  address_line3,
                     ..                  address_line4,
                     ..                  address_line5,
                     ..                  address_line6,
                     ..                  city,
                     ..                  description,
                     ..                  duration_overhead,
                     ..                  lack_of_coverage,
                     ..                  locality,
                     ..                  name_,
                     ..                  post_code_zip,
                     ..                  ram_location_type_id,
                     ..                  ram_time_pattern_id,
                     ..                  start_based_availability,
                     ..                  state
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMLocationName

Syntax:

<Identifier>

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