Pricing Engine Query
Need oracle's suggestion on the below use case,
We have around 40k accounts and 50k products.
We have a standard price list stored in data table
We have some account specific prices ( but no integration between SFDC and CPQ) stored in data table.
We have some account specific discounts stored in data table.
We are planning to use pricing engine to run our pricing logic.
If a particular customer has a account specific pricelist then pick the price from account specific pricelist else pick the prices from standard price list table.
Then apply the discount on top of it and return the discounted price.