InventDim is combination of inventory dimension such was location, warehouse, site and etc. In the inventDim table, you would see the field inventSiteId which is the value part of the entire dimension.
For example, your sales order has warehouse W1 and Site S1, it will try to find in your inventDim combination whether you have this, if not, the new InventDimId will be created such as ID001. In this pair inventDim, you can see the inventDimID = ID001, warehouse =W1 and Site= S1.
When you create a new order with exactly the same inventory dimension combination, your next sales order inventDim will have this value ID001 as inventDim store all the dimension you have for the sales order including the site. If you create another sales order with only Site S1, it will try to find the combination, then create ID002 because it doesn't exists.
If you have another order with warehouse W2 and site S1, then a new combination would be created ID003
Ignore other dimension at this example, I am using site and warehouse only. In example above you can see combination below.
| InventDimId |
InventLocationId |
InventSiteId |
| ID001 |
W1 |
S1 |
| ID002 |
|
S1 |
| ID003 |
W2 |
S1 |
I hope this make sense
