This content has been marked as final. Show 2 replies
what do u mean by top order line?
One sales order can have multiple models
can you brief more?
Sure. Let's assume we have the following structure
ORDER_NUMBER, LINE_NUMBER, CHILD_NUMBER, LINE_ID, Product, Amount, Top Line ID
ABC,1,1,100, Package A, $100, 100
ABC,1,2,101, Bundled Item 1, $50, 100
ABC,1,3,102, Bundled Item 2, $50, 100
ABC,2,1,103, Package B, $50, 103
ABC,2,2,104, Bundled Item 1, $50, 103
So in the above example, there is a single order "ABC". That order has two packages each with a different PTO model. Package A has 2 bundled items and package B has 1 bundled item.
I want a column like that last column, namely Top Line ID that always holds a reference to the record that is on the top line of the PTO model. At this point in time, I don't know a specific column or function or logic that gives me that information.
You are correct, that a single order can have multiple PTO models. But a single order Line should only be part of one PTO model (as far as I know).
Does that make more sense?
Edited by: user9208525 on Jan 30, 2013 7:15 AM