Customer and supplier at same time

View previous topic View next topic Go down

Customer and supplier at same time

Post  fabriciabarbosa on Mon Aug 10, 2015 8:28 am

Hi, Everyone

I would like you help for my project. I have a dilemma.

My data model is related to Business Industry. We have several factories and several deposits related to it. The deposits vedem products to customers, but perform transfer of products between them. In this case, the seller is also a client.

I thought of desing 2 tables fact .: 1 - Sales 2 - transfer.

like this,

1)

customer_id
product_id
qt_product


2)
deposit_id (not customer_id)
product_id
qt_product

the problem is: the manager wants to see the total cost of manufacturing output. And so, we have 2 cost facts.

Is there a way to have a single fact cost?


best regards,
Fabricia Barbosa

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 39
Location : Recife, Brazil

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum