MGCLatticeOpenPurchaseOrderLineEntity
The MGCLatticeOpenPurchaseOrderLineEntity exposes OPEN purchase order lines (lines with a remaining physical quantity still to be received) from PurchLine joined to inventory dimensions (InventDim). Read-only and performance-optimized with an explicit minimal field projection and a baked-in range on RemainPurchPhysical > 0 for high-volume open-order feeds.
- Public collection name:
LatticeOpenPurchaseOrderLines
- Primary key:
PurchaseOrderNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
PurchaseOrderNumber | PurchIdBase | No | |
LineNumber | TradeLineNumber | No | |
ItemNumber | ItemIdSmall | No | |
RemainingPurchaseQuantity | PurchQty | No | |
PurchaseUnitSymbol | PurchUnit | No | |
RequestedReceiptDate | PurchLineRequestedReceiptDate | No | |
PurchaseStatus | PurchStatus | No | |
VendorAccountNumber | VendAccount | No | |
ReceivingSiteId | InventSiteId | No | |
ReceivingWarehouseId | InventLocationId | No | |
Mappings
| Entity field | Data source | Field |
|---|
PurchaseOrderNumber | PurchLine | PurchId |
LineNumber | PurchLine | LineNumber |
ItemNumber | PurchLine | ItemId |
RemainingPurchaseQuantity | PurchLine | RemainPurchPhysical |
PurchaseUnitSymbol | PurchLine | PurchUnit |
RequestedReceiptDate | PurchLine | DeliveryDate |
PurchaseStatus | PurchLine | PurchStatus |
VendorAccountNumber | PurchLine | VendAccount |
ReceivingSiteId | InventDim | InventSiteId |
ReceivingWarehouseId | InventDim | InventLocationId |