MGCLatticeSetBasedProductionReportAsFinishedLineEntity
Imports production report as finished journal lines (good and error quantities 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 | JournalTransDate | No | |
ItemNumber | ItemId | No | |
GoodQuantity | ProdReportedGood | No | |
ErrorQuantity | ProdReportedError | No | |
ErrorCause | ProdErrorCause | No | |
IsLastReportAsFinished | ProdFinishedProd | No | |
AcceptError | ProdJournalAcceptError | No | |
PostPickingList | Name | 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 | ProdJournalProd | ProdId |
LineNumber | ProdJournalProd | LineNum |
TransactionDate | ProdJournalProd | TransDate |
ItemNumber | ProdJournalProd | ItemId |
GoodQuantity | ProdJournalProd | QtyGood |
ErrorQuantity | ProdJournalProd | QtyError |
ErrorCause | ProdJournalProd | ErrorCause |
IsLastReportAsFinished | ProdJournalProd | ProdFinished |
AcceptError | ProdJournalProd | PmfAcceptError |
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 |