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