A salesrep has the ability to issue a discount associated with an entire order and not to a specific item on the order.
The discount is entered as a customer credit to the AR / billing system matched to the orderId # and is mapped to a salesrep discount type along with a comment reason.
For me...
We have a sales fact table and have a question with the customer and address dimension.
A customer can have more than one address for shipping and billing (think large company with many locations).
Each sale need to be tracked to the main parent company and to the specific location or division...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.