> ![](media/image1.png){width="3.238888888888889in"
> height="0.9479166666666666in"}
>
> **Electronic Catalogs**
>
> Procedures for Preparing the Electronic Catalog
>
> **Revision 5.4**

+----------------------------------------------------+-----------------+
| TABLE OF CONTENTS                                  | PAGE(S)         |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Introduction                                       | 3               |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Preparing the Electronic Catalog                   | 4 - 10          |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Attachments                                        | 11 - 12         |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Catalog Submissions                                | 13              |
+----------------------------------------------------+-----------------+
| Preparing the Synonym File                         | 14              |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Examples of Electronic Catalog Submissions         | 15 -- 17        |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| ISO 9000 Country Codes Table                       | 18 -- 20        |
|                                                    |                 |
| Facility Codes                                     | 21              |
+----------------------------------------------------+-----------------+
| Unit or Basis for Measurement                      | 22 -- 24        |
+----------------------------------------------------+-----------------+
| Supplier Category                                  | 25              |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+
| Catalog Submission Form                            | 26              |
+----------------------------------------------------+-----------------+
|                                                    |                 |
+----------------------------------------------------+-----------------+

Introduction

**Preparing the Electronic Catalog**

The Electronic Catalog may be submitted in any of the following formats:

-   ASCII text file (.txt)

-   Access file (.mdb)

-   Excel file (.xls)

ASCII or text files can be created through the export function of most
PC-based programs as well as through mainframe and AS/400 financial and
inventory programs.

**Catalog Submission Form**

The **Catalog Submission Form** (located at the end of this document)
must be completed and submitted with the Electronic Catalog.

**Submitting the Electronic Catalog**

**There are two ways to submit the Electronic Catalog:**

> 1\. E-mail the Electronic Catalog file(s) to: hintonrljr@ornl.gov
>
> Information requested on the Catalog Submission Form (located at the
> end of this document) must be included in the e-mail.

2.  Mail the Electronic Catalog file(s) on diskette along with the
    Catalog Submission Form (located at the end of this document) to:
    Oak Ridge National Laboratory

> Attn. Randy Hinton
>
> P.O. Box 2008 MS6287
>
> Oak Ridge, TN 37831-6287

**For Additional Information**

For additional information please call or e-mail the Catalog
Administrator:

Phone: 865-574-6056

Fax: 865-574-5748

**E-Mail:** hintonrljr@ornl.gov

Preparing the Electronic Catalog

Use the table below as a guide for preparing the Electronic Catalog.
There are 62 fields contained in these procedures. Fields 1 - 43 are for
Supplier specific information. Fields 44 - 62 allow suppliers to
customize their catalogs for specific buying clients.

**Explanation of Procedures**

[Field]{.underline} - describes the type of data that is required in a
given field; may be used as column headings.

[Max Size]{.underline} - indicates the maximum allowable field size.

[Value]{.underline} - indicates whether the field is text, numeric, or
any other combination of text or numeric characters.

[Req]{.underline} - indicates whether a field is mandatory or requested.

> **"M" = Mandatory** (indicates that data entry in this field is
> mandatory)
>
> ***Records without a value in the mandatory fields will be rejected
> from the database and returned to the supplier for correction and
> resubmission.***
>
> **"R" = Requested** (indicates the field is requested although it is
> not mandatory)

[Description]{.underline} - describes in detail the data required in
each field.

**Buying Client Addendum**

In addition to company\'s requirements each Buying Client will have
their own unique data requirements which are added as an Addendum to
these procedures. The **Buying Client Addendum** takes precedence over
the company\'s requirements.

**Attachments to these procedures:**

Attachment 1 - Product Type Table (Separate Attachment)

Attachment 2 - The Unit or Basis for Measurement Table

Attachment 3 - Deleted (No longer valid)

Attachment 4 - The ISO 9000 Country Codes Table

Buying Client Addendum (if applicable)

**Preparing the Electronic Catalog**

Enter data into the fields in the order listed in this document without
exceeding size limits and using the values (data types) shown. All 62
fields must be in the catalog file even if data is not supplied for each
field. If an ASCII (.txt) file is submitted, insert a tilde (\~) between
each field (even if the field is blank).

**TEXT = ALPHANUMERIC CHARACTERS**

