MGCLatticeSetBasedProductionRouteCardLineEntity

Imports production route card and job card journal lines (hours and quantities reported on the operations and jobs 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
OperationNumber	OprNum	No
OperationPriority	RouteOprPriority	No
OperationId	RouteOprId	No
JobId	ProdJobId	No
JobType	RouteJobType	No
ResourceId	WrkCtrIdBase	No
WorkerPersonnelNumber	HcmPersonnelNumberId	No
Hours	ProdReportedHours	No
GoodQuantity	ProdReportedGood	No
ErrorQuantity	ProdReportedError	No
ErrorCause	ProdErrorCause	No
HourCostCategoryId	RouteCostCategoryId	No
HourPrice	ProdHourPrice	No
QuantityCostCategoryId	RouteCostCategoryId	No
QuantityPrice	ProdQtyPrice	No
OperationFinished	ProdFinishedOpr	No
JobFinished	ProdFinishedJob	No
ExecutedPercentage	ProdExecutedPct	No

Mappings

Entity field	Data source	Field
JournalNumber	ProdJournalTable	JournalId
JournalNameId	ProdJournalTable	JournalNameId
ProductionOrderNumber	ProdJournalRoute	ProdId
LineNumber	ProdJournalRoute	LineNum
TransactionDate	ProdJournalRoute	TransDate
OperationNumber	ProdJournalRoute	OprNum
OperationPriority	ProdJournalRoute	OprPriority
OperationId	ProdJournalRoute	OprId
JobId	ProdJournalRoute	JobId
JobType	ProdJournalRoute	JobType
ResourceId	ProdJournalRoute	WrkCtrId
Hours	ProdJournalRoute	Hours
GoodQuantity	ProdJournalRoute	QtyGood
ErrorQuantity	ProdJournalRoute	QtyError
ErrorCause	ProdJournalRoute	ErrorCause
HourCostCategoryId	ProdJournalRoute	CategoryHoursId
HourPrice	ProdJournalRoute	HourPrice
QuantityCostCategoryId	ProdJournalRoute	CategoryQtyId
QuantityPrice	ProdJournalRoute	QtyPrice
OperationFinished	ProdJournalRoute	OprFinished
JobFinished	ProdJournalRoute	JobFinished
ExecutedPercentage	ProdJournalRoute	ExecutedPct