Name |
Datatype |
Length |
Prcn |
SPEC_ID |
NUMBER
|
|
|
SPEC_NAME |
VARCHAR2
|
(80)
|
|
SPEC_VERS |
NUMBER
|
|
10 |
SPEC_DESC |
VARCHAR2
|
(240)
|
|
INVENTORY_ITEM_ID |
NUMBER
|
|
10 |
ITEM_NUMBER |
VARCHAR2
|
(40)
|
|
GRADE_CODE |
VARCHAR2
|
(150)
|
|
REVISION |
VARCHAR2
|
(3)
|
|
SPEC_STATUS |
NUMBER
|
|
5 |
SPEC_STATUS_DESCRIPTION |
VARCHAR2
|
(240)
|
|
OWNER_ORGANIZATION_ID |
NUMBER
|
|
15 |
OWNER_ID |
NUMBER
|
|
15 |
OWNER_NAME |
VARCHAR2
|
(240)
|
|
SAMPLE_INV_TRANS_IND |
VARCHAR2
|
(1)
|
|
OVERLAY_IND |
VARCHAR2
|
(1)
|
|
SPEC_TYPE |
VARCHAR2
|
(2)
|
|
BASE_SPEC_ID |
NUMBER
|
|
|
DELETE_MARK |
NUMBER
|
|
5 |
TEXT_CODE |
NUMBER
|
|
10 |
ATTRIBUTE_CATEGORY |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE2 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE3 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE4 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE5 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE6 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE7 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE8 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE9 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE10 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE11 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE12 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE13 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE14 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE15 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE16 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE17 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE18 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE19 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE20 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE21 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE22 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE23 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE24 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE25 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE26 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE27 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE28 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE29 |
VARCHAR2
|
(240)
|
|
ATTRIBUTE30 |
VARCHAR2
|
(240)
|
|
CREATION_DATE |
DATE
|
|
|
CREATED_BY_ID |
NUMBER
|
|
15 |
CREATED_BY_NAME |
VARCHAR2
|
(240)
|
|
LAST_UPDATE_DATE |
DATE
|
|
|
LAST_UPDATED_BY_ID |
NUMBER
|
|
15 |
LAST_UPDATED_BY_NAME |
VARCHAR2
|
(240)
|
|
LAST_UPDATE_LOGIN |
NUMBER
|
|
15 |
SPEC_TESTS |
GMD_SPEC_TESTS_TAB_TYPE
|
|
|
CUST_SPEC_VRS |
GMD_CUST_SPEC_VRS_TAB_TYPE
|
|
|
WIP_SPEC_VRS |
GMD_WIP_SPEC_VRS_TAB_TYPE
|
|
|
SUPL_SPEC_VRS |
GMD_SUPL_SPEC_VRS_TAB_TYPE
|
|
|
INV_SPEC_VRS |
GMD_INV_SPEC_VRS_TAB_TYPE
|
|
|
MON_SPEC_VRS |
GMD_MON_SPEC_VRS_TAB_TYPE
|
|
|