+---+--------------+------+----+-----+--------------------------------+
|   | **Field**    | *    | *  | *   | **Description**                |
|   |              | *Max | *V | *Re |                                |
|   |              | Si   | al | q** |                                |
|   |              | ze** | ue |     |                                |
|   |              |      | ** |     |                                |
+===+==============+======+====+=====+================================+
|   |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | *            | 1    | Te | M   | Enter the letter **A** or      |
| * | *TRANSACTION |      | xt |     | **D**:                         |
| 1 | TYPE**       |      |    |     |                                |
| * |              |      |    |     | A = Add/Modify this record\    |
| * |              |      |    |     | D = Delete an existing record  |
+---+--------------+------+----+-----+--------------------------------+
| * | **PRODUCT    | 10   | Te | M   | Product Type                   |
| * | TYPE**       |      | xt |     |                                |
| 2 |              |      |    |     | See the Product Type Table. At |
| * |              |      |    |     | a minimum, Level 4 **must** be |
| * |              |      |    |     | provided. However, in order to |
|   |              |      |    |     | improve the search results for |
|   |              |      |    |     | UT-Battelle, it is highly      |
|   |              |      |    |     | recommended that all levels be |
|   |              |      |    |     | defined.                       |
+---+--------------+------+----+-----+--------------------------------+
| * | **EXTERNAL** | 30   | Te | M   | Supplier's alphanumeric        |
| * |              |      | xt |     | identifier for the product to  |
| 3 | **PRODUCT    |      |    |     | the outside world. May be the  |
| * | ID**         |      |    |     | same as Field 12 (Supplier     |
| * |              |      |    |     | Internal Product ID).          |
+---+--------------+------+----+-----+--------------------------------+
| * | **LIST       | 22   | N  | M   | The List Price is an           |
| * | PRICE**      |      | um |     | adjustable price. This field   |
| 4 |              | (1   |    |     | may contain as many as 22      |
| * | You must use | 5.6) |    |     | characters consisting of up to |
| * | list price   |      |    |     | 15 whole numbers, a decimal    |
|   | (Field 4).   |      |    |     | point, and 6 decimal places.   |
|   | Net Price    |      |    |     |                                |
|   | (Field 48)   |      |    |     | The List Price is discounted   |
|   | is no longer |      |    |     | by using Field 52 (List Price  |
|   | an available |      |    |     | Multiplier).                   |
|   | option.      |      |    |     |                                |
|   |              |      |    |     | NOTE: If "0" is entered as the |
|   |              |      |    |     | List Price the word "Inquire"  |
|   |              |      |    |     | will be displayed.             |
+---+--------------+------+----+-----+--------------------------------+
| * | **LIST PRICE | 2    | Te | M   | If you are using list price    |
| * | BASIS**      |      | xt |     | choose one of the following    |
| 5 |              |      |    |     | two-letter codes and enter it  |
| * |              |      |    |     | in this field:                 |
| * |              |      |    |     |                                |
|   |              |      |    |     | CA = Catalog                   |
|   |              |      |    |     |                                |
|   |              |      |    |     | SR = Suggested Retail          |
|   |              |      |    |     |                                |
|   |              |      |    |     | UM = Price per Unit of Measure |
+---+--------------+------+----+-----+--------------------------------+
| * | **FREIGHT    | 1    | Te | M   | (**Y**)es - if freight cost IS |
| * | INCLUDED**   |      | xt |     | included in the                |
| 6 |              |      |    |     | [list]{.underline}             |
| * | **IN LIST    |      |    |     | [price]{.underline}.           |
| * | PRICE**      |      |    |     |                                |
|   |              |      |    |     | (**N**)o - if freight is NOT   |
|   |              |      |    |     | included in the                |
|   |              |      |    |     | [list]{.underline}             |
|   |              |      |    |     | [price]{.underline}.           |
|   |              |      |    |     |                                |
|   |              |      |    |     | This field is [only to be used |
|   |              |      |    |     | with list price]{.underline}.  |
|   |              |      |    |     |                                |
|   |              |      |    |     | Use Field 50 (Buyer Freight    |
|   |              |      |    |     | Included in NET Price) if Net  |
|   |              |      |    |     | Price is quoted.               |
+---+--------------+------+----+-----+--------------------------------+
| * | **INVENTORY  | 9    | N  | R   | Inventory on hand              |
| * | LEVEL**      |      | um |     |                                |
| 7 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | *            | 2    | Te | M   | Enter a code from **Attachment |
| * | *INVENTORY** |      | xt |     | 2**, EDI X.12 Table 355 (Unit  |
| 8 |              |      |    |     | or Basis for Measurement).     |
| * | **UNIT OF    |      |    |     | This UOM is used to describe   |
| * | MEASURE**    |      |    |     | the inventory level. Example:  |
|   |              |      |    |     | EA = each                      |
+---+--------------+------+----+-----+--------------------------------+
| * | **PRODUCT    | 32   | Te | R   | Enter the product's            |
| * | SIZE**       |      | xt |     | dimensions, such as its        |
| 9 |              |      |    |     | diameter or its length and     |
| * |              |      |    |     | width. This field is in free   |
| * |              |      |    |     | format and is included in the  |
|   |              |      |    |     | Free Form Search in the        |
|   |              |      |    |     | application.                   |
+---+--------------+------+----+-----+--------------------------------+
| * | **D          | 2    | Te | M   | This field may contain a       |
| * | ESCRIPTION** | ,000 | xt |     | maximum of 2,000 characters.   |
| 1 |              |      |    |     | The description should follow  |
| 0 | **This is    |      |    |     | a noun, modifier format. For   |
| * | the          |      |    |     | example, paper clip should be  |
| * | *primary*    |      |    |     | entered as "clip, paper" with  |
|   | searchable   |      |    |     | the remainder of the           |
|   | field for    |      |    |     | description following the      |
|   | your Buying  |      |    |     | noun-modifier. In order to     |
|   | Client.**    |      |    |     | improve searching              |
|   |              |      |    |     | capabilities, remember to use  |
|   |              |      |    |     | laymen's terms when describing |
|   |              |      |    |     | the item and avoid             |
|   |              |      |    |     | abbreviations where possible.  |
+---+--------------+------+----+-----+--------------------------------+
| * | **SUPPLIER   | 17   | Te | M   | For Supplier ID we recommend   |
| * | ID**         |      | xt |     | using your Dun and Bradstreet  |
| 1 |              |      |    |     | D-U-N-S number. This creates a |
| 1 |              |      |    |     | unique ID for your catalog.    |
| * |              |      |    |     | This must be used for all      |
| * |              |      |    |     | subsequent catalog loads as    |
|   |              |      |    |     | well.                          |
+---+--------------+------+----+-----+--------------------------------+
| * | **SUPPLIER   | 30   | Te | M   | Supplier's                     |
| * | INTERNAL     |      | xt |     | **[unique]{.underline}**,      |
| 1 | PRODUCT ID** |      |    |     | alphanumeric identifier for    |
| 2 |              |      |    |     | the product within their own   |
| * |              |      |    |     | company. If not supplied,      |
| * |              |      |    |     | Field 3 (External Product ID)  |
|   |              |      |    |     | will be used; however, this    |
|   |              |      |    |     | field must be                  |
|   |              |      |    |     | **[unique]{.underline}**.      |
+---+--------------+------+----+-----+--------------------------------+
| * | **CATALOG    | 1    | Te | M   | Choose one of the following to |
| * | TYPE**       |      | xt |     | indicate the type of catalog:  |
| 1 |              |      |    |     |                                |
| 3 |              |      |    |     | **S** = Supplier Catalog (use  |
| * |              |      |    |     | this if you are a Supplier)    |
| * |              |      |    |     |                                |
|   |              |      |    |     | **I** = Inventory (use this if |
|   |              |      |    |     | you are a Buying Client)       |
|   |              |      |    |     |                                |
|   |              |      |    |     | **P** = Surplus Catalog (use   |
|   |              |      |    |     | this if you are reselling      |
|   |              |      |    |     | surplus)                       |
|   |              |      |    |     |                                |
|   |              |      |    |     | **V =** Services               |
+---+--------------+------+----+-----+--------------------------------+
| * | **HAZARDOUS  | 1    | Te | M   | Hazardous Material Code        |
| * | MATERIAL     |      | xt |     |                                |
| 1 | CODE**       |      |    |     | (**Y**)es if the material is   |
| 4 |              |      |    |     | required to have a Material    |
| * |              |      |    |     | Safety Data Sheet (MSDS)       |
| * |              |      |    |     | according to OSHA regulations. |
|   |              |      |    |     |                                |
|   |              |      |    |     | (**N**)o if not required.      |
+---+--------------+------+----+-----+--------------------------------+
| * | **MA         | 60   | Te | M   | Manufacturer's name. If        |
| * | NUFACTURER'S |      | xt |     | unavailable, supply **N/A**.   |
| 1 | NAME**       |      |    |     |                                |
| 5 |              |      |    |     | This field is one of the       |
| * |              |      |    |     | *searchable* fields.           |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MA         | 30   | Te | R   | Manufacturer's Part Number or  |
| * | NUFACTURER'S |      | xt |     | Serial Number for product.     |
| 1 | PRODUCT ID** |      |    |     |                                |
| 6 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MANU       | 30   | Te | R   | Manufacturer's Figure or       |
| * | FACTURER'S** |      | xt |     | Drawing Number                 |
| 1 |              |      |    |     |                                |
| 7 | **FIGURE     |      |    |     |                                |
| * | NUMBER**     |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MANU       | 3    | Te | R   | The Manufacturer's Country of  |
| * | FACTURER'S** |      | xt |     | Origin.                        |
| 1 |              |      |    |     |                                |
| 8 | **COUNTRY OF |      |    |     | See Country Codes Table        |
| * | ORIGIN**     |      |    |     | (Attachment 4).                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **UPC CODE** | 13   | Te | R   | Universal Product Code         |
| * |              |      | xt |     |                                |
| 1 |              |      |    |     |                                |
| 9 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **INDUSTRY   | 18   | Te | R   | Industry Code (*e.g*. CIMIS,   |
| * | CODE**       |      | xt |     | ASME, etc.)                    |
| 2 |              |      |    |     |                                |
| 0 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **CURRENCY   | 3    | Te | R   | The country code from which    |
| * | COUNTRY      |      | xt |     | this currency originates.      |
| 2 | CODE**       |      |    |     |                                |
| 1 |              |      |    |     | See Country Codes Table        |
| * |              |      |    |     | (**Attachment 4**). If none is |
| * |              |      |    |     | entered the system default is  |
|   |              |      |    |     | USA.                           |
+---+--------------+------+----+-----+--------------------------------+
| * | **KEYWORD**  | 30   | Te | R   | A keyword (primary noun) to    |
| * |              |      | xt |     | define the material or part in |
| 2 |              |      |    |     | one word. Examples: Valve, or  |
| 2 |              |      |    |     | Motor, or Switch. **Any data   |
| * |              |      |    |     | entered here must also be      |
| * |              |      |    |     | entered in the Description     |
|   |              |      |    |     | field (number 10).**           |
+---+--------------+------+----+-----+--------------------------------+
| * | **MODEL**    | 20   | Te | R   | Model Name or Number           |
| * |              |      | xt |     |                                |
| 2 |              |      |    |     | May be a combination of        |
| 3 |              |      |    |     | alphanumeric characters.       |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **BRAND**    | 20   | Te | R   | Brand Name                     |
| * |              |      | xt |     |                                |
| 2 |              |      |    |     |                                |
| 4 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **SHELF      | 15   | Te | R   | Shelf Life                     |
| * | LIFE**       |      | xt |     |                                |
| 2 |              |      |    |     |                                |
| 5 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **INVENTORY  | 9    | N  | R   | Minimum quantity Supplier is   |
| * | MINIMUM      |      | um |     | required to maintain in stock  |
| 2 | LEVEL**      |      |    |     | to satisfy their own internal  |
| 6 |              |      |    |     | requirements.                  |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **INVENTORY  | 9    | N  | R   | Maximum quantity Supplier will |
| * | MAXIMUM      |      | um |     | maintain in stock.             |
| 2 | LEVEL**      |      |    |     |                                |
| 7 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **PRIOR      | 30   | Te | R   | Prior Product ID               |
| * | PRODUCT ID** |      | xt |     |                                |
| 2 |              |      |    |     |                                |
| 8 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **NET        | 9    | N  | R   | Net Weight                     |
| * | WEIGHT**     |      | um |     |                                |
| 2 |              |      |    |     |                                |
| 9 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **GROSS      | 9    | N  | R   | Gross Weight                   |
| * | WEIGHT**     |      | um |     |                                |
| 3 |              |      |    |     |                                |
| 0 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **WEIGHT     | 2    | Te | R   | Unit of measure for the        |
| * | UOM**        |      | xt |     | weight.                        |
| 3 |              |      |    |     |                                |
| 1 |              |      |    |     | See the Unit of Measure Table  |
| * |              |      |    |     | (**Attachment 2**).            |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **SAFETY     | 2    | Te | R   | Nuclear Safety Codes           |
| * | FLAG**       |      | xt |     |                                |
| 3 |              |      |    |     |                                |
| 2 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MINIMUM    | 9    | N  | R   | Minimum Order Quantity         |
| * | ORDER        |      | um |     |                                |
| 3 | QUANTITY**   |      |    |     | Use this example for this      |
| 3 |              |      |    |     | field and the next two.        |
| * |              |      |    |     |                                |
| * |              |      |    |     | Scenario: If the minimum order |
|   |              |      |    |     | quantity is 2 boxes consisting |
|   |              |      |    |     | of 8 cans per box, the number  |
|   |              |      |    |     | 2 is entered in this field.    |
+---+--------------+------+----+-----+--------------------------------+
| * | **ORDER      | 2    | Te | M   | Basis for the quantity         |
| * | UOM**        |      | xt |     | ordered. Suppliers - this      |
| 3 |              |      |    |     | applies to the Unit of Measure |
| 4 |              |      |    |     | in which you sell your         |
| * |              |      |    |     | product.                       |
| * |              |      |    |     |                                |
|   |              |      |    |     | Select your code from          |
|   |              |      |    |     | **Attachment 2** - Unit of     |
|   |              |      |    |     | Measure Table.                 |
|   |              |      |    |     |                                |
|   |              |      |    |     | Based on the scenario for      |
|   |              |      |    |     | Field 33, the letters "BX" for |
|   |              |      |    |     | box are entered in this field. |
+---+--------------+------+----+-----+--------------------------------+
| * | **PACKAGE    | 9    | N  | R   | Package Amount - Clarifies how |
| * | AMOUNT**     |      | um |     | much is in the Ordered UOM.    |
| 3 |              |      |    |     | From the scenario listed in    |
| 5 |              |      |    |     | Field 33, the number 8 is      |
| * |              |      |    |     | entered in this field.         |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | *            | 1    | Te | R   | Condition of material:         |
| * | *CONDITION** |      | xt |     | (**N**)ew, (**U**)sed,         |
| 3 |              |      |    |     | (**R**)econditioned,           |
| 6 |              |      |    |     |                                |
| * |              |      |    |     | not (**A**)pplicable, non      |
| * |              |      |    |     | (**P**)rime                    |
+---+--------------+------+----+-----+--------------------------------+
| * | **LOCATION** | 15   | Te | R   | Location of the item in        |
| * |              |      | xt |     | warehouse, aisle number, bin,  |
| 3 |              |      |    |     | etc.                           |
| 7 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **INVENTORY  | 1    | Te | R   | Provide the inventory control  |
| * | TYPE**       |      | xt |     | flag as specified by the       |
| 3 |              |      |    |     | Buyer.                         |
| 8 |              |      |    |     |                                |
| * |              |      |    |     | Describe the type of inventory |
| * |              |      |    |     | according to:                  |
|   |              |      |    |     |                                |
|   |              |      |    |     | **O** = Open Bin               |
|   |              |      |    |     |                                |
|   |              |      |    |     | **N** = Not inventory          |
+---+--------------+------+----+-----+--------------------------------+
| * | **           | 8    | Da | R   | Date this item should appear   |
| * | ACTIVATION** |      | te |     | in the catalog.                |
| 3 |              |      |    |     |                                |
| 9 |              |      |    |     | Date format is 'YYYYMMDD'.     |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **           | 8    | Da | R   | The date this item should      |
| * | EXPIRATION** |      | te |     | disappear from the catalog.    |
| 4 |              |      |    |     | This field should be left      |
| 0 |              |      |    |     | blank if there is no           |
| * |              |      |    |     | expiration date for this item. |
| * |              |      |    |     |                                |
|   |              |      |    |     | Date format is 'YYYYMMDD'.     |
+---+--------------+------+----+-----+--------------------------------+
| * | **ATTACHMENT | 1    | Te | R   | The sequence number of the     |
| * | SEQUENCE     |      | xt |     | attachment. For attachment 1,  |
| 4 | NUMBER**     |      |    |     | the attachment sequence number |
| 1 |              |      |    |     | is '1'.                        |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **DOCUMENT   | 1    | Te | R   | Type of attached document:     |
| * | TYPE 1**     |      | xt |     | (enter one of the following)   |
| 4 |              |      |    |     |                                |
| 2 |              |      |    |     | '**P**'icture -- graphic       |
| * |              |      |    |     |                                |
| * |              |      |    |     | '**M**'SDS -- Material Safety  |
|   |              |      |    |     | Data Sheet                     |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**T**'erms                    |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**O**'ther                    |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILENAME   | 40   | Te | R   | Filename for attached file.    |
| * | 1**          |      | xt |     | Use file extensions compatible |
| 4 |              |      |    |     | with Netscape (*e.g*. .gif,    |
| 3 |              |      |    |     | .html, .jpg, .txt). If you are |
| * |              |      |    |     | unsure call for assistance.    |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILE       | 40   | Te | R   | Description of attached file.  |
| * | DESCRIPTION  |      | xt |     |                                |
| 4 | 1**          |      |    |     |                                |
| 4 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **ATTACHMENT | 1    | Te | R   | The sequence number of the     |
| * | SEQUENCE     |      | xt |     | attachment. For attachment 2,  |
| 4 | NUMBER 2**   |      |    |     | the attachment sequence number |
| 5 |              |      |    |     | is '2'.                        |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **DOCUMENT   | 1    | Te | R   | Type of attached document:     |
| * | TYPE 2**     |      | xt |     | (enter one of the following)   |
| 4 |              |      |    |     |                                |
| 6 |              |      |    |     | '**P**'icture -- graphic       |
| * |              |      |    |     |                                |
| * |              |      |    |     | '**M**'SDS -- Material Safety  |
|   |              |      |    |     | Data Sheet                     |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**T**'erms                    |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**O**'ther                    |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILENAME   | 40   | Te | R   | Filename for attached file.    |
| * | 2**          |      | xt |     | Use file extensions compatible |
| 4 |              |      |    |     | with Netscape (*e.g*. .gif,    |
| 7 |              |      |    |     | .html, .jpg, .txt). If you are |
| * |              |      |    |     | unsure call for assistance.    |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILE       | 40   | Te | R   | Description of attached file.  |
| * | DESCRIPTION  |      | xt |     |                                |
| 4 | 2**          |      |    |     |                                |
| 8 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **ATTACHMENT | 1    | Te | R   | The sequence number of the     |
| * | SEQUENCE     |      | xt |     | attachment. For attachment 3,  |
| 4 | NUMBER 3**   |      |    |     | the attachment sequence number |
| 9 |              |      |    |     | is '3'.                        |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **DOCUMENT   | 1    | Te | R   | Type of attached document:     |
| * | TYPE 3**     |      | xt |     | (enter one of the following)   |
| 5 |              |      |    |     |                                |
| 0 |              |      |    |     | '**P**'icture -- graphic       |
| * |              |      |    |     |                                |
| * |              |      |    |     | '**M**'SDS -- Material Safety  |
|   |              |      |    |     | Data Sheet                     |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**T**'erms                    |
|   |              |      |    |     |                                |
|   |              |      |    |     | '**O**'ther                    |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILENAME   | 40   | Te | R   | Filename for attached file.    |
| * | 3**          |      | xt |     | Use file extensions compatible |
| 5 |              |      |    |     | with Netscape (*e.g*. .gif,    |
| 1 |              |      |    |     | .html, .jpg, .txt). If you are |
| * |              |      |    |     | unsure call for assistance.    |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **FILE       | 40   | Te | R   | Description of attached file.  |
| * | DESCRIPTION  |      | xt |     |                                |
| 5 | 3**          |      |    |     |                                |
| 2 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER ID** | 17   | Te | M   | The Buyer's Identifier or      |
| * |              |      | xt |     | Plant Code/Location. Specified |
| 5 |              |      |    |     | and provided by the Buying     |
| 3 |              |      |    |     | Client.                        |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER      | 30   | Te | R   | Buyer's product identifier     |
| * | PRODUCT ID** |      | xt |     | (i.e.: Buyer's part number     |
| 5 |              |      |    |     | etc.).                         |
| 4 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER      | 35   | Te | R   | Buyer's alternate product      |
| * | ALTERNATE    |      | xt |     | identifier (i.e.: Buyer's part |
| 5 | PRODUCT ID** |      |    |     | number without                 |
| 5 |              |      |    |     | non-alphanumeric characters).  |
| * |              |      |    |     |                                |
| * |              |      |    |     | This allows a search to be     |
|   |              |      |    |     | conducted on the Product ID    |
|   |              |      |    |     | without any spaces, hyphens,   |
|   |              |      |    |     | or other non-alphanumeric      |
|   |              |      |    |     | characters.                    |
+---+--------------+------+----+-----+--------------------------------+
| * | **PRICING    | 1    | Te | M   | M indicates that the selling   |
| * | FLAG**       |      | xt |     | price is to be based on the    |
| 5 |              |      |    |     | List Price times the           |
| 6 |              |      |    |     | Multiplier.                    |
| * |              |      |    |     |                                |
| * |              |      |    |     | N indicates that the product   |
|   |              |      |    |     | is sold against the Net Price. |
+---+--------------+------+----+-----+--------------------------------+
| * | **NET        | 14   | N  | DO  | The Net price is a fixed       |
| * | PRICE**      |      | um | NOT | price. It is not adjustable    |
| 5 |              | (    |    | USE | and is not computed from the   |
| 7 |              | 9.4) |    |     | List Price.                    |
| * |              |      |    |     |                                |
| * |              |      |    |     | This field may contain up to   |
|   |              |      |    |     | 14 characters consisting of as |
|   |              |      |    |     | many as 9 whole numbers, a     |
|   |              |      |    |     | decimal point, and 4 decimal   |
|   |              |      |    |     | places. If a Net Price is      |
|   |              |      |    |     | entered, Field 52 (List Price  |
|   |              |      |    |     | Multiplier) may be left blank. |
+---+--------------+------+----+-----+--------------------------------+
| * | **NET PRICE  | 2    | Te | DO  | If you are using net price     |
| * | BASIS**      |      | xt | NOT | choose one of the following    |
| 5 |              |      |    | USE | two letter codes and enter it  |
| 8 |              |      |    |     | in this field:                 |
| * |              |      |    |     |                                |
| * |              |      |    |     | CA = Catalog                   |
|   |              |      |    |     |                                |
|   |              |      |    |     | CT = Contract                  |
|   |              |      |    |     |                                |
|   |              |      |    |     | SR = Suggested Retail          |
|   |              |      |    |     |                                |
|   |              |      |    |     | UM = Price per Unit of Measure |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER      | 1    | Te | DO  | (Y)es - if freight cost IS     |
| * | FREIGHT      |      | xt | NOT | included in the NET price.     |
| 5 | INCLUDED IN  |      |    | USE |                                |
| 9 | NET**        |      |    |     | (N)o - if freight is NOT       |
| * |              |      |    |     | included in the NET price.     |
| * | **PRICE**    |      |    |     |                                |
|   |              |      |    |     | Use Field 6 (Freight Included  |
|   |              |      |    |     | in List Price) if freight is   |
|   |              |      |    |     | included in LIST price.        |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER      | 8    | Da | R   | Date that pricing expires for  |
| * | PRICE        |      | te |     | this particular Buying Client. |
| 6 | EXPIRATION** |      |    |     | Pricing will disappear from    |
| 0 |              |      |    |     | the catalog on the date        |
| * |              |      |    |     | identified.                    |
| * |              |      |    |     |                                |
|   |              |      |    |     | Date Format is 'YYYYMMDD'      |
+---+--------------+------+----+-----+--------------------------------+
| * | **LIST PRICE | 6    | N  | \*M | The List Price Multiplier is   |
| * | MULTIPLIER** |      | um |     | multiplied by the List Price   |
| 6 |              | (    |    | \*  | to provide buyers with a price |
| 1 |              | 1.4) |    | Use | discount. For example, a Price |
| * |              |      |    | o   | Multiplier of .80 provides a   |
| * |              |      |    | nly | 20% discount.                  |
|   |              |      |    | if  |                                |
|   |              |      |    | p   | This field is Mandatory if a   |
|   |              |      |    | ric | List Price is being used       |
|   |              |      |    | ing | instead of a Net Price. The    |
|   |              |      |    | is  | format may include up to: 1    |
|   |              |      |    | ba  | whole number, a decimal point, |
|   |              |      |    | sed | and 4 decimal numbers.         |
|   |              |      |    | on  |                                |
|   |              |      |    | L   |                                |
|   |              |      |    | IST |                                |
|   |              |      |    | Pr  |                                |
|   |              |      |    | ice |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **AVERAGE    | 3    | N  | R   | Average Stock Lead Time: a     |
| * | STOCK LEAD   |      | um |     | number which indicates the     |
| 6 | TIME**       |      |    |     | amount of time it will take to |
| 2 |              |      |    |     | deliver this product to the    |
| * |              |      |    |     | Buyer's site.                  |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **AVERAGE    | 1    | Te | R   | Indicates how the Average      |
| * | STOCK LEAD   |      | xt |     | Stock Lead Time is measured.   |
| 6 | TIME UNIT**  |      |    |     |                                |
| 3 |              |      |    |     | Example: D = Days, W = Weeks   |
| * |              |      |    |     |                                |
| * |              |      |    |     | Leave this field blank if Avg. |
|   |              |      |    |     | Stock Lead Time is blank.      |
+---+--------------+------+----+-----+--------------------------------+
| * | **BUYER      | 10   | Te | R   | Buyer's Product Type. Specific |
| * | PRODUCT      |      | xt |     | codes will be provided by the  |
| 6 | TYPE**       |      |    |     | Buying Client if applicable.   |
| 4 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MAX        | 9    | N  | R   | Maximum quantity against the   |
| * | QUANTITY**   |      | um |     | price for this item.           |
| 6 |              |      |    |     |                                |
| 5 |              |      |    |     | Used for pricing levels per    |
| * |              |      |    |     | quantity.                      |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **MIN        | 9    | N  | R   | Minimum quantity against the   |
| * | QUANTITY**   |      | um |     | price for this item.           |
| 6 |              |      |    |     |                                |
| 6 |              |      |    |     | Used for pricing levels per    |
| * |              |      |    |     | quantity.                      |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **SHIP FROM  | 19   | Te | R   | The city from which this item  |
| * | CITY**       |      | xt |     | is shipped.                    |
| 6 |              |      |    |     |                                |
| 7 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **SHIP FROM  | 2    | Te | R   | The state from which this item |
| * | STATE**      |      | xt |     | is shipped.                    |
| 6 |              |      |    |     |                                |
| 8 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **SHIP FROM  | 10   | N  | R   | The zip code from which this   |
| * | ZIP**        |      | um |     | item is shipped.               |
| 6 |              |      |    |     |                                |
| 9 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **OTHER      | 14   | N  | R   | Other charges associated with  |
| * | CHARGES**    |      | um |     | this item.                     |
| 7 |              | (    |    |     |                                |
| 0 |              | 9.4) |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **D          | 5    | Te | M   | Input the Revision number from |
| * | OCUMENTATION |      | xt |     | the cover page of this         |
| 7 | VERSION      |      |    |     | document.                      |
| 1 | NUMBER**     |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **RECYCLE    | 1    | Te | M   | Enter 'Y' is product contains  |
| * | MATERIAL**   |      | xt |     | recycled material.             |
| 7 |              |      |    |     |                                |
| 2 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+
| * | **DUMMY**    |      |    |     | Dummy field -- do not use.     |
| * |              |      |    |     |                                |
| 7 |              |      |    |     |                                |
| 3 |              |      |    |     |                                |
| * |              |      |    |     |                                |
| * |              |      |    |     |                                |
+---+--------------+------+----+-----+--------------------------------+

