IMDS Download Data

IMDS provides several delimited text files that can be used to create configuration data in Materials Compliance Management for common files such as materials classifications, substances, compliance applications, and substance applications.

For the IMDS download procedure, see the Materials Compliance Management User's Guide: Loading IMDS Data.

This topic describes these files:

This page discusses:

IMDS Material Classifications File
IMDS Substance File
IMDS Applications File
IMDS Substance Applications File
IMDS Company/Contact File
Materials
IMDS Internal and Public Modules
IMDS External Modules
File Contents: REACH Component Regulations Record Type RC
File Contents: REACH Component Regulations Record Type RCM
File Contents: REACH Component Regulations Record Type RCR
File Contents: REACH Material Regulations Record Type RM
File Contents: REACH Component Regulations Record Type RMS
File Contents: REACH Component Regulations Record Type RMR
File Contents: Record Type PT
File Contents: Record Type BM
File Contents: Record Type BMS
File Contents: Record Type BMP
File Contents: Record Type BMR
File Contents: Record Type RRR or SRR
Customer Part Number Upload
Renault Attributes

IMDS Material Classifications File

The IMDS Material Classifications file contains classification names (MATCAT_NAME) and IMDS classification codes (MATCAT_CODE) for materials. This file is used to create or update material classifications in Materials Compliance Management for the IMDS compliance type.

File Contents


Field Name	Description	Attribute Mapping
MATCAT_CODE	Material Classification Code	Attribute "Classification Code" of type "Material Classification"
MATCAT_NAME	Material Classification Description	Attribute "Description" of type "Material Classification"

Validation

When the material classification file is imported, the importer does the following:

If the MATCAT_CODE matches an existing material classification code for an IMDS material classification in Materials Compliance Management, the material classification should be updated to reflect the new description in the MATCAT_NAME field.
If a MATCAT_CODE does not match an existing material classification code for an IMDS material classification in Materials Compliance Management, the material classification should be added with the description and classification code.
All the existing IMDS material classifications in Materials Compliance Management that are not contained in the file are deleted. This is done only in the case when no materials in Materials Compliance Management reference the material classification. When the deletion cannot be done due to a material reference, a warning message is displayed.

IMDS Substance File

The IMDS Substance file contains valid IMDS substances. For each substance in IMDS, a name, CAS, IMDS node ID, and aliases are provided. This file is a means to add a new substance to Materials Compliance Management if a material is imported that references a non-existent Materials Compliance Management substance.

File Content: Record Type S


Field No	Description	Attribute Mapping
2	IMDS Node ID of the Substance	Attribute 'IMDS Node ID" of Type "Substance"
3	CAS Number of the Substance	Attribute "CAS Number" of Type "Substance"
4	EU Index Code (not used in Materials Compliance Management)	EU Index Code (not used in Materials Compliance Management)
5	EINECS / ELINCS Code (not used in Materials Compliance Management)	EINECS / ELINCS Code (not used in Materials Compliance Management)
6	GADSL-classification "duty-to-declare" (not used in Materials Compliance Management)	GADSL-classification "duty-to-declare" (not used in Materials Compliance Management)
7	GADSL-classification "IsUnwanted" (not used in Materials Compliance Management)	GADSL-classification "IsUnwanted" (not used in Materials Compliance Management)
8	GADSL-classification "IsProhibited" (not used in Materials Compliance Management)	GADSL-classification "IsProhibited" (not used in Materials Compliance Management)
9	IsDeleted (indicates whether the substance is deleted in IMDS) – 0 =no, 1=yes	Attribute "IMDS Node ID" of Type "Substance". This attribute should be set with IsDeleted as value.
10	IsHidden (indicates whether the substance is hidden in IMDS) – 0 =no, 1=yes	Attribute "IMDS Node ID" of Type "Substance". This attribute should be set with IsHidden as value.

File Content: Record Type SS


