Sales Orders
The Sales Order model analyzes the customer order process such as invoiced and not invoiced orders, and value or quantity by status.
The ability to analyze by different statuses enables the company to analyze open orders. Open orders occur when the customer has not yet paid outstanding invoices or when the company has not yet delivered the ordered goods.
You can analyze products, warehouse, and customer trends using this model. The facts in this model can be analyzed by these dates:
- Order Entry Date
- Planning Date
- Departure Date
- Order Date
- Confirmed Delivery Date
- Requested Delivery Date
Source information
The Sales Order model is based on sales performed using Customer Order Module (OIS) in M3 BE. Its main source is the transactional table customer order lines, OOLINE, including the respective header information found in OOHEAD. This model consists of several scripted sources that combine header and line information into one view. This view can be translated into one or more physical fact tables within Birst depending on the grain.