**Attachments**

To include attachments with this catalog submission continue the
spreadsheet/file by completing fields 41 - 52. Fields 41 - 52 must be
completed for each attachment.

Example: If a particular item has a graphic attachment and a Material
Safety Data Sheet, fields 41 - 48 will be provided; one set for the
graphic attachment and one set for the Material Safety Data Sheet.

+---+--------------+-------+----+-----+-------------------------------+
|   | **Field**    | **Max | *  | *   | **Description**               |
|   |              | S     | *V | *Re |                               |
|   |              | ize** | al | q** |                               |
|   |              |       | ue |     |                               |
|   |              |       | ** |     |                               |
+===+==============+=======+====+=====+===============================+
|   |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+
| * | **ATTACHMENT | 1     | Te | R   |                               |
| * | SEQUENCE     |       | xt |     |                               |
| 4 | NUMBER**     |       |    |     |                               |
| 1 |              |       |    |     |                               |
| * |              |       |    |     |                               |
| * |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+
| * | **DOCUMENT   | 1     | Te | R   | Type of attached document:    |
| * | TYPE**       |       | xt |     | (enter one of the following)  |
| 4 |              |       |    |     |                               |
| 2 |              |       |    |     | '**P**'icture -- graphic      |
| * |              |       |    |     |                               |
| * |              |       |    |     | '**M**'SDS -- Material Safety |
|   |              |       |    |     | Data Sheet                    |
|   |              |       |    |     |                               |
|   |              |       |    |     | '**T**'erms                   |
|   |              |       |    |     |                               |
|   |              |       |    |     | '**O**'ther                   |
+---+--------------+-------+----+-----+-------------------------------+
| * | **FILENAME** | 40    | Te | R   | Filename for attached file.   |
| * |              |       | xt |     | Use file extensions           |
| 4 |              |       |    |     | compatible with Netscape      |
| 3 |              |       |    |     | (*e.g*. .gif, .html, .jpg,    |
| * |              |       |    |     | .txt). If you are unsure call |
| * |              |       |    |     | for assistance.               |
+---+--------------+-------+----+-----+-------------------------------+
| * | **FILE       | 40    | Te | R   | Description of attached file. |
| * | D            |       | xt |     |                               |
| 4 | ESCRIPTION** |       |    |     |                               |
| 4 |              |       |    |     |                               |
| * |              |       |    |     |                               |
| * |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+

