際際滷

際際滷Share a Scribd company logo
Material coding
     hydro power project

The designed schema is to assign
  12 digit code to all materials


The Schema hierarchy is as follows:
Main   First two digits 00 to 99 having 42 main groups and 58
Groups blanks for future use
         Sub    Third & fourth digit constituting four digit
         Groups 0000 sub-group codes for each main group
                totaling 369 sub groups to cover all the items
                used in a hydro power plant the number of SG
                may further increase depending up on the type
                and expanse of items

                  Sub-   Fifth & sixth digit constituting six
                  Sub    digit 000000 of sub-sub-group
                  groups codes for each sub group totaling
                         2293 sub-sub groups to cover all the
                         items used in a hydro power plant the
                         number of SSG may further increase
                         depending up on the type and expanse
                         of items.
Category    Seventh & eighth digit constituting eight digit
            00000000 of category codes for each sub-sub group
            totaling 6902 categories to cover all the items used in
            a hydro power plant the number of CTGRY will
            further increase depending up on the type and
            expanse of items particularly in MG 36, 37, 46, 67,
            74, etc where technical classification remain
            common for each sub-sub group of items say gate
            valve cast steel may have many NBs in its category.

Parameters Ultimate 9th to 12th digits making twelve digit
           000000000000 item code under each category. In
           several cases even last four digits follow technical
           parameters of the items and will not be a serial
           number.
CODE             MAIN GROUP DESCRIPTION
 10    HE POWER PROJECTS
 25    WATER TREATMENT PLANT, COOLING WATER
       SYSTEM & PUMPS
 26    DREDGER, CRAFT, POLLUTION CONTROL &
       ENVIRONMENTAL MONITORING EQUIPMENT
 27    COMPRESSOR, THEIR COMPONENTS AND SPARES
 28    AIRCONDITIONING, VENTILATION, COMPONENTS,
       FANS & BLOWERS
 29    FIRE FIGHTING AND SAFETY EQUIPMENT, DAMAGE
       CONTROL SYSTEM
 36    PIPE TUBES HOSE & CONDUITS WITH THEIR
       FITTINGS
 37    VALVES, COCKS & THEIR SPARES
 40    GASKET OIL SEAL AND ADHESIVE
 44    HAND TOOLS, CUTTING TOOLS, WORK SHOP ITEMS
       WITH ACCESSORIES, GRINDERS
 46    WELDING, GAS CUTTING, BRAZING EQUIPMENT
47   MECHANICAL POWER TRANSMISSION ITEMS
48   FASTENERS
49   BEARINGS, BUSHES, PLUMMER BLOCKS & THEIR SPARES
51   EOT CRANES, HOIST, RIGGING MATERIAL, ROPES, LIFTS &
     ELEVATORS
52   WEIGHBRIDGES, WEIGHING SCALES & WEIGHING DEVICES
     INCLUDING LOAD CELLS
56   POL & DEVICE
57   INDUSTRIAL CHEMICALS, LABORATORY CHEMICALS & ITEMS
61   ELECTRICAL INSULATION ITEMS, THERMAL, ACOUSTIC
     INSULATION, REFRACTORY,
63   ELECTRICAL MEASURING METERS, INSTRUMENTS, TESTING
     EQUIPMENT
65   CABLES, INSULATED WIRES, INSTALLATION ACCESSORIES
66   TRANSMISSION, DISTRIBUTION, LINE TOWER AND SUBSTATION
67   POWER PROTECTION ITEMS, VIZ POWER SUPPLY, SWITCH
     GEAR, LIGHTNING ARRESTER
68   TRANSFORMERS (EHT, HT, LT, CT, PT, CVT & INSTRUMENT),
     REACTORS AND POWER CAPACITORS
71   D.G. SETS, DYNAMO AND AC/DC CONVERTER
72   ALL MOTORS, SPARES, STARTERS, CARBON BRUSHES
73   DC POWER SOURCE & BATTERY, CHARGER, CELLS
74   CONTROL INSTRUMENTATION
75   LAMPS AND LUMINAIRE WITH FITTINGS
80   STRUCTURALCONSTRUCTIONAL STEEL & ALLOY STEEL,
     BARBED WIRES, STEEL WIRE NETS, FENCING MATERIAL
