Part Data Format Specification

This section contains tables illustrating the data file import format for the part entity.

Each column represents a field, and should be separated in the file by a tab (the delimiter). Each row should be terminated with a carriage return.

This page discusses:

RowType=P (Part) or RowType=PUD (Part Update Data

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 NumberField NameDefinition & Materials Compliance Management-Workgroup MappingMaterials Compliance Management Mapping
1RowtypeDefines the type of data in the row. Set to "P" or "PUD".
2LevelPart hierarchy level. Level 1= highest level within scope of file. Not used for Rowtype "PUD".
3 Part NumberThe unique part number (typically from the BoM system). Not required for Rowtype "PUD".Part "Name" attribute
4Part RevisionPart revision number/designatorPart "Revision" attribute
5Part Revision DateDate of the revision. Date format must be YYYY-MM-DD.Part "External Revision Date" attribute
6Part NameName of the part (typically from BOM system). Not required for Rowtype "PUD".Part "Description" attribute
7Part TypeSet to "Assembly" if saleable end item, otherwise "Component". Valid values are: Assembly, Component. Not required for Rowtype "PUD".Not imported in Materials Compliance Management
8Part Quantity AmountQuantity 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.
9Part Quantity UoMUnit 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)
10Part Weight AmountNumerical 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 %.
11Part Weight UoMThe 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 %.
12Weight-Per UoMWeight 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 %.
13Colored FlagFlag indicating whether part is a colored part. Valid values are: Yes, No.Not imported in Materials Compliance Management
14Article FlagFlag indicating whether part is an article. Valid values are: Yes, No.Not imported in Materials Compliance Management
15Recycling CodeA 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
16RSRC Recyclability CategoryRecyclability 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
17RSRC Disassembly CategoryDisassembly 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
18J1344 Recycling CodeNo longer used.Not imported in Materials Compliance Management
19CFCsWhether CFCs are used in the manufacturing process of this part. Valid values are: Yes, No. Part "Contains CFCs" attribute
20Part StageProcess stage of the part. Valid values are: Prototype, Development, Released, Service.Part "External Part Stage" attribute
21Supplier IDSupplier 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.
22Fabrication Plant NameManufacturing 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.
23Supplier 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.
24Supplier RevisionOptional: 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.
25Supplier Rev DateOptional: 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.
26GM Dismantling CategoryThis 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
27Model YearThe four character model year associated with the part.Not imported in Materials Compliance Management
28Division/Product TypeThis 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
29Miscellaneous1Miscellaneous 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
30Miscellaneous2Miscellaneous 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
31Miscellaneous3Miscellaneous 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
32Miscellaneous4Miscellaneous 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
33Miscellaneous5Miscellaneous 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
34Component IMDS IDIMDS Component Node ID attribute of Part object
35SemiComponent IMDS IDIMDS Semicomponent Node ID attribute of Part object
36IMDS Module IDIMDS 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.
37IMDS VersionIMDS 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.
38VersionPart "External Part Version" attribute
39Part ApplicationPart "Part Application" attribute
40Part FamilyNot imported in Materials Compliance Management
41ISO 1043 and ISO 11469 Polymeric MarkingValues are "Yes", "No", and "N/A".Part "Polymeric Marking" attribute
NotesCoordinate 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 %.

RowType=PS (Part Specification)

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

Field NumberField Name

Definition & Materials Compliance Management-Workgroup Mapping

Materials Compliance Management Mapping
1

Rowtype

Defines the type of data in the row. Set to "PS".

2SpecificationThe part specification. Parts with multiple referenced specifications (performance, materials, OEM-specific, etc.), can each be defined in these rows.Specification "Name" attribute.

Row Type=PC (Part Customer)

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

Field NumberField NameDefinition & Materials Compliance Management-Workgroup MappingMaterials Compliance Management Mapping
1RowtypeDefines the type of data in the row. Set to "PC".
2Reference CustomerCustomer 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
3ProgramThe 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.
4Customer Part NumberCustomer's part number for the part.Customer Part Number "Name" attribute
5Customer RevisionCustomer's revision number for the part.Customer Part Number "External Revision Level" attribute
6Customer Revision DateCustomer's revision date for the part. Format must be YYYY-MM-DD.Customer Part Number "External Revision Date" attribute

RowType=M (Material)

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

Field NumberField NameDefinition & Materials Compliance Management-Workgroup MappingMaterials Compliance Management Mapping
1RowtypeDefines the type of data in the row. Set to "M".
2LevelThe level underneath the part or material (Level 2 = material in a top-level part).
3Material NameA name for the material.Material "Title" attribute
4TradenameA tradename (typically manufacturer-specific) for the material.Material "Marketing Name" attribute
5ManufacturerThe manufacturer of the material.Material "Manufacturer" attribute
6Material WeightNumerical 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.
7Material UoMMaterial 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).
8IMDS ClassificationClassification code per IMDS.Classification relationship between Material and matching Material Classification object
9RSRC DesignationDesignation per RSRC.Not imported in MCC
10PIRPost-industrial recyclate percentage in the material. Valid values are: A number from 0 to 100.Material "Percent Post Industrial Recyclate" attribute
11PCRPost-consumer recyclate percentage in the material. Valid values are: A number from 0 to 100.Material "Percent Post Consumer Recyclate" attribute
12Contained Recyclate % (as measured)Valid values are: A number from 0 to 100.Material "Percent Measured Contained Recyclate" attribute
13Specific GravityNumerical measure of specific gravity. Must be a positive number.Material "Specific Gravity" attribute

Material Symbol attribute of Material object

14IMDS SymbolIMDS material symbol.Not imported in MCC
15Miscellaneous1Miscellaneous 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
16IMDS ID
17IMDS Module IDIMDS Material Module ID attribute of Material object
18IMDS VersionIMDS Material Version attribute of Material object
19Internal Material NumberMaterial "Material Number" attribute
20Material StageNot imported in MCC
21Standard Material NumberStandard Material Number attribute of Material object
NotesA minimum of Substance Name or CAS Number is required. If CAS Number is specified, it will be used exclusively for matching.

RowType=MS (Material Specification)

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

Field NumberField Name

Definition & Materials Compliance Management-Workgroup Mapping

Materials Compliance Management Mapping
1

Rowtype

Defines the type of data in the row. Set to "PS".

2Ref CustomerIf a customer specification refers to name of the customer that purchases the part. Blank for an industry specificationNot imported in MCC
3SpecificationThe material specificationSpecification "Name" attribute

RowType=S (Substance Reference)

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

Field NumberField NameDefinition & Materials Compliance Management-Workgroup MappingMaterials Compliance Management Mapping
1RowtypeDefines the type of data in the row. Set to "S".
2CAS 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
3Substance Name The standard name of the substance. Valid values: Name of an existing Materials Compliance Management substance.Used to match a substance only
4Substance 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.