
d859149ff7c46b62e97d05263897f1a7.ppt
- Количество слайдов: 14
ECCMA Coding Concept Explanation & Value Proposition
What is ECCMA Coding? A standardised, structured coding system that will uniquely identify items by their specific properties
How Does it Work? • • • Current Catalogues consist of a list of numbers (stock code) and descriptions ECCMA coding converts the existing catalogue into a database Converting the existing catalogue into such a format involves 4 Steps: 1. 2. 3. 4. Classification Identification Guide Selection and Commercialization Value Extraction Content Enrichment
Step 1 - Classification What is the item in question? ECCMA identifies items based on the principle of a noun and a qualifier (to more accurately describe the noun). In this case: Bearing: Ball; Annular ECCMA Concept Identifier: 0161 -1 -01006687
Step 2 – Identification Guide Commercialization What do I need to know about this bearing in order to buy it? • Bearing: Ball; Annular • • Inner Diameter Outer Diameter Width # Rows Sealing Type Load Rating Speed Rating Commercialized Template
Step 3 – Value Extraction What do I already know about this item from my current catalogue/code? Current Description BEARING SKF 6317 85 MM BORE 180 MM O/D 41 MM W. REF. SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH Brand & Part # Internal Diameter External Diameter Width # of Rows Sealed/Non Sealed
Step 3 – Value Extraction What do I already know about this item from my current catalogue/code? Bearing: Ball; Annular Inner Diameter 85 mm Outer Diameter 180 mm Width 41 mm # Rows 1 Sealing Type Open Load Rating ? ? ? Speed Rating ? ? ? Partially Populated Commercialized Template Missing Properties
Step 4 – Content Enrichment Populating the missing properties to complete the coding process. www. skf. com Bearing: Ball; Annular Inner Diameter 85 mm Outer Diameter 180 mm Width 41 mm # Rows 1 Sealing Type Open Load Rating 3. 55 KN Speed Rating 5000 rpm
The Result Business Unit 1 52368965412 - BEARING SKF 6317 85 MM BORE 180 MM O/D 41 MM W. REF. SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH Bearing: Ball; Annular (ESCI 0161 -1 -01006687) 56329845 - MECHANICAL PLANT SPARES BEARING BALL SINGLE ROW DEEP GROOVE BEARING, 12 MM I. D. X 28 MM O. D. X 8 MM WIDE PART NUMBER: 6001 2 Z SKF Value UOM Inner Diameter 85 mm Outer Diameter Business Unit 2 Property Description 180 mm Width 41 mm Number of Rows 1 Open Load Rating Business Unit 3 Sealing Type 3. 5 KN Speed Rating 5000 rpm 56408913 - BEARING SKF 6317 2 RSH Business Unit 4 965123465 - BEARING, 6001 ZZ DOUBLE STEEL SEAL, SINGLE ROW BALL. SUPPLIER: BEARING MAN. Bearing: Ball; Annular Inner Diameter 85 mm Outer Diameter 180 mm Width 41 mm Number of Rows 1 Sealing Type Open Load Rating 3. 5 KN Speed Rating 5000 rpm Bearing: Ball; An ID 85 mm OD 180 mm W 41 mm One Common Number - 12345678
In Summary From this: Largely “free text” based system: • In order to compare 2 items you would have to read the description BEARING SKF 6317 85 MM BORE 180 MM O/D 41 MM W. REF. SKF 6317 BALL BEARINGS RADIAL RIGID TO BS 292 PART 1 1982 SINGLE ROW OPEN TYPE MEDIUM SERIES WITH ACW Bearing: Ball; Annular (ESCI 0161 -1 -01 -006687) Property Description To this: Structured, Disciplined Database with: • Numeric Fields • UOM • Property Level Search Capability Value UOM Inner Diameter 85 mm Outer Diameter 180 mm Width 41 mm Number of Rows 1 Sealing Type Open Load Rating 3. 5 KN Speed Rating 5000 rpm
From This Stock Code Item Description 373620034 CONVEYOR IDLER 127 MM DIA 340 MM FACE LENTH 350 MM GUAGE LENGTH 384 MM SHAFT LENGTHBELT WIDTH 900 MM 3 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 3 RTI/127/3. 8/25/C 373620038 CONVEYOR IDLER 127 MM DIA 450 MM FACELENGTH 460 MM GUAGE LENGTH 494 MM SHAFTLENGTH BELT WIDTH 1200 MM 3 ROLLTROUGHING IDLER SERIES 25 373620438 CONVEYOR IDLER 127 MM DIA 450 MM FACE LENGTH 460 MM GUAGE LENGTH 498 MM SHAFT LENGTHBELT WIDTH 1200 MM 3 ROLL TROUGHING IDLERSERIES 30 A. C. REF NO 3 RTI 127/3. 8/30/CE 373622034 CONVEYOR IDLER 127 MM DIA 340 MM FACE LENTH 350 MM GUAGE LENGTH 384 MM SHAFT LENGTHBELT WIDTH 900 MM 3 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 3 RTI 127/4. 5/25/C 373622036 CONVEYOR IDLER 127 MM DIA 390 MM FACE LENTH 400 MM GUAGE LENGTH 434 MM SHAFT LENGTHBELT WIDTH 1050 MM 3 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 3 RTI 127/4. 5/25/C 373622038 CONVEYOR IDLER 127 MM DIA 450 MM FACE LENTH 460 MM GUAGE LENGTH 494 MM SHAFT LENGTHBELT WIDTH 1200 MM 3 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 3 RTI 127/4. 5/25/C 373620040 CONVEYOR IDLER 127 MM DIA 560 MM FACE LENGTH 570 MM GUAGE LENGTH 604 MM SHAFT LENGTHBELT WIDTH 1500 MM 3 ROLL TROUGHING IDLERSERIES 25 A. CREF. NO 3 RTI 127/3. 8/25/CE 373620133 CONVEYOR IDLER 127 MM DIA 300 MM FACELENGTH 310 MM GUAGE LENGTH 344 MM SHAFTLENGTH BELT WIDTH 1350 MM 5 ROLLTROUGHING IDLER SERIES 25 373620137 CONVEYOR IDLER 127 MM DIA 400 MM FACELENGTH 410 MM GUAGE LENGTH 444 MM SHAFTLENGTH BELT WIDTH 1800 MM 5 ROLLTROUGHING IDLER SERIES 25 373620139 CONVEYOR IDLER 127 MM DIA 536 MM FACE LENGTH 546 MM GUAGE LENGTH 580 MM SHAFT LENGTHBELT WIDTH 2400 MM 5 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 5 RTI 127/3. 8/25/CE 373620576 CONVEYOR IDLER 127 MM DIA 475 MM FACE LENGTH 485 MM GUAGE LENGTH 523 MM SHAFT LENGTHBELT WIDTH 2100 MM 5 ROLL TROUGHING IDLERSERIES 30 A. C. REF NO 5 RTI 127/3. 8/30/CE 373622134 CONVEYOR IDLER 127 MM DIA 340 MM FACE LENGTH 350 MM GUAGE LENGTH 384 MM SHAFT LENGTHBELT WIDTH 1500 MM 5 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 5 RTI 127/4/5/25/CE 373622137 CONVEYOR IDLER 127 MM DIA 400 MM FACE LENGTH 410 MM GUAGE LENGTH 444 MM SHAFT LENGTHBELT WIDTH 1800 MM 5 ROLL TORUGHING IDLERSERIES 25 A. C. REF NO 5 RTI 127/4. 5/25/CE 373622139 CONVEYOR IDLER 127 MM DIA 475 MM FACE LENTH 485 MM GUAGE LENGTH 519 MM SHAFT LENGTHBELT WIDTH 2100 MM 5 ROLL TROUGHING IDLERSERIES 25 A. C. REF NO 5 RTI 127/4. 5/25/C 373620638 CONVEYOR IDLER 127 MM DIA 840 MM FACE LENGTH 850 MM GUAGE LENGTH 956 MM SHAFT LENGTHBELT WIDTH 750 MM RETURN IDLER SERIES 30 A. C. REF NO RI 127/3. 8/30/EXCE DRW NO 373620641 CONVEYOR IDLER 127 MM DIA 994 MM FACE LENGTH 1004 MM GUAGE LENGTH 1200 MM SHAFT LENGTH BELT WIDTH 900 MM RETURN IDLER SERIES 30 A. C. REF NO RI 127/3. 8/30/EXCE DRW NO 373620642 CONVEYOR IDLER 127 MM DIA 1146 MM FACE LENGTH 1156 MM GUAGE LENGTH 1262 MM SHAFT LENGTH BELT WIDTH 1050 MM RETURN IDLER SERIES 30 A. C. REF NO RI 127/3. 8/30/EXCE DRW 373620643 CONVEYOR IDLER 127 MM DIA 1298 MM FACE LENGTH 1308 MM GUAGE LENGTH 1414 MM SHAFT LENGTH BELT WIDTH 1200 MM RETURN IDLER SERIES 30 A. C. REF NO RI 127/3. 8/30/EXCE DRW 373620329 CONVEYOR IDLER 127 MM DIA 475 MM FACE LENGTH 485 MM GUAGE LENGTH 519 MM SHAFT LENGTHBELT WIDTH 900 MM V-RETURN IDLER SERIES 25 A. C. REF NO VRI 127/3. 8/25/CE DRW NO 373620332 CONVEYOR IDLER 127 MM DIA 560 MM FACELENGTH 570 MM GUAGE LENGTH 604 MM SHAFTLENTH BELT WIDTH 1050 MM V-RETURN IDLERSERIES 25 A. C. REF VRI 127/3. 8/25/CE 373620334 CONVEYOR IDLER 127 MM DIA 635 MM FACELENGTH 645 MM GUAGELENGTH 679 MM SHAFTLENGTH BELT WIDTH 1200 MM V-RETURN IDLERSERIES 25 A. C. REF VRI 127/3. 8/25/CE 373620336 CONVEYOR IDLER 127 MM DIA 720 MM FACELENGTH 730 MM GUAGE LENGTH 764 MM SHAFTLENGTH BELT WIDTH 1350 MM V-RETURN SERIES 25 A. C. REF NO VRI 127/3. 8/25/CE 373620337 CONVEYOR IDLER 127 MM DIA 800 MM FACE LENGTH 810 MM GUAGE LENGTH 844 MM SHAFT LENGTHBELT WIDTH 1500 MM V-RETURN IDLER SERIES 25 A. C. REF NO VRI 127/3. 8/25/CE DRW NO 373620340 CONVEYOR IDLER 127 MM DIA 965 MM FACELENGTH 975 MM GUAGE LENGTH 1009 MM SHAFTLENGTH BELT WIDTH 1800 MM V-RETURN IDLERSERIES 25 A. C. REF VRI 127/3. 8/25/CE Imagine a list like this for over 200, 000 items!!!
To This Pivot Table & Data Base Drill Down Capability
Coding Detail Are two items the same, when do we have a common item? Stapler Staple Size # 16 Same Item!
Coding Detail Are two items the same, when do we have a common item? Stapler Staple Size Additional Properties # 16 Color Red/Blue Material Metal/Plastic Different Item!