1 / 51

API/CIMIS UN/SPSC

API/CIMIS UN/SPSC. DATA CONTENT. S imple D efinition of the E -commerce C ontent P roblem. 1. A fundamental requirement for any successful economic system is a common currency of trade. 2. The currency of trade between computer systems is data!

zarola
Download Presentation

API/CIMIS UN/SPSC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. API/CIMISUN/SPSC DATA CONTENT

  2. Simple Definition of the E-commerce ContentProblem 1. A fundamental requirement for any successful economic system is a common currency of trade. 2. The currency of trade between computer systems is data! 3. Existing data standards do not address a common content currency at the object level. 4. Therefore, the exchange of non-numeric data continues to be the single largest hurdle to effective electronic commerce.

  3. Variability of Descriptive Content PART NUMBERDESCRIPTION 56-549852-02 6 INCH STD LR 90DEG ELBOW A234 ELL-308756-CS ELBOW, CS, LONG RADIUS BUTTWELDING, 90 DEGREE, ASTM A234, ASME SA234, ANSI B16.9 619-EL284977 6” LR SCHEDULE 40 BW ELBOW, 90 DEG ASTM/ASME A/SA234 07-88-34496 ELL BUTTWELD, 6 IN 90 DEGREE LONG RAD. , 0.280 WALL (SCHEDULE 40 OR STD) 936318836 6 IN STD LR 90 BW ELL 37BW433-002 ELBOW, 90 DEGREE CARBON STEEL, LONG RADIUS BUTTWELD, 37-1/2 DEG BEVEL, BLACK, ASTM A105 876-566-EL 90 DEG ELL, BW, CS, 6” X STD, A234

  4. Inter-Company Communication ANSI X12 ANSI X12 COMPANY A (BUYER) COMPANY B (SELLER)

  5. CONTENT LINK FOR X12 PROCESSES BUYER TRANS SELLER

  6. CONTENT LINK FOR X12 PROCESSES Translator ABC=123 DEF=345 GHI=678

  7. Part Number TranslationTable 16000086 9914 16000086 68-16000086 16000086 70-16000086 16000086 9503020605 16000086 49421 P06 16000086 7-1272 16000086 4289030 16000086 33040400 16000086 67-16000086 16000086 4250120 16000086 33-STL-0142 16000086 668227010157 16000086 4212812 16000086 325984 16000086 62 E40 10151 16000086 4212809 16000086 3154452 16000086 60875183 16000086 4212709 16000086 313318 16000086 60805249 16000086 42-22-739 16000086 3126122 16000086 60000459 16000086 4192333 16000086 302983 16000086 59-16000086 16000086 41-16000086 16000086 91104901 16000086 58302268 16000086 4054000 16000086 9110000645 16000086 558870 16000086 4042281150 16000086 910570 16000086 55250601 16000086 39337 16000086 903634C1 16000086 54-25-1350 16000086 380103090 16000086 80854600737 16000086 517046 16000086 380/02/ 16000086 80854600737 16000086 51-298-030 16000086 6029070 16000086 8003320S184 16000086 5007601 16000086 35797500 16000086 7300-003-01 16000086 500334 16000086 3360690 16000086 72200235 9 16000086 500A8A016X04

  8. Inter-Company Communication COMPANY A COMPANY 001 (1000) (1000) COMPANY 002 XREF TABLE (1000) COMPANY 003 (1,000,000) (1000) COMPANY 004 (1000) COMPANY 1000

  9. Matrix Communication E=C ENG/DESIGN CONSTRUCTION E=F C=F C=D FABRICATION DISTRIBUTION F=D F=M D=M MANUFACTURING

  10. Matrix Communications with Standard ENG/DESIGN CONSTRUCTION E=X C=X X FABRICATION DISTRIBUTION F=X D=X MANUFACTURING M=X

  11. Electronic Synergy Between Buyer/Seller 85,000 Items 250,000 Items BUYER SELLER 1500 Items

  12. MATURE MATRIX IS COMPLEX/LIMITED M M S M M BUYER S S M M S M M

  13. TRADITIONAL PURCHASING FLOW USER PO REQ PURCHASING PLANNER B/M SELLER

  14. EMPOWERMENT OF THE USER USER ITEM MASTER SELLER ERP SYSTEM PURCHASING CONTRACT

  15. STOCK VERSUS BUYOUT USER ERP SYSTEM PHONE IN STOCK? SELLER N FAX INTERNET Y

  16. WHAT DOES THE USER NEED TO KNOW? USER WHAT DO I NEED? WHICH SUPPLIER HAS IT? WHERE IS IT LOCATED? WHEN CAN I GET IT? WHAT IS THE COST?

  17. TODAY’S INTERNET SHOPPING SOLUTION CAT USER SELLER1 CAT SELLER2 CAT SELLER3

  18. PROPOSED INTERNET SOURCING SOLUTION CONTENT STANDARD CAT1 USER CAT2 XML TAG CAT3 RESULT

  19. Ratio of Generic to Proprietary Components

  20. Proprietary vs. Generic Products Proprietary Products: The object is unique to a given manufacturer by preference or design. Examples: 1. Can of DIET COKE 2. PUMP SHAFT for a specific model pump 3. CAM SHAFT for a specific v12 sports car engine Generic Products: The object is manufactured by multiple manufacturers based on some standard design criteria or market requirement. Examples: 1. 1/4 x 1 SAE machine bolt 2. Ream of 3 hole punched lined notebook paper 3. Joint of API-5CT oil field casing

  21. Common Industry Material Identification Standards(CIMIS)

  22. CIMISExpert Process Typical Expert Group Composition Interested parties from industry supply chain from Point of manufacture to point of consumption (1) CIMIS Facilitator (2) Manufacturing (2) Distribution (2) Fabrication (2) Engineering/Design/Construction (2) Owner/Operators

  23. Format Group - CS/SSPipe MANUFACTURER AVESTA-SHEFFIELD UNITED KINGDOM MANUFACTURER BRISTOL METALS UNITED STATES MANUFACTURER MANNESMANN WEST GERMANY MANUFACTURER USX UNITED STATES DISTRIBUTOR MCJUNKIN UNITED STATES DISTRIBUTOR R..J. GALLAGER UNITED STATES DISTRIBUTOR RED MAN PIPE & SUPPLY UNITED STATES DISTRIBUTOR TUBE SALES UNITED STATES DISTRIBUTOR VAN LEEUWEN NETHERLANDS FABRICATOR INTERPRO FABRICATORS UNITED STATES FABRICATOR MIDSTATES PIPE FABRICATING UNITED STATES FABRICATOR THE SHAW GROUP UNITED STATES FABRICATOR WORD INDUSTRIES UNITED STATES DESIGN/CONSTRUCTION FLUOR DANIEL UNITED STATES DESIGN/CONSTRUCTION J.A. JONES UNITED STATES DESIGN/CONSTRUCTION S & B ENGINEERS UNITED STATES OWNER/OPERATOR AIR PRODUCTS & CHEMICALS UNITED STATES OWNER/OPERATOR AMOCO UNITED STATES OWNER/OPERATOR E.I. DUPONT UNITED STATES OWNER/OPERATOR SHELL OIL COMPANY NETHERLANDS

  24. Create Associations Create Linked Data Build Attributes and Values Expert Development Tool Expert Development Process Spreadsheet Data Format Development Team CIMIS Data Base

  25. Attributed Content / CIMISI.D. SIZE 1/2 3/4 1 1-1/4 1-1/2 2 2-1/2 3 4 5 6 7 8 10 12 14 16 MTRL CS T304SS T316SS T304ELC T316ELC T317ELC T321SS FINISH Black Galv Bare RATING STD XH XXH SCH10 SCH20 SCH30 SCH40 SCH60 SCH80 SCH100 SCH120 SCH140 SCH160 CONFIG LR 90 Deg SR 90 Deg LR 45 Deg END PREP STD BEV PE SC SPEC A234 COMPONENT Elbow, BW Pipe CIMIS CODE = 66xxxxxxxxxx

  26. UN/SPSC 1. Segment <40> (Distribution and Conditioning Systems) 2. Family <14> (Fluid and Gas Distribution) 3. Class <16> (Valves) 4. Commodity <13> (Gate Valves) 5. Function <XX> (Construction, MRO, Lease, etc.)

  27. UN/SPSC 1. Functions as a financial classification system. 2. Evolved from D&B company profile data. 3. Mixes Form with Function. 4. Envisions secondary tables to define common attributes for objects. 5. Is gaining wide acceptance. 6. Needs significant modification to enhance clarity of definition.

  28. CURRENT ENDEAVOR TO EXPAND UN/SPSC UN/SPSC SECONDARY TABLE OBJECT (NOUN) TYPE (MODIFIER) MATERIAL SIZE RATING END PREPARATION 40141718

  29. PIDX UN/SPSC ATTRIBUTE TASK GROUP API USERS PIDX PORTALS CIMIS CONTENT PROVIDERS TASK GROUP ELECTRONIC COMMERCE CODE MAMAGEMENT ASSOCIATION (ECCMA)

  30. BASIC PROCESS 1 USER 1 DATABASE USER 2 DATABASE USER 3 DATABASE USER 4 DATABASE ATTRIBUTE SETS ATTRIBUTE SETS ATTRIBUTE SETS ATTRIBUTE SETS AGGREGATE

  31. BASIC PROCESS 2 SELECT NOUN/MODIFIER PAIR NORMALIZE ATTRIBUTES RECEIVED CREATE AND DISTIBUTE BALLOT TASK GROUP MEMBERS TALLEY BALLOTS VOTE MANDATORY OR SUPPLIMENTAL

  32. BASIC PROCESS 3 MANDATORY ATTRIBUTES NOUN/MODIFIER FORMAT ECCMA API/PIDX DATABASE UN/SPSC DATABASE MANDATORY ATTRIBUTES SUPLIMENTAL ATTRIBUTES ATTRIBUTE DEFINITIONS

  33. MANDATORY VERSUS SUPPLIMENTAL Mandatory Attributes:A minimal set of attributes needed to enable buyers and sellers to search and find products or services. Example: NOUNMODIFIERMATERIALSIZERATINGEND PREPARATION VALVE GATE CARBON STEEL 6 150# FLANGED Supplemental Attributes: Secondary attributes that enhance the Mandatory Attributes and provide a means of differentiation. Example: TRIMPACKINGBONNET GASKETOPERATOR API 8 GRAPHITE CORREGATED METAL HANDWHEEL

  34. EXAMPLE OF UN/SPSC RESULT 40 = Distribution and Conditioning Systems and Equipment and Components 14 = Fluid and gas distribution 16 = Valves 13 = Gate valves 40141613 4014161300 ATTRIBUTE TABLE OBJECTTYPEMATERIALSIZERATINGEND PREPARATION

  35. EXAMPLE OF API/PIDX RESULT 40 = Distribution and Conditioning Systems and Equipment and Components 14 = Fluid and gas distribution 16 = Valves 13 = Gate valves 40141613 4014161300 MANDATORYATTRIBUTE TABLE OBJECTTYPEMATERIALSIZERATINGEND PREPARATION 4014161300 SUPPLEMENTAL ATTRIBUTE TABLE TRIMPACKINGBONNET GASKETOPERATOR 4014161300 ATTRIBUTE LABEL DEFINITION TABLE

  36. TODAY’S ENVIRONMENT PORTAL 1 CONTENT PORTAL 1 DISTR 1 USER 1 PORTAL 2 CONTENT PORTAL 2 DISTR 2 USER 2 PORTAL 3 CONTENT PORTAL 3 DISTR 3 USER 3

  37. TOMORROW’S ENVIRONMENT PORTAL 1 CONTENT PORTAL 1 USER 1 DISTR 1 UN/SPSC ATTRIBUTES PORTAL 2 CONTENT PORTAL 2 USER 2 DISTR 2 PORTAL 3 CONTENT PORTAL 3 USER 3 DISTR 3

  38. XML EQUIVALENT <search key> <object> valve <object> <type> gate <type> <material> a216 wcb <material> <size> 6 <size> <rating> 150# <rating> <end preparation> flanged <end preparation> <search key>

  39. SO WHERE ARE WE NOW? UN/SPSC CODES CIMIS ECCMA FORMAT COMMITTEES TASK GROUP CIMIS DATABASE ATTRIBUTE TABLES NATIVE DATABASES NATIONAL STANDARDS POPULATED DATA FORMAT ONLY

  40. WHERE CAN WE GO FROM HERE? UN/SPSC CODES CIMIS ECCMA FORMAT COMMITTEES TASK GROUP CIMIS DATABASE ATTRIBUTE TABLES NATIVE DATABASES NATIONAL STANDARDS POPULATED DATA W/UNSPSC FORMAT ONLY

  41. WHERE ELSE CAN WE GO FROM HERE? UN/SPSC ATTRIBUTE TABLES CIMIS FORMAT MFG 1 MFG 2 MFG 3 DATA DICTIONARY CIMIS DATABASE

  42. EXAMPLE OF COLLABORATIVE AGGREGATION UN/SPSCNOUNMODIFIERMATERIALSIZERATINGEND PREPMFGFIGURE# 40141613 VALVE GATE A216 WCB 6 150# FLANGED POWELL 1503 40141613 VALVE GATE A216 WCB 6 150# FLANGED WALWORTH 5202F 40141613 VALVE GATE A216 WCB 6 150# FLANGED KITZ 150SCL 40141613 VALVE GATE A216 WCB 6 150# FLANGED DSI CS150F

  43. WHY GO THERE? • THE INDUSTRY NEEDS STANDARDIZED SEARCH CONTENT TO EMPLOY CURRENT TECHNOLOGY. • THE UN/SPSC TABLES WILL PROVIDE A UNIFORM TEMPLATE TO POPULATE THE REQUISITE DATA. • THE MANUFACTURING SECTOR HAS THE REQUISITE DATA IMMEDIATELY AVAILABLE. • THE APPROACH IS PRACTICAL AND COST EFFECTIVE.

  44. WHAT THE END USER SEES PARAMETRIC SEARCH ENGINE IN PLAIN ENGLISH NOUNMODIFIERMATERIALSIZERATINGEND PREPARATION VALVEGATEA216 WCB 2 150#FLANGED GLOBE A217 C5 3 300# BUTTWELD CHECK 4 600# 6 900# 8 1500# 10 2500# 12

  45. RECEIVING COMPUTER SEES XML SEARCH STRING <search key> <object> valve <object> <type> gate <type> <material> a216 wcb <material> <size> 2 <size> <rating> 150# <rating> <end preparation> flanged <end preparation> <search key>

  46. PROBLEM OF STANDARDIZING VALUES POSSIBLE INPUTS FOR ATTRIBUTE = SIZE 2 INCH INPUT 1 = 2 INPUT 2 = 2 INCH INPUT 3 = 2 IN INPUT 4 = 2” INPUT 5 = 2.0

  47. PROPOSED CIMIS SEARCH KEYS DATA DICTIONARY MANUFACTURER INPUT UN/SPSC FORMAT CIMIS UN/SPSCNOUNMODIFIERMATERIALSIZERATINGEND PREPMFGFIG# 40141613 VALVE GATE A216 WCB 6 150# FLANGED POWELL 1503 UN/SPSCNOUNMODIFIERMATERIALSIZERATINGEND PREP 40141613 VALVE GATE A216 WCB 6 150# FLANGED = SK123456789012 CIMIS DATABASE SUPPLY CHANNEL

  48. RECEIVING COMPUTER SEES XML SEARCH STRING <search key> SK123456789012 <search key> OTHER POSSIBLE FILTERS XML VENDOR STRING <vendor> (vendor id) <vendor> XML GEOGRAPHIC STRING <region> (geographic id) <region>

  49. SUMMARY OF CODE DEFINITIONS CODE AUTHORITYUSAGE UN/SPSC FINANCIAL CLASSIFICATION CIMIS CODE COMMODITY DEFINITION CIMIS SEARCH KEY PROPRIETARY PRODUCT SEARCH UPC/EAN (BEST PRACTICE) PROPRIETARY PRODUCT ID VENDOR PART# PROPRIETARY PRODUCT ID

  50. NOTHING HAPPENS UNTIL WE LINK THE BUYER TO THE SELLER! BUYER SELLER BUYER CONTNENT STANDARDS SELLER BUYER SELLER BUYER SELLER

More Related