MGCLatticeSetBasedProductionPickingListLineEntity
Imports production picking list journal lines (material consumption against the BOM lines of started production orders) in bulk with set-based processing.
- Primary key:
JournalNumber, LineNumber
Fields
| Name | Type | Mandatory | Description |
|---|
JournalNumber | ProdJournalId | Yes | |
JournalNameId | ProdJournalNameId | No | |
ProductionOrderNumber | ProdId | No | |
LineNumber | LineNum | Yes | |
TransactionDate | TransDate | No | |
InventoryLotId | InventTransIdBase | No | |
BOMLineNumber | LineNum | No | |
ItemNumber | ItemIdInventoried | No | |
ConsumptionBOMQuantity | UnitQty | No | |
ProposalBOMQuantity | UnitQty | No | |
BOMUnitSymbol | UnitOfMeasureSymbol | No | |
IsConsumptionEnded | NoYes | No | |
ErrorCause | ProdErrorCause | No | |
InventorySiteId | InventSiteId | No | |
InventoryWarehouseId | InventLocationId | No | |
WarehouseLocationId | WMSLocationId | No | |
ItemBatchNumber | InventBatchId | No | |
ItemSerialNumber | InventSerialId | No | |
InventoryStatusId | WHSInventStatusId | No | |
LicensePlateNumber | WHSLicensePlateId | No | |
ProductConfigurationId | EcoResItemConfigurationName | No | |
ProductSizeId | EcoResItemSizeName | No | |
ProductColorId | EcoResItemColorName | No | |
ProductStyleId | EcoResItemStyleName | No | |
ProductVersionId | EcoResItemVersionName | No | |
Mappings
| Entity field | Data source | Field |
|---|
JournalNumber | ProdJournalTable | JournalId |
JournalNameId | ProdJournalTable | JournalNameId |
ProductionOrderNumber | ProdJournalBOM | ProdId |
LineNumber | ProdJournalBOM | LineNum |
TransactionDate | ProdJournalBOM | TransDate |
InventoryLotId | ProdJournalBOM | InventTransId |
ItemNumber | ProdJournalBOM | ItemId |
ConsumptionBOMQuantity | ProdJournalBOM | BOMConsump |
BOMUnitSymbol | ProdJournalBOM | BOMUnitId |
IsConsumptionEnded | ProdJournalBOM | EndConsump |
ErrorCause | ProdJournalBOM | ErrorCause |
InventorySiteId | InventDim | InventSiteId |
InventoryWarehouseId | InventDim | InventLocationId |
WarehouseLocationId | InventDim | wMSLocationId |
ItemBatchNumber | InventDim | inventBatchId |
ItemSerialNumber | InventDim | inventSerialId |
InventoryStatusId | InventDim | InventStatusId |
LicensePlateNumber | InventDim | LicensePlateId |
ProductConfigurationId | InventDim | configId |
ProductSizeId | InventDim | InventSizeId |
ProductColorId | InventDim | InventColorId |
ProductStyleId | InventDim | InventStyleId |
ProductVersionId | InventDim | InventVersionId |