Field No	Description	Attribute Mapping
2	IMDS Node ID of the Substance	Attribute "IMDS Node ID" of type "Substance"
3	Position: 0 – this row contains the name of the substance 1:n-these rows contain aliases of the substance
4	Language – Process only SS rows that contain "EN" in this field
5	When field 3 is 0 then this column has the Substance name	Add the Substance Name to the S record
6	When field 3 is 1:n then this column is the synonym of the Substance name	Attribute "Substance Name" on type Substance (created with Alias relationship to the substance created with S record)

Validation

When imported, the substance file is searched for a matching substance when a material is imported that references a substance and no matching substance is found in Materials Compliance Management. If the substance is found in the file, the data in this file is used to add the substance to Materials Compliance Management so that the material can then reference it. If the substance is not found, the material is not created and an error is displayed.

Substance classifications are assigned automatically to the substances created with the IMDS File. This file does not contain substance classification information, but a separate file is created that maps CAS Numbers to substance classifications. The format of this file is in Materials Compliance Management SubstanceList XML format. Whenever a substance is about to be added to Materials Compliance Management from the IMDS substance file, this mapping file is used to automatically look up for the substance classification to use for the substance. If no mapping file is provided or there is no classification defined in the mapping file for a CAS Number, then the substance is not classified.

IMDS Applications File

The IMDS Applications file contains the valid compliance applications for IMDS. This file is used to create or update compliance applications in Materials Compliance Management.

File Contents: Record Type SA


Field No	Description	Attribute Mapping
2	Application Code of Compliance Application	Attribute "Application Code" of Type "Compliance Application"
3	Description of Compliance Application	Attribute "Description" of Type "Compliance Application"
4	IsDeleted (indicates whether the application is deleted in IMDS) – 0=no, 1=yes	N/A

Validation

After import of the Applications file, following validations are done:

If the Application is not marked as deleted (isDeleted=0) then:
- If the Application Code (Field 2) matches an existing Application Code for an IMDS compliance application in Materials Compliance Management, the compliance application should be updated to reflect the new description.
- If the Application Code (Field 2) does not match an existing Application Code for an IMDS Compliance Application in Materials Compliance Management, the compliance application should be added with the description and classification code.
Otherwise, it is marked as deleted (isDeleted=1):
If the Application Code (Field 2) matches an existing Application Code for an IMDS Compliance Application in Materials Compliance Management, the compliance application should be deleted if no substances in Materials Compliance Management reference the compliance application. If it cannot be deleted, a warning message is displayed stating that it could not be deleted due to substance references.

IMDS Substance Applications File

The IMDS substance applications file contains the valid substance applications for IMDS. Substance applications are relationships that define which compliance applications apply to particular combinations of substances and material classifications. This file is used to update the substance application relationships between existing Materials Compliance Management substances and compliance applications and to create the substance application relations.

File Contents

This table maps fields to attributes of Materials Compliance Management objects.


Field Name	Description	Attribute Mapping
SUBST_NODE_ID	IMDS Node ID - Used to look up a substance to connect this relationship TO	Attribute "IMDS Node ID" of type "Substance"
MATCAT_CODE	Material Classification Code of Substance Application relationship	Attribute "Material Classification Code" of relationship "Substance Application"
APPLICATION_ID	Compliance Application Code – used to look up a Compliance Application to connect this relationship FROM	Attribute "Application Code" of type "Compliance Application"
PER_CENT	Threshold of Substance Application relationship	Attribute "Threshold" of relationship "Substance Application"

Validation

Upon import, the contents of this file completely replace the existing substance applications to IMDS compliance applications. The existing ones in Materials Compliance Management are deleted and new connections are created for each substance application in this file.

This file contains references to substances by IMDS Node ID. In order to create a substance application connection to the substance, the substance needs to be found by IMDS Node ID. There are two IMDS Node IDs associated with the substance: IMDS Node ID and IMDS Alternative Node ID. The IMDS Alternative Node ID takes precedence when looking up a substance. The IMDS Alternative Node ID is searched first, and if not found, a search is done by IMDS Node ID.

IMDS Company/Contact File

The IMDS Company/Contact file contains a set of all IMDS companies and their contacts. This file contains the list of contact persons of the host company that can be referenced on an upload to IMDS. It also contains supplier company data, including contacts, that can be used by the importer when modules are imported.

