                               OE DATA DICTIONARY             09/10/94  15:57:17
                                                                      Page:    1

Database    : CUST.DBF        - Customer file                           
Alias       : CUST      
Flags       : N/A
Misc file 1 : N/A
Index       : CUST1.NTX       { cust_no }
Index       : CUST2.NTX       { upper(name) }
Record size : 201  bytes

NO  FIELD      TYPE LEN DEC
===========================
1   CUST_NO      C    8       - customer number                         
2   NAME         C   30       - customer/vendor name                    
3   ADDRESS1     C   30       - address line 1                          
4   ADDRESS2     C   30       - address line 2                          
5   CITY         C   20       - address city                            
6   STATE        C    2       - address state                           
7   ZIP          C   10       - address zipcode                         
8   CONTACT      C   30       - contact name                            
9   PHONE        C   20       - phone number                            
10  FAX          C   20       - fax number                              


Database    : ORDER.DBF       - Order file                              
Alias       : ORDER     
Flags       : N/A
Misc file 1 : N/A
Index       : ORDER1.NTX      { order_no }
Index       : ORDER2.NTX      { cust_no+dtos(order_dt) }
Index       : ORDER3.NTX      { cust_no+dtos(ship_dt) }
Record size : 64   bytes

NO  FIELD      TYPE LEN DEC
===========================
1   ORDER_NO     C    8       - order number                            
2   CUST_NO      C    8       - customer number                         
3   ORDER_DT     D    8       - date the order was entered              
4   SHIP_DT      D    8       - date order shipped                      
5   SHIP_VIA     C   10       - shipment method (UPS, Fed Ex, etc..)    
6   PAY_METHOD   N    1       - payment method (check, visa, etc.. )    
7   ACCT_NO      C   20       - credit card account number              


Database    : ORDITEM.DBF     - Order Items file                        
Alias       : ORDITEM   
Flags       : N/A
Misc file 1 : N/A
Index       : ORDITEM1.NTX    { order_no+part_no }
Index       : ORDITEM2.NTX    { part_no+order_no }
Record size : 32   bytes

NO  FIELD      TYPE LEN DEC
===========================
1   ORDER_NO     C    8       - order number                            
<more>

                               OE DATA DICTIONARY             09/10/94  15:57:19
                                                                      Page:    2

NO  FIELD      TYPE LEN DEC
===========================
2   PART_NO      C    8       - our part number                         
3   ORDER_QTY    N    6       - the quantity ordered                    
4   PRICE        N    9   2   - selling price                           


Database    : PARTS.DBF       - Parts file                              
Alias       : PARTS     
Flags       : N/A
Misc file 1 : N/A
Index       : PARTS1.NTX      { part_no }
Index       : PARTS2.NTX      { upper(desc) }
Record size : 60   bytes

NO  FIELD      TYPE LEN DEC
===========================
1   PART_NO      C    8       - our part number                         
2   DESC         C   30       - part description                        
3   PRICE        N    9   2   - selling price                           
4   IN_STOCK     N    6       - quantity in stock                       
5   REORDER      N    6       - reorder quantity                        


Database    : VENDOR.DBF      - Vendor file                             
Alias       : VENDOR    
Flags       : N/A
Misc file 1 : N/A
Index       : VENDOR1.NTX     { vendor_no }
Index       : VENDOR2.NTX     { upper(name) }
Record size : 201  bytes

NO  FIELD      TYPE LEN DEC
===========================
1   VENDOR_NO    C    8       - vendor number                           
2   NAME         C   30       - customer/vendor name                    
3   ADDRESS1     C   30       - address line 1                          
4   ADDRESS2     C   30       - address line 2                          
5   CITY         C   20       - address city                            
6   STATE        C    2       - address state                           
7   ZIP          C   10       - address zipcode                         
8   CONTACT      C   30       - contact name                            
9   PHONE        C   20       - phone number                            
10  FAX          C   20       - fax number                              



                               OE DATA DICTIONARY             09/10/94  15:57:20
                                                                      Page:    3

Database    : VPARTS.DBF      - Vendor Parts file                       
Alias       : VPARTS    
Flags       : N/A
Misc file 1 : N/A
Index       : VPARTS1.NTX     { part_no+vendor_no }
Index       : VPARTS2.NTX     { vendor_no+part_no }
Record size : 64   bytes

NO  FIELD      TYPE LEN DEC
===========================
1   PART_NO      C    8       - our part number                         
2   VENDOR_NO    C    8       - vendor number                           
3   VEND_PART    C    8       - vendor's part number                    
4   DESC         C   30       - part description                        
5   COST         N    9   2   - cost of part                            



                