81   ALUMINIUM, NON FERROUS, POLYMER & OTHER NON
     METALLIC SECTIONS
82   CIVIL CONSTRUCTION EQUIP, BUILDING MATERIAL
83   SANITARY TOILET FITTINGS AND SEWAGE FACILITIES,
     DRAINAGE
84   SURFACE PREPARATION ITEMS, PAINTS, COATINGS,
     DISPENSING EQUIPMENT
85   WOOD, TIMBER, PLYWOOD SECTIONS, DOORS, WINDOW AND
     FITTINGS
88   METALLIC, WOODEN, GLASS AND PLASTIC FURNITURE AND
     FITTINGS
91 COMPUTER AND ACCESSORIES
92 OFFICE EQUIPMENT & STATIONARY ITEMS
93 COMMUNICATION SYSTEM, TELEPHONE, WIRELESS INCLUDING
   SATELLITE COMMUNICATION
94 HOUSE KEEPING ITEMS, FOOD STUFF, GARDENING, TREE
   PLANTATION & ALLIED ITEMS
95 KITCHEN APPLIANCES, ACCOMMODATION/COMFORT,
   LAUNDRY EQUIPMENT, SPORTS & MUSICAL ITEMS. FLOOR
   COVERING CARPETS, MATTRESS,DOOR MATS, CANVAS &
   WATER PROOF MATERIAL FURNISHING MATERIAL , BEDDING
   MATERIAL, CURTAIN, DRESS, UNIFORM AND CLOTHING,
   UPHOLSTERY, LINEN, ETC

98 HMV, LV, MULTIPURPOSE VEHICLES, AMBULANCE, PICK-UP
   VANES, CARS, MOTOR CYCLE, SCOOTER, CYCLE
Ad

Recommended

CV RKG-RKHCPVTL 28-11-12
CV RKG-RKHCPVTL 28-11-12
Ranjit Kumar Ghose
Coding in material management
Coding in material management
Dinesh Nikam
Store management & Codification
Store management & Codification
Varun Venugopalan
e-Waste Management in Electronics industry (IWM group presentation ME-2).pptx
e-Waste Management in Electronics industry (IWM group presentation ME-2).pptx
ssuser02fa7e
14. introduction to supply chains presentation
14. introduction to supply chains presentation
CREA Inc.
Kohler Power Systems Corporate Presentation
Kohler Power Systems Corporate Presentation
Md.Nurun Nobi Raju
WSS Group & AEL Aberdeen
WSS Group & AEL Aberdeen
Dina Izteleuova
Technical textile in industerial sector
Technical textile in industerial sector
Afzal Rana
Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Copperberg
Building services -
Building services -
Rami Reddy
Smart Grid Innovation, Interoperability, and Standards Management
Smart Grid Innovation, Interoperability, and Standards Management
IHS
Diary Report
Diary Report
Chong Chin Pin
Industrial Dep.
Industrial Dep.
nixmed
B service
B service
Teh Yang
Introduction to the IEC and its Smart Grid initiative
Introduction to the IEC and its Smart Grid initiative
International Electrotechnical Commission (IEC)
Material handling
Material handling
Nishant Agrawal
Building Services Project 2 Diary
Building Services Project 2 Diary
Nekumi Kida
Introduction To Building Services
Introduction To Building Services
M. Arkam C. Munaaim Adj. Prof, PhD, PEPC, IntPE.
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
PradiprajChatti
Eco Design
Eco Design
BSI British Standards Institution
Odyssey 09 08-11
Odyssey 09 08-11
vicjrme49
2 logistics
2 logistics
Rishi Mathur
Elektro Tipp Jan 2010
Elektro Tipp Jan 2010
Rajesh Rajan
Pavilion public toilet and store rooms at open space for pak shek kok
Pavilion public toilet and store rooms at open space for pak shek kok
bumatech
parts tree
parts tree
saeid teymoori
Hands Group Corporation G5 S Activities
Hands Group Corporation G5 S Activities
RATAHGO
Open Source Ecology at Open Knowledge Conference 2011
Open Source Ecology at Open Knowledge Conference 2011
nikolayhg
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
IndiaMART InterMESH Limited

More Related Content

