Siebel Order Management Guide Addendum for Fleet Management > Administering Siebel Orders for Fleet Management >

Configuring Picklists for Fleet Management


Many fields used by Siebel Orders for Fleet Management contain picklists that let you select a value. You might want to modify these picklists to suit your business model. For example, when the customer service representative chooses actions for each commodity or for each stop, your company probably wants a picklist with different values from the default to suit your business model.

The values displayed in this picklist are controlled in the List of Values view of the Data Administration screen. For each value displayed in the picklist, there is one record in the List of Values view.

Table 4 shows the value of the Type field for picklists used in Siebel Orders for Fleet Management and the default values for each type. If you want to change the default values for any type, modify the records in the List Of Values view.

Table 4. Type Fields for Picklists and the Default Values
Type
Display Values by Default
Language Independent Code by Default

FM_ACTION_STATUS_TYPE

Cancelled

Complete

In Progress

Inactive

Not Started

Cancelled

Complete

In Progress

Inactive

Not Started

FM_ACTION_TYPE

 

Driver Assist Load

Driver Assist Unload

Driver Hand Load by Piece

Driver Hand Unload

Driver Hand Unload By Piece

Drop Loaded Trailer

Hire Lumper To Load

Hire Lumper to Unload

Mechanical Driver Load

Mechanical Driver Unload

Pickup Loaded Trailer

Driver Assist Load

Driver Assist Unload

Driver Hand Load by Piece

Driver Hand Unload

Driver Hand Unload By Piece

Drop Loaded Trailer

Hire Lumper To Load

Hire Lumper to Unload

Mechanical Driver Load

Mechanical Driver Unload

Pickup Loaded Trailer

FM_DIMENSION_UOM

Centimeter

Feet

Inches

Meter

Yard

Centimeter

Feet

Inches

Meter

Yard

FM_DISTANCE_UOM

Kilometer

Miles

Nautical Miles

Kilometer

Miles

Nautical Miles

FM_HOLD_REASON

Credit

Credit

FM_LINE_OF_BUSINESS

Bulk

Dedicated & Southwest

Global Supply Chain (GSCM)

Intermodal

One Way

Regional

SFI

Transportation Management (STM)

Bulk

Dedicated & Southwest

Global Supply Chain (GSCM)

Intermodal

One Way

Regional

SFI

Transportation Management (STM)

FM_LOC_ROLE

Invoice To

Ship From/Ship To

Invoice To

Ship From/Ship To

FM_LOC_TYPE

Airport

Border Crossing

Carrier

Dispatch Location

Invoice To

Port

Rail Station

Ship From/Ship To

XDock

Airport

Border Crossing

Carrier

Dispatch Location

Invoice To

Port

Rail Station

Ship From/Ship To

XDock

FM_MILEAGE_PCKG

19 (HHMG)

MileMaker version 18

PC Miler version 15-21

PTV

19 (HHMG)

MileMaker version 18

PC Miler version 15-21

PTV

FM_ORDER_MODE

Air Transport

All

Barge Transport

Drayage Transport

Express Transport

Handling

Intermodal Transport

LTL

Multi

Ocean

Parcel Transport

Pipeline Network Transport

Rail

Small Pack

Truckload

Unknown

Vessel Transport - Charter

Vessel Transport - Container

Vessel Transport - NVOCC

Air Transport

All

Barge Transport

Drayage Transport

Express Transport

Handling

Intermodal Transport

LTL

Multi

Ocean

Parcel Transport

Pipeline Network Transport

Rail

Small Pack

Truckload

Unknown

Vessel Transport - Charter

Vessel Transport - Container

Vessel Transport - NVOCC

FM_ORD_DTL_TYPE

Order Reference

Order Reference

FS_ORDER_STATUS

Inactive

Accepted

PI-Sent To Analysis

PI-Sent To Decontamination

Received

Assigned

Moving

Released

Submitted-Pending

Transportation Order

Inactive

Accepted

PI-Sent To Analysis

PI-Sent To Decontamination

Received

Assigned

Moving

Released

Submitted-Pending

Transportation Order

FM_PACKAGING

Bags

Bales

Boxes

Bundles

Cans

Coils

Crates

Drums

Kegs

Pail

Racks / Cages

Rolls

Super Sacks

Tubes

BG

BL

BX

BD

CA

CO

CR

DR

KG

PA

RX

RL

SS

TU

FM_REJECT_REASON

Commodity not feasible

Credit Cancel

Customer Cancel

Customer Request

Failed To Meet Min Profit Req

Market restrictions

No agreement

No capability

Order Expired

Rate not competitive

Transit not feasible

Commodity not feasible

Credit Cancel

Customer Cancel

Customer Request

Failed To Meet Min Profit Req

Market restrictions

No agreement

No capability

Order Expired

Rate not competitive

Transit not feasible

FM_SHIPPING

Floor

Pallet Double Stacked

Pallet Single Stacked

Slipsheet

FL

PD

PL

SS

FM_STOP_DTL_TYPE

Accounting Number

Appointment Number

Bond Number

Customs Broker Name

Master Bill (MB)

PARS Number

Pickup Reference Number

Purchase Order (PO)

Release Number

Seal Number

Accounting Number

Appointment Number

Bond Number

Customs Broker Name

Master Bill (MB)

PARS Number

Pickup Reference Number

Purchase Order (PO)

Release Number

Seal Number

FM_STOP_STATUS_TYPE

Arrived

Assigned

Cancelled

Complete

Inactive

Unassigned

Arrived

Assigned

Cancelled

Complete

Inactive

Unassigned

FM_STOP_TYPE

DROP-OFF (Dest)

PICK-UP (Origin)

BORDERX Pickup

Border Crossing

DROP-OFF

Delivery

Other

PICK-UP

DROP-OFF (Dest)

PICK-UP (Origin)

BORDERX Pickup

Border Crossing

DROP-OFF

Delivery

Other

PICK-UP

FM_VOLUME_UOM

Cubic Centimeter

Cubic Feet

Cubic Inches

Cubic Meter

Cubic Yards

Gallons

Gallons (Canada)

Liters

Cubic Centimeter

Cubic Feet

Cubic Inches

Cubic Meter

Cubic Yards

Gallons

Gallons (Canada)

Liters

FM_WEIGHT_UOM

KILOGRAMS

KIPS (1000 POUNDS)

METRIC TONS (1000 KG)

POUNDS

TONS (2000 POUNDS)

KILOGRAMS

KIPS (1000 POUNDS)

METRIC TONS (1000 KG)

POUNDS

TONS (2000 POUNDS)

PROD_CD

Transportation

Accessorial

Special Service

Commodity

Transportation

Accessorial

Special Service

Commodity

To configure a picklist

  1. Navigate to the Administration - Data screen, then the List of Values view.
  2. In the Type field, query for the type you want to modify, using one of the type values listed in Table 4.
  3. Add one record for each value of this type that will be displayed in the picklist.
Siebel Order Management Guide Addendum for Fleet Management Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.