Used Data Structures
Our calculation logic will use the following simple data structures:
Product Master
Contains Product Group information for each Product. We will need only the Product Group attribute for our calculation.
| Product ID | Product Group |
|---|---|
| sku | attribute2 |
Product_Costs PX
Contains products' Average Costs valid at different Valid From dates. We will use this information to calculate product cost on a specific target date and also an average cost for a whole product group.
| Product ID | Average Cost | Last Purchasing Price | Valid From |
|---|---|---|---|
| sku | attribute1 | attribute2 | attribute4 |
MarginAdj PP
Contains a percentual Margin adjustment for each Product Group. We will add this percentage to the final price based on the product group.
| Product Group | Margin (%) |
|---|---|
| name | attribute1 |
CountryFactor PP
Contains a Factor per Country code and Product Group. We will multiply the final price with this factor. Country code will be a user input.
| Country Code | Product Group | Factor |
|---|---|---|
| key1 | key2 | attribute1 |
Found an issue in documentation? Write to us.