**[ADDING ATTACHMENTS TO PREVIOUSLY SUBMITTED CATALOG
ITEMS]{.underline}**

To add attachments to previously supplied items (meaning that fields 1 -
40 have been previously submitted) complete fields 1, 2, 11, 12, 13, and
41 - 52. A maximum of three attachments may be provided per product/line
item.

+---+--------------+-------+----+-----+-------------------------------+
|   | **Field**    | **Max | *  | *   | **Description**               |
|   |              | S     | *V | *Re |                               |
|   |              | ize** | al | q** |                               |
|   |              |       | ue |     |                               |
|   |              |       | ** |     |                               |
+===+==============+=======+====+=====+===============================+
|   |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+
| * | *            | 1     | Te | M   | Enter the letter **A** or     |
| * | *TRANSACTION |       | xt |     | **D**:                        |
| 1 | TYPE**       |       |    |     |                               |
| * |              |       |    |     | A = Add/Modify this record\   |
| * |              |       |    |     | D = Delete an existing record |
+---+--------------+-------+----+-----+-------------------------------+
| * | **PRODUCT    | 10    | Te | M   | Product Type                  |
| * | TYPE**       |       | xt |     |                               |
| 2 |              |       |    |     | See the Product Type Table    |
| * |              |       |    |     | (**Attachment 1**).           |
| * |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+
| * | **SUPPLIER   | 17    | Te | M   | For Supplier ID we recommend  |
| * | ID**         |       | xt |     | using your Dun and Bradstreet |
| 1 |              |       |    |     | D-U-N-S number. This creates  |
| 1 |              |       |    |     | a unique ID for your catalog. |
| * |              |       |    |     | This must be used for all     |
| * |              |       |    |     | subsequent catalog loads as   |
|   |              |       |    |     | well.                         |
+---+--------------+-------+----+-----+-------------------------------+
| * | **SUPPLIER   | 30    | Te | M   | Supplier's unique,            |
| * | INTERNAL     |       | xt |     | alphanumeric identifier for   |
| 1 | PRODUCT ID** |       |    |     | the product within their own  |
| 2 |              |       |    |     | company. If not supplied,     |
| * |              |       |    |     | Field 3 (External Product ID) |
| * |              |       |    |     | will be used.                 |
+---+--------------+-------+----+-----+-------------------------------+
| * | **CATALOG    | 1     | Te | M   | Choose one of the following   |
| * | TYPE**       |       | xt |     | to indicate type of catalog:  |
| 1 |              |       |    |     |                               |
| 3 |              |       |    |     | **S** = Supplier Catalog (use |
| * |              |       |    |     | this if you are a supplier).  |
| * |              |       |    |     |                               |
|   |              |       |    |     | **I** = Inventory (use this   |
|   |              |       |    |     | if you are a Buying Client).  |
|   |              |       |    |     |                               |
|   |              |       |    |     | **P** = Surplus Catalog (use  |
|   |              |       |    |     | this if you are reselling     |
|   |              |       |    |     | surplus).                     |
|   |              |       |    |     |                               |
|   |              |       |    |     | **V** = Services              |
+---+--------------+-------+----+-----+-------------------------------+
| * | **ATTACHMENT | 1     | Te | R   |                               |
| * | SEQUENCE     |       | xt |     |                               |
| 4 | NUMBER**     |       |    |     |                               |
| 1 |              |       |    |     |                               |
| * |              |       |    |     |                               |
| * |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+
| * | **DOCUMENT   | 1     | Te | R   | Type of attached document:    |
| * | TYPE**       |       | xt |     | (enter one of the following)  |
| 4 |              |       |    |     |                               |
| 2 |              |       |    |     | '**P**'icture - graphic       |
| * |              |       |    |     |                               |
| * |              |       |    |     | '**M**'SDS - Material Safety  |
|   |              |       |    |     | Data Sheet                    |
|   |              |       |    |     |                               |
|   |              |       |    |     | '**T**'erms                   |
|   |              |       |    |     |                               |
|   |              |       |    |     | '**O**'ther                   |
+---+--------------+-------+----+-----+-------------------------------+
| * | **FILENAME** | 40    | Te | R   | Filename for attached file.   |
| * |              |       | xt |     | Use file extensions           |
| 4 |              |       |    |     | compatible with theNetscape   |
| 3 |              |       |    |     | Navigator web browser (*e.g*. |
| * |              |       |    |     | .gif, .htm, .jpg, .txt). If   |
| * |              |       |    |     | you are unsure call for       |
|   |              |       |    |     | assistance.                   |
+---+--------------+-------+----+-----+-------------------------------+
| * | **FILE       | 40    | Te | R   | Description of attached file. |
| * | D            |       | xt |     |                               |
| 4 | ESCRIPTION** |       |    |     |                               |
| 4 |              |       |    |     |                               |
| * |              |       |    |     |                               |
| * |              |       |    |     |                               |
+---+--------------+-------+----+-----+-------------------------------+

Catalog Submissions

Data for your Buying Client and Catalog Updates

**Choose one of the following two options:**

**Option 1 - New Catalog Submission (Submit Fields 1 - 73)**

> To customize your catalog for a particular Buying Client complete
> Fields 45 - 73. These must be submitted with fields 1 - 44.

**Option 2 - Updating the Catalog (Submit Fields 1, 2, 11, 12, 13, and
41-73)**

> To update your catalog (including additions, deletions and/or
> modifications) complete fields 1, 2, 11, 12, 13, and 41 - 73.

**Preparing the SYNONYM File**

The Synonym file, which is loaded as a separate entry in the company\'s
database, provides abbreviations or word variations that a buyer may use
while performing a text search. Enter the product type and appropriate
synonyms in a synonym file.

+---+---------------+----+-----+----+---------------------------------+
|   | **Field       | ** | **V | ** | **Description**                 |
|   | Element**     | Si | alu | Re |                                 |
|   |               | ze | e** | q. |                                 |
|   |               | ** |     | ** |                                 |
+---+---------------+----+-----+----+---------------------------------+
| * | **PRODUCT     | 10 | T   | Te | Enter the Product Type to Level |
| * | TYPE**        |    | ext | xt | 4 only.                         |
| 1 |               |    |     |    |                                 |
| . |               |    |     |    | See the Product Type Table      |
| * |               |    |     |    | (**Attachment 1**).             |
| * |               |    |     |    |                                 |
+---+---------------+----+-----+----+---------------------------------+
| * | **SYNONYM**   | 30 | T   | M  | Enter each applicable synonym,  |
| * |               |    | ext |    | abbreviation, or alternative    |
| 2 |               |    |     |    | spelling.                       |
| . |               |    |     |    |                                 |
| * |               |    |     |    | This field may be repeated as   |
| * |               |    |     |    | needed.                         |
+---+---------------+----+-----+----+---------------------------------+

**Using ASCII Format**

**Example:**

To establish synonyms for carbon steel, switch box, and circuit breaker,
the following entries could be made in the SYNONYM.TXT file:

**FILE SYNONYM.TXT**

**[TYPE\~SYNONYM\~SYNONYM\~SYNONYM....]{.underline}**

PT\~Carbon Steel\~CS\~C/S\~Carb S\~Crb Stl

EL\~Switch Box\~Outlet Box\~OB\~S Box

EL\~Circuit Breaker\~Circuit-Breaker\~C Bkr\~C. Bkr.

NOTE: Synonyms are [not]{.underline} case sensitive.

> The synonyms match to phrases. If ***C Breaker*** is a synonym and the
> user types in ***breaker*** there will not be a match unless the word
> ***breaker*** appears in the description.

**[TYPE\~SYNONYM\~SYNONYM\~SYNONYM....]{.underline}**

MM\~BP\~Back Pressure\~Base Plate

MM\~B PL\~Base Plate\~Base Gold

If the user types in ***base plate*** matches will be displayed for any
items containing the following:

BP, Back Pressure, Base Plate, B PL, Base Gold.

**Examples of Electronic Catalog Submissions**

**Preparing the Electronic Catalog in Database Format**

The screen print below shows the fields and data in the correct order.
Column headings may be an abbreviated

version of the field name.

![](media/image2.wmf){width="6.553472222222222in"
height="1.5277777777777777in"}

If using an unlisted application remember to save the file in the
appropriate database format.

  ------------------------------------- ---------------------------------
  **Database**                          **Extension**

  Access                                .mdb
  ------------------------------------- ---------------------------------

**Preparing the Electronic Catalog in Spreadsheet Format**

The screen print below shows the fields and data in the correct order.
Column headings may be an abbreviated version of the field name.

![](media/image2.wmf){width="6.553472222222222in"
height="1.5277777777777777in"}

If using an unlisted application remember to save the file in the
appropriate database format.

  ---------------------------------- ------------------------------------
  **Spreadsheet**                    **Extension**

  Excel                              .xls
  ---------------------------------- ------------------------------------

