CN117709694A - Manufacturing execution system and method - Google Patents

Abstract

The invention discloses a manufacturing execution system and a manufacturing execution method. The manufacturing execution system comprises a plurality of functional modules; each functional module corresponds to at least one functional unit, and each functional unit corresponds to a plurality of functional operation point subunits; the functional module comprises at least one of: the system comprises a purchase management module, a sales management module and a warehouse management module; business data corresponding to each functional module are stored in a stock-in-stock data association table, and the purchase management module, the sales management module and the warehouse management module manage the business data through the stock-in-stock data association table, wherein the attributes of the stock-in-stock data association table comprise types and subtypes; and the business data in the purchase management module, the sales management module and the warehouse management module are correlated through the identity numbers in the stock data correlation table. The problem of manufacturing execution system only be limited to single module and cause the material management difficulty is solved, material management's efficiency and rate of accuracy have been improved.

Description

Manufacturing execution system and method

Technical Field

The invention relates to the technical field of material data management, in particular to a manufacturing execution system and a manufacturing execution method.

Background

For manufacturing, the material flow includes: links such as sales, purchasing, warehouse, production, quality and the like comprise a large amount of material data in each link, so that the management of the large amount of material data is important.

The inventors have found that the following drawbacks exist in the prior art in the process of implementing the present invention: currently, manufacturing execution systems (MES, manufacturing Execution System) are limited to a single module or production related modules, are not managed from the perspective of system modules that are operated entirely in a factory, have technical limitations, and cause data faults.

Disclosure of Invention

The invention provides a manufacturing execution system and a manufacturing execution method, which are used for realizing the management of the whole life cycle of material data and improving the efficiency and the accuracy of material management.

According to the technical scheme of the embodiment of the invention, the manufacturing execution system comprises: a plurality of functional modules; each functional module corresponds to at least one functional unit, and each functional unit corresponds to a plurality of functional operation point subunits; the functional module comprises at least one of the following: the system comprises a purchase management module, a sales management module and a warehouse management module; the purchase management module is used for managing material purchase information, and comprises at least one of the following: a purchase order function unit, a purchase warehouse-in function unit and a purchase return function unit; the sales management module is used for managing material sales, and comprises at least one of the following: a sales order function unit, a sales delivery function unit, and a sales return function unit; the warehouse management module is used for managing material warehouse-in and warehouse-out, and comprises at least one of the following: a material warehouse-in functional unit, a material warehouse-out functional unit and a material transfer warehouse-out; the business data corresponding to each functional module is stored in a business-in-business-out data association table, the purchase management module, the sales management module and the warehouse management module all manage the business data through the business-in-business-out data association table, the attribute of the business-in-business-out data association table comprises a type and a subtype, and the business data comprises at least one of the following: identity number and number; and the business data in the purchase management module, the sales management module and the warehouse management module are correlated through the identity numbers in the stock data correlation table. The problem that the manufacturing execution system is limited to a single module to cause material management difficulty is solved, the efficiency and the accuracy of material management are improved, the problem of faults caused by material data association is solved, and the management of the whole life cycle of the material data is realized.

It should be noted that, the background database of the business table of purchase, sale and stock in the application is 1 table, namely, the data association table of purchase, sale and stock, is designed according to types and subtypes, so that the query speed of the past multi-table joint query is greatly reduced, and the query performance is improved. The material table, the material relation table and the material inventory table record the material basic information, the associated information and the real-time inventory quantity, so that the data calculation efficiency is improved, the data query use efficiency is improved, and the method is also the basis for realizing the light weight of the MES.

Specifically, due to the logical relations among the material table, the material relation table, the material inventory table and the stock-in and stock-out data association table, each management department can optimize service operation by checking and analyzing shared data. Under the condition that purchase, sales, inventory, production and quality management are operated independently, the sales department can know the inventory condition of the materials in real time by looking up the inventory condition table, so that the overstock or shortage is avoided. The purchasing department can make purchasing decision according to the information in the sales data association table, so that timely inventory replenishment is ensured, and excessive purchasing is avoided. By real-time monitoring of inventory conditions, it is possible to reduce the amount of funds occupied in excessive inventory while preventing business loss due to inventory shortages. Because the material relation table is established, the consistency of the data can be ensured according to the association relation. The purchase and sale data association table enables information such as sales, purchase and inventory to be associated with each other in the transaction process, and ensures accuracy of data.

In addition, comprehensive business monitoring is realized by carrying out consistency management on data in the fields of purchase, sales, inventory, production and quality management. All departments can share data, so that the whole business condition can be more comprehensively known, more effective strategy and decision making can be facilitated, the data change of all management fields can be monitored in real time, and a foundation is laid for accurate reports of subsequent production. Each department can generate accurate and comprehensive reports by using the shared data, and powerful support is provided for business decisions. Through data consistency management, enterprises can better cooperate with the operation of each department, the overall operation efficiency is improved, the resource waste is reduced, and finally more refined and intelligent management is realized.

