[Home] [Help] [Dependency Information]
Object Name: | GMD_SAMPLES_REC_TYPE |
---|---|
Object Type: | TYPE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
SAMPLING_EVENT_ID | NUMBER |
|
|
STEP_NO | NUMBER |
|
|
STEP_ID | NUMBER |
|
|
SAMPLE_ID | NUMBER |
|
|
SAMPLE_NO | VARCHAR2 | (80) | |
SAMPLE_DESC | VARCHAR2 | (80) | |
SPEC_ID | NUMBER |
|
|
SPEC_NAME | VARCHAR2 | (80) | |
SPEC_VERS | NUMBER |
|
10 |
LAB_ORGANIZATION_ID | NUMBER |
|
|
INVENTORY_ITEM_ID | NUMBER |
|
|
REVISION | VARCHAR2 | (3) | |
ITEM_NUMBER | VARCHAR2 | (240) | |
LOCATOR_ID | NUMBER |
|
|
EXPIRATION_DATE | DATE |
|
|
LOT_NUMBER | VARCHAR2 | (80) | |
PARENT_LOT_NUMBER | VARCHAR2 | (80) | |
BATCH_ID | NUMBER |
|
|
PLANT_CODE | VARCHAR2 | (4) | |
BATCH_NO | VARCHAR2 | (32) | |
RECIPE_ID | NUMBER |
|
|
RECIPE_NO | VARCHAR2 | (32) | |
RECIPE_VERSION | NUMBER |
|
5 |
FORMULA_ID | NUMBER |
|
|
FORMULA_NO | VARCHAR2 | (32) | |
FORMULA_VERS | NUMBER |
|
4 |
FORMULALINE_ID | NUMBER |
|
|
FORMULALINE_NO | NUMBER |
|
5 |
LINE_TYPE | NUMBER |
|
5 |
ROUTING_ID | NUMBER |
|
|
ROUTING_NO | VARCHAR2 | (32) | |
ROUTING_VERS | NUMBER |
|
5 |
OPRN_ID | NUMBER |
|
|
OPRN_NO | VARCHAR2 | (16) | |
OPRN_VERS | NUMBER |
|
5 |
BATCHSTEP_ID | NUMBER |
|
15 |
BATCHSTEP_NO | NUMBER |
|
10 |
CHARGE | NUMBER |
|
|
CUST_ID | NUMBER |
|
|
CUST_NAME | VARCHAR2 | (360) | |
ORDER_ID | NUMBER |
|
|
ORDER_TYPE | VARCHAR2 | (30) | |
ORDER_NUMBER | NUMBER |
|
|
ORDER_LINE_ID | NUMBER |
|
|
ORDER_LINE_NUMBER | NUMBER |
|
|
ORG_ID | NUMBER |
|
|
ORG_NAME | VARCHAR2 | (240) | |
SUPPLIER_ID | NUMBER |
|
|
SUPPLIER_NO | VARCHAR2 | (30) | |
SAMPLE_QTY | NUMBER |
|
|
SAMPLE_QTY_UOM | VARCHAR2 | (4) | |
SOURCE | VARCHAR2 | (1) | |
SAMPLER_ID | NUMBER |
|
|
SAMPLER | VARCHAR2 | (30) | |
DATE_DRAWN | DATE |
|
|
SOURCE_COMMENT | VARCHAR2 | (1024) | |
STORAGE_SUBINVENTORY | VARCHAR2 | (10) | |
STORAGE_LOCATOR_ID | NUMBER |
|
|
EXTERNAL_ID | VARCHAR2 | (32) | |
SAMPLE_APPROVER_ID | VARCHAR2 | (30) | |
INV_APPROVER_ID | VARCHAR2 | (30) | |
PRIORITY | VARCHAR2 | (2) | |
SAMPLE_INV_TRANS_IND | VARCHAR2 | (1) | |
SUPPLIER_SITE_ID | NUMBER |
|
|
SUPPLIER_SITE | VARCHAR2 | (15) | |
SUBINVENTORY | VARCHAR2 | (10) | |
ORGANIZATION_ID | NUMBER |
|
|
PO_HEADER_ID | NUMBER |
|
|
PO_NUMBER | VARCHAR2 | (20) | |
PO_LINE_ID | NUMBER |
|
|
PO_LINE_NUMBER | NUMBER |
|
|
RECEIPT_ID | NUMBER |
|
|
RECEIPT_NO | VARCHAR2 | (30) | |
RECEIPT_LINE_ID | NUMBER |
|
|
RECEIPT_LINE | NUMBER |
|
|
SAMPLE_DISPOSITION | VARCHAR2 | (3) | |
SHIP_TO_SITE_ID | NUMBER |
|
|
SHIP_TO_LOCATION | VARCHAR2 | (40) | |
SUPPLIER_LOT_NO | VARCHAR2 | (32) | |
LOT_RETEST_IND | VARCHAR2 | (1) | |
SAMPLE_INSTANCE | NUMBER |
|
|
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | |
SOURCE_LOCATOR_ID | NUMBER |
|
|
DATE_RECEIVED | DATE |
|
|
DATE_REQUIRED | DATE |
|
|
RESOURCES | VARCHAR2 | (16) | |
INSTANCE_ID | NUMBER |
|
|
RETRIEVAL_DATE | DATE |
|
|
SAMPLE_TYPE | VARCHAR2 | (2) | |
TIME_POINT_ID | NUMBER |
|
|
VARIANT_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 | NUMBER |
|
15 |
CREATED_BY_NAME | VARCHAR2 | (30) | |
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY | NUMBER |
|
15 |
LAST_UPDATED_BY_NAME | VARCHAR2 | (30) | |
LAST_UPDATE_LOGIN | NUMBER |
|
15 |
RETAIN_AS | VARCHAR2 | (3) | |
REMAINING_QTY | NUMBER |
|
|
|
|