Electronic Parts Systems and Data Management

Chapter Introduction

This chapter covers the electronic systems used in the parts technician trade. Mastering these systems is essential for passing the Red Seal exam, as they represent a significant portion of daily tasks. You will learn the principles of inventory management systems, data formats, standardized codes, search procedures, as well as safety and traceability requirements. This chapter is structured to reflect the competency blocks of the National Occupational Analysis.

Computerized Inventory Management Systems (CIMS)

Definition and Role

A computerized inventory management system (CIMS) is a software application that allows you to track, control, and optimize parts inventories. It centralizes data related to purchases, sales, transfers, and adjustments. The CIMS is the primary tool for the parts technician to locate a part, check its availability, determine its price, and review its history.

Components of a CIMS

A complete CIMS includes several interconnected modules:

Inventory Module: manages stock quantities, locations, and reorder thresholds.

Order Module: generates purchase orders, tracks outstanding orders, and manages supplier returns.

Billing Module: creates invoices, quotes, and delivery slips.

Search Module: queries the database by part number, description, vehicle, or cross-reference code.

Reports Module: produces analyses of turnover, inventory value, and supplier performance.

Operating Principles

The CIMS operates on the principle of a relational database. Each part has a unique record containing standardized fields: part number, description, manufacturer, supplier, purchase price, selling price, quantity in stock, location, classification code, and status code.

Inventory updates are done in real-time or in batches, depending on the system. The most common method is real-time updating with each transaction (sale, receipt, transfer). This method reduces inventory discrepancies but requires strict discipline in data entry.

Replenishment Calculations

The CIMS can automatically calculate order quantities based on predefined formulas. The reorder point (ROP) is the stock level that triggers an order. It is calculated as follows:

ROP = (Average daily consumption × Lead time in days) + Safety stock

Example: average consumption of 5 units/day, lead time of 10 days, safety stock of 20 units.

ROP = (5 × 10) + 20 = 70 units.

The economic order quantity (EOQ) minimizes total ordering and holding costs. The basic formula is:

EOQ = √(2 × Annual demand × Ordering cost ÷ Annual unit holding cost)

Example: annual demand of 1200 units, ordering cost of $25, holding cost of $4/unit/year.

EOQ = √(2 × 1200 × 25 ÷ 4) = √(60000 ÷ 4) = √15000 ≈ 122 units.

Exam Tip

On the exam, you will often be asked to calculate the reorder point or the EOQ. Read the units carefully (days vs. weeks, annual vs. monthly cost). Convert all values to the same unit before calculating.

Part Identification Codes and Standards

OEM Part Number

The Original Equipment Manufacturer (OEM) part number is the alphanumeric code assigned by the original equipment manufacturer. It is unique for each part and application. Examples: an oil filter may carry the number 15208-65A0A (Nissan) or 90915-YZZD1 (Toyota). You must know the number structure of major manufacturers to avoid search errors.

Aftermarket Part Number

Aftermarket parts manufacturers use their own numbering systems. For example, Bosch uses 10-digit numbers, NGK uses codes like BKR6E-11, and ACDelco uses codes like PF63. Cross-referencing between OEM and aftermarket numbers is done through cross-reference tables built into the CIMS or through specialized electronic catalogs.

Barcodes and the EAN/UPC Standard

Parts are identified by barcodes conforming to international standards. The two main systems are:

UPC-A (Universal Product Code): used primarily in North America, 12 digits.

EAN-13 (European Article Number): 13 digits, used internationally.

The barcode contains the GTIN (Global Trade Item Number), which uniquely identifies the product. You must know how to read and verify a barcode, and understand that the GTIN is not the internal part number.

ISO 9001 Standard and Traceability

The ISO 9001 standard (Quality Management Systems) requires documented procedures for product traceability. In the parts context, this means that each part must be traceable from the supplier to the end customer. The CIMS must record lot numbers, receipt dates, and invoice numbers.

The VIN (Vehicle Identification Number)

The VIN is a 17-character code that uniquely identifies a vehicle. It is essential for parts searching. You must know how to:

Decode the VIN: the first character indicates the country of manufacture, characters 4 through 8 indicate the model and engine, the 10th character indicates the model year, and the 11th indicates the assembly plant.

Use the VIN to query manufacturer electronic catalogs.

Verify that the ordered part matches the VIN (year, engine, transmission).

VIN Character Table (Model Year)

Character	Year	Character	Year
A	1980	N	1992
B	1981	P	1993
C	1982	R	1994
D	1983	S	1995
E	1984	T	1996
F	1985	V	1997
G	1986	W	1998
H	1987	X	1999
J	1988	Y	2000
K	1989	1	2001
L	1990	2	2002
M	1991	3	2003

Note that the letters I, O, and Q are excluded from the VIN to avoid visual confusion.

Electronic Parts Catalogs

Types of Catalogs

There are two main types of electronic catalogs:

OEM Catalogs: provided by manufacturers (e.g., Toyota EPC, GM EPC, Ford ETIS). They are brand-specific and contain original parts.

Aftermarket Catalogs: consolidate parts from multiple manufacturers (e.g., Mitchell, ALLDATA, ProDemand). They offer cross-referencing functions between brands.

Search Procedure in an Electronic Catalog

Searching is typically done by:

58.VIN: the most accurate method for recent vehicles.

59.Model and Year: manual vehicle selection.

60.Part Number: direct search if the number is known.

61.Keywords: part description (e.g., "alternator," "oil filter").

Once the vehicle is identified, the catalog displays a tree structure of groups and subgroups (e.g., Group 12 – Cooling System, Subgroup 01 – Radiator). You must navigate this tree to find the exact part.

Common Search Pitfalls

Supersession: manufacturers sometimes replace a part number with a new one. The catalog indicates the supersession (e.g., "Replaces 12345"). You must verify that the new part is compatible.

Vehicle Variants: the same model may have multiple engines, transmissions, or options. A part may be specific to one variant.

Market: parts for the Canadian market may differ from those for the American market (e.g., lighting, emissions).

Exam Tip

On the exam, you will be presented with a search scenario with a VIN and a part description. First, identify the critical VIN information (year, engine, transmission), then choose the most appropriate search method. Never skip the supersession verification step.

Electronic Document Management (EDM)

Definition

Electronic document management (EDM) is the set of techniques and tools used to digitize, store, index, and retrieve documents. In the parts context, this includes invoices, delivery slips, certificates of conformity, repair manuals, and technical data sheets.

Standardized File Formats

You must be familiar with common formats:

PDF (Portable Document Format): universal format for documents.

CSV (Comma-Separated Values): used for exporting tabular data (e.g., price lists).

XML (eXtensible Markup Language): used for exchanging structured data between systems.

EDI (Electronic Data Interchange): standardized protocol for electronic transactions between businesses (e.g., orders, invoices).

Electronic Data Interchange (EDI)

EDI is an electronic communication system that enables the exchange of standardized business documents between partners. EDI messages are structured according to standards such as ANSI X12 (North America) or EDIFACT (international). Common transactions are:

850: Purchase Order

855: Purchase Order Acknowledgment

856: Advance Shipment Notice

810: Invoice

You must understand that EDI reduces data entry errors and speeds up order processing, but requires rigorous data validation.

Data Security

The Personal Information Protection and Electronic Documents Act (PIPEDA) is the Canadian federal law governing the collection, use, and disclosure of personal information. You must:

Protect customer data (names, addresses, VINs).

Use strong passwords and change them regularly.

Never share your login credentials.

Report any data breach to your supervisor.

Backup and Archiving

Data must be backed up regularly. The basic rule is the 3-2-1 rule: 3 copies of the data, on 2 different media, with 1 copy off-site. Archiving of legal documents (invoices, purchase orders) must comply with the requirements of the Canada Revenue Agency (CRA) , which requires a 6-year retention period for accounting documents.

Point of Sale (POS) Systems

Definition

The point of sale (POS) system is the interface between you and the customer during a sale. It integrates barcode scanning, tax calculation, payment method management, and receipt printing.

Taxes

You must correctly apply Canadian taxes:

GST (Goods and Services Tax): 5% (federal rate).

QST (Quebec Sales Tax): 9.975% (Quebec provincial rate).

HST (Harmonized Sales Tax): 13% in certain provinces (Ontario, New Brunswick, etc.).

The calculation is as follows: Net price = Gross price ÷ (1 + Tax rate) to remove a tax, or Gross price = Net price × (1 + Tax rate) to add a tax.

Example: a net price of $100 with 13% HST.

Gross price = 100 × 1.13 = $113.

Payment Methods

Common payment methods are: cash, cheque, debit card, credit card, electronic transfer, and invoicing. You must know the verification procedures (e.g., credit card authorization, identity verification for cheques) and the liability limits in case of fraud.

Returns and Exchanges

Managing returns is a critical procedure. You must:

Verify that the returned part matches the original invoice.

Inspect the part for damage or installation.

Apply the dealership's or store's return policy.

Update the CIMS accordingly (return to stock, customer credit, supplier return).

Communication and Ordering Systems

Electronic Ordering

Parts ordering is increasingly done electronically. You use the CIMS to generate an electronic purchase order that is transmitted to the supplier via EDI or a web portal. The advantages are speed, reduced errors, and real-time tracking.

Order Tracking

The CIMS must allow you to track each order through its statuses: in progress, shipped, received, partial, cancelled. You must know how to interpret status codes and communicate with the supplier in case of delay or shortage.

Service Levels

