I know that prices are stored in rows in the ITM1 table along with a PriceList ItemCode fields.
I have one populated price list in my B1 db which is list #1 and I named it Master. The name shows up in OPLN.
In the ITM1 table, however, at present there are 10 rows for each OITM row, keyed by ItemCode and PriceList fields. 2-10 are currently unused.
OK, so my question is this: How is the underlying association formed between the price in the ITM1 table and the Item in the OITM table? I cannot see any foreign key that would associate the OITM row with a particular ITM1 row, yet the Item Master form in B1 knows to show me "Master" as the Price List.
I am looking for the sql to get the price of an Item given a designated OITM row.
What it really boils down to is how do I get the PriceList key for the OITM table select given an OITM row?
Thanks in advance,