Importing Service Times

The following example illustrates how you specify SERVICE_TIME data in CSV format.

SERVICE_TIME
X_LANE_GID,RATE_SERVICE_GID,SERVICE_TIME_VALUE,SERVICE_DAYS,DOMAIN_NAME,SERVICE_TIME_VALUE_UOM_CODE,SERVICE_TIME_VALUE_BASE
EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDDHH24MISS'
MYDOMAIN.194-064,MYDOMAIN.VOYAGE-DEFAULT,172800,,MYDOMAIN,S,172800
MYDOMAIN.194-065,MYDOMAIN.VOYAGE-DEFAULT,86400,,MYDOMAIN,S,86400

In the above example, note that you must specify SERVICE_DAYS, and leave the SERVICE_TIME_VALUE unspecified. As an alternative, you must specify SERVICE_TIME_VALUE in seconds, and leave the SERVICE_DAYS unspecified. You must never specify both a SERVICE_TIME_VALUE and a SERVICE_DAYS value on the same record for the SERVICE_TIME table.