Mandatory Sheets for Import of Smart 3D Specification - Intergraph Smart Reference Data - Version 10.0 - Training - Hexagon

The following are minimum mandatory sheets and the corresponding columns, required for importing a Smart 3D specification to Smart Reference Data:

1. FluidCode

   1. FluidSystem ShortDescription

   2. FluidCode ShortDescription

   3. Codelist Number

2. DesignStandards

   1. DesignStandardPractice ShortDescription

   2. DesignStandard ShortDescription

   3. CodeList Number

3. Examination

   1. ExaminationPractice ShortDescription

   2. Examination ShortDescription

   3. Codelist Number

4. PressureRating

   1. RatingPractice ShortDescription

   2. PressureRating ShortDescription

   3. Codelist Number

5. MaterialsType

   1. MaterialsGroup ShortDesciption

   2. MaterialsType ShortDesciption

   3. CodeList Number

6. StressRelief

   1. StressReliefPractice ShortDescription

   2. StressRelief ShortDescription

   3. Codelist Number

7. StressReliefRequirement

   1. StressReliefRequirement ShortDescription

   2. Codelist Number

8. CorrosionAllowance

   1. SpecName

   2. CorrosionAllowance

9. WasherCreationOption

   1. WasherCreationOption ShortDescription

   2. Codelist Number

10. PipingCommodityType

    1. PipingCommodityClass ShortDescription

    2. PipingCommoditySubClass ShortDescription

    3. PipingCommodityType ShortDescription

    4. Codelist Number

11. GasketType

    1. GasketCategory ShortDescription

    2. GasketType ShortDescription

    3. Codelist Number

12. BoltType

    1. BoltType ShortDescription

    2. Codelist Number

13. NutType

    1. NutType ShortDescription

    2. Codelist Number

14. WasherType

    1. WasherType ShortDescription

    2. Codelist Number

15. PipingMaterialsClassData

    1. SpecName

    2. RevisionNumber

    3. MaterialsDescription

    4. FluidService

    5. DesignStandard

    6. WasherCreationOption

    7. StressRelief

    8. StressReliefRequirement

    9. MaterialsGroup

    10. MaterialsType

16. ServiceLimits

    1. Specname

    2. RevisionNumber

    3. Temperature

    4. Pressure

17. PipingCommodityFilter

    1. SpecName

    2. ShortCode

    3. OptionCode

    4. FirstSizeFrom

    5. FirstSizeTo

    6. FirstSizeUnits

    7. SecondSizeFrom

    8. SecondSizeTo

    9. SecondSizeUnits

    10. CommodityCode

    11. FirstSizeSchedule

    12. SecondSizeSchedule

    13. SelectionBasis

    14. EngineeringTag

18. GasketSelectionFilter

    1. SpecName

    2. RevisionNumber

    3. NominalDiameterFrom

    4. NominalDiameterTo

    5. NpdUnitType

    6. GasketOption

    7. EndPreparation

    8. PressureRating

    9. EndStandard

    10. FluidCode

    11. ScheduleThickness

    12. ContractorCommodityCode

19. BoltSelectionFilter

    1. SpecName

    2. RevisionNumber

    3. NominalDiameterFrom

    4. NominalDiameterTo

    5. NpdUnitType

    6. BoltOption

    7. ContractorCommodityCode

20. NutSelectionFilter

    1. SpecName

    2. RevisionNumber

    3. NutOption

    4. BoltType

    5. BoltDiameter

    6. ContractorCommodityCode

21. WasherSelectionFilter

    1. SpecName

    2. RevisionNumber

    3. WasherOption

    4. BoltDiameter

    5. ContractorCommodityCode

22. PipingCommodityMatlControlData

    1. ContractorCommodityCode

    2. ShortMaterialDescription

    3. LongMaterialDescription

23. PipeNominalDiameters

    1. SpecName

    2. RevisionNumber

    3. Npd

    4. NpdUnitType

24. ShortCodeHierarchyRule

    1. ShortCodeHierarchyType

    2. ShortCode

25. CommodityOption

    1. OptionCategory ShortDescription

    2. CommodityOption ShortDescription

    3. Codelist Number

26. GasketOption

    1. GasketOption ShortDescription

    2. Codelist Number

27. BoltOption

    1. BoltOption ShortDescription

    2. Codelist Number

28. WasherOption

    1. WasherOption ShortDescription

    2. Codelist Number

29. NutOption

    1. NutOption ShortDescription

    2. Codelist Number

30. SelectionBasis

    1. SelectionBasis ShortDescription

    2. Codelist

31. ScheduleThickness

    1. ScheduleThicknessPractice ShortDescription

    2. ScheduleThickness ShortDescription

    3. CodeList Number

32. PipeStock

    1. IndustryCommodityCode

    2. CommodityType

    3. ScheduleThickness[1]

    4. ScheduleThickness[2]

    5. Npd[1]:Primary

    6. NpdUnitType[1]

    7. Npd[2]:Secondary

    8. NpdUnitType[2]

    9. EndPreparation[1]

    10. EndPreparation[2]

33. EndPreparation

    1. TerminationClass ShortDescription

    2. TerminationSubClass ShortDescription

    3. EndPreparation ShortDescription

    4. Codelist Number

34. NotePurpose

    1. ShortDescription

    2. Codelist Number

35. StandardNoteData

    1. Name

    2. Purpose

    3. Description

36. PipeBranch

    1. SpecName

    2. RevisionNumber

    3. HeaderSize

    4. BranchSize

    5. AngleLow

    6. AngleHigh

    7. HdrSizeNPDUnitType

    8. BrSizeNPDUnitType

    9. ShortCode

For PartClass (except Pipestock)

1. IndustryCommodityCode

2. CommodityType

3. GeometryType

4. MaterialGrade

5. GeometricIndustryStandard

6. PressureRating[1]

7. EndPreparation[1]

8. EndStandard[1]

9. ScheduleThickness[1]

10. PressureRating[2]

11. EndPreparation[2]

12. EndStandard[2]

13. ScheduleThickness[2]

14. Npd[1]

15. NpdUnitType[1]

16. Npd[2]

17. NpdUnitType[2]

18. Dimensional Attributes as required such as FacetoFace, Width Etc

For Gaskets

1. GasketPartData

   1. IndustryCommodityCode

   2. NominalDiameterFrom

   3. NominalDiameterTo

   4. NpdUnitType

   5. GasketType

For Washer

1. WasherPartData

   1. IndustryCommodityCode

   2. WasherType

   3. MaterialsGrade

   4. WasherThickness

For Bolt

1. BoltPartData

   1. IndustryCommodityCode

   2. BoltType

   3. MaterialsGrade

For Nut

1. NutPartData

   1. IndustryCommodityCode

   2. NutType

   3. MaterialsGrade

   4. NutHeight

Common sheets required for Part Data

1. GeometryType

   1. Codelist Number

   2. GeometryType ShortDescription

2. GeometricIndustryStandard

   1. GeometricIndustryPractice ShortDescription

   2. GeometricIndustryStandard ShortDescription

   3. Codelist Number

3. MaterialGrade

   1. MaterialsGradePractice ShortDescription

   2. MaterialsCategory ShortDescription

   3. MaterialsGrade ShortDescription

   4. Codelist Number

4. EndStandard

   1. EndPractice ShortDescription

   2. EndStandard ShortDescription

   3. Codelist Number

If you want to use rule based assisted mapping then load all codelist sheets and corresponding Industry Commodity Code Rule sheets that are mentioned in Formats sheet (Industry Commodity Code Rule workbook).