Where is the item lookup and price stored?

**********

Can anyone point me to where that would be? I am trying to generate a script based on that.

I am looking to find the normal sale price. I am not looking for price levels, but if you could tell me those it would help too maybe in the future.

also how about costs?

BTW why do you say "some pric> Jonathan,

Item.Price Item.PriceA Item.PriceB Item.PriceC Item.Cost Item.SalePrice

The price information in the item table tells you what you expect the item to be sold for under various conditions.

It you want to know what it *actually* sold for on any given transaction, you would need to refer to the TransactionEntry Table. Same thing for the Cost at the time of sale (remember that cost can change over time)...

Glenn Adams Tiber Creek C> I am looking to find the normal sale price. I am not looking for price

message news: snipped-for-privacy@microsoft.com...

**********

also how about costs?

BTW why do you say "some pric > Jonathan, > > The Item table.contains the ILC and some pricing info. > > What price are you looking for? > > -- > * > Get Secure! -

> > You must be using Outlook Express or some other type of newsgroup reader to > see and download the file attachment. If you are not using a reader, follow > the link below to setup Outlook Express. Click on "Open with newsreader" > under the MS Retail Management System on the right. > > > > ********** > > "Jonathan Smith" wrote in message news: snipped-for-privacy@microsoft.com... > I am wondering where in the sql tables is the item lookup and price stored? > It should all be on one table correct? > > Can anyone point me to where that would be? I am trying to generate a script > based on that