Table 3. Type Fields for Picklists and the Default Values
|
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 |