Open Production Orders

In Scope

Technical: ProdTable | ID: D365FO-MFG-PRODTABLE-OPEN_PRODUCTION_ORDERS

See how this object fits into Manufacturing

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: High
Sequencing: Stage 3 - Open Transactions
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ProdTable

This object has high complexity or dependency level

Review sequencing requirements before loading

Field Definitions(5)

Rules & Considerations(50)

Sample Load Data(4)

_scenario	ItemIdR	ProdIdRPK	StatusR	DueDateR	ScheduledDateR	BOMId	UnitId	RouteId	ProdName	ProdType	QtySched	CreatedDate	ProductType	InventSiteId	InventLocationId	DefaultDimensionDisplayValue	ReleasedDate	Reservations	InventBatchId	ReportAsFinishedDate	ReportAsFinishedQuantity	WorkerResponsible	InventConfigurationId
Example values from field definitions	FG001	PROD-MIG001	Scheduled	2023-11-25	2023-11-20	BOM-FG001-STD	ea	RTE-FG001-STD	Assembly of FG001 standard	Standard	100.0	2023-11-15T09:00:00Z	Product	USMF	WAREHOUSE01	Dept-01-CC001	—	—	—	—	—	—	—
Production order, partially reported as finished, with batch tracking	FG002-BATCH	PROD-MIG002	ReportedAsFinished	2023-11-18	2023-11-10	BOM-FG002-BATCH	pcs	RTE-FG002-BATCH	Batch production of FG002	Standard	200	2023-11-05T14:15:00Z	Product	USMF	BULKREC	—	2023-11-11	Automatic	BT20231116A	2023-11-16	150	—	—
Project production order for a configured item	CUSTCONFIG-001	PROD-MIG003	Released	2023-12-15	2023-12-01	BOM-CUSTCONFIG	ea	RTE-CUSTCONFIG	Custom configured widget for Project X	Standard	1	2023-11-20T11:00:00Z	Project	USMF	ASSEMBLE	—	2023-11-25	—	—	—	—	000123	CFG-PJT-X

Example values from field definitions

ItemIdR: FG001
ProdIdRPK: PROD-MIG001
StatusR: Scheduled
DueDateR: 2023-11-25
ScheduledDateR: 2023-11-20
BOMId: BOM-FG001-STD
UnitId: ea
RouteId: RTE-FG001-STD
ProdName: Assembly of FG001 standard
ProdType: Standard
QtySched: 100.0
CreatedDate: 2023-11-15T09:00:00Z
ProductType: Product
InventSiteId: USMF
InventLocationId: WAREHOUSE01
DefaultDimensionDisplayValue: Dept-01-CC001
ReleasedDate: —
Reservations: —
InventBatchId: —
ReportAsFinishedDate: —
ReportAsFinishedQuantity: —
WorkerResponsible: —
InventConfigurationId: —

Production order, partially reported as finished, with batch tracking

ItemIdR: FG002-BATCH
ProdIdRPK: PROD-MIG002
StatusR: ReportedAsFinished
DueDateR: 2023-11-18
ScheduledDateR: 2023-11-10
BOMId: BOM-FG002-BATCH
UnitId: pcs
RouteId: RTE-FG002-BATCH
ProdName: Batch production of FG002
ProdType: Standard
QtySched: 200
CreatedDate: 2023-11-05T14:15:00Z
ProductType: Product
InventSiteId: USMF
InventLocationId: BULKREC
DefaultDimensionDisplayValue: —
ReleasedDate: 2023-11-11
Reservations: Automatic
InventBatchId: BT20231116A
ReportAsFinishedDate: 2023-11-16
ReportAsFinishedQuantity: 150
WorkerResponsible: —
InventConfigurationId: —

Project production order for a configured item

ItemIdR: CUSTCONFIG-001
ProdIdRPK: PROD-MIG003
StatusR: Released
DueDateR: 2023-12-15
ScheduledDateR: 2023-12-01
BOMId: BOM-CUSTCONFIG
UnitId: ea
RouteId: RTE-CUSTCONFIG
ProdName: Custom configured widget for Project X
ProdType: Standard
QtySched: 1
CreatedDate: 2023-11-20T11:00:00Z
ProductType: Project
InventSiteId: USMF
InventLocationId: ASSEMBLE
DefaultDimensionDisplayValue: —
ReleasedDate: 2023-11-25
Reservations: —
InventBatchId: —
ReportAsFinishedDate: —
ReportAsFinishedQuantity: —
WorkerResponsible: 000123
InventConfigurationId: CFG-PJT-X

Rule Validation Summary

Source Rule Count: 50
Governed Rule Count: 50