PART NUMBER SEARCH – TABLE OF CONTENTS

I LOG IN
A) New Professional
B) Current Professional
II PROFESSIONAL INFORMATION
A) Updating Professional User Information
B) Updating Supplier Information
1) Mapping Function
III INQUIRY PAGE
A) How to conduct a Part Number Search
B) Preferred Suppler Groups
C) Entering Part Number & Quantities
D) Performing Wildcards Searches
E) Uploading & Updating Inventories
IV RESULTS PAGE
A) Sorting Data 
B) Viewing Part Information
C) Viewing Supplier Information
D) Generating RFQs to Suppliers
V RFQ REVIEW PAGE
A) Adding Suppliers to RFQ
B) Global Messages
C) Personalized Messages
D) Canceling RFQs
E) RFQ Status
F) Sending or Canceling all your RFQ's
G) Supplier Contact Information
VI RFQ'S (REQUEST FOR QUOTE)
A) Viewing RFQs
B) Quantity Desired
C) Personalized Messages
"D) Submit, Save & Cancel"
VII COMPANY PROFILES
A) What is a Company Profile
VIII SUPPLIER INFORMATION
A) How suppliers access & change their Company Profiles
B) Required and Optional Filds. Field lengths and Condition Codes
C) Mapping Funcion
D) Uploading & Updating Inventories

HOW TO USE ABDONLINE
Welcome to ABDOnline, aviation’s web site for locating sources of supply and industry information. The web site is divided into four main areas:
1. PART NUMBER SEARCH
2. DIRECTORY SEARCH
3. PARTING OUT SEARCH
4. EDITORIAL SEARCH
The “directory”, “parting out” and “editorial” search functions are in the process of being created. This explanation will be limited to the “Part Number Search” feature. From the Home Page, click on the button for “Part Number Search.” Enter in your I.D. number and password under “REGISTERED PROFESSIONALS” and click “submit.” If you do not have an I.D. number and password, you will need to create one and then complete the “Professional Profile” form presented. Start this process by clicking “Initial Registration for user access and to list as a supplier on our system FREE” under “New Professionals.” If you have forgotten your password, click on “Forgot Your Password?” to have your password e-mailed to you.

How To Get Your Company Listed With ABDOnline
If your company sells to the industry in any capacity, you should get listed with ABD Online. To list the products and services of your company, you will first need to complete the registration process as a user of the system (a “Professional”). First create a “User ID” and “Password” at the log in screen. Then complete the “Professional Profile” screen making sure to enter information in the required bold fields. Indicate yes to the question toward the bottom of the “Professional Profile” form which asks, “Do you wish to list your inventory/services with our database?” You will then be asked to complete the supplier registration form known as the “Company Profile Page Questionnaire.” Once this is submitted, ABD Online will contact you with specifications on how to list your company. For more information see the FAQ topics of “mapping functions for suppliers” and “uploading and updating inventories” later in this document.

THE INQUIRY PAGE

How To Conduct A Part Number Search
You start your search for industry suppliers from the “Inquiry Page.” Information about suppliers who can provide that part or repair is presented on the “Results Page.” First specify what you are looking for by clicking the appropriate button next to “Search By:” – if you are looking to buy a part, click “Part Availability.” If you are looking for someone to repair or overhaul a part, component or aircraft, click “Overhaul Capability.” You cannot search for parts suppliers and overhaul shops at the same time; each type of search must be performed separately. Next indicate how you would like the information displayed on the “Results Page” by clicking the appropriate radio button next to “Sort Results By” Clicking “Part Number” will display the results by part number with all the suppliers who can provide that part. Clicking “Supplier” will sort the results by company, with a list of the part numbers you have queried that those companies can provide.

Preferred Supplier Groups
ABDOnline allows you to create “Preferred Supplier Groups.” The listings of companies in your “Preferred Supplier Group” will appear first on the “Results Page” if they have the part or can perform the service you are inquiring about. You may create as many “Preferred Supplier Groups” as you like, but can only include six companies in each group. Also, for each part number search you perform, you will only be able to select one of your “Preferred Supplier Groups” to be included in the search results. You can specify which of your previously created “Preferred Supplier Groups” you want for the current part number search by selecting it from the pull down menu presented. To create or modify a “Preferred Supplier Group,” click on the colored line “Create/Modify Preferred Supplier Group”. Follow the instructions on the screen to create, modify or delete groups or individual group members. From the “Adding a Supplier” screen you may easily e-mail companies who are not on our system and request that they get listed.

