Skip to main content

Column Titles and Definitions

Learn more about the column titles in 3E Exchange

D
Written by David Zindler

For the columns in 3E Exchange, below we detail the column definitions and how we recommend the data in them to be organized. If another use for the column fits your process better, feel free to use it that way. Custom columns can also be set-up using the BOM Column Template. 

Naming Conventions-

(P) — A (P) indicates that the column is a product-level field, which means it's editable in the Level 1's of a product.

(M) — An (M) indicated that the column is a material-level field, which means it's editable in the summary row of a material.

  • % of Wet Ingredient in Final Product (P): If using 3E Exchange Standard Auto-calculations, this is how much of a wet ingredient would be left in a product after chemical or mechanical reactions. 2025 help-center wording: % of Wet Ingredient in Final Product (P): This is how much of a wet ingredient would be left in a product after chemical or mechanical reactions.

  • % Post-Consumer Recycled Content (M): The post-consumer recycled content by percentage, used in the recycled content calculation.

  • % Pre-Consumer Recycled Content (M): The pre-consumer recycled content by percentage, used in the recycled content calculation.

  • Alternative? (P): This field is used to specify if two or more different chemicals or materials can be used interchangeably at the same position in the hierarchy within a product.

  • Biodegradable? (M): Whether this part is biodegradable. This only needs to be filled out if the part is biodegradable. A blank in this field equates to a "no".

  • Chemical Registry Number (M): Also known as CAS number, is a widely recognized unique identifier for chemicals.

  • CLP Classification (P): CLP classification is the EU system for identifying and labeling chemical hazards. It classifies substances and mixtures based on their physical, health, and environmental risks, ensuring chemicals are labeled with standard hazard symbols, warnings, and safety information. This helps ensure the safe use, transport, and handling of chemicals, aligning with the UN’s Globally Harmonized System (GHS). – Used in SCIP Reporting

  • Cradle to Cradle Notes (M): Information about this part pertaining to Cradle to Cradle certification.

  • Custom Flag: Used to screen against a list, including custom lists. The contents cannot be edited, but the list can be edited via the button in the header.

  • Data Source (M): The originating source of your data.

  • Description (M): Another identifying descriptor for the row of data, typically regarding the substance or part.

  • Description of Rapidly Renewable Content (M): Information about rapidly renewable content (can be used for i.e. wood certifications).

  • Do connections permit easy disassembly? (M): Whether this part can easily be removed from the whole.

  • EC Number (M): The European Commission number, another unique identifier for chemical substances.

  • Exclude From Compliance Score(M): Select the checkbox to determine if this material should be considered in auto compliance determinations. This has similar functionality as within the compliance section using the “Applicability” checkbox but will not consider compliance for all regulations.

  • External DB ID(P): A reference to internal system records when using API connection for Data imports

  • HPD Special Condition (M): Which HPD Special Condition, if any, applies to this row.

  • Is this part intended to be an EMC? (M): Whether this part is an Externally Managed Component, used in Cradle to Cradle reporting. See the Cradle to Cradle product standard for details.

  • IUCLID Biodegradability Data: contains information on how chemicals degrade in the environment, such as in water, soil, or air. It includes test results that assess whether a substance is easily biodegradable or requires specific conditions to break down. This data is essential for regulatory submissions like REACH and helps evaluate the environmental impact of chemical substances. – This information fills out based on CAS#

  • Level (M): The hierarchy of the row. For example, a level 1 row is composed of the level 2 rows below it.

  • Material % by Weight (P): The percent by weight of each chemical or material can be entered here. This percent indicates how much a chemical or material makes up of the next highest level/material (i.e. how much a level 2 component makes up of a level 1 material).

  • Material Family (M): A classification category for your materials.

  • Material Type (M): This field is used specifically for HPD's and provides a broad classification of a material based on chemical makeup and molecular structure.

  • Nanomaterial (M): Define whether a specific chemical is a nanomaterial. Will default to "unknown" if left blank.

  • Notes (M): These notes are used within HPD reporting at both the chemical and material levels.

  • OECD Industrial Function Codes(P): are standardized codes used by the OECD (Organization for Economic Co-operation and Development )to classify the various functions or applications of chemicals in industrial settings. These codes describe the specific roles chemicals play in products or processes, such as solvents, additives, or stabilizers. They facilitate uniform reporting and assessment of chemicals across different industries and regulatory frameworks.

  • Overall Rating: The overall GreenScreen score for the chemical. Set based on the chemical registry number, and cannot be edited. 2025 help-center wording: Overall Rating: The overall GreenScreen score for the chemical. Set based on the chemical registry number and cannot be edited.

  • Part Name (M): The main identifying descriptor for all materials or components.

  • Percent Rapidly Renewable Content (M): The percent of this row that can be grown and harvested in a cycle of fewer than 10 years.

  • Plant (M): The location within your firm where the product or component is manufactured.

  • Product % by Weight (P): The percent by weight of each material or chemical can be entered here, or will be filled in here based on the auto-calculation mode.

  • Product Number(P): An internal number used to identify products – Can be included in surveys as an extra identifier for your supplier.

  • PBT or vPVB(P): stands for Persistent, Bioaccumulative, and Toxic, and refers to substances that remain in the environment for long periods, accumulate in the tissues of living organisms, and cause adverse effects on human health or the environment. On the other hand, vPvB stands for very Persistent and very Bioaccumulative, describing substances that have an extremely long half-life in the environment and a high tendency to accumulate in living organisms. Both classifications are crucial for regulatory purposes, particularly under frameworks like REACH, as they help identify substances that pose significant risks to human health and the environment.

  • Proprietary(M): This column will include an eyeball icon. When selecting the icon a slash will appear through the icon. When this setting is enabled, specific chemical information will not be included when sharing products or materials, but this still can display compliance information while not disclosing the chemical.

  • Package Structure(P): Within the BOM, you may use this column to add packaging information

  • Physical State(P): refers to the form of a chemical substance at room temperature and can be classified as solid, liquid, or gas. – This column is relevant for TSCA 8(a)(7).

  • PMN #(P): The Pre-Manufacture Notice number. This number is assigned to notifications submitted to the Environmental Protection Agency (EPA) under the Toxic Substances Control Act (TSCA) before a new chemical substance is manufactured or imported in the United States. – Related to TSCA 8 (a) (7).

  • Quantity (P): The number of each chemical or material used in a particular product. This is multiplied with unit weight in the qty/unit weight auto-calculation settings to create total product weights.

  • REACH/RoHS Flag: Used to screen against the REACH and RoHS lists. Set based on the registry number, and cannot be edited. 2025 help-center wording: REACH/RoHS Flag: Used to screen against the REACH and RoHS lists. Set based on the registry number and cannot be edited.

  • REACH Registration Number(P): a unique identifier assigned to chemical substances registered under the REACH (Registration, Evaluation, Authorisation, and Restriction of Chemicals) regulation in the European Union.

  • Recyclable? (M): Whether this part is recyclable.

  • Recycled Content (M): The total recycled content by percentage. Used in HPD reporting.

  • Regulatory Flag: Used to screen against regulatory lists. Set based on the registry number, and cannot be edited.

  • Residuals and Impurities Evaluation Completed? (M): Note whether residuals and impurities testing has been completed to report to HPD.

  • Residuals and Impurities Notes (M): Note any details about residual and impurity research. Used in HPD reporting.

  • Role (P): This field is used specifically for HPD's and captures the substance’s purpose or function for inclusion in the material or product. Examples include binder, anti-microbial, flame retardant, etc.

  • SCIP Concern Element Material Category(P): A classification used in the SCIP (Substances of Concern In articles as such or in complex objects (Products)) database, which aims to improve information on hazardous substances in articles. It identifies specific materials that contain substances of very high concern (SVHCs) as defined by the REACH regulation. This category helps categorize and track these materials, enabling better regulatory oversight and consumer awareness, ultimately promoting safer handling and recycling of products that may pose environmental or health risks.

  • SCIP Concern Element Mixture Category(P): to identify and categorize mixtures that contain substances of very high concern (SVHCs) under the REACH regulation. This category helps specify the type of mixture where an SVHC is found, providing detailed information for regulatory compliance, waste management, and improving consumer awareness about the presence of hazardous substances. This ensures safer handling and disposal of products containing harmful chemicals.

  • Scrap Rate (M): The average amount of scrap created in producing a component.

  • Supplier (M): The company that provides a specific material. When imported in a material row using extract and link material import, this value will be included as a summary data supplier to send surveys or otherwise track. 2025 help-center wording: Supplier (M): The company that provides a specific material.

  • Supplier ID: A unique ID associated with supplier records.

  • Supplier Part # (M): The identifier that your supplier uses for their parts/materials.

  • Technical or Biological Nutrient (M): Whether this part is intended to be recycled or go into the biosphere at end of life. Used in Cradle to Cradle reporting. See the Cradle to Cradle product standard for details.

  • Threshold (M): This identifies the concentration above which the manufacturer itemizes the substances present in a material. Only required for the Nested Material Inventory HPD Report.

  • TSCA Accession Number(P): is a unique identifier assigned to a confidential chemical substance listed on the Toxic Substances Control Act (TSCA) Inventory when the substance's identity is protected as Confidential Business Information (CBI). Unlike the public TSCA Inventory, where chemicals are listed by their Chemical Abstracts Service (CAS) number, substances with an Accession Number have their identities protected for confidentiality reasons. The Accession Number allows the U.S. Environmental Protection Agency (EPA) to track and manage these confidential substances while protecting the proprietary information of the manufacturer or importer. This number is used during regulatory filings, such as Pre-Manufacture Notices (PMN) or other TSCA-related submissions, to ensure compliance while maintaining confidentiality.

  • Unit of Measure (M): The units for the imported weights, i.e. g, kg or lbs.

  • Unit Weight (M): The weight of each chemical or material used in a particular product. This is multiplied with quantity in the qty/unit weight auto-calculation settings to create total product weights.

  • URL (M): Note if the URL of an HPD for your material if it is available. Used in HPD reporting.

  • Version Description (M): Note any details about a version's description.

  • Weight (P): The overall weight of the chemical or material used in a particular product. This is used with the weight auto-calculation settings to create percent weights.

  • Wet Material % by Weight (P): If using 3E Exchange Standard Auto-calculations, this is the wet percent by weight of each chemical or material.

  • Wet Product % by Weight (P): If using 3E ExchangeStandard Auto-calculations, this is the wet percent by weight of each material or chemical, or it will be filled in here based on the auto-calculations. 2025 help-center wording: Wet Product % by Weight (P): If using 3E Exchange Standard Auto-calculations, this is the wet percent by weight of each material or chemical, or it will be filled in here based on the auto-calculations.

  • Wet Unit Weight (M): If using 3E ExchangeStandard Auto-calculations, this is the wet weight of each chemical or material used in a particular product. This is multiplied with quantity in the qty/wet unit weight auto-calculation settings to create total product weights. 2025 help-center wording: Wet Unit Weight (M): If using 3E Exchange Standard Auto-calculations, this is the wet weight of each chemical or material used in a particular product. This is multiplied with quantity in the qty/wet unit weight auto-calculation settings to create total product weights.

  • Wet Weight (P): If using 3E Exchange Standard Auto-calculations, this is the overall wet weight of the chemical or material used in a particular product. This is used with the weight auto-calculation settings to create percent weights.

  • Yield (M): The manufacturing yield rate for the particular substance or material.

