MGCLatticeWarehouseWorkLineEntity
The MGCLatticeWarehouseWorkLineEntity exposes warehouse (WHS) work lines from WHSWorkLine with a lean projection of line number, work type/status, warehouse location, item and inventory dimensions (batch, serial, status, license plate), and work/inventory quantities. Read-only, related back to the MGCLatticeWarehouseWorkEntity header by WorkId.
- Public collection name:
LatticeWarehouseWorkLines
- Primary key:
WorkId, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
WorkId | WHSWorkId | No | |
LineNumber | LineNum | No | |
WorkType | WHSWorkType | No | |
WorkStatus | WHSWorkStatus | No | |
WarehouseLocationId | WMSLocationId | No | |
AllocatedWarehouseLocationId | WMSLocationId | No | |
ItemNumber | ItemId | No | |
InventoryDimensionId | InventDimId | No | |
WorkQuantity | WHSQtyWork | No | |
RemainingQuantity | WHSQtyRemain | No | |
InventoryWorkQuantity | WHSInventQtyWork | No | |
InventoryRemainingQuantity | WHSInventQtyRemain | No | |
UnitSymbol | UnitOfMeasureSymbol | No | |
InventoryLotId | InventTransId | No | |
LoadId | WHSLoadId | No | |
ShipmentId | WHSShipmentId | No | |
WorkClassId | WHSWorkClassId | No | |
ZoneId | WHSZoneId | No | |
WorkStartedDateTime | WHSWorkInProcessUTCDateTime | No | |
WorkClosedDateTime | WHSWorkClosedUTCDateTime | No | |
ItemBatchNumber | InventBatchId | No | |
ItemSerialNumber | InventSerialId | No | |
InventoryStatusId | WHSInventStatusId | No | |
LicensePlateId | WHSLicensePlateId | No | |
Mappings
| Entity field | Data source | Field |
|---|
WorkId | WHSWorkLine | WorkId |
LineNumber | WHSWorkLine | LineNum |
WorkType | WHSWorkLine | WorkType |
WorkStatus | WHSWorkLine | WorkStatus |
WarehouseLocationId | WHSWorkLine | WMSLocationId |
AllocatedWarehouseLocationId | WHSWorkLine | AllocatedWMSLocationId |
ItemNumber | WHSWorkLine | ItemId |
InventoryDimensionId | WHSWorkLine | InventDimId |
WorkQuantity | WHSWorkLine | QtyWork |
RemainingQuantity | WHSWorkLine | QtyRemain |
InventoryWorkQuantity | WHSWorkLine | InventQtyWork |
InventoryRemainingQuantity | WHSWorkLine | InventQtyRemain |
UnitSymbol | WHSWorkLine | UnitId |
InventoryLotId | WHSWorkLine | InventTransId |
LoadId | WHSWorkLine | LoadId |
ShipmentId | WHSWorkLine | ShipmentId |
WorkClassId | WHSWorkLine | WorkClassId |
ZoneId | WHSWorkLine | ZoneId |
WorkStartedDateTime | WHSWorkLine | WorkInProcessUTCDateTime |
WorkClosedDateTime | WHSWorkLine | WorkClosedUTCDateTime |
ItemBatchNumber | InventDim | inventBatchId |
ItemSerialNumber | InventDim | inventSerialId |
InventoryStatusId | InventDim | InventStatusId |
LicensePlateId | InventDim | LicensePlateId |