Similar to Material coding schema (20)

Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Copperberg
Building services -
Building services -
Rami Reddy
Smart Grid Innovation, Interoperability, and Standards Management
Smart Grid Innovation, Interoperability, and Standards Management
IHS
Diary Report
Diary Report
Chong Chin Pin
Industrial Dep.
Industrial Dep.
nixmed
B service
B service
Teh Yang
Introduction to the IEC and its Smart Grid initiative
Introduction to the IEC and its Smart Grid initiative
International Electrotechnical Commission (IEC)
Material handling
Material handling
Nishant Agrawal
Building Services Project 2 Diary
Building Services Project 2 Diary
Nekumi Kida
Introduction To Building Services
Introduction To Building Services
M. Arkam C. Munaaim Adj. Prof, PhD, PEPC, IntPE.
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
PradiprajChatti
Eco Design
Eco Design
BSI British Standards Institution
Odyssey 09 08-11
Odyssey 09 08-11
vicjrme49
2 logistics
2 logistics
Rishi Mathur
Elektro Tipp Jan 2010
Elektro Tipp Jan 2010
Rajesh Rajan
Pavilion public toilet and store rooms at open space for pak shek kok
Pavilion public toilet and store rooms at open space for pak shek kok
bumatech
parts tree
parts tree
saeid teymoori
Hands Group Corporation G5 S Activities
Hands Group Corporation G5 S Activities
RATAHGO
Open Source Ecology at Open Knowledge Conference 2011
Open Source Ecology at Open Knowledge Conference 2011
nikolayhg
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
IndiaMART InterMESH Limited
Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Sune S淡rensen, GGP Group presentation at Spare Parts 2013
Copperberg
Building services -
Building services -
Rami Reddy
Smart Grid Innovation, Interoperability, and Standards Management
Smart Grid Innovation, Interoperability, and Standards Management
IHS
Industrial Dep.
Industrial Dep.
nixmed
B service
B service
Teh Yang
Building Services Project 2 Diary
Building Services Project 2 Diary
Nekumi Kida
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
guidelines_GUIDELINES FOR DISTRIBUTION UTILITIES FOR DEVELOPMENT OF DISTRIBUT...
PradiprajChatti
Odyssey 09 08-11
Odyssey 09 08-11
vicjrme49
Elektro Tipp Jan 2010
Elektro Tipp Jan 2010
Rajesh Rajan
Pavilion public toilet and store rooms at open space for pak shek kok
Pavilion public toilet and store rooms at open space for pak shek kok
bumatech
Hands Group Corporation G5 S Activities
Hands Group Corporation G5 S Activities
RATAHGO
Open Source Ecology at Open Knowledge Conference 2011
Open Source Ecology at Open Knowledge Conference 2011
nikolayhg
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
Silverline Metal Engineering Private Limited, Navi Mumbai, Fabricated Machine...
IndiaMART InterMESH Limited

Material coding schema

  • 1. Material coding hydro power project The designed schema is to assign 12 digit code to all materials The Schema hierarchy is as follows:
  • 2. Main First two digits 00 to 99 having 42 main groups and 58 Groups blanks for future use Sub Third & fourth digit constituting four digit Groups 0000 sub-group codes for each main group totaling 369 sub groups to cover all the items used in a hydro power plant the number of SG may further increase depending up on the type and expanse of items Sub- Fifth & sixth digit constituting six Sub digit 000000 of sub-sub-group groups codes for each sub group totaling 2293 sub-sub groups to cover all the items used in a hydro power plant the number of SSG may further increase depending up on the type and expanse of items.
  • 3. Category Seventh & eighth digit constituting eight digit 00000000 of category codes for each sub-sub group totaling 6902 categories to cover all the items used in a hydro power plant the number of CTGRY will further increase depending up on the type and expanse of items particularly in MG 36, 37, 46, 67, 74, etc where technical classification remain common for each sub-sub group of items say gate valve cast steel may have many NBs in its category. Parameters Ultimate 9th to 12th digits making twelve digit 000000000000 item code under each category. In several cases even last four digits follow technical parameters of the items and will not be a serial number.
  • 4. CODE MAIN GROUP DESCRIPTION 10 HE POWER PROJECTS 25 WATER TREATMENT PLANT, COOLING WATER SYSTEM & PUMPS 26 DREDGER, CRAFT, POLLUTION CONTROL & ENVIRONMENTAL MONITORING EQUIPMENT 27 COMPRESSOR, THEIR COMPONENTS AND SPARES 28 AIRCONDITIONING, VENTILATION, COMPONENTS, FANS & BLOWERS 29 FIRE FIGHTING AND SAFETY EQUIPMENT, DAMAGE CONTROL SYSTEM 36 PIPE TUBES HOSE & CONDUITS WITH THEIR FITTINGS 37 VALVES, COCKS & THEIR SPARES 40 GASKET OIL SEAL AND ADHESIVE 44 HAND TOOLS, CUTTING TOOLS, WORK SHOP ITEMS WITH ACCESSORIES, GRINDERS 46 WELDING, GAS CUTTING, BRAZING EQUIPMENT
  • 5. 47 MECHANICAL POWER TRANSMISSION ITEMS 48 FASTENERS 49 BEARINGS, BUSHES, PLUMMER BLOCKS & THEIR SPARES 51 EOT CRANES, HOIST, RIGGING MATERIAL, ROPES, LIFTS & ELEVATORS 52 WEIGHBRIDGES, WEIGHING SCALES & WEIGHING DEVICES INCLUDING LOAD CELLS 56 POL & DEVICE 57 INDUSTRIAL CHEMICALS, LABORATORY CHEMICALS & ITEMS 61 ELECTRICAL INSULATION ITEMS, THERMAL, ACOUSTIC INSULATION, REFRACTORY, 63 ELECTRICAL MEASURING METERS, INSTRUMENTS, TESTING EQUIPMENT 65 CABLES, INSULATED WIRES, INSTALLATION ACCESSORIES 66 TRANSMISSION, DISTRIBUTION, LINE TOWER AND SUBSTATION 67 POWER PROTECTION ITEMS, VIZ POWER SUPPLY, SWITCH GEAR, LIGHTNING ARRESTER 68 TRANSFORMERS (EHT, HT, LT, CT, PT, CVT & INSTRUMENT), REACTORS AND POWER CAPACITORS
  • 6. 71 D.G. SETS, DYNAMO AND AC/DC CONVERTER 72 ALL MOTORS, SPARES, STARTERS, CARBON BRUSHES 73 DC POWER SOURCE & BATTERY, CHARGER, CELLS 74 CONTROL INSTRUMENTATION 75 LAMPS AND LUMINAIRE WITH FITTINGS 80 STRUCTURALCONSTRUCTIONAL STEEL & ALLOY STEEL, BARBED WIRES, STEEL WIRE NETS, FENCING MATERIAL 81 ALUMINIUM, NON FERROUS, POLYMER & OTHER NON METALLIC SECTIONS 82 CIVIL CONSTRUCTION EQUIP, BUILDING MATERIAL 83 SANITARY TOILET FITTINGS AND SEWAGE FACILITIES, DRAINAGE 84 SURFACE PREPARATION ITEMS, PAINTS, COATINGS, DISPENSING EQUIPMENT 85 WOOD, TIMBER, PLYWOOD SECTIONS, DOORS, WINDOW AND FITTINGS 88 METALLIC, WOODEN, GLASS AND PLASTIC FURNITURE AND FITTINGS
  • 7. 91 COMPUTER AND ACCESSORIES 92 OFFICE EQUIPMENT & STATIONARY ITEMS 93 COMMUNICATION SYSTEM, TELEPHONE, WIRELESS INCLUDING SATELLITE COMMUNICATION 94 HOUSE KEEPING ITEMS, FOOD STUFF, GARDENING, TREE PLANTATION & ALLIED ITEMS 95 KITCHEN APPLIANCES, ACCOMMODATION/COMFORT, LAUNDRY EQUIPMENT, SPORTS & MUSICAL ITEMS. FLOOR COVERING CARPETS, MATTRESS,DOOR MATS, CANVAS & WATER PROOF MATERIAL FURNISHING MATERIAL , BEDDING MATERIAL, CURTAIN, DRESS, UNIFORM AND CLOTHING, UPHOLSTERY, LINEN, ETC 98 HMV, LV, MULTIPURPOSE VEHICLES, AMBULANCE, PICK-UP VANES, CARS, MOTOR CYCLE, SCOOTER, CYCLE