Customer and supplier at same time

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,



deposit_id (not customer_id)

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


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

View user profile

Back to top Go down

Back to top

- Similar topics

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