/SCWM/ESI_HDR

Header Data for a Parcel | #header | Component: Shipping and Receiving
Column Name Description
CLIENT Client
GUID_ESI Unique Internal Identification for Parcel/Label
Column Name Description
Column Name Description
📏 Weight Unit (UNIT_WEIGHT):
WEIGHT_ITEM Total Weight of Parcel
WEIGHT_SHIP Total Weight of Shipment
📏 Volume Unit (UNIT_VOLUME):
VOLUME_ITEM Total Volume of Parcel
VOLUME_SHIP Total Volume of Shipment
📏 Unit of Dimension for Length/Width/Height (UNIT_LWH):
LENGTH Length
WIDTH Width
HEIGHT Height
Column Name Description
FIXED_DATE Fixed Date of First Delivery Attempt
EARLIESTDELTIME Earliest Delivery Time
PICKUP_DATE Date of Handover to Express Delivery Company
Column Name Description
POD_REQU Proof of Delivery Required Show values
HOLDFPICKUP Shipment/Parcel Will Be Picked Up Show values
FIRST_LABEL Indicator: First Parcel of Shipment Show values
Column Name Description Domain name
DOCTYPE Category of Referenced Doc.
DOCID Document Number
TERMINAL Terminal/Work Center
CREATED_BY User Name UNAME
CREATED_AT UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CHANGED_BY User Name UNAME
CHANGED_AT UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CARRIER Express Delivery Company
SHIPACCT Customer Number at Express Delivery Company
TRACKN Parcel Tracking Number
SHIPID Express-Delivery-Company-Specific Shipment Identification
PARCEL_N Position of Parcel in Shipment
PARCEL_OF_M Total Number of Parcels in Shipment
ROUTECODE Express-Delivery-Company-Specific Route Code
TOURCODE Express-Delivery-Company-Specific Description of a Trip
HUB_DEP Inbound Load Transfer Point for Express Delivery Company
HUB_DEST Outbound Load Transfer Point for Express Delivery Company
HUB_ADD Additional Load Transfer Point for Exp. Del. Company
ROUTESOURCE Source of Route Data
DEST_CODE Express-Delivery-Company-Specific Coding for Destination
SERVICECODE Express-Delivery-Company-Specific Service Code
PRODUCTCODE Express-Delivery-Company-Specific Product Code
COUNTER Counter for Parcel Number
BILLOPT Indicator for Settlement Options
FREIGHT_TERM Code for Prepayment of Charges
PALOCOL Indicator: Whole Pallet or Individual Parcel
BULKIND Bulk Goods Indicator
LETTER Indicator for Sending Documents/Letters
LONGCODE Express-Delivery-Company-Specific Leading Code/Maxicode
ADD_A Freely Usable Additional Field, Length 1
ADD_B Freely Usable Additional Field, Length 1
ADD_C Freely Usable Additional Field, Length 1
ADD05 Freely Usable Additional Field, Length 5
ADD10 Freely Usable Additional Field, Length 10
ADD20 Freely Usable Additional Field, Length 20
SATDELV Saturday Delivery Required
CONFIDENTIAL Indicator - Confidential Delivery
DIMWEIGHT Volume Weight
PRINTED Already printed?
MANIFEST Internal Identification - Day-End Closing
CANCELLED_MAN Indicator: Document for Day-End Closing Canceled
HANDOVER_TRK Data was transferred to a tracking server
HANDOVER_PRINT Data was transferred to third-party system
ESI_HDR_DUMMY Dummy function in length 1 DUMMY
COD_DAT_EXIST null
FOTRADE_EXIST null
ADDTEXT_EXIST null
HAZ_MAT_EXIST null
RETURNS_EXIST null
TRACKDT_EXIST null