LMD_COM_ROUTES

Last Mile Distribution Routes | #transactional | Component: Last Mile Distribution
Column Name Description
CLIENT Client
ROUTE_UUID Route UUID
Column Name Description
Column Name Description
📏 Distance Unit of Measure (ODOMETER_UOM):
ACTUAL_ODOMETER_START Odometer Reading at Departure
ACTUAL_ODOMETER_END Odometer Reading at Arrival
Column Name Description
SELECTION_DEPARTURE_DATE Departure Date
SELECTION_ARRIVAL_DATE Arrival Date
Column Name Description
ROUTE_CATEGORY Route Category Show values
DIFFERENCES Settlement Differences Containing Products / Money Items Show values
MOBILE_ACCESS_TYPE Mobile Access Type Show values
Column Name Description Domain name
ROUTE_ID Route ID
MAIN_DRIVER_ID Driver BU_PARTNER
CO_DRIVER_ID Driver BU_PARTNER
VEHICLE_TYPE Vehicle Type CHAR10
VEHICLE_ID Vehicle ID
VEHICLE_LICENSE_PLATE License Plate
TRAILER_ID Vehicle ID
TRAILER_LICENSE_PLATE License Plate
ROUTE_STOCK_IDENTIFIER Route Stock Identifier LMD_COM_ROUTE_STOCK_IDENTIFIER
ROUTE_DEPARTURE_TIMEZONE Time Zone TZNZONE
COUNTRY_REGION Country/Region Key LAND1
REF_ROUTE_TYPE Reference Route Type
ROUTE_TYPE Route Type
PLANNED_DEPARTURE_TIMESTAMP Timestamp TZNTSTMPS
PLANNED_ARRIVAL_TIMESTAMP Timestamp TZNTSTMPS
ACTUAL_DEPARTURE_TIMESTAMP Departure Timestamp TZNTSTMPS
ARRIVAL_LOCATION_ID Arrival Location /SAPAPO/LOCNO
DEPARTURE_LOCATION_ID Departure Location /SAPAPO/LOCNO
ACTUAL_ARRIVAL_TIMESTAMP Arrival Timestamp TZNTSTMPS
SETTLEMENT_COMMENTS Comments
REASON_CODE Reason Code
DEPARTURE_SHIPPING_POINT Departure Shipping Point VSTEL
ARRIVAL_SHIPPING_POINT Arrival Shipping Point VSTEL
EXECUTION_ORGANIZATION Execution Organization
MESSAGE_CREATION_TIMESTAMP UTC-Timestamp Long YYYYMMDDhhmmssmmmuuun TZNTSTMPL
CREATION_TIMESTAMP Timestamp TZNTSTMPS
LAST_CHANGE_TIMESTAMP Timestamp TZNTSTMPS
CHECK_SUM_UPL_STOPS Checksum for Number of Uploaded Stops
GENERIC_BATCH Generic Batch
EEW_LMD_COM_ROUTE Dummy function in length 1 DUMMY