Note: Record Type CU is not imported into Materials Compliance Management.

File Contents: Record Type CO

This table lists imported fields.


Field No	Description
2	IMDS Company ID
3	Company Name
4	Street
5	Postbox - NOT IMPORTED
6	ISO Country Code
7	Postal Code
8	City - NOT IMPORTED
9	isDeleted - NOT IMPORTED

File Contents: Record Type CT

This table lists imported fields.


Field No	Description
2	IMDS Company ID - NOT IMPORTED
3	Contact ID in the company’s contact list (starting at 1)
4	isDeleted - NOT IMPORTED
5	Contact Last name
6	Contact First name
7	Contact Phone number
8	Contact Fax number
9	Contact email address
10	Contact Department name - NOT IMPORTED
11	Contact Mailbox - NOT IMPORTED
13	IsREACHContact

File Contents: Record Type OC

Materials Compliance Management is supported the data move (DMV) file, to support the merging of IMDS companies in IMDS 12.2. The data move (DMV) file is created that is specific to the IMDS company download file. This table lists the record type as OC that is generated in the data move (DMV) file when the owner of the IMDS module is changed.


Field No	Name	Type
1	OC (Recod Identifier)	A2
2	Node ID	N18
3	Organization Unit ID	N9
4	Company ID	N9
5	Contact Person ID	N4
6	Data Move Date	DT

File Contents: Record Type RC

This table lists the record type as RC that is generated in the data move (DMV) file when the reciepent of the IMDS module is changed.


Field No	Name	Type
1	RC (Recod Identifier)	A2
2	Node ID	N18
3	Original Company or Organization Unit ID	N9
4	Company or Organization Unit ID	N9
5	Data Move Date	DT

Materials

File Contents: Record Type Material

This table maps fields to attributes of Materials Compliance Management objects.


Field No	Description	Mapping
2	NodeID	Attribute "IMDS Material Node ID" on type "Material"
3	Supplier	Attribute "Manufacturer" on type "Material"
4	Material Classification Code	Relationship to type "Material Classification"
5	Supplier Material-No.	Attribute "Internal Material Number" on type "Material"
6	Chemical Symbol	Attribute "IMDS Symbol" on type "Material"
7	Standard Material Number	Attribute "Standard Material Number" on type "Material"
8	No Joker for GADSL	Attribute "No Joker for GADSL" on type "Material"

File Contents: Record Type Multilingual

This table maps fields to attributes of Materials Compliance Management objects.


Field No	Description	Mapping
2	NodeID	Attribute "IMDS Material Node ID" on type "Material". (Same as field 2 of MATERIAL record)
3	ISO Language	None
4	Name	Attribute "Name" on type "Material" when ISO Language is "EN"
5	Trade Name	Attribute "Trade Name" on type "Material"
6	Remark	Attribute "IMDS Miscellaneous Substance Remark" on type "Material"

File Contents: Record Type Normentry

This table maps fields to attributes of Materials Compliance Management objects.


Field No	Description	Mapping
2	NodeID	Attribute "IMDS Material Node ID" on type "Material". (Same as field 2 of MATERIAL record)
3	Institute Name Code	Attribute "IMDS Institute" on type "Material Specification"
4	Norm Code	Attribute "Name" on type "Material Specification"

IMDS Internal and Public Modules

File Contents: Record Type MODULINFORMATION

This table maps fields to attributes of Materials Compliance Management objects.


Field No	Description	Mapping
2	Module ID	Attribute "IMDS Material Module ID" of type "Material" of top-level node if it is a material. Attribute "IMDS Semicomponent Module ID" of type "EnterprisePart" of top-level node if it is a semicomponent. Attribute "IMDS Component Module ID" of type "EnterprisePart" of top-level node if it is a component.
3	Version	Attribute "IMDS Material Version" of type "Material" of top-level node if it is a material. Attribute "IMDS Semicomponent Version" of type "EnterprisePart" of top-level node if it is a semicomponent. Attribute "IMDS Component Version" of type "EnterprisePart" of top-level node if it is a component.

