Could someone explain to me the difference in the values found in the various Part Cost Bucket tables?
- part_cost_bucket_tab
- part_cost_bucket_one_tab
- part_cost_bucket_history_tab
I am attempting to construct a Bill of Materials for a data warehouse, and these three tables seem to carry slightly different values. For the purposes of demand calculations in the data warehouse, I need to be able to leverage a Bill of Materials as of any point in time, so I was hopeful that the history table would include everything I need -- but there are some examples of Part associations in the other two tables not available there.
I could perform a simple union of these tables in my SQL query in order to handle for any missing data -- but that feels like a weak solution that could generate more confusion than it alleviates.
Any guidance others could provide me on the nuances between these tables would be greatly appreciated. Thanks!
Best answer by ShawnBerk
View original