Export tables - Intergraph Smart Reference Data - Help - Hexagon

Intergraph Smart Reference Data Help (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

M_SPISO_EXP_SPEC_ASSOC_MTLS

Name

Data Type

SESAM_ID

NUMBER(12,0)

NOT NULL

SPIES_ID

NUMBER(12,0)

NOT NULL

ITEM_CODE

VARCHAR2(60)

NOT NULL

ASSOC_ITEM_CODE

VARCHAR2(60)

NOT NULL

QUANTITY

NUMBER(15,3)

NOT NULL

PROJ_ID

VARCHAR2(10)

NOT NULL

USR_ID

VARCHAR2(10)

NOT NULL

LMOD

DATE

NOT NULL

INT_REV

NUMBER(6,0)

NOT NULL

M_SPISO_EXP_SPEC_CCS

Name

Data Type

SPIESCCS_ID

NUMBER(12,0)

NOT NULL

SPIES_ID

NUMBER(12,0)

NOT NULL

ORDER_SEQ

NUMBER(5,0)

NOT NULL

SPIS_CODE

VARCHAR2(4 CHAR)

NOT NULL

SPIC_NUMBER

VARCHAR2(6 CHAR)

NOT NULL

SPIG_NUMBER

VARCHAR2(6 CHAR)

NOT NULL

SPICT_NUMBER

VARCHAR2(6 CHAR)

NOT NULL

COMMODITY_CODE

VARCHAR2(60 CHAR)

NOT NULL

FROM_SIZE1

VARCHAR2(12 CHAR)

NOT NULL

TO_SIZE1

VARCHAR2(12 CHAR)

NOT NULL

UNIT_CODE

VARCHAR2(10 CHAR)

NOT NULL

CC_DESCRIPTION

VARCHAR2(1024 CHAR)

OPTION_CODE

VARCHAR2(10 CHAR)

NOT NULL

M_SPISO_EXP_SPEC_IDENTS

Name

Data Type

SPIESI_ID

NUMBER(12,0)

NOT NULL

SPIESCCS_ID

NUMBER(12,0)

NOT NULL

INDEX_NUMBER

NUMBER(6,0)

NOT NULL

IDENT_CODE

VARCHAR2(60 CHAR)

NOT NULL

IDENT_DESCRIPTION

VARCHAR2(1024 CHAR)

BORE_A

VARCHAR2(10 CHAR)

NOT NULL

BORE_B

VARCHAR2(10 CHAR)

NOT NULL

BORE_C

VARCHAR2(10 CHAR)

NOT NULL

BORE_D

VARCHAR2(10 CHAR)

NOT NULL

DIM_A

VARCHAR2(10 CHAR)

NOT NULL

DIM_B

VARCHAR2(10 CHAR)

NOT NULL

DIM_C

VARCHAR2(10 CHAR)

NOT NULL

DIM_D

VARCHAR2(10 CHAR)

NOT NULL

WEIGHT

VARCHAR2(10 CHAR)

NOT NULL

UNIT_BORE

VARCHAR2(10 CHAR)

UNIT_LENGTH

VARCHAR2(10 CHAR)

UNIT_WEIGHT

VARCHAR2(10 CHAR)

BOLT_COMMODITY_CODE

VARCHAR2(70 CHAR)

BOLT_QUANTITY

VARCHAR2(3 CHAR)

UNIQUE_COMMODITY_CODE

VARCHAR2(70 CHAR)

ATTRIBUTE1

VARCHAR2(20 CHAR)

ATTRIBUTE2-99

VARCHAR2(20 CHAR)

ATTRIBUTE100

VARCHAR2(20 CHAR)

BOLT_DIA

VARCHAR2(10 CHAR)

BOLT_LENGTH

VARCHAR2(10 CHAR)

SCHEDULE_RATING

VARCHAR2(80 CHAR)

MATERIAL

VARCHAR2(80 CHAR)

STANDARD

VARCHAR2(255 CHAR)