This tutorial assumes that you have installed the Order Entry (OE) and Human Relations (HR) sample schemas. The OE schema is used as the consolidated database. It encapsulates information about employees, orders, customers, and products. For this tutorial, you are primarily interested in the OE schema.
Here is a brief description of the relevant tables in the OE schema:
|CUSTOMERS||Customers whose information is kept on record.|
|INVENTORIES||How much of each product is stored in each warehouse.|
|ORDER_ITEMS||A list of products included in each order.|
|ORDERS||A record of a sale between a salesperson and a customer on a specific date.|
|PRODUCT_DESCRIPTIONS||Descriptions of each product in different languages.|
|PRODUCT_INFORMATION||A record of each product in the system.|
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|