Part Data Format Specification

Creates a enterprise part or an enterprise plant-specific part in Materials Compliance Management and will also connect this part to parent parts for Level >1.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "P" or "PUD".
2	Level	Part hierarchy level. Level 1= highest level within scope of file. Not used for Rowtype "PUD".
3	Part Number	The unique part number (typically from the BoM system). Not required for Rowtype "PUD".	Part "Name" attribute
4	Part Revision	Part revision number/designator	Part "Revision" attribute
5	Part Revision Date	Date of the revision. Date format must be YYYY-MM-DD.	Part "External Revision Date" attribute
6	Part Name	Name of the part (typically from BOM system). Not required for Rowtype "PUD".	Part "Description" attribute
7	Part Type	Set to "Assembly" if saleable end item, otherwise "Component". Valid values are: Assembly, Component. Not required for Rowtype "PUD".	Not imported in Materials Compliance Management
8	Part Quantity Amount	Quantity of sub-part. Applicable and required if Level > 1. Will be ignored if an end item (i.e. Level = 1). Valid values are: Positive number. Not required for Rowtype "PUD".	Creates EBOM relationship between part and parent part (using the Level field to define the position of the part in the BOM hierarchy). This field maps to the Quantity attribute of this relationship.
9	Part Quantity UoM	Unit of Measure of sub-part. Applicable and required if Level > 1. Will be ignored if an end item (i.e. top level). Valid values are: each, g, kg, lb, in, ft, yd, mm, cm, m, in*2, ft*2, mm*2, cm*2, m*2, in*3, ft*3, mm*3, cm*3, m*3, gallon, liter. Not required for Rowtype "PUD" unless Part Quantity Amount is specified.	EBOM relationship Quantity Unit of Measure attribute (see above)
10	Part Weight Amount	Numerical measured weight of the part. This is always unit weight, even if Part Quantity is not 1. Value values are: Any positive number.	Part "Weight" dimensional attribute. Required for Rowtype "P" leaf parts that have materials specified (typically bottom-level leaf parts) using a quantity of %.
11	Part Weight UoM	The part weight units designator. Valid values are: g, kg, lb.	Part "Weight" dimensional attribute. Required for Rowtype "P" leaf parts that have materials specified (typically bottom-level leaf parts) using a quantity of %.
12	Weight-Per UoM	Weight units per amount. Valid values are: each, in, ft, yd, mm, cm, m, in*2, ft*2, mm*2, cm*2, m*2, in*3, ft*3, mm*3,, cm*3, m*3, gallon, liter.	Part “Unit of Measure” attribute. Required for Rowtype "P" leaf parts that have materials specified (typically bottom-level leaf parts) using a quantity of %.
13	Colored Flag	Flag indicating whether part is a colored part. Valid values are: Yes, No.	Not imported in Materials Compliance Management
14	Article Flag	Flag indicating whether part is an article. Valid values are: Yes, No.	Not imported in Materials Compliance Management
15	Recycling Code	A multi-value field that indicates whether the part is physically marked for the purpose of recycling. Each value should be quoted, and multiple quoted values separated by a comma. Valid values are: "Chemical Symbol", "VDA 260", "ISO 11469", "ISO 1629", "ISO 1043-2", "ISO 1043-1", "SAE J1344", "Not Marked", "Not Applicable".	Part "Recycling Code Standards" attribute
16	RSRC Recyclability Category	Recyclability category indicating how recyclable it is based on the material(s) it is made from. Valid values are: 1, 2, 3, 4, 5, 6.	Not imported in Materials Compliance Management
17	RSRC Disassembly Category	Disassembly category that best reflects the amount of time and effort required to remove the part from the assembly it is used in. Valid values are: 1, 2, 3, 4, 5.	Not imported in Materials Compliance Management
18	J1344 Recycling Code	No longer used.	Not imported in Materials Compliance Management
19	CFCs	Whether CFCs are used in the manufacturing process of this part. Valid values are: Yes, No.	Part "Contains CFCs" attribute
20	Part Stage	Process stage of the part. Valid values are: Prototype, Development, Released, Service.	Part "External Part Stage" attribute
21	Supplier ID	Supplier ID (Name or Code/Number) of the part supplier. Valid values are: Supplier Name of a Row Type=V entry or an existing Materials Compliance supplier name OR Vendor Code/Number of an Row Type=V entry or an existing Materials Compliance Management supplier code. Note: This should include an internal code for in-house make parts.	Used to identify a supplier in Materials Compliance Management for an MEP that is matched or created and then connected to the enterprise part as a manufacturer equivalent.
22	Fabrication Plant Name	Manufacturing Fabrication Plant Name associated to the part. Valid values are: Fabrication Plant Name in a Row Type=VP (Supplier Plant) row or an existing Materials Compliance Management fabrication plant name.	Used to identify a supplier location (by Location "Name" attribute) to be used as the manufacturer location for an MEP that is matched or created and then connected to the enterprise part as a manufacturer equivalent.
23	Supplier Part #	Optional: Supplier part number, if purchased part.	Attribute "Name" of the MEP that is matched or created and then connected to the enterprise part as a Manufacturer Equivalent.
24	Supplier Revision	Optional: Supplier part revision designator, if purchased part.	Attribute "External Revision Level" of the MEP that is matched or created and then connected to the enterprise part as a Manufacturer Equivalent.
25	Supplier Rev Date	Optional: Supplier part rev date, if purchased part. Format must be YYYY-MM-DD.	Attribute "External Revision Date" of the MEP that is matched or created and then connected to the enterprise part as a Manufacturer Equivalent.
26	GM Dismantling Category	This is the dismantling category for the part according to the General Motors GMW3116 standard. Valid values are: D1, D2, or D3.	Not imported in Materials Compliance Management
27	Model Year	The four character model year associated with the part.	Not imported in Materials Compliance Management
28	Division/Product Type	This field is used to define the product type or company division to which the part belongs. The name must correspond exactly to one of the valid names already defined in MCC for this field. If multiple company divisions/ product types are associated with the part, use comma to delimit. For example, "div1","div2".	Causes a plant-specific part to be created for the enterprise part. This field maps to a host company location in MCC
29	Miscellaneous1	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	Not imported in Materials Compliance Management
30	Miscellaneous2	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	Not imported in Materials Compliance Management
31	Miscellaneous3	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	Not imported in Materials Compliance Management
32	Miscellaneous4	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	Not imported in Materials Compliance Management
33	Miscellaneous5	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	Not imported in Materials Compliance Management
34	Component IMDS ID		IMDS Component Node ID attribute of Part object
35	SemiComponent IMDS ID		IMDS Semicomponent Node ID attribute of Part object
36	IMDS Module ID		IMDS Component/Semicomponent Module ID attribute of Part object. This field (if non-empty) will be mapped to attribute "IMDS Component Module ID" if field "Component IMDS ID" is non-empty and field "SemiComponent IMDS ID" is empty. This field (if non-empty) will be mapped to attribute "IMDS Semicomponent Module ID" if field "Component IMDS ID" is empty and field "SemiComponent IMDS ID" is non-empty. An error will be reported that reflects this field cannot be imported if it is non-empty and fields "Component IMDS ID" and "SemiComponent IMDS ID" are non-empty.
37	IMDS Version		IMDS Component/Semicomponent Version attribute of Part object. This field (if non-empty) will be mapped to attribute "IMDS Component Version" if field "Component IMDS ID" is non-empty and field "SemiComponent IMDS ID" is empty. This field (if non-empty) will be mapped to attribute "IMDS Semicomponent Version" if field "Component IMDS ID" is empty and field "SemiComponent IMDS ID" is non-empty. An error will be reported that reflects this field cannot be imported if it is non-empty and fields "Component IMDS ID" and "SemiComponent IMDS ID" are non-empty.
38	Version		Part "External Part Version" attribute
39	Part Application		Part "Part Application" attribute
40	Part Family		Not imported in Materials Compliance Management
41	ISO 1043 and ISO 11469 Polymeric Marking	Values are "Yes", "No", and "N/A".	Part "Polymeric Marking" attribute
Notes	Coordinate any use of Miscellaneous fields in advance with ENOVIA. ------------------------------------- Required for Rowtype "P" leaf parts that have materials specified (typically bottom-level leaf parts) using a quantity of %.

