PROGRESS-PLUS.com logo   DATABASE TABLE STRUCTURE

Order

 LABEL:  
DESCRIPTION: Order header information

TABLE STRUCTURE
  key  Name   Label   Datatype   Format   Extent  Mnd.  Default   View-As
  Order            
PK n/m AK  Order-num     integer  >>>>9  0 no  0  ?
Should lookup valid carriers.  Carrier     character  x(20)  0 no     ?
Help:Name n/m AK FK  Cust-Num     integer  >>>>9  0 no  0  ?
 Instructions     character  x(20)  0 no     ?
 Order-Date  Ordered  date  99/99/99  0 no  TODAY  ?
 PO     character  x(20)  0 no     ?
 Promise-Date  Promised  date  99/99/99  0 no  ?  ?
FK  Sales-Rep     character  x(4)  0 no     ?
 Ship-Date  Shipped  date  99/99/99  0 no  ?  ?
This should default to the TERMS specified by the CUSTOMER record.  Terms     character  x(20)  0 no  Net30  ?
AK  Cust-Order  Unique Active 
 Cust-Num  Ascending
 Order-num  Ascending
 iOrder-num2  Active ** Index is not used. [112]
 Order-num  Ascending
 Cust-Num  Ascending
 Order-Date  Active ** Index is not used. [112]
 Order-Date  Ascending
PK  Order-Num  Unique Active  ** Redundant Index. [114] (by iOrder-num2)
 Order-num  Ascending
 Sales-Rep  Active 
 Sales-Rep  Ascending

TABLE RELATIONS
CHILD TABLES (Child Table OF Order)
Order header information  Order
This contains transactions for the Receivables system  Invoice  
Help:Name  Cust-Num  
 Order-num  
Order line information  Order-Line  
 Order-num  
 
PARENT TABLES (Order OF Parent Table)
Order header information  Order
Customer information  Customer  
 Cust-Num  
Sales representative information  Salesrep  
 Sales-Rep  

TABLE TRIGGERS
EVENT TRIGGER FILE NAME OVERRIDE
CREATE sports/crord.p no

FOREIGN KEYS NOT DEFINED
# FIELD NAME POSSIBLE RELATION NOTES
No possible relations found.

TABLE USAGE ANALYSIS
MODULE NAME ACCESS CREATE DELETE REFERENCE SORT-ACCESS UPDATE NOTES
oleauto.p 2           ** File is not used. [100]
flex.w 5       1   ** File is not used. [100]
selval.p 3     1 1   ** File is not used. [100]

FIELDS USAGE ANALYSIS
FIELD NAME ACCESS REFERENCE SORT-ACCESS UPDATE NOTES
Order.Carrier    
Order.Cust-Num        
Order.Instructions         ** Field is not used. [113]
Order.Order-Date      
Order.Order-num        
Order.PO         ** Field is not used. [113]
Order.Promise-Date         ** Field is not used. [113]
Order.Sales-Rep        
Order.Ship-Date         ** Field is not used. [113]
Order.Terms         ** Field is not used. [113]

INDEXES USAGE ANALYSIS
INDEX NAME MODULES USING NOTES
Cust-Order    
iOrder-num2   ** Index is not used. [112]
Order-Date   ** Index is not used. [112]
Order-Num    
Sales-Rep    


Last updated 05/05/2003 6:47:41 pm
Generated by PRO4m v3.02.00.