The Sports 2020 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 2020 database. For details about the fields and indexes of the Sports 2020 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 2020 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