Shulou(Shulou.com)05/31 Report--

This article introduces the meaning of data tables and fields in MySQL. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

1. The field meaning of this system

Dosage refers to a unit of master parts, how many units of sub-parts composition, such as 1PCS B2 need 5PCS D3 composition

Defective rate is the ratio of dosage; total = dosage × (1 + defective rate)

The tag refers to the position of the child in the master.

Deployment description column, which mainly refers to the order of material input.

Substitution means that when there is a substitute, the system will select the content; the process name of the process material processed

Pause means that the child is no longer in use, but it is temporarily saved. You can use this value.

Do not send materials when multi-stage delivery, because the semi-finished products outsourced have been formed, do not need to send raw materials and directly send semi-finished products, you can use this function

2. Table structure

NAME name TYPE remarks Part_no master code Char (24) cannot be empty or repeated, maximum character length is 24 digits Part_no1 subpart code Char (24) cannot be empty, maximum character length is 24 digits Yl_qty usage Numeric (8 refine 4) longest is 8 digits, decimal place 4, default value 0Bad_r defective rate Numeric (7) longest 7 digits, decimal point 4 The default value is 0Stop pause Char (1) Locator process number Char (2) cannot be empty, the default value is'N' The maximum character length is 2-bit No_pur1 pause Char (1) the default value is' N'No_pur2 do not send Char (1) the default value is' N'Rem tag Varchar (250) the longest character length is 250 digits Gg_person modifier Chan (20) the maximum character length is 20 bits Ecn_noECN single number Char (12) the maximum character length is 12 3, the preparatory work for the establishment of BOM in order to achieve information sharing and facilitate computer processing There must be a common logo, so we need to do a series of preparatory work, the most important of which is coding and standardization.

1) the establishment of material coding system.

When formulating the classification and coding system, the design, manufacturing and management departments should put forward the use requirements from their own application purposes, so that they can be comprehensively considered in the formulation of the code. The coding standard should have the uniqueness of identification, classification function, sorting function and specific meaning.

2) data standardization.

This part of the work includes two aspects, one is to improve the level of generalization and standardization in product design, and the other is data consistency. Improving the level of modularization and generalization of product parts is a powerful means to shorten the manufacturing cycle. The work of data consistency is inevitable. In the past, manual management or department independent computer management can cover up the contradiction of inconsistency, but this problem must be solved in order to realize data sharing in ERP system. The common problems are: multi-number or number-1 of material code, multi-value of material quota, multi-value of man-hour quota and so on. The inconsistency of these data requires inter-departmental consultation and unification, otherwise it will cause confusion in management.

3) determine the structural hierarchy of the BOM table.

Some experts said: "BOM table is not only a technical document, more importantly, it is a management document." There is a lot of truth in this sentence. For the same product, there may be different BOM in the company, and there may be different levels of BOM tables. The difference between them is because there are differences in production operation, material control operation, processing technology and cost control between companies, that is to say, there are differences in management. Therefore, before formulating the BOM, we must synthesize the characteristics and opinions of the company's production, material control and process, determine the structure and level of the BOM, and formulate the corresponding documents as the guide for the whole BOM filing work.

4) clearly establish and maintain the responsible units of all kinds of data.

In the implementation of ERP, the beneficiary unit is the management department, and the product data comes from the design department, and the design department is often reluctant to undertake the task of establishing BOM, so it is suggested that the responsibility of establishing BOM should be assigned to the design department and included in the performance evaluation. Each design department inputs BOM data directly through the computer network to achieve how much the design is completed and how much the ERP system can enjoy. Try to avoid the task of establishing the product database by the production management department or the computing center, because this will cause the new product BOM table can not be entered into the system in time and it is very difficult to maintain BOM.

5) establish the workflow management standard of BOM.

The workflow is as follows: coding-documentation-data entry and maintenance-standardization review-audit-expansion. The company must establish the production process of BOM table and standardize the workload of each link.

On the MySQL data table and what the field meaning is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.