It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a schematic diagram of a manufacturing execution system according to a first embodiment of the present invention;

FIG. 2 is a flow chart of a method of manufacturing execution provided according to a second embodiment of the present invention;

fig. 3 is a schematic structural view of a manufacturing execution device according to a third embodiment of the present invention;

fig. 4 is a schematic structural diagram of an electronic device according to a fourth embodiment of the present invention.

Detailed Description

In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.

It should be noted that the terms "target," "current," and the like in the description and claims of the present invention and the above-described drawings are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Example 1

Fig. 1 is a schematic structural diagram of a manufacturing execution system according to a first embodiment of the present invention, where the manufacturing execution system 100 includes: a plurality of functional modules; wherein each functional module corresponds to at least one functional unit respectively, and each functional unit corresponds to a plurality of functional operation point subunits respectively; the functional module comprises at least one of the following: a procurement management module 110, a sales management module 120, and a warehouse management module 130.

The purchase management module 110 is configured to manage material purchase information, where the purchase management module includes at least one of the following: a purchase order function unit, a purchase warehouse-in function unit and a purchase return function unit;

the sales management module 120 is configured to manage sales of materials, and the sales management module includes at least one of the following: a sales order function unit, a sales delivery function unit, and a sales return function unit;

the warehouse management module 130 is configured to manage material input and output, and the warehouse management module includes at least one of the following: a material warehouse-in functional unit, a material warehouse-out functional unit and a material transfer warehouse-out;

the business data corresponding to each functional module is stored in a business-to-stock data association table, the purchase management module 110, the sales management module 120 and the warehouse management module 130 all manage the business data through the business-to-stock data association table, the attribute of the business-to-stock data association table comprises a type and a subtype, and the business data comprises at least one of the following: identity number and number; the business data in the purchase management module 110, the sales management module 120 and the warehouse management module 130 are associated with the business data by the identity numbers in the stock data association table.

Specifically, the purchasing management module has a plurality of secondary menus under the primary menu, which may include: a purchase order function unit, a purchase warehouse-in function unit and a purchase return function unit. In detail, the purchase order functional unit includes a plurality of functional operation point sub-units, which may specifically include: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking-out subunit, a searching subunit and a list display function subunit. The purchasing and warehousing functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit. The purchase return functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit.

Specifically, the sales management module has a plurality of secondary menus under the primary menu, which may include: the sales order function unit includes a plurality of function operation point sub-units, which may specifically include: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit. The sales outlet functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit. The sales return function unit comprises a plurality of function operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit.

The warehouse management module has a plurality of secondary menus under the primary menu, and can comprise: the system comprises a material warehouse-in functional unit, a material warehouse-out functional unit and a material allocating warehouse-out function unit. The material warehouse-in functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit. The material warehouse-out functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit. The material transferring and delivering warehouse comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a viewing subunit, a copying subunit, a deleting/batch deleting subunit, a printing subunit, a batch checking/batch checking subunit, a viewing subunit, a searching subunit and a list display function subunit.

In this embodiment, the service data corresponding to each functional module is stored in a stock-and-sell data association table, and the purchase management module, the sales management module and the warehouse management module all manage the service data through the stock-and-sell data association table, where the attributes of the stock-and-sell data association table include a type and a subtype. The advantages of this arrangement are that: the business table background database is 1 table, and the attribute of the business data association table is designed according to the type and subtype, so that the data query use efficiency is improved, and the business data association table is also the basis for realizing light weight of MES.

In addition, the business data in the purchase management module, the sales management module and the warehouse management module are correlated through the identity numbers in the stock data correlation table, so that information inquiry and correlation can be more accurately carried out, and the accuracy and the speed of data inquiry are improved.

Optionally, the functional module further includes at least one of: the system comprises a basic data module, a production management module, a work order management module, a quality management module, a material management module, a traceability management module, a report query module and a visual large screen module; the basic data module is used for managing basic data, and comprises at least one of the following: a supplier information function unit, a customer information function unit, a warehouse information function unit, a production unit function unit, a capacity information function unit, a defect information function unit, and a production calendar function unit; the production management module is used for managing a production plan, and comprises at least one of the following: a production plan functional module and a production plan Gantt chart functional module; the work order management module is used for managing material work order information, and comprises at least one of the following: a work order information function unit and a work report information function unit; the quality management module is used for managing the quality of materials, and comprises: a quality management function unit; the material management module is used for managing material information, and comprises at least one of the following: a material information functional unit and a measurement unit functional unit; the traceability management module is used for managing the bar codes of the materials, and comprises: a material bar code management function unit; the report query module is used for querying and managing the material report, and comprises at least one of the following: the system comprises a material stock function unit, a purchase statistics function unit, a sales statistics function unit, a warehouse entry detail function unit, a warehouse exit detail function unit, a material allocation detail function unit, a warehouse entry summarization function unit, a warehouse exit summarization function unit and a warehouse entry, sales and storage statistics function unit; visual display is carried out according to at least one preset display service; and generating corresponding display business according to the data in the module to be visualized.