Suppliers offer different service levels (e.g., next-day delivery, urgent delivery). You must know standard delivery times and associated costs to advise the customer.

Customer Relationship Management (CRM) Systems

Definition

A customer relationship management (CRM) system is a tool that centralizes interactions with customers: purchase history, preferences, communications, and complaints. It enables personalized service and customer loyalty.

Use by the Technician

You use the CRM to:

Review a customer's purchase history.

Identify parts frequently purchased by a customer.

Manage maintenance reminders (e.g., oil changes).

Record complaints and resolutions.

Protection of Personal Information

The CRM contains personal information. You must comply with PIPEDA and the company's internal policies. You must never disclose a customer's information to a third party without consent.

Diagnostic and Programming Systems

The Link Between Diagnostics and Parts

As a parts technician, you must understand the role of on-board diagnostic (OBD) systems. Modern vehicles are equipped with OBD-II (On-Board Diagnostics, second generation), which allows reading fault codes. These codes help identify the defective part.

DTC Codes

Diagnostic Trouble Codes (DTCs) are 5-character alphanumeric codes (e.g., P0301 = cylinder 1 misfire). You must know how to:

Interpret the first character: P (Powertrain), B (Body), C (Chassis), U (Network).

Use the DTC to recommend the appropriate part.

Verify that the recommended part is compatible with the vehicle.

Programming of Electronic Parts

Some parts (control modules, sensors, keys) require programming after installation. You must be able to identify these parts and inform the customer of additional costs and delays. You must also be aware of security requirements (e.g., PIN codes, coded keys).

Applicable Canadian Standards and Regulations

The Canadian Electrical Code

The Canadian Electrical Code, Part I (CSA C22.1) applies to electrical installations. Although it does not apply directly to parts, you must know the requirements for electrical parts (e.g., fuses, relays, connectors). Rule 2-024 requires that parts used be approved for the intended use.

CSA B149.1 Standard

The CSA B149.1 standard (Natural Gas and Propane Code) applies to parts used in gas systems. You must ensure that parts (e.g., valves, regulators) are certified to comply with this standard.

The Motor Vehicle Safety Act

The Motor Vehicle Safety Act (Canada) and its regulations require that replacement parts meet safety standards. You must know the requirements for safety parts (e.g., brakes, steering, suspension) and refuse to sell non-compliant parts.

ISO 9001 Standard

As mentioned earlier, ISO 9001 is a quality management standard. Companies certified to ISO 9001 must document their processes and ensure traceability. You must follow your company's documented procedures.

Pitfalls to Avoid

157.Confusing OEM and aftermarket part numbers: they are not interchangeable without compatibility verification.

158.Ignoring supersession: a part may be replaced by a new number; always verify.

159.Misdecoding the VIN: the 10th character indicates the model year, but be careful with 2010 and later years (characters are digits 0-9, then letters A-Y).

160.Forgetting taxes in calculations: GST, QST, and HST vary by province; verify the applicable rate.

161.Not backing up data: data loss can be catastrophic; apply the 3-2-1 rule.

162.Using a weak or shared password: this compromises data security.

163.Not checking availability before promising a part to a customer: this damages credibility.

164.Confusing DTC codes: a P0301 code does not necessarily indicate a defective part; diagnosis is required.

165.Not complying with CRA requirements: documents must be retained for 6 years.

166.Ignoring safety standards: selling a non-compliant part can lead to legal action.

Summary

The CIMS is the central tool for the parts technician; it manages inventory, orders, invoices, and reports.

Replenishment calculations (reorder point, economic order quantity) are essential for optimizing stock.

Identification codes (OEM number, GTIN, VIN) are fundamental for searching and traceability.

Electronic catalogs enable efficient searching by VIN, model, or part number; always verify supersession.

EDM and EDI improve the efficiency and accuracy of data exchange.

Data security is governed by PIPEDA; you must protect personal information.

Taxes (GST, QST, HST) must be applied correctly according to the province.

Canadian standards (Canadian Electrical Code, CSA B149.1, Motor Vehicle Safety Act) must be respected.

DTC codes and programming of electronic parts are increasingly important skills.

Final Exam Tips

Manage your time: the exam has approximately 90 questions for 3 hours. Do not spend more than 2 minutes per question.

Read each question twice before answering; traps are often in the details (units, negations, supersession).

Use the process of elimination: eliminate obviously wrong answers, then choose from the remaining ones.

Know your formulas: reorder point, EOQ, tax calculations. Practice applying them quickly.

Review the standards: know the exact names of Canadian standards and key rule numbers.

Practice VIN decoding: it is a frequent question with high point value.

This chapter has provided you with the essential knowledge on electronic parts systems and data management. Review regularly, practice calculations and search scenarios, and you will be well prepared for the Red Seal exam. Good luck!

Electronic Parts Systems and Data Management