**Note:** Save each catalog file as a separate
[spreadsheet]{.underline}. Do not save files as separate sheets in the
same spreadsheet.

**Data Entry**

This example shows how to list a product using an ASCII file. In this
case (1) a product is being added; (2) the product type is PT for pipe;
(3) the supplier external product ID is "123ITEM"; (4) the [list
price]{.underline} is \$6.00; (5) the list price basis is per Unit of
Measure; (6) Freight is not included in the list price;

\(7\) the inventory level has been skipped, this is indicated by the
tilde; (8) the inventory unit of measure is EA for each; (9) the product
size is ¾" diameter; (10) the description is plastic pipe. You may enter
up to 2000 text characters under description, but only 255 characters
per field.

**A\~PT\~123ITEM\~6.0000\~UM\~N\~\~EA\~ 3/4\" DIA\~PLASTIC
PIPE\~**(CR/LF)

ISO 9000 Country Codes Table

  -----------------------------------------------------------------------
  **COUNTRY**                                          **CODE**
  ---------------------------------------------------- ------------------
  Afghanistan                                          AFG

  Albania                                              ALB

  Algeria                                              DZA

  American Samoa                                       ASM

  Andorra                                              AND

  Angola                                               AGO

  Anguilla                                             AIA

  Antarctica                                           ATA

  Antigua And Barbuda                                  ATG

  Argentina                                            ARG

  Armenia                                              ARM

  Aruba                                                ABW

  Australia                                            AUS

  Austria                                              AUT

  Azerbaijan                                           AZE

  Bahamas                                              BHS

  Bahrain                                              BHR

  Bangladesh                                           BGD

  Barbados                                             BRB

  Belarus                                              BLR

  Belgium                                              BEL

  Belize                                               BLZ

  Benin                                                BEN

  Bermuda                                              BMU

  Bhutan                                               BTN

  Bolivia                                              BOL

  Bosnia And Herzegowina                               BIH

  Botswana                                             BWA

  Bouvet Island                                        BVT

  Brazil                                               BRA

  British Indian Ocean Territory                       IOT

  Brunei Darussalam                                    BRN

  Bulgaria                                             BGR

  Burkina Faso                                         BFA

  Burundi                                              BDI

  Cambodia                                             KHM

  Cameroon                                             CMR

  Canada                                               CAN

  Cape Verde                                           CPV

  Cayman Islands                                       CYM

  Central African Republic                             CAF

  Chad                                                 TCD

  Chile                                                CHL

  China                                                CHN

  Christmas Island                                     CXR

  Cocos (Keeling) Islands                              CCK

  Colombia                                             COL

  Comoros                                              COM

  Congo                                                COG

  Cook Islands                                         COK

  Costa Rica                                           CRI

  Cote D'ivoire                                        CIV

  CROATIA (Or Hrvatska)                                HRV

  Cuba                                                 CUB

  Cyprus                                               CYP

  Czech Republic                                       CZE

  Denmark                                              DNK

  Djibouti                                             DJI

  Dominica                                             DMA

  Dominican Republic                                   DOM

  East Timor                                           TMP

  Ecuador                                              ECU

  Egypt                                                EGY

  El Salvador                                          SLV

  Equatorial Guinea                                    GNQ

  Eritrea                                              ERI

  Estonia                                              EST

  Ethiopia                                             ETH

  Falkland Islands (Malvinas)                          FLK

  Faroe Islands                                        FRO

  Fiji                                                 FJI

  Finland                                              FIN

  Former Republic Of Macedonia                         MKD

  France                                               FRA

  France, Metropolitan                                 FXX

  French Guiana                                        GUF

  French Polynesia                                     PYF

  French Southern Territories                          ATF

  Gabon                                                GAB

  Gambia                                               GMB

  Georgia                                              GEO

  Germany                                              DEU

  Ghana                                                GHA

  Gibraltar                                            GIB

  Greece                                               GRC

  Greenland                                            GRL

  Grenada                                              GRD

  Guadeloupe                                           GLP

  Guam                                                 GUM

  Guatemala                                            GTM

  Guinea                                               GIN

  Guinea-Bissau                                        GNB

  Guyana                                               GUY

  Haiti                                                HTI

  Heard And McDonald Islands                           HMD

  Honduras                                             HND

  Hong Kong                                            HKG

  Hungary                                              HUN

  Iceland                                              ISL

  India                                                IND

  Indonesia                                            IDN

  Iran (Islamic Republic Of)                           IRN

  Iraq                                                 IRQ

  Ireland                                              IRL

  Israel                                               ISR

  Italy                                                ITA

  Jamaica                                              JAM

  Japan                                                JPN

  Jordan                                               JOR

  Kazakhstan                                           KAZ

  Kenya                                                KEN

  Kiribati                                             KIR

  Korea, People\'s Republic Of                         PRK

  Korea, Republic Of                                   KOR

  Kuwait                                               KWT

  Kyrgyzstan                                           KGZ

  Lao People's Democratic Republic                     LAO

  Latvia                                               LVA

  Lebanon                                              LBN

  Lesotho                                              LSO

  Liberia                                              LBR

  Libyan Arab Jamahiriya                               LBY

  Liechtenstein                                        LIE

  Lithuania                                            LTU

  Luxembourg                                           LUX

  Macau                                                MAC

  Madagascar                                           MDG

  Malawi                                               MWI

  Malaysia                                             MYS

  Maldives                                             MDV

  Mali                                                 MLI

  Malta                                                MLT

  Marshall Islands                                     MHL

  Martinique                                           MTQ

  Mauritania                                           MRT

  Mauritius                                            MUS

  Mayotte                                              MYT

  Mexico                                               MEX

  Micronesia, Federated States Of                      FSM

  Moldova, Republic Of                                 MDA

  Monaco                                               MCO

  Mongolia                                             MNG

  Montserrat                                           MSR

  Morocco                                              MAR

  Mozambique                                           MOZ

  Myanmar                                              MMR

  Namibia                                              NAM

  Nauru                                                NRU

  Nepal                                                NPL

  Netherlands                                          NLD

  Netherlands Antilles                                 ANT

  New Caledonia                                        NCL

  New Zealand                                          NZL

  Nicaragua                                            NIC

  Niger                                                NER

  Nigeria                                              NGA

  Niue                                                 NIU

  Norfolk Island                                       NFK

  Northern Mariana Islands                             MNP

  Norway                                               NOR

  Oman                                                 OMN

  Pakistan                                             PAK

  Palau                                                PLW

  Panama                                               PAN

  Papua New Guinea                                     PNG

  Paraguay                                             PRY

  Peru                                                 PER

  Philippines                                          PHL

  Pitcairn                                             PCN

  Poland                                               POL

  Portugal                                             PRT

  Puerto Rico                                          PRI

  Qatar                                                QAT

  Reunion                                              REU

  Romania                                              ROM

  Russian Federation                                   RUS

  Rwanda                                               RWA

  Saint Kitts And Nevis                                KNA

  Saint Lucia                                          LCA

  Saint Vincent And The Grenadines                     VCT

  Samoa                                                WSM

  San Marino                                           SMR

  Sao Tome And Principe                                STP

  Saudi Arabia                                         SAU

  Senegal                                              SEN

  Seychelles                                           SYC

  Sierra Leone                                         SLE

  Singapore                                            SGP

  Slovakia (Slovak Republic)                           SVK

  Slovenia                                             SVN

  Solomon Islands                                      SLB

  Somalia                                              SOM

  South Africa                                         ZAF

  Spain                                                ESP

  Sri Lanka                                            LKA

  St. Helena                                           SHN

  St. Pierre And Miquelon                              SPM

  Sudan                                                SDN

  Suriname                                             SUR

  Svalbard And Jan Mayen Islands                       SJM

  Swaziland                                            SWZ

  Sweden                                               SWE

  Switzerland                                          CHE

  Syrian Arab Republic                                 SYR

  Taiwan, Province Of China                            TWN

  Tajikistan                                           TJK

  Tanzania, United Republic Of                         TZA

  Thailand                                             THA

  Togo                                                 TGO

  Tokelau                                              TKL

  Tonga                                                TON

  Trinidad And Tobago                                  TTO

  Tunisia                                              TUN

  Turkey                                               TUR

  Turkmenistan                                         TKM

  Turks And Caicos Islands                             TCA

  Tuvalu                                               TUV

  Uganda                                               UGA

  Ukraine                                              UKR

  United Arab Emirates                                 ARE

  United Kingdom                                       GBR

  United States                                        USA

  United States Minor Islands                          UMI

  Uruguay                                              URY

  Uzbekistan                                           UZB

  Vanuatu                                              VUT

  Venezuela                                            VEN

  Viet Nam                                             VNM

  Virgin Islands (British)                             VGB

  Virgin Islands (U.S.)                                VIR

  Wallis And Futuna Islands                            WLF

  Western Sahara                                       ESH

  Yemen                                                YEM

  Yugoslavia                                           YUG

  Zaire                                                ZAR

  Zambia                                               ZMB

  Zimbabwe                                             ZWE
  -----------------------------------------------------------------------

