Sales management of Open source supply chain database outline Design

Sales Management sub-sales plan, sales quotation, sales orders, sales returns, sales and settlement, in the original development plan, because the development of manpower shortage, only ready to do sales order management and sales return management, in view of the current development team situation, plans to increase sales settlement management, this article only describes the sales order and sales return concept model.

1. Sales Order Management

Sales order management is mainly used to handle sales order management in the actual business.

The following figure is the basic entity diagram related to sales order management.

Sales Order Management

Sales order records the main information of sales, such as trading venues, order amount of information, and so on;

Sales orders are related to the invoice type, currency, transaction terms, and payment terms in relation to other objects, in addition to entities such as companies, departments, employees, customers, and so on.

Trading conditions refer to the performance of the sales order, such as the first delivery after the payment, the first payment after the delivery.

Payment terms are mainly used to control transaction risk, belong to configuration information, the main records of information such as 10th, 30th pay, monthly knot and so on.

The order detail refers to the specific product information, such as product name, unit of measure, price, quantity, discount, tax and so on.

2, Sales return management:

Sales return management is mainly used to deal with the actual business of the sales orders occurred in the process of return events.

The basic entity relationships for sales return management are shown in the following illustration:

Sales Return Order Management

The sales return order records the main information of the return, such as customer information, company, department, employee who participates in the return process, and the returned orders that are referenced. In order to solve the possibility of a return order to achieve a return of more than one sales order returns, in the design, the sales order and sales return orders between the One-to-many relationship is nullable.

Sales Return Order Details record the product name, unit of measure, price, quantity, discount, tax and other basic information, and also record the source of the order details.