Bills of Materials

In Scope

Technical: BOMTable | ID: D365FO-MFG-BOMTABLE-BILLS_OF_MATERIALS

See how this object fits into Manufacturing

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2 - Dependent Master Data
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: BOMTable

Field Definitions(5)

Rules & Considerations(20)

Sample Load Data(4)

_scenario	BOMIdRPK	ItemIdR	EffectiveDateR	Name	Active	SiteId	BOMType	Approved	DefaultBOM	ForModeling	ExpirationDate	BOMHeaderQuantity	ProductionGroupId	BOMHeaderUnitSymbol	BOMCalculationGroupId	EngineeringChangeOrderNumber
Example values from field definitions	FG-BOM-001	FG001	2023-01-01	FG001 Standard Build BOM	Yes	USMF	Standard	Yes	Yes	No	2024-12-31	1.00	ELECTRONICS	ea	STD_COST	ECO-2024-001
Variation 1 - type-safe variation anchored to example values	FGBOM00102	FG001	20230207	FG001STANDARDBUILDBOM02	ZES	VSMF	Planning	ZES	ZES	OO	20250206	1002	FLECTRONICS	FA	STDCOST02	ECO202400102
Variation 2 - additional in-range variation with row-level constraint alignment	FGBOM00103	FG002	20230316	FG001STANDARDBUILDBOM03	YGS	UUMF	Sales	YGS	YGS	NQ	20250315	1003	ENECTRONICS	EC	STDCOST03	ECO202400103

Example values from field definitions

BOMIdRPK: FG-BOM-001
ItemIdR: FG001
EffectiveDateR: 2023-01-01
Name: FG001 Standard Build BOM
Active: Yes
SiteId: USMF
BOMType: Standard
Approved: Yes
DefaultBOM: Yes
ForModeling: No
ExpirationDate: 2024-12-31
BOMHeaderQuantity: 1.00
ProductionGroupId: ELECTRONICS
BOMHeaderUnitSymbol: ea
BOMCalculationGroupId: STD_COST
EngineeringChangeOrderNumber: ECO-2024-001

Variation 1 - type-safe variation anchored to example values

BOMIdRPK: FGBOM00102
ItemIdR: FG001
EffectiveDateR: 20230207
Name: FG001STANDARDBUILDBOM02
Active: ZES
SiteId: VSMF
BOMType: Planning
Approved: ZES
DefaultBOM: ZES
ForModeling: OO
ExpirationDate: 20250206
BOMHeaderQuantity: 1002
ProductionGroupId: FLECTRONICS
BOMHeaderUnitSymbol: FA
BOMCalculationGroupId: STDCOST02
EngineeringChangeOrderNumber: ECO202400102

Variation 2 - additional in-range variation with row-level constraint alignment

BOMIdRPK: FGBOM00103
ItemIdR: FG002
EffectiveDateR: 20230316
Name: FG001STANDARDBUILDBOM03
Active: YGS
SiteId: UUMF
BOMType: Sales
Approved: YGS
DefaultBOM: YGS
ForModeling: NQ
ExpirationDate: 20250315
BOMHeaderQuantity: 1003
ProductionGroupId: ENECTRONICS
BOMHeaderUnitSymbol: EC
BOMCalculationGroupId: STDCOST03
EngineeringChangeOrderNumber: ECO202400103

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 20