Lookups

  • cycle_count supports various count types (demand, ABC, near-zero, empty location) and methods (by location, item, or LPN), with statuses including not started, in progress, completed (with or without discrepancies), and canceled.

  • storage is categorized by type (trailer, bulk, door, lane, etc.), area (yard, receiving, inventory, shipping, processing), zone (with recommended values like ZONE01, DOCK, STAGE, etc.), and location status (in service, out of service, locked, errored).

  • Standard units of measure are defined for volume (cubic foot, cubic centimeter), weight (kilogram, pound), dimensions (centimeter, inch), and quantity (each).

  • outbound_orders progress through statuses like created, planned, released, picked, packed, staged, loaded, shipped, and canceled, reflecting their journey from order creation to shipment.

  • inbound_orders follow statuses such as created, delivered, unloaded, received, and putaway, covering the stages from order creation to storage, and can be of type purchase order, move order, or sales order.

cycle_count.count_status

Value Description
NOT_STARTED Not Started
IN_PROGRESS In progress
COMPLETED Completed without Discrepancies
COMPLETED_WITH_DISCREPANCIES Completed with Discrepancies
CANCELED Cancelled

cycle_count.count_type

Value Description
DEMAND On-demand counts
ABC ABC
COUNT_NEAR_ZERO Count Near Zero
EMPTY_LOCATION Empty Location Count

cycle_count.count_method

Value Description
COUNT_BY_LOCATION Count by Location
COUNT_BY_ITEM Count by Item
COUNT_BY_LPN Count by LPN

storage_type

Value Description
TRL Trailer
BULK Bulk storage
STOTRL Storage Trailer
DOOR Door
LANE Lane
RSRCH Verification/Research
TRACK Tracking Devices
BULK Bulk
SRCK Server Racks
PLT Pallet
CNT Carton
BIN Bin
QTN Quarantine

storage_area

Value Description
YARD Yard Management
RECV Receiving
INV Inventory
SHIP Shipping
PROC Processing
Value Description
ZONE(#) Zone (for example: ZONE01,ZONE02)
DOCK Dock
STAGE Staging
HRI(#) High Risk Inventory (for example: HRI01)
RMA Return Merchandise Authorization
SCRAP Scrap
QUAL Quality
FLOOR(#) Floor (for example: FLOOR01)
RACK(#) Rack (for example: RACK01)
BAT(#) Battery Room (for example: BAT01)
VLM(#) Vertical Lift Module (for example: VLM01)
FWDPK Forward Pick
PACK Packing
PLTB Pallet Build
PND Pickup & Deposit
ASRS Automated Storage and Retrieval System
XDOCK(#) Cross dock

storage_location_status

Value Description
IN_SERVICE In Service
OUT_OF_SERVICE Out of Service
LOCKED Movement both out of or into the location is blocked
ERRORED Location is in error due to an existing process error

volume_uom

Value Description
FTQ Cubic foot
CMQ Cubic centimeter

weight_uom

Value Description
KG Kilogram
LB Pound

height_uom, length_uom, width_uom

Value Description
CM Centimeter
IN Inch
Value Description
EACH Each quantity

outbound_orders.last_wms_order_status, outbound_orders.next_wms_order_status

Value Description
CREATED Order has been created in the WMS (EDI 940).
PLANNED Order has been planned, meaning the order has been fully allocated with available inventory.
RELEASED Order has been released in the WMS and pick work has been or is being generated.
PICKED Physically picked from the allocated location.
PACKED All picked material has been physically packed / palletized into the final containers / pallets.
HOLD Material is being held for some quality related reason (e.g. CI Hold, DG Review).
STAGED All material associated with the order has been physically located in the ship staging lane.
LOADED All material associated with the order has been physically loaded on the transportation equipment.
SHIPPED Order systemically and physically shipped from the site.
CANCELED Order has been canceled in both WMS.

inbound_orders.last_wms_order_status, inbound_orders.next_wms_order_status

Value Description
CREATED Order has been created in the WMS (EDI 856).
DELIVERED Order has been physically delivered to the receiving sites property, whether at the front desk, dock door, trailer yard.
UNLOADED Completely unloaded into the receiving area.
RECEIVED Order has been systemically received in full in WMS.
PUTAWAY Physically put away into a storage location.

inbound_orders.order_type

Value Description
PURCHASE_ORDER Purchase order
MOVE_ORDER Intra company move order
SALES_ORDER Sales order