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_tabI 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!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.