Table lawprod.MSCM.PO_LINE_RECEIPT_RECORD Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
LINE_ID number 20
PO_LINE.LINE_ID SYS_C00914358 R
REC_ID number 20
PO_RECEIPT.REC_ID SYS_C00914359 R
SEQ number 20
BIN varchar2 7  √  null
SERIAL varchar2 16  √  null
LOT varchar2 16  √  null
SUB_LOT varchar2 6  √  null
TRK_NO varchar2 40  √  null
RCV_LOC number 38
LOCATION.LOCATION_ID SYS_C00914360 R
RCV_QTY number 10,4  √  null
RCV_UOM varchar2 4  √  null
LOT_EXP date 7  √  null
UPLOAD_STATUS char 1
UPLOAD_MSG varchar2 100  √  null
NEED_INSP char 1
CAN_BACK_ORD char 1 'B'

Analyzed at Wed May 18 12:10 CDT 2011

Requirements (check constraints):
Constraint Constraint Name
CAN_BACK_ORD IN ('Y','N','B') POLRR_CAN_BO_CK

Indexes:
Column(s) Type Sort Constraint Name
REC_ID + SEQ Primary key Asc/Asc SYS_C00914357

Close relationships  within of separation: