Unit price difference between orderdetails and Product table

[raju_salmon]

Dear Team,

I am new to database and understanding it, though it is very basic question can anyone please let me know the dirrerence between unit price in order_details table and Product table.

I have productID and UnitPrice in both tables so synthetic key is forming. If i rename it, which unit price i need to consider for sales calculation.

Thank you.

Regards,

Raju

[sunny_talwar]

Does each ProductID has a unique and equivalent UnitPrice in both the tables? If it is always unique and remains same, then it doesn't matter which one you use.

[MayilVahanan]

HI

As per my understanding, Price from product table should be refer in "Order" table for calculation.

[raju_salmon]

No Sunny, It is not unique. Can you please refer the attachment.

[MayilVahanan]

Hi

For Sales calculation, You can refer the "Unit Price" in Order Details.

[raju_salmon]

Thanks for your reply. May i know what is the difference between both? The unit price in order table is lower/higher than unit price in product table.

[MayilVahanan · Accepted solution]

Hi Raju,

I think,

Product Table: Original price of the product is available.

Order Table: Contains the price of the product is sold. It may be contains some discount, adjustment, co-pay or tax.

Based on the order table, we can able to find the sales of the product / company.

[qlikviewwizard]

Hi Raju Salmon, Please close the thread by selecting Correct Answer. Thank you.

[raju_salmon]

Hi,

Can you please provide me correct answer. I have received only helpful answer.

Regards,

Raju

[qlikviewwizard]

Hi Raju, Please attach the sample data to demonstrate your issue. It will help us in better understand.Thank you.