PMC/PCD Table Structure - Intergraph Smart Materials - Version 2020 (10.0) - Administration & Configuration - Hexagon

Intergraph Smart Materials Integration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Construction Version
8
Smart Materials/Smart Reference Data Version
2020 (10.0)

Here is the structure of two Smart Materials tables that contain PMC/PCD information. You can use it when you are creating SQL code.

m_pds_pcd

pmc_id NUMBER(12) NOT NULL

spec_item_id NUMBER(12) NOT NULL

short_code VARCHAR2(10)

rkl VARCHAR2(16) NOT NULL

commodity_id NUMBER(12) NOT NULL

zydex VARCHAR2(7) NOT NULL

unit VARCHAR2(10)

opt VARCHAR2(10) NOT NULL

dn1_from VARCHAR2(12) NOT NULL

dn1_to VARCHAR2(12) NOT NULL

endprp1 VARCHAR2(4)

rating1 VARCHAR2(6)

sch1 VARCHAR2(8)

ts1 VARCHAR2(4)

dn2_from VARCHAR2(12) NOT NULL

dn2_to VARCHAR2(12) NOT NULL

endprp2 VARCHAR2(4)

rating2 VARCHAR2(6)

sch2 VARCHAR2(8)

ts2 VARCHAR2(4)

model VARCHAR2(6)

geostd VARCHAR2(6)

modif VARCHAR2(5)

matgrd VARCHAR2(4)

max_temp VARCHAR2(6)

fabcat VARCHAR2(4)

weightcode VARCHAR2(3)

endprpgrp1 VARCHAR2(4)

endprpgrp2 VARCHAR2(4)

instrument_no VARCHAR2(20)

standard_note_a VARCHAR2(20)

standard_note_b VARCHAR2(20)

physical_data_id VARCHAR2(20)

pds_sort_code VARCHAR2(20)

ident NUMBER(12) NOT NULL

group_id NUMBER(12) NOT NULL

part_id NUMBER(12) NOT NULL

input_1 VARCHAR2(10) NOT NULL

input_2 VARCHAR2(10) NOT NULL

input_3 VARCHAR2(10)

input_4 VARCHAR2(10)

free1 VARCHAR2(60)

free2 VARCHAR2(60)

free3 VARCHAR2(60)

free4 VARCHAR2(60)

free5 VARCHAR2(60)

free6 VARCHAR2(60)

free7 VARCHAR2(60)

free8 VARCHAR2(60)

free9 VARCHAR2(60)

free10 VARCHAR2(60)

proj_id VARCHAR2(10) NOT NULL

usr_id VARCHAR2(10) NOT NULL

lmod DATE NOT NULL

int_rev NUMBER(6) NOT NULL

m_pds_pmc

pmc_id NUMBER(12) NOT NULL

header_id NUMBER(12) NOT NULL

datum DATE NOT NULL

kind NUMBER NOT NULL

pt VARCHAR2(15)

dn VARCHAR2(15)

branch VARCHAR2(15)

tap VARCHAR2(15)

gasket VARCHAR2(15)

fluid VARCHAR2(15)

wall VARCHAR2(15)

revision NUMBER(2)

mater_of_construction VARCHAR2(20)

corrosion_allowed NUMBER(14,4)

material_description NUMBER(6)

thickness_equotation VARCHAR2(15)

vent_drain_macro VARCHAR2(15)

standard_note_a VARCHAR2(15)

standard_note_b VARCHAR2(15)

bend_deflection_table VARCHAR2(15)

pipe_length_table VARCHAR2(15)

cl148 VARCHAR2(6)

free1 VARCHAR2(15)

free2 VARCHAR2(15)

free3 VARCHAR2(15)

free4 VARCHAR2(15)

free5 VARCHAR2(15)

free6 VARCHAR2(15)

free7 VARCHAR2(15)

free8 VARCHAR2(15)

free9 VARCHAR2(15)

free10 VARCHAR2(15)

proj_id VARCHAR2(10) NOT NULL

usr_id VARCHAR2(10) NOT NULL

lmod DATE NOT NULL

int_rev NUMBER(6) NOT NULL

sp_id NUMBER(12) NOT NULL

shortage VARCHAR2(50)