Where is the item lookup and price stored?

Question

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.

Jeff · Accepted Answer

**********  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.

Jonathan Smith · Answer

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,

Glenn Adams [MVP - Retail Mgmt] · Answer

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 AdamsTiber Creek Consulting           DO NOT respond to me directly but post all responses here in thenewsgroup so that all can share the information.Jmessage news:

Jeff · Answer

**********  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 pricing info" which ones are some?  "Jeff" wrote:  > Jonathan,  >   > The Item  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.  >   >   >   > **********  >   >   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

Where is the item lookup and price stored?

Join the Discussion

Didn't find your answer?