SERIAL_LOT |
Default Table Name | SERIAL_LOT |
Definition |
SERIAL_LOT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SERIAL_LOT_KEY![]() |
NUMBER(10, 0) | NO | ||
SERIAL_ID | VARCHAR2(20) | YES | ||
LOT_ID | VARCHAR2(20) | YES | ||
PART_KEY![]() |
NUMBER(10, 0) | NO | ||
PART_ID | VARCHAR2(50) | NO | ||
PART_RVSN_ID | VARCHAR2(10) | NO | ||
S_ORD_REF_TYPE_CD | VARCHAR2(1) | NO | ||
ORIG_ORD_ID | VARCHAR2(10) | NO | ||
ORIG_PO_RLSE_NO | NUMBER(5, 0) | YES | ||
ORIG_ORD_LN_KEY | NUMBER(10, 0) | YES | ||
S_INVT_TRN_TYPE | VARCHAR2(1) | YES | ||
ORIG_WHSE_ID | VARCHAR2(8) | YES | ||
ORIG_INVT_TRN_ID | VARCHAR2(10) | YES | ||
OR_INVT_TRN_LN_KEY | NUMBER(10, 0) | YES | ||
VEND_WARR_EXP_DT | DATE | YES | ||
SHELF_LIFE_EXP_DT | DATE | YES | ||
MANUF_ID | VARCHAR2(10) | YES | ||
MANUF_PART_ID | VARCHAR2(30) | NO | ||
MANUF_PART_RVSN_ID | VARCHAR2(3) | NO | ||
VEND_ID | VARCHAR2(12) | YES | ||
VEND_PART_ID | VARCHAR2(30) | NO | ||
VEND_PART_RVSN_ID | VARCHAR2(3) | NO | ||
MAN_VEND_SERIAL_ID | VARCHAR2(20) | YES | ||
MAN_VEND_LOT_ID | VARCHAR2(20) | YES | ||
NOTES_NT | VARCHAR2(254) | NO | ||
TOTAL_QTY | NUMBER(14, 4) | NO | ||
UDEF_DESC_1 | VARCHAR2(30) | NO | ||
UDEF_DESC_2 | VARCHAR2(30) | NO | ||
UDEF_DESC_3 | VARCHAR2(30) | NO | ||
UDEF_DESC_4 | VARCHAR2(30) | NO | ||
UDEF_DESC_5 | VARCHAR2(30) | NO | ||
TRN_DT | DATE | YES | ||
ENTR_USER_ID | VARCHAR2(20) | NO | ||
ENTR_DTT | DATE | NO | ||
PHYS_COUNT_DEL_FL | VARCHAR2(1) | NO | ||
MANUF_NAME | VARCHAR2(30) | NO | ||
VEND_NAME | VARCHAR2(25) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
COMPANY_ID | VARCHAR2(10) | NO | ||
BOM_CONFIG_ID | VARCHAR2(10) | YES | ||
ROUT_NO | NUMBER(5, 0) | YES | ||
EFFECT_DT | DATE | YES | ||
VEND_WARR_CD![]() |
VARCHAR2(6) | YES | ||
VEND_WARR_START_DT | DATE | YES | ||
CUST_WARR_CD![]() |
VARCHAR2(6) | YES | ||
CUST_WARR_START_DT | DATE | YES | ||
CUST_WARR_EXP_DT | DATE | YES | ||
MAINT_FL | VARCHAR2(1) | NO | ||
MAINT_SO_ID | VARCHAR2(10) | YES | ||
MAINT_SO_RLSE_NO | NUMBER(5, 0) | YES | ||
MAINT_SO_LN_KEY | NUMBER(10, 0) | YES | ||
SO_TAG_ID | VARCHAR2(30) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
UID_CD | VARCHAR2(78) | YES | ||
S_UID_TYPE | VARCHAR2(5) | YES | ||
UID_IAC_CD | VARCHAR2(3) | YES | ||
UID_EID_CD | VARCHAR2(13) | YES | ||
UDEF_DESC_6 | VARCHAR2(30) | YES | ||
UDEF_DESC_7 | VARCHAR2(30) | YES | ||
UDEF_DESC_8 | VARCHAR2(30) | YES | ||
UDEF_DESC_9 | VARCHAR2(30) | YES | ||
UDEF_DESC_10 | VARCHAR2(30) | YES | ||
UDEF_DESC_11 | VARCHAR2(30) | YES | ||
UDEF_DESC_12 | VARCHAR2(30) | YES | ||
UDEF_DESC_13 | VARCHAR2(30) | YES | ||
UDEF_DESC_14 | VARCHAR2(30) | YES | ||
UDEF_DESC_15 | VARCHAR2(30) | YES | ||
S_SHELF_LIFE_TYPE | VARCHAR2(1) | YES | ||
ORIG_EXP_DT | DATE | YES | ||
LAST_EXT_DT | DATE | YES | ||
EXT_TAKEN_NO | NUMBER(5, 0) | YES | ||
AVAIL_FOR_USE_FL | VARCHAR2(1) | YES |
SERIAL_LOT Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_6376 | PrimaryKey | SERIAL_LOT_KEY |
SERIAL_LOT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
PART | Non-Identifying | One To Zero or More | F20570 | PART_KEY | NO | NO | NO | ||
WARRANTY | Non-Identifying | Zero or One to Zero or More | F21365 | VEND_WARR_CD | NO | NO | NO | ||
WARRANTY | Non-Identifying | Zero or One to Zero or More | F21366 | CUST_WARR_CD | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
INVT_WHS_LOC_SR_LT | Identifying | One To Zero or More | F20574 | NO | NO | NO | |||
INVT_TRN_LN_SR_LT | Identifying | One To Zero or More | F20576 | NO | NO | NO | |||
MO_SERIAL_LOT | Identifying | One To Zero or More | F20788 | NO | NO | NO | |||
SO_ISS_SERIAL_LOT | Identifying | One To Zero or More | F21391 | NO | NO | NO | |||
PO_LN_SERIAL_LOT | Identifying | One To Zero or More | FK_PO_LN_SERIAL_LOT_SE_IDX | NO | NO | NO | |||
RQ_LN_SERIAL_LOT | Identifying | One To Zero or More | FK_RQ_LN_SERIAL_LOT_SE_IDX | NO | NO | NO |