Entering Part Numbers and Quantities
You may query up to 19 different part numbers at a time, by entering each part number in the field provided. You may also indicate the desired quantity of each item, so that this information will be automatically entered when you RFQ your selected suppliers. YOU MUST ENTER THE PART NUMBER EXACTLY, INCLUDING DASHES. When you have completed entering the part numbers you are interested in, simply click “Search.” Clicking “Reset” will clear the “Inquiry Page” of any part numbers or quantities entered, for reentry. The total number of suppliers of a particular part number may not be presented to you on the “Results Page” because of the amount of part numbers you are querying at any one time. To see the entire list of suppliers for a particular part number, simply perform a part number search for that part number alone, without an asterisk.

Performing WILD CARD Searches
To return results based upon the first four digits of a part number, simply enter in those first four digits followed by an asterisk *. This will return a list of suppliers who sell or repair parts similar to the one you are inquiring about.

Uploading and Updating Inventories
(Correcting specific part information or replacing an entire inventory listing) Once a supplier company is registered with ABDOnline, it is possible for them to change information about their inventory or capabilities directly from our web site. Changes to a supplier company’s ABDOnline database listings may be performed one part number at a time or by replacing the company’s entire database listings. To change information about an individual part number (such as to add it, delete it, change the quantity or condition information, etc.) click on the green bar “Update Your Existing Inventory” then enter in the necessary information as prompted. To change your company’s entire database listing information, click on the yellow bar entitled “Upload Your Entire Inventory.”

THE RESULTS PAGE

Sorting of Data on the Results Page
The results of a part number inquiry may be presented in one of two ways – either by part number first with all the suppliers who have or repair that part number, or by supplier first with all the part numbers that that company can provide or repair. By clicking the “Resort” bar at the top of the “Results Page,” the presented data will toggle between these two options.

Viewing Part Information
If a supplier has provided more information about a specific part, such as traceability, price, applicable aircraft, serial number, etc., you may access this information by simply clicking on the part number listed.

Viewing Supplier Information
It is strongly recommended that before e-mailing an RFQ to a selected supplier, the user (professional) click on the listing of the company to learn as much as possible about the firm in advance. Suppliers whose listings appear in red, underlined type have taken extra steps in providing to the aviation community more relevant detail’s about their business, so that you as a buyer may know whom you are dealing with.

Generating RFQs to Suppliers
By clicking in the first column to the left of a suppliers name, that company will be selected to receive an e-mail RFQ from you for the part number specified. Once all your suppliers are chosen click on the “Select” bar at the top or bottom of the screen to see the “RFQ Review Screen” before sending the RFQs

COMPANY PROFILES

What is a Company Profile?
Detailed information about a supplier firm is presented in their “Company Profile.” Scroll down the page to learn about company’s AOG hours, its authorized distributorship lines, its worldwide government repair station approvals, its key personnel, etc. Some suppliers may also provide a display ad or brochure attached to the bottom of their company profile, to tell more about their company or capabilities. Suppliers interested in obtaining “Company Profiles” should contact ABDOnline at 914-242-8700 ext. 307.

SUPPLIER INFORMATION

How Suppliers access and change their “Company Profiles”
From anywhere on the web site, click on the portion of the header bar called “Update User Profile” which will lead you to the “Professional Profile” screen. Scroll down to the bottom and click the blue bar “Update Company Profile Information.”

Required and Optional Fields, Field Lengths and Condition Codes
The required fields for listing "Parts" with field length in BOLD are: (a)Part Number (30); (b) Description (30); (c) Quantity (10); and (d) Condition (2)

The required fields for listing "Overhauls" with field length in BOLD are: (a) Part Number (30); (b) Desctiption (30)

