Try OpenEdge Now
skip to main content
Database Essentials
Introduction to Databases : OpenEdge database and the relational model : Sports 2000 database
 

Sports 2000 database

The Sports 2000 database is one of several sample databases provided with the product, and it is frequently used in the documentation to illustrate database concepts and programming techniques. This database holds the information necessary to track customers, take and process orders, bill customers, and track inventory. The following table describes the tables of the Sports 2000 database. For details about the fields and indexes of the Sports 2000 database, you can use either the Data Dictionary or the Data Admin Tool to create table and index reports. For details on how to create reports, see the online Help.
Table 1. The Sports 2000 database
Table
Description
Benefits
Contains employee benefits
BillTo
Contains bill to address information for an order
Bin
Represents the bins in each warehouse that contain items
Customer
Contains customer information including balance and address
Department
Contains a master listing of departments
Employee
Stores employee information including name and address
Family
Tracks an employee's family information
Feedback
Contains customer feedback regarding likes and dislikes
InventoryTrans
Contains information about the movement of inventory
Invoice
Contains financial information by invoice for the receivables subsystem
Item
Provides quick reference for stocking, pricing, and descriptive information about items in inventory
Local-Default
Contains format and label information for various countries
Order
Contains sales and shipping header information for orders
Order-Line
Provides identification of and pricing information for a specific item ordered on a specific order
POLine
Contains the PO detail information including the item and quantity on the PO
PurchaseOrder
Contains information pertaining to the purchase order including PO number and status
Ref-Call
Contains all history for a customer
Salesrep
Contains names, regions, and quotas for the sales people
ShipTo
Contains the ship to address information for an order
State
Provides U.S. state names, their abbreviations, and sales region
Supplier
Contains a supplier's name, address, and additional information pertaining to the supplier
SupplierItemXr
Lists all of the items that are supplied by a particular supplier
TimeSheet
Records time in and out, hours worked, and overtime
Vacation
Tracks employee vacation time
Warehouse
Contains warehouse information including warehouse name and address