@ShawnBerk: I see multi_level_structure_tab in the back-end, but in my case, it’s blank; I have assumed that this entity, like many in IFS, is only populated when a user elects to view the data in question.My use case is to calculate demand as of various moments in time, in order to analyze improvements in inventory management over time. That requires being able to associate Customer Orders with a Bill of Materials as of that moment in time to see how much material one would need to fulfill that demand. Thus, all these questions about historical data I’ve been throwing your way. :)In any case, you’ve been extraordinarily helpful. I’m marking your initial reply as the best answer. Thank you!
@ShawnBerk: This is all super helpful, thank you so much.Last question, I promise. :) The appeal of part_cost_bucket_one_tab is that it has already “exploded” the Bill of Materials for us: a clean look of top-level, parent, and component parts, including the “level 0” of the part being used to make itself (if applicable), allowing a user to filter for a top-level part and see all descendent parts at a glance. Is there a similar such table or view amongst the manuf_structure group of entities that does this for me? I’m certainly capable of crafting the SQL necessary atop manuf_structure_tab to explode it myself -- but it’s not trivial, and I’d prefer to avoid reinventing the wheel if it’s already available for my purposes.
@ShawnBerk: Fantastic explanation, and very prompt; thank you, fellow Shawn. :) A couple of follow-up questions:I don’t care about costs for the purpose of this demand analysis, to be honest; I’m more concerned about quantities, in order to associate a top-level part to its constituent parts. For that purpose, and based on your explanation, should I focus my extract on part_cost_bucket_one_tab? Or is there a different table I might want to use instead? I understand your point about not unioning all three of these tables. However, based on your description, would I be able to safely union one_tab and history_tab in order to generate a full historical record? Asked another way: is the history table a record of previous structures for Cost Set 1? (The history table doesn’t carry a COST_SET column, which is why I ask.)Thank you for your help!
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.