**Facility Codes**

**Select the applicable code from the table below and enter it in Field
53, Buyer ID.**

### GLOBAL 

If ***GLOBAL* (no spaces)** is entered into Field 53 (Buyer ID) the
Supplier's catalog will be displayed to **all** UT-Battelle facilities.
This option generally applies to Suppliers who have a national agreement
with UT-Battelle. A universal catalog will be displayed without any site
specific information.

  ---------------------------------- ------------------------------------
  **Facilities**                     **Codes**

  ORNL                               GLOBAL (type as one word, all CAPS)

                                     

                                     

                                     
  ---------------------------------- ------------------------------------

#  **Unit or Basis for Measurement Table**

**Derived from Table 355 of the EDI ANSI X.12 Standard**. These codes
have been selected UT-Battelle for use in their electronic catalog
system. Any [Unit of Measure]{.underline} provided in the electronic
catalog must be chosen from this table.

.

  -----------------------------------------------------------------------
  **ANSI CODE**            **UNIT**
  ------------------------ ----------------------------------------------
  AM                       Ampoule

  AY                       Assembly

  AS                       Assortment

  BG                       Bag

  BA                       Bale

  AA                       Ball

  BI                       Bar

  BR                       Barrel

  BL                       Block

  BF                       Board Feet

  BM                       Bolt

  BK                       Book

  BO                       Bottle

  BX                       Box

  BD                       Bundle

  BU                       Bushel

  KA                       Cake

  CN                       Can

  CB                       Carboy

  CT                       Carton

  CQ                       Cartridge

  CM                       Centimeter

  CX                       Coil

  CJ                       Cone

  CH                       Container

  CC                       Cubic Centimeter

  CR                       Cubic Meter

  CY                       Cubic Yard

  CL                       Cylinder

  DA                       Days

  DZ                       Dozen

  DR                       Drum

  EA                       Each

  FT                       Foot

  GA                       Gallon

  GM                       Gram

  GS                       Gross

  10                       Group

  HA                       Hank

  HU                       Hundred

  HF                       Hundred Feet

  HV                       Hundred Weight (Short)

  IN                       Inch

  JR                       Jar

  JU                       Jug

  KE                       Keg

  KG                       Kilogram

  KT                       Kit

  LN                       Length

  LF                       Linear Foot

  LI                       Linear Inch

  LY                       Linear Yard

  LT                       Liter

  LO                       Lot

  Q3                       Meal

  MR                       Meter

  MU                       Millicurie

  ME                       Milligram

  ML                       Milliliter

  MM                       Millimeter

  MO                       Months

  OZ                       Ounce -- Av

  11                       Outfit

  PK                       Package

  12                       Packet

  PD                       Pad

  QB                       Pages - Hardcopy

  PR                       Pair

  WP                       Pennyweight

  PC                       Piece

  PT                       Pint

  PP                       Plate

  PJ                       Pounds

  QT                       Quart

  QR                       QUIRE

  13                       Ration

  RM                       Ream

  RE                       Reel

  RL                       Roll

  SG                       Segment

  ST                       Set

  SH                       Sheet

  SP                       Shelf Package

  NS                       Short Ton

  14                       Shot

  SW                       Skein

  SV                       Skid

  SL                       Sleeve

  SO                       Spool

  SQ                       Square

  SF                       Square Foot

  SY                       Square Yard

  5I                       Standard Cubic Foot

  15                       Stick

  SR                       Strip

  TH                       Thousand

  TZ                       Thousand Cubic Feet

  TQ                       Thousand Feet

  TO                       Troy Ounce

  TB                       Tube

  VI                       Vial

  WK                       Week

  YD                       Yard

  YR                       Years
  -----------------------------------------------------------------------

Supplier Category

Suppliers: You must identify a supplier category when submitting an

electronic catalog for UT-Battelle. Choose one or more of the

following:

> (BB) Big Business
>
> (SB) Small Business
>
> \* (SDB) Small Disadvantaged Business
>
> (WOSB) Women-Owned Small Business
>
> \*(HUBZone) Historically Under Utilized Business Zone
>
> (Vet-Owned) Veteran Owned
>
> (SD-Vet) Service Disabled Veteran Owned
>
> \*8(a) Small Disadvantaged Business
>
> \*MUST be SBA Certified and in CCR (Central Contractor
>
> Registration) database. (www.ccr.gov)

Enter this information next to "Company Name" on the Catalog Submission
Form found on the last page of the Electronic Catalog Procedures 5.4.

Email to:

hintonrljrl@ornl.gov Phone: 865-574-6056

Fax: 865-574-5748

### Catalog Submission Form

**SUPPLIER INFORMATION**

  ----------------------- -----------------------------------------------
  **COMPANY NAME:**       

  **ADDRESS:**            

  **D-U-N-S NUMBER:**     

  **CATALOG PREPARED      
  BY:**                   

  **CONTACT E-MAIL        
  ADDRESS:**              

  **CONTACT PHONE:**      
  ----------------------- -----------------------------------------------

**ELECTRONIC CATALOG PROCEDURE VERSION NUMBER:
\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

**(Found on the first page of this document.)**

**CHECK THE FILE TYPE:**

  ------- ------------- ------- ----------------- ------- -------------------------------
  ****   **ASCII**     ****   **Access** (.mdb) ****   **Excel** (.xls)
          (.txt)                                          

  ------- ------------- ------- ----------------- ------- -------------------------------

**BUYING CLIENT INFORMATION**

  ----------------------------------- -----------------------------------
  **BUYER COMPANY NAME:**             

  **BUYER LOCATION: (Plant Location   
  Number etc.)**                      

  **AGREEMENT NO. WITH BUYER:**       
  ----------------------------------- -----------------------------------