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) |