MGCLatticeWarehouseWorkEntity
The MGCLatticeWarehouseWorkEntity exposes warehouse (WHS) work headers from WHSWorkTable with a lean projection of work identification, status, transaction type, source order references, wave/load/shipment, target license plate, and execution timestamps. Read-only, optimized for high-volume warehouse execution feeds.
- Public collection name:
LatticeWarehouseWorks
- Primary key:
WorkId
Fields
| Name | Type | Mandatory | Description |
|---|
WorkId | WHSWorkId | No | |
WorkStatus | WHSWorkStatus | No | |
WorkTransactionType | WHSWorkTransType | No | |
OrderNumber | WHSOrderNum | No | |
ShipmentId | WHSShipmentId | No | |
LoadId | WHSLoadId | No | |
WaveId | WHSWaveId | No | |
WorkPoolId | WHSWorkPoolId | No | |
TargetLicensePlateId | WHSTargetLicensePlateId | No | |
ContainerId | WHSContainerId | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
WorkTemplateCode | WHSWorkTemplateCode | No | |
WorkPriority | WHSWorkPriority | No | |
WorkCreatedBy | UserId | No | |
WorkStartedDateTime | WHSWorkInProcessUTCDateTime | No | |
WorkClosedDateTime | WHSWorkClosedUTCDateTime | No | |
WorkCancelledDateTime | WHSWorkCancelledUTCDateTime | No | |
Mappings
| Entity field | Data source | Field |
|---|
WorkId | WHSWorkTable | WorkId |
WorkStatus | WHSWorkTable | WorkStatus |
WorkTransactionType | WHSWorkTable | WorkTransType |
OrderNumber | WHSWorkTable | OrderNum |
ShipmentId | WHSWorkTable | ShipmentId |
LoadId | WHSWorkTable | LoadId |
WaveId | WHSWorkTable | WaveId |
WorkPoolId | WHSWorkTable | WorkPoolId |
TargetLicensePlateId | WHSWorkTable | TargetLicensePlateId |
ContainerId | WHSWorkTable | ContainerId |
InventorySiteId | WHSWorkTable | InventSiteId |
InventoryWarehouseId | WHSWorkTable | InventLocationId |
WorkTemplateCode | WHSWorkTable | WorkTemplateCode |
WorkPriority | WHSWorkTable | WorkPriority |
WorkCreatedBy | WHSWorkTable | WorkCreatedBy |
WorkStartedDateTime | WHSWorkTable | WorkInProcessUTCDateTime |
WorkClosedDateTime | WHSWorkTable | WorkClosedUTCDateTime |
WorkCancelledDateTime | WHSWorkTable | WorkCancelledUTCDateTime |