Table lawprod.MSCM.DISTRIB_LINE 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
DELIVERY_TICKET_ID varchar2 40
ACCOUNT_DIST.DELIVERY_TICKET_ID SYS_C00914532 R
DELIVERY_EVENT_LINE.DELIVERY_TICKET_ID SYS_C00914549 R
MANIFEST_LINE.DELIVERY_TICKET_ID SYS_C00914556 R
PO_TRANSDTL.DELIVERY_TICKET_ID SYS_C001030852 R
RECEIPT_LINE_DISTRIB.DELIVERY_TICKET_ID SYS_C00914563 R
DELIVERY_UNIT.DELIVERY_TICKET_ID SYS_C00914525 R
DELIVERY_UNIT_NO number 4
ACCOUNT_DIST.DELIVERY_UNIT_NO SYS_C00914532 R
DELIVERY_EVENT_LINE.DELIVERY_UNIT_NO SYS_C00914549 R
MANIFEST_LINE.DELIVERY_UNIT_NO SYS_C00914556 R
PO_TRANSDTL.DELIVERY_UNIT_NO SYS_C001030852 R
RECEIPT_LINE_DISTRIB.DELIVERY_UNIT_NO SYS_C00914563 R
DELIVERY_UNIT.DELIVERY_UNIT_NO SYS_C00914525 R
DISTRIB_LINE_NO number 5
ACCOUNT_DIST.DISTRIB_LINE_NO SYS_C00914532 R
DELIVERY_EVENT_LINE.DISTRIB_LINE_NO SYS_C00914549 R
MANIFEST_LINE.DISTRIB_LINE_NO SYS_C00914556 R
PO_TRANSDTL.DISTRIB_LINE_NO SYS_C001030852 R
RECEIPT_LINE_DISTRIB.DISTRIB_LINE_NO SYS_C00914563 R
SOURCE_LINE_NO number 6  √  null
PO_LINE_NO number 6  √  null
ITEM_NO varchar2 32  √  null
DESCR varchar2 30  √  null
VENDOR_ITEM_NO varchar2 32  √  null
MFR_CAT_NO varchar2 35  √  null
DELIVERY_QTY number 15,4
ORDERED_QTY number 15,4  √  null
UOM varchar2 4  √  null
LAST_MODIFIED_DT date 7
STATUS varchar2 10
STATE varchar2 10
RECV_LINE_NO number 6  √  null
CURRENT_LOCATION_ID number 22
NEXT_LOCATION_ID number 22  √  null
NEXT_ACTION varchar2 10  √  null
NOTE_ID number 20  √  null
NOTE.NOTE_ID SYS_C00914524 R
BO_REM_QTY number 15,4  √  null
BO_CAN_BACK_ORD char 1  √  'B'
BIN varchar2 7  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
DELIVERY_TICKET_ID + DELIVERY_UNIT_NO + DISTRIB_LINE_NO Primary key Asc/Asc/Asc SYS_C00914523
CURRENT_LOCATION_ID + STATUS Performance Asc/Asc DL_CURLOC_IDX
STATUS Performance Asc DL_STATUS_IDX

Close relationships  within of separation: