Supplier Data File Format Specification

Creates a Location in MCC-Enterprise and connects it to the supplier.

Field Number	Field Name	Definition & MCC-Workgroup Mapping	MCC-Enterprise Mapping
1	Rowtype	Defines the type of data in the row. Set to "V".
2	Supplier Name	The name of the company supplying the part.	Supplier Company "Name" attribute
3	Vendor Code / Number	A unique identifier for the supplier. If multiple vendor codes are associated with the supplier, use a comma to delimit and place the codes within quotes (" "). For example, "code1","code2"	Supplier Company "Organization ID" attribute
4	Supplier Type	Set to either "External" or "Internal", if in-house part.	Supplier Company "Supplier Type" attribute
5	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 supplier.	Not imported in MCC
Notes	Neither Supplier Name nor Vendor Code/Number can be reused over different suppliers. For example, a supplier name for one supplier cannot be used as a supplier code for another supplier.

Creates a location in Materials Compliance Management and connects it to the supplier.

Field Number	Field Name	Definition & MCC-Workgroup Mapping	MCC-Enterprise Mapping
1	Rowtype	Defines the type of data in the row. Set to "VP".
2	Fabrication Plant Name	The name of the plant (typically the city the plant is in).	Location "Name" attribute

Creates a location in Materials Compliance Management and connects it to the supplier.

Field Number	Field Name	Definition & MCC-Workgroup Mapping	MCC-Enterprise Mapping
1	Rowtype	Defines the type of data in the row. Set to "VPC".	Not imported in MCC
2	Customer Name	The name of the company being supplied by the plant.Valid values are: Customer Name in a Row Type=C (Customer) entry or an existing Materials Compliance Management customer name.	Not imported in MCC
3	Plant ID	Customer-assigned Plant ID for the supplier.	Not imported in MCC

Creates a person in Materials Compliance Management and connects it to the supplier.

Field Number	Field Name	Definition & MCC-Workgroup Mapping	MCC-Enterprise Mapping
1	Rowtype	Defines the type of data in the row. Set to "VC".
2	Name	Name of the contact person	Field parsed into “First Name, "Middle Name", and "Last Name" attributes
3	Type	Describes the type. (e.g., IMDS leader, etc.)	Not imported in Materials Compliance Management
4	Fabrication Plant Name	f applicable, the name of the plant for the contact. Valid values are: Fabrication Plant Name in a Row Type=VP (Supplier Plant) entry	Creates Primary Contact relationship between the supplier location and the person
5	Title	Job title of the contact person	Person "Title" attribute
6	Department	Department of the contact person	Creates Relationship "Department Employee" between the person and the department with this name.
7	Mail Code	Mail code (if applicable) of the contact person	Person "Mail Code" attribute
8	eMail	Email address of the contact person	Person "Email Address" attribute
9	Phone	Phone number of the contact person	Person “Work Phone Number” attribute
10	Fax	Fax number of the contact person	Person "Fax Number" attribute
11	Cell	Cell phone number of the contact person	Person "Pager Number" attribute
12	Address1	Address line 1 of the contact person	Address 1 and 2 are combined into the Person "Address" attribute
13	Address2	Address line 2 of the contact person	Address 1 and 2 are combined into the Person "Address" attribute
14	City	City of the contact person	Person "City" attribute
15	State/Province	State/Province of the contact person	Person "State/Region" attribute
16	Zip/Postal Code	Zip/Postal Code of the contact person	Person "Postal Code" attribute
17	Country	Country of the contact person	Person "Country" attribute
18	Comment	Text comment string, which should be enclosed in quotes
Notes	A maximum of one supplier contact per fabrication plant is allowed.