Order Life Cycle
This ERD (see the following figure) illustrates how orders are tracked through their full life cycle by Siebel Business Applications. The cycle starts with an opportunity that tracks the consideration of purchase of one or more products. This opportunity leads to one or more quotes, composed of one or more quoted product items. A quote can then lead to one or more orders. An order is composed of one or more ordered product items. Fulfillment of the order can be tracked through a set of part movements of various types, culminating in a shipment of products to the customer, and the invoicing for shipped goods.

The following table lists the entities in this ERD and their corresponding tables.
Entity | Table |
---|---|
Account |
S_ORG_EXT, S_PARTY |
Invoice |
S_INVOICE |
Invoice Item |
S_INVOICE_ITEM |
Opportunity |
S_OPTY |
Opportunity Product |
S_REVN |
Order |
S_ORDER |
Order Item |
S_ORDER_ITEM |
Order Part Movement |
S_ORDPART_MVMT |
Product or Service |
S_PROD_INT |
Quote |
S_DOC_QUOTE |
Quote Item |
S_QUOTE_ITEM |
Shipment |
S_SHIPMENT |