For example, you may well have multiple work orders for one sales order. The diagram above is not a table or entity diagram.

This step completes the transaction (ignoring returns, Change Orders, or other issues). Lastly, the customer makes payment along with some kind of Remittance Advice referencing the Invoice number/id. The Invoice should reference the Purchase Order number/id. When any part or whole of the Purchase Item has been rendered to the customer, an Invoice is prepared by the vendor and delivered to the customer to demand payment. The vendor's internal staff, the production-related managers (senior artisans, manufacturing managers, warehouse supervisors, etc.) create one or more Work Order documents directing their staff on what to do to render the services/products desired by the customer. The Sales Order is produced by the sales people of the vendor, reflecting the content of the Purchase Order but using the format and lingo that makes sense to the internal staff of the vendor. If accepted by the vendor, a legally-binding contract is established. Yellow items = documents internal to the vendor.Īfter consulting with a sales person (optional), the customer submits a Purchase Order to a vendor, describing exactly what service/product they have decided to buy.Blue items = documents from/to the customer.

Pink items = customer-vendor contact/interaction without documents.Using the definitions from Wikipedia, the usual work flow of vendor-customer is shown in this diagram. Just this, 'Which one has Employee', could mean any of dozens of things as mentioned in the Answer by Neil McGuigan: the person who first took customer inquiry phone call, the sales person who responded, the sales assistant who filled out Sales Order, the production manager who acknowledged receipt of the Sales Order, the workers who produced the items on the work order, and so on.īut I'll give you a simplified overview that might provide some of the insight you requested. Your Question is much too broad to provide any specific table design suggestions.

Facebook business manager invoices