The basic data module is provided with a plurality of secondary menus below the primary menu, and the secondary menus can comprise a supplier information function unit, a client information function unit, a warehouse information function unit, a production unit function unit, a capacity information function unit, a defect information function unit and a production calendar function unit.

Specifically, the vendor information function unit includes a plurality of function operation point sub-units, which may specifically include: a new add subunit, an edit subunit, an import subunit, an export subunit, a delete/bulk delete subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The client information functional unit includes a plurality of functional operation point subunits, which may specifically include: a new add subunit, an edit subunit, an import subunit, an export subunit, a delete/bulk delete subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The warehouse information functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a new add subunit, an edit subunit, a delete/bulk delete subunit, a set default subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The production unit functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a new add subunit, an edit subunit, an import subunit, a log subunit, a delete/bulk delete subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The capacity information functional unit includes a plurality of functional operation point sub-units, and may specifically include: a new add subunit, an edit subunit, an import subunit, a log subunit, a delete/bulk delete subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The defect information functional unit includes a plurality of functional operation point subunits, and may specifically include: a new add subunit, an edit subunit, an import subunit, a log subunit, a delete/bulk delete subunit, a print subunit, a view subunit, a search subunit, and a list-display function subunit.

The production calendar function unit includes a plurality of function operation point subunits, which may specifically include: calendar presentation subunits, working day subunits, non-working day switching subunits and switching month subunits.

Specifically, the production management module has a plurality of secondary menus below the primary menu, which may include: the production plan functional module and the production plan Gantt chart functional module. Wherein, the production plan functional module comprises a plurality of functional operation point subunits, which can specifically comprise: the system comprises a new adding subunit, an editing subunit, a issuing/batch issuing generation work order, a recycling/batch recycling, a deleting/batch deleting subunit, a closing/reverse closing subunit, a log subunit, a printing subunit, a checking subunit, a searching subunit and a list display function subunit. The production planning Gantt chart functional module comprises a plurality of functional operation point subunits, and can specifically comprise: the Gantt chart subunit is displayed according to the non-closed production plan, the non-occurrence plan Gantt chart subunit can be edited, and the identification (overload, light load and full load) subunit can be displayed.

Specifically, the job management module has a plurality of second-level menus under the first-level menu, and may include: and the work order information functional unit and the work report information functional unit. The work order information functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: and checking the issuing work order information subunit, the newly built report work subunit and the work order two-dimension code display/printing. The report information functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit (which can support scanning work order two-dimension codes), an editing subunit, a deleting subunit, a log subunit, a viewing subunit, a searching subunit and a list display function subunit.

Specifically, the quality management module is used for managing the quality of materials, and a secondary menu is arranged below the primary menu of the quality management module and can comprise a quality management functional unit. The quality management functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a new add subunit, an edit subunit, a delete subunit, a print subunit, a log subunit, a view subunit, a search subunit, and a list-display function subunit.

Specifically, the material management module is used for managing material information. The material management module is provided with a plurality of secondary menus below the primary menu, and can comprise a material information functional unit and a metering unit functional unit. Wherein, the material information functional unit includes a plurality of function operation point subunits, can specifically include: a new add subunit, an edit/bulk edit subunit, an import subunit, an export subunit, a delete/bulk delete subunit, a print subunit, a bulk enable/bulk disable subunit, a bulk modify inventory subunit, a column setup subunit, a view subunit, a search subunit, and a list display function subunit. The unit of measurement functional unit includes a plurality of function operating point subunits, can specifically include: a new add subunit, an edit subunit, a delete/bulk delete subunit, a print subunit, a bulk enable/bulk disable subunit, a view subunit, a search subunit, and a list-display function subunit.

Specifically, a second-level menu is arranged below the first-level menu of the traceability management module, and the second-level menu can comprise a material bar code management function unit. The material bar code management functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a new adding subunit, an editing subunit, a deleting/batch deleting subunit, a printing subunit, an importing subunit, a related information inquiring subunit, a searching subunit and a list displaying functional subunit.