Creates a specification in Materials Compliance Management and connects it to the part.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "PS".
2	Specification	The part specification. Parts with multiple referenced specifications (performance, materials, OEM-specific, etc.), can each be defined in these rows.	Specification "Name" attribute.

Creates a customer part number in Materials Compliance Management and connects it to the part.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "PC".
2	Reference Customer	Customer name of the customer that purchases the part. Valid values are: Customer Name in a Row Type=C (Customer) row or an existing Materials Compliance customer.	Used to match a customer in MCC. Used with the Program field to connect the Customer Part Number to the matched Customer Program in MCC
3	Program	The name of the customer vehicle program using the part. Valid values are: Program in a Row Type=CP (Customer Program) row or an existing Materials Compliance program.	Used to match a customer program in MCC. Used with the Reference Customer field to connect the Customer Part Number to the matched Customer Program in MCC.
4	Customer Part Number	Customer's part number for the part.	Customer Part Number "Name" attribute
5	Customer Revision	Customer's revision number for the part.	Customer Part Number "External Revision Level" attribute
6	Customer Revision Date	Customer's revision date for the part. Format must be YYYY-MM-DD.	Customer Part Number "External Revision Date" attribute

Creates a material in Materials Compliance Management and will also connect this material to parent parts and materials.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "M".
2	Level	The level underneath the part or material (Level 2 = material in a top-level part).
3	Material Name	A name for the material.	Material "Title" attribute
4	Tradename	A tradename (typically manufacturer-specific) for the material.	Material "Marketing Name" attribute
5	Manufacturer	The manufacturer of the material.	Material "Manufacturer" attribute
6	Material Weight	Numerical measured mass of the material. Applicable and required if Level > 1. Valid values are: A positive number.	Creates Component Material relationship between material and parent part or material (using the Level field to define the position of the material in the BOM hierarchy). This field maps to the Quantity attribute of this relationship.
7	Material UoM	Material mass units designator. Applicable and required if Level > 1. Valid values are: g, kg, lb, %.	Component Material relationship Quantity Unit of Measure attribute (see above).
8	IMDS Classification	Classification code per IMDS.	Classification relationship between Material and matching Material Classification object
9	RSRC Designation	Designation per RSRC.	Not imported in MCC
10	PIR	Post-industrial recyclate percentage in the material. Valid values are: A number from 0 to 100.	Material "Percent Post Industrial Recyclate" attribute
11	PCR	Post-consumer recyclate percentage in the material. Valid values are: A number from 0 to 100.	Material "Percent Post Consumer Recyclate" attribute
12	Contained Recyclate % (as measured)	Valid values are: A number from 0 to 100.	Material "Percent Measured Contained Recyclate" attribute
13	Specific Gravity	Numerical measure of specific gravity. Must be a positive number.	Material "Specific Gravity" attribute Material Symbol attribute of Material object
14	IMDS Symbol	IMDS material symbol.	Not imported in MCC
15	Miscellaneous1	Miscellaneous field that can be populated with site-specific data. This field is pre-configured to support any single text string entry to be associated to the part.	IMDS Material Node ID attribute of Material object
16	IMDS ID
17	IMDS Module ID		IMDS Material Module ID attribute of Material object
18	IMDS Version		IMDS Material Version attribute of Material object
19	Internal Material Number		Material "Material Number" attribute
20	Material Stage		Not imported in MCC
21	Standard Material Number		Standard Material Number attribute of Material object
Notes	A minimum of Substance Name or CAS Number is required. If CAS Number is specified, it will be used exclusively for matching.

Creates a material specification in Materials Compliance Management and connects it to the material.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "PS".
2	Ref Customer	If a customer specification refers to name of the customer that purchases the part. Blank for an industry specification	Not imported in MCC
3	Specification	The material specification	Specification "Name" attribute

Creates a component substance connection between a substance and a material in Materials Compliance Management.

Field Number	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "S".
2	CAS Number	The unique CAS ID number for the substance. Valid values: CAS ID of an existing Materials Compliance Management substance.	Used to match a substance only
3	Substance Name	The standard name of the substance. Valid values: Name of an existing Materials Compliance Management substance.	Used to match a substance only
4	Substance Amount	Numerical amount of the substance. The valid value is a positive number.	Creates a Component Substance relationship between a substance and parent material. This field maps to the Quantity attribute of this relationship.