The following are minimum mandatory sheets and the corresponding columns, required for importing a Smart 3D specification to Smart Reference Data:
-
FluidCode
-
FluidSystem ShortDescription
-
FluidCode ShortDescription
-
Codelist Number
-
-
DesignStandards
-
DesignStandardPractice ShortDescription
-
DesignStandard ShortDescription
-
CodeList Number
-
-
Examination
-
ExaminationPractice ShortDescription
-
Examination ShortDescription
-
Codelist Number
-
-
PressureRating
-
RatingPractice ShortDescription
-
PressureRating ShortDescription
-
Codelist Number
-
-
MaterialsType
-
MaterialsGroup ShortDesciption
-
MaterialsType ShortDesciption
-
CodeList Number
-
-
StressRelief
-
StressReliefPractice ShortDescription
-
StressRelief ShortDescription
-
Codelist Number
-
-
StressReliefRequirement
-
StressReliefRequirement ShortDescription
-
Codelist Number
-
-
CorrosionAllowance
-
SpecName
-
CorrosionAllowance
-
-
WasherCreationOption
-
WasherCreationOption ShortDescription
-
Codelist Number
-
-
PipingCommodityType
-
PipingCommodityClass ShortDescription
-
PipingCommoditySubClass ShortDescription
-
PipingCommodityType ShortDescription
-
Codelist Number
-
-
GasketType
-
GasketCategory ShortDescription
-
GasketType ShortDescription
-
Codelist Number
-
-
BoltType
-
BoltType ShortDescription
-
Codelist Number
-
-
NutType
-
NutType ShortDescription
-
Codelist Number
-
-
WasherType
-
WasherType ShortDescription
-
Codelist Number
-
-
PipingMaterialsClassData
-
SpecName
-
RevisionNumber
-
MaterialsDescription
-
FluidService
-
DesignStandard
-
WasherCreationOption
-
StressRelief
-
StressReliefRequirement
-
MaterialsGroup
-
MaterialsType
-
-
ServiceLimits
-
Specname
-
RevisionNumber
-
Temperature
-
Pressure
-
-
PipingCommodityFilter
-
SpecName
-
ShortCode
-
OptionCode
-
FirstSizeFrom
-
FirstSizeTo
-
FirstSizeUnits
-
SecondSizeFrom
-
SecondSizeTo
-
SecondSizeUnits
-
CommodityCode
-
FirstSizeSchedule
-
SecondSizeSchedule
-
SelectionBasis
-
EngineeringTag
-
-
GasketSelectionFilter
-
SpecName
-
RevisionNumber
-
NominalDiameterFrom
-
NominalDiameterTo
-
NpdUnitType
-
GasketOption
-
EndPreparation
-
PressureRating
-
EndStandard
-
FluidCode
-
ScheduleThickness
-
ContractorCommodityCode
-
-
BoltSelectionFilter
-
SpecName
-
RevisionNumber
-
NominalDiameterFrom
-
NominalDiameterTo
-
NpdUnitType
-
BoltOption
-
ContractorCommodityCode
-
-
NutSelectionFilter
-
SpecName
-
RevisionNumber
-
NutOption
-
BoltType
-
BoltDiameter
-
ContractorCommodityCode
-
-
WasherSelectionFilter
-
SpecName
-
RevisionNumber
-
WasherOption
-
BoltDiameter
-
ContractorCommodityCode
-
-
PipingCommodityMatlControlData
-
ContractorCommodityCode
-
ShortMaterialDescription
-
LongMaterialDescription
-
-
PipeNominalDiameters
-
SpecName
-
RevisionNumber
-
Npd
-
NpdUnitType
-
-
ShortCodeHierarchyRule
-
ShortCodeHierarchyType
-
ShortCode
-
-
CommodityOption
-
OptionCategory ShortDescription
-
CommodityOption ShortDescription
-
Codelist Number
-
-
GasketOption
-
GasketOption ShortDescription
-
Codelist Number
-
-
BoltOption
-
BoltOption ShortDescription
-
Codelist Number
-
-
WasherOption
-
WasherOption ShortDescription
-
Codelist Number
-
-
NutOption
-
NutOption ShortDescription
-
Codelist Number
-
-
SelectionBasis
-
SelectionBasis ShortDescription
-
Codelist
-
-
ScheduleThickness
-
ScheduleThicknessPractice ShortDescription
-
ScheduleThickness ShortDescription
-
CodeList Number
-
-
PipeStock
-
IndustryCommodityCode
-
CommodityType
-
ScheduleThickness[1]
-
ScheduleThickness[2]
-
Npd[1]:Primary
-
NpdUnitType[1]
-
Npd[2]:Secondary
-
NpdUnitType[2]
-
EndPreparation[1]
-
EndPreparation[2]
-
-
EndPreparation
-
TerminationClass ShortDescription
-
TerminationSubClass ShortDescription
-
EndPreparation ShortDescription
-
Codelist Number
-
-
NotePurpose
-
ShortDescription
-
Codelist Number
-
-
StandardNoteData
-
Name
-
Purpose
-
Description
-
-
PipeBranch
-
SpecName
-
RevisionNumber
-
HeaderSize
-
BranchSize
-
AngleLow
-
AngleHigh
-
HdrSizeNPDUnitType
-
BrSizeNPDUnitType
-
ShortCode
-
For PartClass (except Pipestock)
-
IndustryCommodityCode
-
CommodityType
-
GeometryType
-
MaterialGrade
-
GeometricIndustryStandard
-
PressureRating[1]
-
EndPreparation[1]
-
EndStandard[1]
-
ScheduleThickness[1]
-
PressureRating[2]
-
EndPreparation[2]
-
EndStandard[2]
-
ScheduleThickness[2]
-
Npd[1]
-
NpdUnitType[1]
-
Npd[2]
-
NpdUnitType[2]
-
Dimensional Attributes as required such as FacetoFace, Width Etc
For Gaskets
-
GasketPartData
-
IndustryCommodityCode
-
NominalDiameterFrom
-
NominalDiameterTo
-
NpdUnitType
-
GasketType
-
For Washer
-
WasherPartData
-
IndustryCommodityCode
-
WasherType
-
MaterialsGrade
-
WasherThickness
-
For Bolt
-
BoltPartData
-
IndustryCommodityCode
-
BoltType
-
MaterialsGrade
-
For Nut
-
NutPartData
-
IndustryCommodityCode
-
NutType
-
MaterialsGrade
-
NutHeight
-
Common sheets required for Part Data
-
GeometryType
-
Codelist Number
-
GeometryType ShortDescription
-
-
GeometricIndustryStandard
-
GeometricIndustryPractice ShortDescription
-
GeometricIndustryStandard ShortDescription
-
Codelist Number
-
-
MaterialGrade
-
MaterialsGradePractice ShortDescription
-
MaterialsCategory ShortDescription
-
MaterialsGrade ShortDescription
-
Codelist Number
-
-
EndStandard
-
EndPractice ShortDescription
-
EndStandard ShortDescription
-
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).