Specifically, the report query module has a plurality of secondary menus under the primary menu, which may include: the system comprises a material stock function unit, a purchase statistics function unit, a sales statistics function unit, a warehouse entry detail function unit, a warehouse exit detail function unit, a material allocation detail function unit, a warehouse entry summarization function unit, a warehouse exit summarization function unit and a warehouse entry, sales and storage statistics function unit. The material inventory function unit comprises a plurality of function operation point subunits, and can specifically comprise: a review subunit, a print subunit, a export subunit, a statistics subunit, a total stock amount subunit, a gross weight subunit, a search subunit, and a list display function subunit. The purchase statistics functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a viewing subunit, a printing subunit, a exporting subunit, a statistics actual purchasing subunit, a searching subunit and a list display function subunit. The sales statistics functional unit includes a plurality of functional operation point subunits, and may specifically include: a viewing subunit, a printing subunit, a exporting subunit, a statistics actual sales subunit, a searching subunit, and a list display function subunit. The warehouse entry detail functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a review subunit, a print subunit, a export subunit, a statistics total stock subunit, a total stock amount subunit, a total weight subunit, a search subunit, and a list display function subunit. The ex-warehouse detail functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a view subunit, a print subunit, a export subunit, a search subunit, and a list-display function subunit. The material transfer detail functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a view subunit, a print subunit, a export subunit, a search subunit, and a list-display function subunit. The warehouse entry summarizing functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a view subunit, a print subunit, a export subunit, a search subunit, and a list-display function subunit. The ex-warehouse summarizing functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a view subunit, a print subunit, a export subunit, a search subunit, and a list-display function subunit. The purchase, sale and stock statistics functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a viewing subunit, a printing subunit, a deriving subunit, a counting month total sum subunit, a searching subunit and a list display function subunit.

In addition, the visual large screen module is used for performing visual display according to at least one preset display service; and generating corresponding display business according to the data in the module to be visualized. It can be understood that the user can establish a corresponding display service according to the module for visualization, so as to perform display operation on the data in the module. The user can customize the module which needs to display the data, thereby generating the corresponding display service.

Optionally, the functional module further includes: an extension item information module; wherein the extension information module comprises at least one of the following: visual design functional unit, personal office functional unit, task center functional unit, message center functional unit, flow engine functional unit, print template functional unit, integration center functional unit, element center functional unit, portal engine functional unit, online development functional unit, system management functional unit and log center functional unit.

Specifically, the visual design functional unit includes a plurality of functional operation point subunits, which may specifically include: report design subunit and large screen design subunit. The personal office function unit includes a function operating point subunit, which may specifically include: and a service application subunit. The task center functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: my hair driver unit, my done subunit, and my to-do subunit. The message center functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the system comprises a message receiving subunit, a message module subunit, a message configuration list subunit, a robot management subunit and a custom message reminding subunit. The flow engine functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: form design subunit, flow listening subunit, and dynamic data source subunit. The printing template functional unit comprises a functional operation point subunit, and can specifically comprise: and a print template design subunit. The integrated center functional unit comprises a functional operation point subunit, and may specifically include: and integrating the management subunit. The element center functional unit comprises a functional operation point subunit, and may specifically comprise: the elements design the subunits. The portal engine functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a page style setting subunit, a portal design subunit and a portal layout library subunit. The online development functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: the method comprises the steps of developing a table sub-unit, a system check rule sub-unit and a system coding rule sub-unit on line. The system management functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: an organization subunit, a job management subunit, a department management subunit, a my department subunit, a user management subunit, a role management subunit, a menu management subunit, and a data dictionary subunit. The log center functional unit comprises a plurality of functional operation point subunits, and can specifically comprise: a data log subunit and a log management subunit.

Optionally, in the background database, the type includes at least one of: ex-warehouse type, warehouse-in type, and other types; the subtype corresponding to the ex-warehouse type comprises at least one of the following: other delivery, sales delivery, purchasing return, allocating delivery; the subtype corresponding to the warehouse-in type comprises at least one of the following: purchasing, warehousing, other warehousing, selling and returning; the subtype corresponding to the other type comprises at least one of the following: sales orders and purchase orders.

Optionally, in the front end, the type includes at least one of: sales type, procurement type, and other types; the subtype corresponding to the sales type comprises at least one of the following: sales order sub-types, sales delivery sub-types, and sales return sub-types; the subtype corresponding to the purchase type comprises at least one of the following: purchasing order list type, purchasing warehouse-in subtype and purchasing return subtype; other types of material subtypes include at least one of the following: other ex-warehouse sub-types, other warehouses, and dial ex-warehouse.

The manner of displaying the attributes (types and subtypes) of the entry and exit data association table is different in the background database or in the front end, but exists in parallel.

The advantages are that: the convenience degree of the respective users corresponding to the front end and the background database is facilitated, and the respective roles and authorities are used for classified management. The background database of the business table is 1 table, is designed according to types and subtypes, greatly reduces the query speed of the prior multi-table joint query, and improves the query performance. In addition, the material table, the material relation table and the material inventory table can be queried in real time to record the material basic information, the associated information and the real-time inventory quantity, so that the data calculation efficiency is improved, the data query use efficiency is improved, and the method is also the basis for realizing the light weight of the MES.

