Table lawprod.MSCM.PO_RECEIPT 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
REC_ID number 20
PO_LINE_RECEIPT.REC_ID SYS_C00914367 R
PO_LINE_RECEIPT_RECORD.REC_ID SYS_C00914359 R
REC_NO number 10
PO_ID number 20
PO_HEADER.PO_ID SYS_C00914344 R
RELEASED_BY number 38  √  null
USERS.USER_ID SYS_C00914345 R
CREAT_DATE date 7
BOL varchar2 22  √  null
REC_DATE date 7  √  null
CARRIER varchar2 19  √  null
REF_NO varchar2 10  √  null
CARRIER_TRK_NO varchar2 40  √  null
RCV_LOC number 38  √  null
LOCATION.LOCATION_ID SYS_C00914346 R
UPLOAD_MSG varchar2 100  √  null
UPLOAD_STATUS char 1
INT_STATUS char 1
EXT_STATUS char 1
LABEL_PRINT_ID number 8  √  null
DOC_PRINT_ID number 8  √  null
NEED_PRINT char 1

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
REC_ID Primary key Asc SYS_C00914343

Close relationships  within of separation: