MGCLatticeIntercompanyPurchaseOrderLineEntity
The MGCLatticeIntercompanyPurchaseOrderLineEntity exposes the purchase order LINES of intercompany purchase orders (PurchLine joined to its intercompany PurchTable header), read-only, for full intercompany order reconciliation. Purchase-side counterpart to MGCLatticeIntercompanyOrderLineEntity.
- Public collection name:
LatticeIntercompanyPurchaseOrderLines
- Primary key:
PurchaseOrderNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
PurchaseOrderNumber | `` | No | |
LineNumber | `` | No | |
InventoryLotId | `` | No | |
ItemNumber | `` | No | |
LineDescription | `` | No | |
OrderedPurchaseQuantity | `` | No | |
PurchaseUnitSymbol | `` | No | |
PurchPrice | `` | No | |
LineAmount | `` | No | |
RemainingPurchasePhysicalQuantity | `` | No | |
VendorAccountNumber | `` | No | |
IntercompanyLegalEntityId | `` | No | |
IntercompanySalesOrderNumber | `` | No | |
Mappings
| Entity field | Data source | Field |
|---|
PurchaseOrderNumber | PurchLine | PurchId |
LineNumber | PurchLine | LineNumber |
InventoryLotId | PurchLine | InventTransId |
ItemNumber | PurchLine | ItemId |
LineDescription | PurchLine | Name |
OrderedPurchaseQuantity | PurchLine | PurchQty |
PurchaseUnitSymbol | PurchLine | PurchUnit |
PurchPrice | PurchLine | PurchPrice |
LineAmount | PurchLine | LineAmount |
RemainingPurchasePhysicalQuantity | PurchLine | RemainPurchPhysical |
VendorAccountNumber | PurchTable | OrderAccount |
IntercompanyLegalEntityId | PurchTable | InterCompanyCompanyId |
IntercompanySalesOrderNumber | PurchTable | InterCompanySalesId |