Optionally, the background database further comprises: a material table, a material relation table and a material inventory table; the entry and sales data association table is respectively associated with a material table, a material relation table and a material inventory table through at least one type of association key in the background database; the associated keys of the entry and sales data associated table comprise an entry and sales main key, an entry and sales first external key and an entry and sales second external key; the associated key of the material table comprises a material main key; the association key of the material relation table comprises a first material relation external key and a second material relation external key; the associated keys of the material inventory list comprise a material inventory main key and a material inventory external key; the first external key of the entry and sales data association table is associated with the main key of the materials in the materials table; a first external key and a second external key of the material relation table are associated with a main key of the material in the material table; and the material stock external key of the material stock table is associated with the material main key in the material table.

Wherein, the material relation table is used for expressing the relation between materials, say: and assembling relation between the parent material and the child material. The material relationship first foreign key may correspond to a parent material number; the material relationship second foreign key may correspond to a child material number. The material primary key of the material table may be a material number. The material stock list is used for tracking stock information of each material, the material stock main key can be a stock number, and the material stock external key can be a material number. The purchase-sale-stock primary key may be a data number. The first external key of the pin deposit may be a material number. The purchase, sale and store second foreign key may be a transaction number.

In addition, the entry and exit data association table is used for associating materials with entry and exit data, and can be convenient for tracking materials involved in specific transactions.

In the embodiment, the tables are connected through the external key relation, so that the inquiry and analysis of materials across the tables are realized. For example, the hierarchical structure of the material can be known by connecting parent-child materials in a material relationship table. And checking the stock condition of each material by connecting the material list in the material stock list. In the stock data association table, the materials involved in each transaction are tracked. This relationship design helps to maintain consistency and traceability of the data.

Optionally, a plurality of basic data tables are designed in the basic data module, each unit corresponds to one basic data table or a plurality of units corresponds to one basic data table, and the stock data table and the basic data table are linked through a field mobilizing interface.

In this embodiment, since a plurality of basic data tables are involved in the basic data module, each unit corresponds to one basic data table or a plurality of units corresponds to one basic data table, and the purchase, sale and warehouse (purchase, sale and warehouse) needs to be linked with the information in the basic data module through the field mobilizing interface.

For example, a new purchase order is added in the purchase module, and a supplier selection is provided, so that information corresponding to the supplier in the basic data module can be read through a field of 'supplier', wherein the information includes a saleable product category and the like, so that the new purchase order can be selected. It will be appreciated that a plurality of units corresponds to a table, e.g., a vendor information function unit, a customer information function unit may employ a table, and that types may be distinguished by type, i.e., vendor, customer, or both vendor and customer.

In particular, the front-end programming language may be 、/>And->. The base frame may be +.>、And->Micro-services. The application integration may be->、/>、/>And。

further, the backend programming language may be JAVA11. The base frame may be、And->. The rights authentication may be +.>. The flow engine may be +.>. Task debugging may be +.>And->. The database may be +.>. The message service may be. The file stores may be FTP, OSS, and BOS. The cache service may be +.>. The running environment may be->And->. Other components may be +.>、/>、/>、/>、/>、/>、、/>And->。

Optionally, the method comprises the following steps: the material data corresponding to each functional unit is stored in a material database; wherein the material data comprises at least one of: material type, material subtype, material identity number and material quantity.

Specifically, the material type may be set as'". The material subtype may be set to "+.>"or" - ">”。

In this embodiment, the parameters of the obtained material data may include a material type, a material subtype, a material identity number and a material number, and may further store a material database. Correspondingly, the distinguishing and searching processing of the material data can be performed through the material identity numbers.

According to the technical scheme of the embodiment of the invention, the manufacturing execution system comprises: a plurality of functional modules; each functional module corresponds to at least one functional unit, and each functional unit corresponds to a plurality of functional operation point subunits; the functional module comprises at least one of the following: the system comprises a basic data module, a production management module, a work order management module, a quality management module, a material management module and a traceability management module; the basic data module is used for managing basic data, and comprises at least one of the following: a supplier information function unit, a customer information function unit, a warehouse information function unit, a production unit function unit, a capacity information function unit, a defect information function unit, and a production calendar function unit; the production management module is used for managing the production plan and comprises at least one of the following: a production plan functional module and a production plan Gantt chart functional module; the work order management module is used for managing material work order information and comprises at least one of the following: a work order information function unit and a work report information function unit; the quality management module is used for managing the quality of materials, and comprises: a quality management function unit; the material management module is used for managing material information and comprises at least one of the following: a material information functional unit and a measurement unit functional unit; the traceability management module is used for managing the bar codes of the materials, and comprises: and a material bar code management function unit. The problem that the manufacturing execution system is limited to a single module to cause material management difficulty is solved, the efficiency and the accuracy of material management are improved, the problem of faults caused by material data association is solved, and the management of the whole life cycle of the material data is realized.