Automatic Matching

How matching works

When you import a file, 3E Exchange will recognize certain column header names, and automatically match them to 3E Exchange's pre-defined fields. All columns will get matched by their names in the above section. In addition, here are the other names that will match: 

  • Chemical Registry Number - Chemical Registry Number, Registry Number, Rn, Cas, Casrn, Cas Rn, Cas Number, Cas#, Cas #, Cas Num

  • Material Name (Linked) - Material, Homogenous Material Name

  • Alternative - Alternative?, Alt

  • EC Number - EC-Number, EC, ECN

  • Level - Lvl, Lv

  • Material Name - Material

  • Nanomaterial - Nano

  • Notes - Note

  • Part Name - Part, Component Description

  • Plant - Plant id, Plant name, Facility, Facility name

  • Quantity - Qty

  • Recycled Content - RC, Recycled

  • Tags - Tag - Separate different tags by Column

  • Threshold - Inv Threshold, Inventory Threshold, Material Threshold

  • Unit of Measure - UOM, Unit, Units

  • Percent Post-consumer Recycled Content - Post consumer, Post-consumer, % Post consumer, etc.

  • Percent Pre-consumer Recycled Content - Percent preconsumer, % pre consumer, pre consumer recycled, etc.

  • Residuals and Impurities Considered? - Residuals and Impurities Considered?, Residuals and Impurities

  • Product % by Weight - Percent by Weight, Percent Weight, % by Weight, % Weight, Product Percent by Weight, Product Percent Weight, Product % Weight

  • Material % by Weight - Component Percent by Weight, Component Percent Weight, Component % by Weight, Component % Weight, Material Percent by Weight, Material Percent Weight, Material % Weight, Homogenous Material Percent by Weight, Homogenous Material Percent Weight, Homogenous Material % by Weight, Homogenous Material % Weight

  • Scrap Rate - Scrap

  • Proprietary - Proprietary?

  • Do connections permit easy disassembly? - Do connections permit easy disassembly

  • Biodegradable? - Biodegradable

  • Recyclable? - Recyclable

  • Cradle To Cradle Notes - C2C notes

Getting Help

If you have questions about using 3E Exchange or the material covered in this help article, reach out in chat in the bottom right-hand corner or email [email protected].
​

Did this answer your question?