File Contents: Record Type C

This table maps fields to Materials Compliance Management attributes of Enterprise Parts.


Field No	Description	Mapping
2	IMDS Node ID of the Component	Attribute "IMDS Component Node ID" of type "Enterprise Part"
3	Description	Attribute "Description" of type "Enterprise Part"
4	Tolerance	Attribute "IMDS Weight Tolerance"
5	Measured weight in grams	Attribute "Weight (Reference)" of type "Enterprise Part"
	Calculated Weight in grams	Attribute "Weight (Reference)" of type "Enterprise Part"
7	Part/Item No.	Attribute "Name" of type "Enterprise Part"
9	Polymeric Parts Marking	Attribute "ISO 1043 and ISO 11469 Polymeric Marking" of type "Enterprise Part"
9	Is Primary	B
11	Is multi source	N1 (0=No, 1=Yes)

File Contents: Record Type H

This table maps fields to Materials Compliance Management attributes.


Field No	Description	Mapping
2	IMDS Node ID of the Semicomponent	Attribute "IMDS Semicomponent Node ID" of type "Enterprise Part"
3	Article Nam	Attribute "Description" of type "Enterprise Part"
4	Item No.	Attribute "Name" of type "Enterprise Part"
5	Specific Weight (in kg)	Attribute "Weight (Reference)" on type "MEP"
6	Specific Weight Type (0=Weightless,1=m,2=m2,3=m3)	Attribute "Unit of Measure" on type "MEP"

IMDS External Modules

File Contents: Record Type MDBCOMMON

This table maps the fields to Materials Compliance Management attributes.


Field No	Description	Mapping
4	Company ID (MDS Supplier)	Attribute "IMDS Company ID"

File Contents: Record Type RECIPIENT SPEC

This table maps fields to attributes of Materials Compliance Management objects.


Field No	Description	Mapping
4	Product Name or Description	Attribute "Description" on type "Enterprise Part"
6	Part number or item number	Attribute "Name" on type "Enterprise Part"
9	Rejection comments	Attribute "Rejection Comments" on type "Material Declaration"
11	Supplier Code	Attribute "Company ID" on type "Supplier"
22	Recipient Status	Current State of type "Material Declaration"
	Field 22 Value	Action
	A	Promote the Material Declaration to Accepted
	N or B	Promote the Material Declaration to Received
	C	Promote the Material Declaration to Canceled
	R	Promote the Material Declaration to Rejected

File Contents: Record Type C

This table maps fields to attributes of the MEP.


Field No	Description	Mapping
2	IMDS Node ID of the Component	Attribute "IMDS Component Node ID" of type "MEP"
3	Description	Attribute "Description" of type "MEP"
5	Measured weight in grams	Attribute "Weight (Reference)" of type "MEP"
7	Part/Item No.	Attribute "Name" of type "MEP"
8	Polymeric Parts Marking	Attribute "ISO 1043 and ISO 11469 Polymeric Marking" of type "MEP"

File Contents: Record Type H

This table maps fields to attributes of the MEP.


Field No	Description	Mapping
2	IMDS Node ID of the Semicomponent	Attribute "IMDS Semicomponent Node ID" of type "MEP"
3	Article Nam	Attribute "Description" of type "MEP"
4	Item No.	Attribute "Name" of type "MEP"
5	Specific Weight (in kg)	Attribute "Weight (Reference)" on type "MEP"
6	Specific Weight Type (0=Weightless,1=m,2=m2,3=m3)	Attribute "Unit of Measure" on type "MEP"

File Contents: REACH Component Regulations Record Type RC

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Component object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation REACH Component"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation REACH Component"

Version Create Date

Attribute "Version Create Date" on type "IMDS Regulation REACH Component"

Version Release Date

Attribute "Version Release Date" on type "IMDS Regulation REACH Component"

Produced in EEA?

Attribute "Produced In EEA" on type "IMDS Regulation REACH Component"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes
2	Available From Stock