Example two

Fig. 2 is a flowchart of a manufacturing execution method according to a second embodiment of the present invention, where the method may be executed by a manufacturing execution device, and the manufacturing execution device may be implemented in hardware and/or software.

Accordingly, as shown in fig. 2, the method includes:

and S210, when the target functional unit receives the material receiving and sending instruction, analyzing the material receiving and sending instruction to obtain the target receiving and sending material identity number and the target receiving and sending material quantity.

S220, carrying out matching inquiry according to the material identity number of the target material receiving and sending number in a stock-in and stock-out data association table corresponding to the material database, and if matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target material receiving and sending number.

And S230, judging whether the current material quantity meets the target material receiving and sending quantity, if so, determining that the material receiving and sending instruction is met, carrying out data processing on the current material type, the current material subtype and the current material quantity, and updating the material database.

In this embodiment, the target functional unit in the manufacturing execution system needs to receive the material receiving and sending instruction in real time, and after receiving the material receiving and sending instruction, needs to analyze and process the material receiving and sending instruction, so as to obtain the information parameter of the material to be received and sent, where the information parameter may include the identity number of the material to be received and sent and the number of the material to be received and sent.

The target receiving and sending material identity number can be used for searching and matching materials in a material database to obtain unique material data information. The target transceiving material quantity is used to describe the size of the quantity of transceiving material.

Further, searching of materials in the material database can be performed according to the target material receiving and sending identity numbers, and the current material type, the current material subtype and the current material quantity matched with the searching of materials can be determined.

Correspondingly, the current material quantity and the target purchased material quantity need to be compared, for example, the target material receiving and sending quantity is 100, but if the current material quantity is 100, the material receiving and sending instruction is determined to be met, the current material type, the current material subtype and the current material quantity are exported in a data mode, and a material database is updated.

Optionally, after the determining whether the current material quantity meets the target material receiving and sending quantity, the method further includes: if not, determining that the material receiving and dispatching instruction is not satisfied, returning to the operation of the upper interface, and feeding back a material receiving and dispatching failure instruction to the user.

In the previous example, the target material receiving and sending quantity is 100, but the current material quantity is 0, it can be determined that the material receiving and sending instruction is not satisfied, and the operation of the previous interface is directly returned, and the material receiving and sending failure instruction is fed back to the user.

In addition, judge the material database "Main key "(currently receiving and transmitting Material identity number) and'"(target material receiving and sending identity number) major key">If the (target material receiving and sending quantity) is 0, returning to the upper layer to re-input legal data if the (target material receiving and sending quantity) is 0, and if the (target material receiving and sending quantity) is not 0, creating service data of the associated material and the corresponding target material receiving and sending quantity "/-and->". The material type can be set to be +.>", the subtype of the material is'And the material identity number is the primary key record data. At the same time with>"and">"update the quantity of material in the target material table in the material database for the primary key".

The advantages of this arrangement are that: the warehouse-in and warehouse-out of the materials can be more accurately carried out, and the database can be updated in time, so that the management operation of the materials can be more convenient.

According to the technical scheme, when the target functional unit receives the material receiving and dispatching instruction, the material receiving and dispatching instruction is analyzed to obtain the target receiving and dispatching material identity number and the target receiving and dispatching material quantity; according to the material identity numbers of the target receiving and dispatching material in the stock-in and stock-out data association table corresponding to the material database, carrying out matching inquiry, and if matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target receiving and dispatching material identity numbers; judging whether the current material quantity meets the target material receiving and sending quantity, if yes, determining that a material receiving and sending instruction is met, carrying out data processing on the current material type, the current material subtype and the current material quantity, and updating the material database. The problem that the manufacturing execution system is limited to a single module to cause material management difficulty is solved, the efficiency and the accuracy of material management are improved, the problem of faults caused by material data association is solved, and the management of the whole life cycle of the material data is realized.

Example III

Fig. 3 is a schematic structural diagram of a manufacturing execution device according to a third embodiment of the present invention. The manufacturing execution device provided in the embodiment of the present invention may be implemented by software and/or hardware, and may be configured in a terminal device or a server to implement a manufacturing execution method in the embodiment of the present invention. As shown in fig. 3, the apparatus includes: the target transception materials identity number and target transception materials quantity determining module 310, the matching query module 320, and the material transception instructions satisfying module 330.

The target material receiving and sending identity number and target material receiving and sending number determining module 310 is configured to parse the material receiving and sending instruction when the target functional unit receives the material receiving and sending instruction, so as to obtain a target material receiving and sending identity number and a target material receiving and sending number;