Optional fields for information about your parts/capabilities are: (e) Alternate Part Number (30); (f) Manufacturer (15); (g) Unit of Measure (10); (h) CAGE Code (5); (i) Traceability (Y/N); (j) Aircraft (20); (k) Assembly (20); (l) Availability (15); (m) Rotable Serial Number (30); (n) Price (10);

Condition Codes are as follows:
New = NE; Factory new = FN; New Surplus = NS; Overhaul = OH; Serviceable = SV; Used Surplus = US; As Removed = AR

Mapping Function
To list your inventory or overhaul capabilities with our system you first must tell us how you will submit your data and you must specify what format your data is in and where information is situated within the file. The mapping function simply tells our program where to look in your file so that your data is entered into the correct fields for presentation on our “Results Page”. Specify the parameters as prompted on the screen. Please delete out any letters or codes placed in front of part numbers, we do not need them. ABDOnline has created a mapping function to provide you with an easy three-step process to tell our system how you will be providing your data.

Step (1) Select a format.

ABDOnline is only able to accept data in one of these four formats:
A) Database – (DBF)
B) Microsoft Excel (MS Excel) or any spreadsheet that uses a similar format.
C) Comma-Delimited Text (TXT)
D) Fixed Length Text (TXT)

To indicate which format you will use to supply your data please click next to the radio button of the appropriate format.

Step (2) Decide how you wish to receive RFQs

ABDOnline will provide free e-mailing of RFQs to the e-mail address listed in the company profile. If you wish to have RFQs faxed to you instead, we can provide this service for a fee. You will need to select the preferred way you wish to receive RFQs by clicking next to the appropriate radio button.

Step (3) Layout of Map Format

You will next have to provide us your particular data layout for each parts list and overhaul capabilities list, if you provide both services. When you press on the button to map your data you will see a screen that contains two columns. On the left is the list of information we can provide for each part (i.e. Part Number, Part Description, Condition Code etc.). On the right is the default for each type of data we can accept. Required fields are indicated in red. The following are the methods for each format.

A) DBF – If you provide your data in a DBF format you will need to indicate the “Field Name” for each field that contains that piece of data. For example, “PART NUMBER” appears in the field with the name “PARTNO” and “PART DESCRIPTION” appears in the field with the name “PARTDESC” etc.

B) MS Excel – If you provide your data in an XLF format you will need to indicate in which Excel Column a particular piece of data appears. For example, “PART NUMBER” appears in “EXCEL COLUMN: A” and “PART DESCRIPTION appears in “EXCEL COLUMN: B” etc. Whenever you supply a file in MS Excel you must be sure to start your descriptive headers in row “1” and your data in row “2.”

C) Comma-Delimited Text – If you provide your data in a TXT format that is comma-delimited you will need to provide us with the number of the field that the appropriate data appears in. For example, “PART NUMBER” appears in the “FIELD NUMBER: 1” and “PART DESCRIPTION” appears in “FIELD NUMBER: 2.” Please make sure that all field information begins and ends in quotation marks (“ ”) and that each field of data is separated with a comma ( , ).

D) Fixed Length Text – If you provide your data in a TXT format that is fixed length you will need to provide us with the starting point of that piece of data and the length of each field. For example, “PART NUMBER” begins or “START” at position “1” and runs “LENGTH: 30” characters long, and “PART DESCRIPTION” begins or “START” at position “31” and runs “LENGTH: 30” characters long.

Uploading and Updating Inventories
(Correcting specific part information or replacing an entire inventory listing) Once a supplier company is registered with ABDOnline, it is possible for them to change information about their inventory or capabilities directly from our web site. Access these functions from the “Inquiry Page.” Changes to a supplier company’s ABDOnline database listings may be performed one part number at a time or by replacing the company’s entire database listings. To change information about an individual part number (such as to add it, delete it, change the quantity or condition information, etc.) click on the green bar “Update Your Existing Inventory” then enter in the necessary information as prompted. To change your company’s entire database listing information, click on the yellow bar entitled “Upload Your Entire Inventory.”

RFQ REVIEW SCREEN

The suppliers you selected on the “Results Page” to generate RFQs to now appear on the “RFQ Review Page.”