File Contents: REACH Component Regulations Record Type RCM

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Component object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation REACH Component"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation REACH Component"

Node ID material

Attribute "Material Node ID" on type "IMDS Regulation REACH Component"

Material Imported

Attribute "Material Imported" on type "IMDS Regulation REACH Component"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

Authorization status ID

Attribute "Material Authorization Status" on type "IMDS Regulation REACH Component"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	Done
1	In progress
2	Unanswered
3	Not intended
4	By material manufacturer

File Contents: REACH Component Regulations Record Type RCR

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Component object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period


Field No	Description	Mapping
2	Regulation ID	Attribute "Name" on type "IMDS Regulation REACH Component"
3	Node ID Module	Attribute "Module Node ID" on type "IMDS Regulation REACH Component"
4	Node ID Parent	Attribute "Parent Node ID" on type "IMDS Regulation REACH Component"
5	Node ID Component	Attribute "Component Node ID" on type "IMDS Regulation REACH Component"
6	Regulation Create Date	Attribute "Regulation Create Date" on type "IMDS Regulation REACH Component"

File Contents: REACH Material Regulations Record Type RM

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Material object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation REACH Material"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation REACH Material"

Version Create Date

Attribute "Version Create Date" on type "IMDS Regulation REACH Material"

Version Release Date

Attribute "Version Release Date" on type "IMDS Regulation REACH Material"

Still in Production?

Attribute "Still In Production" on type "IMDS Regulation REACH Material"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

EEA produced/imported

Attribute "EEA Produced Imported" on type "IMDS Regulation REACH Material"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

File Contents: REACH Component Regulations Record Type RMS

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Material object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation REACH Material"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation REACH Material"

Node ID Subst

Attribute "IMDS Substance Node ID" on type "Substance"

Authorization status ID

Attribute "Substance Authorization Status" on relationship "IMDS Regulation Substance"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	Done
1	In progress (applied after latest application date)
2	Unanswered
3	Not intended
4	In progress (applied before latest application date)

File Contents: REACH Component Regulations Record Type RMR

This table maps fields from any of the below file types to attributes of the IMDS Regulation REACH Material object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period


Field No	Description	Mapping
2	Regulation ID	Attribute "Name" on type "IMDS Regulation REACH Material"
3	Node ID Module	Attribute "Module Node ID" on type "IMDS Regulation REACH Material"
4	Node ID Parent	Attribute "Parent Node ID" on type "IMDS Regulation REACH Material"
5	Node ID Component	Attribute "Component Node ID" on type "IMDS Regulation REACH Material"
6	Regulation Create Date	Attribute "Regulation Create Date" on type "IMDS Regulation REACH Material"

File Contents: Record Type PT

This table maps fields from any of the below file types for substances in biocidal materials to an IMDS Product Type object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period


Field No	Description	Mapping
2	Product Type ID	"Name" of the "IMDS Product Type" type
3	Product Type description	"Description" of the "IMDS Product Type" type

File Contents: Record Type BM

This table maps fields from any of the below file types for biocidal material regulations to an "IMDS Regulation Biocidal Material" type.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation Biocidal Material"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation Biocidal Material"

Version Create Date

Attribute "Version Create Date" on type "IMDS Regulation Biocidal Material"

Version Release Date

Attribute "Version Release Date" on type "IMDS Regulation Biocidal Material"

Still in Production?

Attribute "Still In Production" on type "IMDS Regulation Biocidal Material"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

File Contents: Record Type BMS

This table maps fields from any of the below file types for biocidal material regulations to an "IMDS Regulation Biocidal Material" type.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period

Field No

Description

Mapping

Regulation ID

Attribute "Name" on type "IMDS Regulation Biocidal Material"

Regulation Version

Attribute "Regulation Version" on type "IMDS Regulation Biocidal Material"

Node ID Subst

Attribute "IMDS Substance Node ID" on type "Substance"

Added for biocidal property

Attribute "Added For Biocidal Property" on rel "IMDS Regulation Substance"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

Biocidal property desired in finished article/product