the matching query module 320 is configured to perform matching query according to the material identity number of the target receiving and sending material identity number in the entry and exit data association table corresponding to the material database, and if it is determined that the material identity number matches, obtain a current material type, a current material subtype, and a current material quantity corresponding to the target receiving and sending material identity number;

and a material purchase instruction satisfaction module 330, configured to determine whether the current material quantity satisfies the target material receiving and sending quantity, if yes, determine that the material receiving and sending instruction is satisfied, process the current material type, the current material subtype and the current material quantity, and update the material database.

According to the technical scheme, when the target functional unit receives the material receiving and dispatching instruction, the material receiving and dispatching instruction is analyzed to obtain the target receiving and dispatching material identity number and the target receiving and dispatching material quantity; according to the material identity numbers of the target receiving and dispatching material in the stock-in and stock-out data association table corresponding to the material database, carrying out matching inquiry, and if matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target receiving and dispatching material identity numbers; judging whether the current material quantity meets the target material receiving and sending quantity, if yes, determining that a material receiving and sending instruction is met, carrying out data processing on the current material type, the current material subtype and the current material quantity, and updating the material database. The problem that the manufacturing execution system is limited to a single module to cause material management difficulty is solved, the efficiency and the accuracy of material management are improved, the problem of faults caused by material data association is solved, and the management of the whole life cycle of the material data is realized.

Optionally, the material receiving and dispatching instruction does not meet the requirement of the module, and the module can be specifically used for: after judging whether the current material quantity meets the target material receiving and sending quantity or not, if the current material quantity does not meet the target material receiving and sending quantity, determining that the material receiving and sending instruction is not met, returning to the operation of a previous interface, and feeding back a material receiving and sending failure instruction to a user.

The manufacturing execution device provided by the embodiment of the invention can execute the manufacturing execution method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the execution method.

Example IV

Fig. 4 shows a schematic diagram of an electronic device 10 that may be used to implement a fourth embodiment of the invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as a manufacturing execution method.

In some embodiments, the method of manufacturing execution may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the manufacturing execution method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to perform the manufacturing execution method in any other suitable manner (e.g., by means of firmware).

The method comprises the following steps: when the target functional unit receives a material receiving and dispatching instruction, analyzing the material receiving and dispatching instruction to obtain a target material receiving and dispatching identity number and a target material receiving and dispatching quantity; according to the material identity numbers of the target receiving and dispatching material in the stock-in and stock-out data association table corresponding to the material database, carrying out matching inquiry, and if matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target receiving and dispatching material identity numbers; judging whether the current material quantity meets the target material receiving and sending quantity, if yes, determining that a material receiving and sending instruction is met, carrying out data processing on the current material type, the current material subtype and the current material quantity, and updating the material database.

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.

It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.

The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims (10)

1. A manufacturing execution system, the manufacturing execution system comprising: a plurality of functional modules;

wherein each functional module corresponds to at least one functional unit respectively, and each functional unit corresponds to a plurality of functional operation point subunits respectively;

the functional module comprises at least one of the following: the system comprises a purchase management module, a sales management module and a warehouse management module;

The purchase management module is used for managing material purchase information, and comprises at least one of the following: a purchase order function unit, a purchase warehouse-in function unit and a purchase return function unit;

the sales management module is used for managing material sales, and comprises at least one of the following: a sales order function unit, a sales delivery function unit, and a sales return function unit;

the warehouse management module is used for managing material warehouse-in and warehouse-out, and comprises at least one of the following: a material warehouse-in functional unit, a material warehouse-out functional unit and a material transfer warehouse-out;

the business data corresponding to each functional module is stored in a business-in-business-out data association table, the purchase management module, the sales management module and the warehouse management module all manage the business data through the business-in-business-out data association table, the attribute of the business-in-business-out data association table comprises a type and a subtype, and the business data comprises at least one of the following: identity number and number; and the business data in the purchase management module, the sales management module and the warehouse management module are correlated through the identity numbers in the stock data correlation table.

2. The system of claim 1, wherein the functional module further comprises at least one of: the system comprises a basic data module, a production management module, a work order management module, a quality management module, a material management module, a traceability management module, a report query module and a visual large screen module;

the basic data module is used for managing basic data, and comprises at least one of the following: a supplier information function unit, a customer information function unit, a warehouse information function unit, a production unit function unit, a capacity information function unit, a defect information function unit, and a production calendar function unit;

the production management module is used for managing a production plan, and comprises at least one of the following: a production plan functional module and a production plan Gantt chart functional module;

the work order management module is used for managing material work order information, and comprises at least one of the following: a work order information function unit and a work report information function unit;

the quality management module is used for managing the quality of materials, and comprises: a quality management function unit;