Adding Suppliers to RFQ
If you forgot to include a supplier, click the “Back” button at the top of your browser to go back one page and add that supplier to your list by simply clicking next to their name in the “RFQ” column.

Global Messages
You may create a global message to all of your selected vendors by entering that message in the text box at the bottom of the “RFQ Review Page.” This message will appear on the RFQs of your selected vendors for this inquiry only.

Personalized Messages
If you wish to create a personalized message to a particular supplier, simply click in the column titled “View RFQ” next to their name and scroll down to the bottom of that supplier’s presented RFQ, and enter your message in the text box indicated.” Clicking “Submit” on the bottom of the RFQ will send it.

Canceling RFQs
If you have changed your mind and decided not to send an RFQ to a selected supplier, simply click “Cancel” in the Cancel column and the supplier will be removed from the “RFQ Review Page” entirely.

RFQ Status
The “RFQ Status” column tells you where you are in the RFQ process for this part number inquiry. For instance, some of your RFQs may have already been sent, others may have been cancelled, etc.

Sending or Canceling RFQs
When you are ready to send out all listed RFQs, click the green “Send” bar at the bottom of the page. Clicking the red “Cancel” bar below “Send” will nullify all unsent RFQs and return you to the “Inquiry Page.”

Supplier Information
Supplier phone numbers are included on the “RFQ Review Page” for your convenience. Please note that you may view a supplier’s basic listing information by clicking on their name. Red listing’s are preferred suppliers who have provided detailed “Company Profiles”. by viewing a supplier’s specific RFQ and then sending it.

RFQs (Request For Quote)

The relevant part numbers that you are inquiring about have been entered for you automatically in the appropriate fields. Also entered are any alternate part number and the amount of your initially entered “desired quantity.” The supplier’s on-hand quantity is also entered automatically for your reference as well as the manufacturer’s name for clarity.

Quantity Desired
You may change the quantity of the part number you desire by indicating the new amount in this field.

Personalized Messages
If you wish to create a personalized message to a particular supplier, enter your message in the text box indicated.

“Submit,” “Save,” “Cancel”
Clicking “Submit” on the bottom of the RFQ will send it. Clicking “Save” will save it and clicking “Cancel” will return you to the “RFQ Review Page” where you may completely delete the RFQ to this supplier or proceed on with the RFQ process.

PROFESSIONAL INFORMATION

A) Updating Professional Profile Information
Make changes to your “Professional Profile” as needed at any time by simply entering in the new information in the fields provided. Required fields are indicated in BOLD type. Addresses two and three are for supplementary information such as mail stop or suite number. If you were recommended to our site by a person or company in the industry, or if you saw an ad in a publication, please enter that information in the “Referred By” field. At lease one “Industry Affiliations” field must be ticked. Employee numbers are strictly confidential and will never be accessed, used, released, sold/ or in any way misused by ABDOnline. We require these numbers merely to verify employment.

B) Updating Supplier Information
You access the “Supplier Profile Questionnaire” page from the “Professional Profile” page. If you desire to have your company list its inventory or overhaul capabilities on our system then check off the box next to the question “Do you wish to list your inventory/services with our database?” Next, click on the blue bar at the bottom of the form named “Update Supplier Information.”

ABD Online allows only one individual at a firm to change information about that company or to update or upload its listings of parts and/or services. Basic information about a supplier will be presented to buyers who click on a business listing. The full “Company Profile” is available to companies as a paid service. Please keep “Brief Descriptions” to 50 words or less. “Authorized Distributorships” refers to agreements your firm may have with manufacturers, distributors, repair stations, consignors, etc. “Repair Station Approvals” include any and all governmental approvals (i.e. –FAA, CAAC, CAA, etc.). Please limit personnel information to company management, purchasing, sales/marketing, etc. ABDOnline welcomes the inclusion of more than ten company personnel; please contact our executive offices at 914-242-8700 ext. 307 for more information. “E-Bullets” are related only to advertisers. E-mail is ABD Online’s standard method for transmitting RFQs and “E-Bullets.” Faxing service is available for a fee - please contact our offices if you are interested. To list your inventory or overhaul/repair capabilities, please see the section of these instructions entitled “Mapping Functions”.