CME Order Management

This ERD (see the following figure) illustrates order management. Companies provide products and services to their customers over an extended period of time. Quotes and orders are used to capture the changes to a customer's installed services. The cycle starts when a customer requests the initial installation of a product or service in the form of a quote. The quote is converted to an order and that order is provisioned. At that time, the products and services described in the order are converted into assets associated with the customer's account. Subsequent changes to the configuration, disconnect instructions, or additions to the installed assets are captured in further quotes and orders. Order synchronization failures can also be tracked.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Account	S_ORG_EXT, S_PARTY
Asset	S_ASSET
Asset Attribute	S_ASSET_XA
Order	S_ORDER
Order Item	S_ORDER_ITEM
Order Item Attribute	S_ORDER_ITEM_XA
Product or Service	S_PROD_INT
Quote	S_DOC_QUOTE
Quote Item	S_QUOTE_ITEM
Quote Item Attribute	S_QUOTE_ITEM_XA
Failed Service Order	S_SRV_ORD_FAIL
Service Request	S_SRV_REQ