The material management module is used for managing material information, and comprises at least one of the following: a material information functional unit and a measurement unit functional unit;

the traceability management module is used for managing the bar codes of the materials, and comprises: a material bar code management function unit;

the report query module is used for querying and managing the material report, and comprises at least one of the following: the system comprises a material stock function unit, a purchase statistics function unit, a sales statistics function unit, a warehouse entry detail function unit, a warehouse exit detail function unit, a material allocation detail function unit, a warehouse entry summarization function unit, a warehouse exit summarization function unit and a warehouse entry, sales and storage statistics function unit;

the visual large screen module is used for performing visual display according to at least one preset display service; and generating corresponding display business according to the data in the module to be visualized.

3. The system of claim 2, wherein the functional module further comprises: an extension item information module;

wherein the extension information module comprises at least one of the following: visual design functional unit, personal office functional unit, task center functional unit, message center functional unit, flow engine functional unit, print template functional unit, integration center functional unit, element center functional unit, portal engine functional unit, online development functional unit, system management functional unit and log center functional unit.

4. The system of claim 1, wherein in the background database, the types include at least one of: ex-warehouse type, warehouse-in type, and other types; the subtype corresponding to the ex-warehouse type comprises at least one of the following: other delivery, sales delivery, purchasing return, allocating delivery; the subtype corresponding to the warehouse-in type comprises at least one of the following: purchasing, warehousing, other warehousing, selling and returning; the subtype corresponding to the other type comprises at least one of the following: sales orders and purchase orders.

5. The system of claim 1, wherein in the front end, the types include at least one of: sales type, procurement type, and other types; the subtype corresponding to the sales type comprises at least one of the following: sales order sub-types, sales delivery sub-types, and sales return sub-types; the subtype corresponding to the purchase type comprises at least one of the following: purchasing order list type, purchasing warehouse-in subtype and purchasing return subtype; other types of material subtypes include at least one of the following: other ex-warehouse sub-types, other warehouses, and dial ex-warehouse.

6. The system of claim 2, wherein the base data module is provided with a plurality of base data tables, each unit corresponds to one base data table or a plurality of units corresponds to one base data table, and the entry and exit data tables are linked with the base data tables through a field mobilizing interface.

7. The system of claim 1, further comprising, in the background database: a material table, a material relation table and a material inventory table;

the entry and sales data association table is respectively associated with a material table, a material relation table and a material inventory table through at least one type of association key in the background database; the associated keys of the entry and sales data associated table comprise an entry and sales main key, an entry and sales first external key and an entry and sales second external key; the associated key of the material table comprises a material main key; the associated key of the material relation table comprises a first material relation external key and a second material relation external key; the associated keys of the material inventory list comprise a material inventory main key and a material inventory external key;

the first external key of the entry and sales data association table is associated with the main key of the materials in the materials table; a first external key and a second external key of the material relation table are associated with a main key of the material in the material table; and the material stock external key of the material stock table is associated with the material main key in the material table.

8. A manufacturing execution method, characterized by comprising:

when the target functional unit receives a material receiving and dispatching instruction, analyzing the material receiving and dispatching instruction to obtain a target material receiving and dispatching identity number and a target material receiving and dispatching quantity;

According to the material identity numbers of the target receiving and dispatching material in the stock-in and stock-out data association table corresponding to the material database, carrying out matching inquiry, and if matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target receiving and dispatching material identity numbers;

judging whether the current material quantity meets the target material receiving and sending quantity, if yes, determining that a material receiving and sending instruction is met, carrying out data processing on the current material type, the current material subtype and the current material quantity, and updating the material database.

9. The method of claim 8, further comprising, after said determining whether said current quantity of material meets said target transceiving material quantity:

if not, determining that the material receiving and dispatching instruction is not satisfied, returning to the operation of the upper interface, and feeding back a material receiving and dispatching failure instruction to the user.

10. A manufacturing execution device, characterized by comprising:

the system comprises a target material receiving and dispatching identity number and target material receiving and dispatching number determining module, a target material receiving and dispatching number determining module and a target material receiving and dispatching number determining module, wherein the target material receiving and dispatching number determining module is used for analyzing a material receiving and dispatching command when a target functional unit receives the material receiving and dispatching command to obtain a target material receiving and dispatching identity number and a target material receiving and dispatching number;

The matching inquiry module is used for carrying out matching inquiry according to the material identity number of the target receiving and sending material identity number in the stock data association table corresponding to the material database, and if the matching is determined, acquiring the current material type, the current material subtype and the current material quantity corresponding to the target receiving and sending material identity number;

and the material receiving and dispatching instruction satisfaction module is used for judging whether the current material quantity meets the target material receiving and dispatching quantity, if yes, determining that the material receiving and dispatching instruction is met, processing the current material type, the current material subtype and the current material quantity, and updating the material database.