Attribute "Biocidal Property Desired In Finished Article Product" on rel "IMDS Regulation Substance"

The IMDS attribute values are mapped as follows:


IMDS Attribute Value	MCC Attribute Value
-1	(blank)
0	No
1	Yes

File Contents: Record Type BMP

This table maps fields from any of the following file types for biocidal material regulations to an "IMDS Regulation Biocidal Material" type.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period


Field No	Description	Mapping
2	Regulation ID	Attribute "Name" on type "IMDS Regulation Biocidal Material"
3	Regulation Version	Attribute "Regulation Version" on type "IMDS Regulation Biocidal Material"
4	Node ID Subst	Attribute "IMDS Substance Node ID" on type "Substance"
5	Product Type ID	If an IMDS Product Type does not already exist, creates a "IMDS Product Type" rel and connects it to the "IMDS Regulation Biocidal Material"

File Contents: Record Type BMR

This table maps fields from any of the below file types to attributes of the IMDS Regulation Biocidal Material object.

PRDaily: Public Regulation data for a particular day
PRAll: All Public Regulation data
CRDaily: Company Regulation data for a particular day
CRAll: All Company Regulation data
CRPeriod: Company Regulation data for a requested time period


Field No	Description	Mapping
2	Regulation ID	Attribute "Name" on type "IMDS Regulation Biocidal Material"
3	Node ID Module	Attribute "Module Node ID" on type "IMDS Regulation Biocidal Material"
4	Node ID Parent	Attribute "Parent Node ID" on type "IMDS Regulation Biocidal Material"
5	Node ID Material	Attribute "Material Node ID" on type "IMDS Regulation Biocidal Material"
6	Regulation Create Date	Attribute "Regulation Create Date" on type "IMDS Regulation Biocidal Material"

File Contents: Record Type RRR or SRR

This table maps fields from any of the below file types to attributes of the IMDS Regulation object. The RRR record type includes host company regulation requests and the SRR record type includes supplier regulation requests.

RRDaily: Company specific regulation requests for a particular date
RRAll: All company specific regulation requests
CRPeriod: Company specific regulation requests for a requested time period


Field No	Description	Mapping
2	Regulation ID	Attribute "Name" on type "IMDS Regulation"
3	Request Date Create	Attribute "Request Create Date" on type "IMDS Regulation"
4	Date Resolved	Attribute "Request Resolved Date" on type "IMDS Regulation"

Customer Part Number Upload

This table maps the IMDS Recipient fields to Materials Compliance Management attributes.


IMDS Recipient Data Field	MCC CPN Attribute
Drawing No.	Drawing Number
Drawing dated	Drawing Date
Drawing Change Level	Drawing Change Level
Report No.	Report Number
Date of Report	Report Date
Purchase Order No.	Purchase Order Number
Bill of Delivery No.	Bill of Delivery Number
Supplier Code	Supplier Code
Forwarding allowed	IMDS forwarding allowed
Supplier Site Code	Ford Supplier Site Code
SC1 (supplementary code1)	Daimler Supplementary Code 1
SC2 (supplementary code2)	Daimler Supplementary Code 2
DGL (drawing geometry technical level)	Daimler DGT Level
Parts for which the MDS is valid	Fiat Reference Part Numbers
Index Renault part	Renault Part Index
Engineering: I.V. checkbox	Renault Engineering IV
Engineering: I.D.V.U. checkbox	Renault Engineering IDVU
Engineering: I.M. checkbox	Renault Engineering IM
Engineering: I.D.P.A. checkbox	Renault Engineering IDPA
Concerned project	Renault Concerned Project
e-mail of the designer	Email Address
Index of the standard	Renault Standard Index
Comment	Renault Comment
NoJokerForGADSL	Nissan attribute to specify whether a reference wildcard substance does not refer to GADSL substances.

Renault Attributes

This table maps the IMDS recipient data to Materials Compliance Management attributes.


IMDS Recipient Data Field	MCC Renault Valid Part Relationship Attribute
Parts for which the IMDS is valid	Renault Valid Reference + Renault Valid Index