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. There are two fact tables in this model, one based on order lines and the other based on order header data. All order lines regardless of status are captured. The order date is the base for the Time dimension.