CN101339635A - Method, system and equipment for determining material demand plan and obtaining material low level code - Google Patents
Method, system and equipment for determining material demand plan and obtaining material low level code Download PDFInfo
- Publication number
- CN101339635A CN101339635A CNA2008101312433A CN200810131243A CN101339635A CN 101339635 A CN101339635 A CN 101339635A CN A2008101312433 A CNA2008101312433 A CN A2008101312433A CN 200810131243 A CN200810131243 A CN 200810131243A CN 101339635 A CN101339635 A CN 101339635A
- Authority
- CN
- China
- Prior art keywords
- low level
- level code
- temporary table
- module
- subitem
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of material management and provides a method for determining the plan of material requirements and obtaining material low level code, a system and a device thereof. The method for determining the plan of material requirements comprises the following steps: A a bill of materials is extracted from a database, and the relation of subordination of material is extracted from the bill of materials; B. a temporary table is established according to the relation of subordination of the material and is converged layer by layer, and the material low level code is obtained based on the convergent process of the temporary table; C. the material requirements of each level is calculated according to the ordinal relation of the low level code, thus determining the plan of the material requirements. Each bill of materials in the process of obtaining the low level code in the invention need not to be processed, and the data in the temporary table can be converged layer by layer, thus greatly reducing calculated amount and improving the efficiency of obtaining the material low level code and determining the plan of the material requirements.
Description
Technical field
The present invention relates to the handling of goods and materials field, more particularly, relate to a kind of definite MRP and obtain method, system and the equipment of material Low Level Code.
Background technology
In product manufacturing enterprise, for supplying client's required product or supply the market demand on time, and can not cause stock, need carry out MRP (Material Requirement Planning is called for short " MRP ").MRP is the plan management of materials and quipment pattern in a kind of product manufacturing enterprise, be meant subordinate and quantitative relation according to the material of each level of product structure, with each material is the plan object, with completion period be the time reference back scheduling, by the time in advance length distinguish the assign plans sequencing of time of each article.Therefore, MRP need calculate the demand of each level material.
The basic Data Source of MRP is Bill of Material (BOM) (Bill of Material is called for short " BOM ").BOM is the technological document of definition product structure, is called product tree, product structure table or BOM table again, and it has indicated the structural relation between the material and the quantity required of every kind of material.
Low Level Code (Low Level Code is called for short " LLC ") is meant a certain material residing lowest hierarchical level in BOM.When expansion MRP carries out MRP, calculating the order of material requirement carries out from top to down, promptly 0 level (highest level) from product begins to calculate, order by Low Level Code is calculated toward the big material of Low Level Code from the little material of Low Level Code, when a certain level that calculates this product (for example 1 layer) but Low Level Code (for example the Low Level Code of material is 2) not simultaneously, then only calculate the material of level height (being that Low Level Code is little), the result of calculation of the material of (being that Low Level Code is greater than the product level that calculates) temporarily stores at the bottom of the level ratio calculating level, total demand can gather storage but not carry out the MRP demand and calculate and raw-material stock's distribution, like this, available tank farm stock priority allocation has been given the material that is in lowermost layer, guaranteed on time that at first the material of demand obtains the stock earlier and distributes, avoided the material of late demand to assign plans in advance and take the stock.Therefore Low Level Code is the computation sequence of MRP.
When prior art is carried out MRP calculating, the method of obtaining Low Level Code adopts the method for circulation recurrence, specifically may further comprise the steps: (1) calculates material residing level in each Bill of Material (BOM), be specially: according to the material subordinate relation in the Bill of Material (BOM), to a certain Bill of Material (BOM), the level of the top father's item of initialization material is 0, calculate the level of material from top to bottom successively, computing formula is: level+1 of the level of subitem material=father's item material, thus successively obtain material residing level in each Bill of Material (BOM); (2) get the maximal value of material level of living in each Bill of Material (BOM), be the Low Level Code of this material.Because prior art needs when obtaining the material Low Level Code one by one Bill of Material (BOM) to be handled, and causes double counting, can not carry out batch processing, causes operational efficiency low.
Therefore need a kind of new earnest material plan of needs really and obtain method, system and the equipment of material Low Level Code, thereby improve operational efficiency.
Summary of the invention
Method, system and equipment that one of purpose of the present invention is to provide a kind of definite MRP and obtains the material Low Level Code are intended to solve the low problem of prior art operational efficiency.
In order to realize goal of the invention, the system of described definite MRP, comprise the database that is used for the storage products Bill of Material (BOM), the Low Level Code acquiring unit that is used to calculate the material Low Level Code, and be used for MRP unit according to the demand of the material of each level of order computation of material Low Level Code
Link to each other with described database and the MRP unit line data of going forward side by side of described Low Level Code acquiring unit is mutual, set up temporary table according to the material subordinate relation of from described Bill of Material (BOM), extracting, and described temporary table successively restrained, obtain the Low Level Code of material based on the convergence process of described temporary table.
Preferably, described Low Level Code acquiring unit comprises:
Tables of data makes up module, sets up temporary table and low level code table according to the material subordinate relation, and described temporary table is successively restrained;
Data processing module, to make up the link to each other line data of going forward side by side of module mutual with tables of data for it, based on the convergence process of described temporary table the low level code table carried out computing, obtains the Low Level Code of material.
Preferably, described tables of data structure module comprises:
The temporary table generation module is set up temporary table according to the material subordinate relation, and extracts the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item, rebuilds temporary table;
Described Low Level Code table generates module, and the line data of going forward side by side of linking to each other with the temporary table generation module is mutual, is used for setting up the low level code table according to described temporary table.
Further preferably, described data processing module comprises:
Search module, be used for searching temporary table father item and the overlapping material of subitem, lookup result is sent computing module;
Computing module, the link to each other line data of going forward side by side of module is mutual with searching, and according to described lookup result the low level code table is carried out computing.
Further preferably, described temporary table generation module is further used for, when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
In order to realize goal of the invention better, the method for described definite MRP may further comprise the steps:
A. from database, extract Bill of Material (BOM), and extraction obtains the material subordinate relation from described Bill of Material (BOM);
B. set up temporary table according to described material subordinate relation, and described temporary table is successively restrained, obtain the Low Level Code of material based on the convergence process of described temporary table;
C. calculate the demand of the material of each level according to the ordinal relation of Low Level Code, determine MRP.
Preferably, described step B further comprises:
B1. according to the material subordinate relation of from described Bill of Material (BOM), extracting, set up temporary table and low level code table;
B2. search and determine father's item and the overlapping material of subitem in the temporary table, and extract the subordinate relation data that described material is positioned at father's item, rebuild temporary table;
B3. based on the process of reconstruction of temporary table the low level code table is carried out computing, obtain the Low Level Code of material.
Preferably, described step B2 also comprises when rebuilding temporary table: the number of times that material occurs at subitem in the record temporary table.
Preferably, described step B2 and step B3 are the parallel processing relations or successively deal with relationship.
Preferably, also comprise after the described step B3:, the Low Level Code of material is sorted according to the ordinal relation of material Low Level Code.
In order to realize goal of the invention better, the described equipment that obtains the material Low Level Code comprises:
Tables of data makes up module, sets up temporary table and low level code table according to the material subordinate relation, and described temporary table is successively restrained;
Data processing module, to make up the link to each other line data of going forward side by side of module mutual with tables of data, based on the convergence process of described temporary table the low level code table carried out computing, obtains the Low Level Code of material.
Preferably, described tables of data structure module comprises:
The temporary table generation module is used for setting up temporary table according to the material subordinate relation, and extracts the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item, rebuilds temporary table;
The Low Level Code table generates module, and the line data of going forward side by side of linking to each other with the temporary table generation module is mutual, is used for setting up the low level code table according to described temporary table;
Preferably, described data processing module comprises:
Search module, be used for searching temporary table father item and the overlapping material of subitem, lookup result is sent computing module;
Computing module, the link to each other line data of going forward side by side of module is mutual with searching, and is used for according to described lookup result the low level code table being carried out computing.
Further preferably, described temporary table generation module is further used for, when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
In order to realize goal of the invention better, the described method of obtaining the material Low Level Code may further comprise the steps:
A '. according to the material subordinate relation of from Bill of Material (BOM), extracting, set up temporary table and low level code table;
B '. to successively restraining in the described temporary table;
C '. the convergence process based on described temporary table is carried out computing to the low level code table, obtains the Low Level Code of material.
Preferably, the convergence among the described step B ' comprises: search and determine father's item and the overlapping material of subitem in the temporary table, and extract the subordinate relation data that described material is positioned at father's item, rebuild temporary table.
Further preferably, described step B ' further comprises: when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
Preferably, described step B ' and step C ' are the parallel processing relations or successively deal with relationship.
Preferably, described step C ' also comprises afterwards: according to the ordinal relation of material Low Level Code, the Low Level Code of material is sorted.
As from the foregoing, the present invention is in the process of obtaining the material Low Level Code, and difference with the prior art do not need to be each Bill of Material (BOM) is handled, and the calculation times maximum only is the number of plies of Bill of Material (BOM) when obtaining the material Low Level Code, has therefore dwindled calculated amount greatly; In addition, in the process of obtaining the material Low Level Code, difference with the prior art is to have set up temporary table according to the material subordinate relation, and can successively restrain the data in the temporary table, thereby has also reduced calculated amount.Therefore the present invention has improved operational efficiency.
Description of drawings
Fig. 1 is a system construction drawing of determining MRP in one embodiment of the present of invention;
Fig. 2 is the equipment structure chart that obtains the material Low Level Code in one embodiment of the present of invention;
Fig. 3 is a method flow diagram of determining MRP in one embodiment of the present of invention;
Fig. 4 is the method flow diagram that obtains the material Low Level Code in one embodiment of the present of invention;
Fig. 5 is the product structure figure in one embodiment of the present of invention;
Fig. 6 is the method flow diagram that obtains the material Low Level Code in one embodiment of the present of invention;
Fig. 7 is the method flow diagram that obtains the material Low Level Code in one embodiment of the present of invention.
In order to make purpose of the present invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with drawings and Examples.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
Embodiment
The present invention has set up temporary table and low level code table, by searching father's item and the overlapping material of subitem in the temporary table, and father's item and the overlapping material of subitem are positioned at the subordinate relation data of father's item in the extraction temporary table, successively restrain temporary table, convergence process based on temporary table is carried out computing to the low level code table, thereby obtains the Low Level Code of material.Because temporary table can successively restrain, only be the number of plies of Bill of Material (BOM) to the operation times maximum of Low Level Code, therefore dwindle calculated amount greatly, thereby improved the efficient of obtaining material Low Level Code and definite MRP.
Fig. 1 shows the system architecture of determining MRP in one embodiment of the present of invention, and this system comprises database 100, Low Level Code acquiring unit 200 and MRP unit 300.Should be noted that the annexation between each equipment is the needs of explaining its information interaction and control procedure for clear in all diagrams of the present invention, therefore should be considered as annexation in logic, and should not only limit to physical connection.Need to prove that in addition the communication mode between each functional module can be taked multiple, protection scope of the present invention should not be defined as the communication mode of certain particular type.Wherein:
Low Level Code acquiring unit 200, mutual with link to each other with MRP unit 300 line data of going forward side by side of database 100, set up temporary table according to the material subordinate relation of from Bill of Material (BOM), extracting, and temporary table is successively restrained, obtain the Low Level Code of material based on the convergence process of temporary table.
The present invention adopts the equipment that obtains the material Low Level Code to realize obtaining of Low Level Code.Fig. 2 shows the equipment that obtains the material Low Level Code in one embodiment of the present of invention.This equipment comprises that tables of data makes up module 201 and data processing module 202, wherein:
Tables of data makes up module 201, and the line data of going forward side by side of linking to each other with data processing module 202 is mutual, is used for setting up temporary table and low level code table according to the material subordinate relation, and temporary table is successively restrained.It comprises that temporary table generation module 2011 and Low Level Code table generate module 2012, wherein:
Temporary table generation module 2011, to generate the link to each other line data of going forward side by side of module 2012 mutual with the Low Level Code table, be used for setting up temporary table, and extract the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item, rebuild temporary table according to the material subordinate relation.The detailed process of setting up temporary table about temporary table generation module 2011 will be described in detail in conjunction with Fig. 3 follow-up.
The Low Level Code table generates module 2012, and the line data of going forward side by side of linking to each other with temporary table generation module 2011 is mutual, is used for setting up the low level code table according to temporary table.
Fig. 3 shows the method flow of determining MRP in one embodiment of the present of invention, and this method is based on system architecture shown in Figure 1, and detailed process is as follows:
In step S301, from database 100, extract Bill of Material (BOM), and extraction obtains the material subordinate relation from Bill of Material (BOM).
In step S302, Low Level Code acquiring unit 200 is set up temporary table according to the material subordinate relation, and temporary table is successively restrained, and obtains the Low Level Code of material based on the convergence process of temporary table.
In step S303, MRP unit 300 calculates the demand of the material of each level according to the ordinal relation of Low Level Code, determines MRP.
Fig. 4 shows the method flow that obtains the material Low Level Code in one embodiment of the present of invention, and this method specifically comprises following step based on system architecture shown in Figure 2:
In step S401, tables of data makes up module 201 and sets up temporary table and low level code table according to the material subordinate relation.In one embodiment, the detailed process of step S401 is: temporary table generation module 2011 is set up temporary table according to the material subordinate relation.Fig. 5 shows the product structure in one embodiment of the present of invention, wherein, production material A needs material B, and production material B needs material C.......Temporary table generation module 2011 is set up temporary table according to this material subordinate relation.In an exemplary scenario, employing father's item and subitem are represented the subordinate relation between the material in the temporary table, and for example: to material A and material B, material A is father's item of material B, and material B is the subitem of material A; To material B and material C, material B is father's item of material C, and material C is the subitem of material B ... and the like, the temporary table that temporary table generation module 2011 is set up is shown in table 1-1:
| Father's item | Subitem |
| A | B |
| B | C |
| C | D |
| M | N |
| N | B |
| B | C |
| C | D |
Table 1-1
The Low Level Code table generates module 2012 and sets up the low level code table.After setting up the low level code table, can establish initial value, in a preferred embodiment, the Low Level Code of all materials is initially 0, and the Low Level Code that upgrades the material that is positioned at subitem is 1 the Low Level Code of material.In an exemplary scenario, after the temporary table shown in his-and-hers watches 1-1, Low Level Code table generated that module 2012 is set up the low level code table and the material Low Level Code established initial value, the low level code table was shown in table 2-1:
| Material | Low Level Code |
| A | 0 |
| M | 0 |
| N | 1 |
| B | 1 |
| C | 1 |
| D | 1 |
Table 2-1
It should be noted that above-mentioned table 1-1 and table 2-1 only are used to explain the process of setting up of temporary table of the present invention and low level code table, temporary table and low level code table are not limited to show the form of 1-1 and table 2-1, also can adopt other form.In addition, cause finally only needs to obtain the ordinal relation of Low Level Code, thereby guarantees the computation sequence of MRP, so the Low Level Code of material also can be initially other numeral, for example the Low Level Code of all materials is initially 1, and the Low Level Code that will be positioned at the material of subitem is updated to 2 etc.
In step S402, data processing module 202 is searched and is determined that father's item and the overlapping material of subitem in the temporary table, tables of data make up module 201 and extract the subordinate relation data that described material is positioned at father's item, rebuilds temporary table.In one embodiment, step S402 is specially: search module 2021 and search father's item and the overlapping material of subitem in the temporary table, as the temporary table of table shown in the 1-1, search that module 2021 finds father's item and the overlapping material of subitem is material B, material C and material N.Temporary table generation module 2011 extracts the subordinate relation data that these materials are positioned at father's item according to this lookup result, rebuilds temporary table.As show among the 1-1, the overlapping material of father's item and subitem is material B, material C and material N, extracts the material subordinate relation data that it is positioned at father's item, the temporary table of reconstruction is shown in table 1-2:
| Father's item | Subitem |
| B | C |
| C | D |
| N | B |
Table 1-2
In step S403, data processing module 202 carries out computing based on the process of reconstruction of temporary table to the low level code table, obtains the Low Level Code of material.In one embodiment, step S403 is specially: computing module 2022 carries out computing based on the process of reconstruction of temporary table to the low level code table, obtains the Low Level Code of material.Afterwards, can the Low Level Code of material be sorted according to the ordinal relation of Low Level Code.
It should be noted that step S402 and step S403 can be concurrency relations, also can be precedence relationship.To be described in detail both of these case below.
Fig. 6 shows the embodiment of step S402 and step S403 parallel processing.Detailed process is as follows:
In step S601, tables of data makes up module 201 and sets up temporary table and low level code table according to the material subordinate relation, and the Low Level Code of initialization material.In an exemplary scenario, temporary table generation module 2011 is set up the temporary table shown in table 1-1, Low Level Code generation unit 2012 is set up the low level code table shown in table 2-1, and the Low Level Code of initialization material, be preferably: the Low Level Code of all materials is initially 0, and the Low Level Code that upgrades the material that is positioned at subitem is 1.
In step S602, search module 2021 and search father's item and the overlapping material of subitem in the temporary table, if having father's item and the overlapping material of subitem, then enter step S603, otherwise, enter step S605.
In step S603, the subitem of the overlapping material of father's item and subitem carries out the Low Level Code computing in 2022 pairs of temporary tables of computing module.In an exemplary scenario, as show the temporary table shown in the 1-1, search module 2021 and find that father's item and the overlapping material of subitem are material B, material C and material N among the table 1-1, be that material C, material D and material B carry out the Low Level Code computing then to its subitem, preferably, be material C, material D and material B to be carried out Low Level Code add 1.At this moment, the low level code table of material is shown in table 2-2:
| Material | Low Level Code |
| A | 0 |
| M | 0 |
| N | 1 |
| B | 2 |
| C | 2 |
| D | 2 |
Table 2-2
In step S604, father's item and the overlapping material of subitem are positioned at the subordinate relation data of father's item in the temporary table generation module 2011 extraction temporary tables, rebuild temporary table.In an exemplary scenario, in table 1-1, the overlapping material of father's item and subitem is material B, material C and material N, extracts the subordinate relation data that it is positioned at father's item, rebuilds temporary table shown in table 1-2.
Step is got back to step S602 after setting up new temporary table, and temporary table is searched once more.In one embodiment, temporary table shown in the his-and-hers watches 1-2, find that father's item and the overlapping material of subitem are material B and material C among the table 1-2, enter step S603, the subitem of 2022 couples of material B of computing module and material C, promptly material C and material D carry out the Low Level Code computing, preferably, be material C and material D to be carried out Low Level Code add 1, this moment, the low level code table was shown in table 2-3:
| Material | Low Level Code |
| A | 0 |
| M | 0 |
| N | 1 |
| B | 2 |
| C | 3 |
| D | 3 |
Table 2-3
Step enters step S604 once more afterwards, and father's item and the overlapping material of subitem are positioned at the subordinate relation data of father's item among the extraction table 1-2, rebuilds temporary table shown in table 1-3:
| Father's item | Subitem |
| B | C |
| C | D |
Table 1-3
Step is got back to step S602 once more and is searched afterwards, and father's item and the overlapping material of subitem are carried out the Low Level Code computing, and so circulation does not exist father's item and the overlapping material of subitem in temporary table.For example, in above-mentioned exemplary scenario, temporary table is finally shown in table 1-4:
| Father's item | Subitem |
| C | D |
Table 1-4
This moment, the low level code table was shown in table 2-4:
| Material | Low Level Code |
| A | 0 |
| M | 0 |
| N | 1 |
| B | 2 |
| C | 3 |
| D | 4 |
Table 2-4
At this moment, searched in the temporary table, then entered step S605 less than father's item and the overlapping material of subitem.
At step S605, obtain the Low Level Code of material, according to the ordinal relation of material Low Level Code Low Level Code is sorted.
Should be noted that in the embodiment shown in fig. 6, both can carry out, also can after low level code table of every renewal is step S603, carry out at step S605 to the step that the material Low Level Code sorts.Therefore, the ordered steps in the present embodiment is not limited to above-mentioned described precedence.
Fig. 7 shows the embodiment of step S502 and the aftertreatment of step S503 elder generation.Detailed process is as follows:
In step S701, tables of data makes up module 201 and sets up temporary table and low level code table according to the material subordinate relation, and the Low Level Code of initialization material.In an exemplary scenario, temporary table generation module 2011 is set up the temporary table shown in table 1-1, Low Level Code generation unit 2012 is set up the low level code table shown in table 2-1, and the Low Level Code of initialization material, be preferably: the Low Level Code of all materials is initially 0, and the Low Level Code that upgrades the material that is positioned at subitem is 1.
In step S702, search module 2021 and search father's item and the overlapping material of subitem in the temporary table, if having father's item and the overlapping material of subitem, then enter step S703, otherwise, enter step S705.
In step S703, father's item and the overlapping material of subitem are positioned at the subordinate relation data of father's item in the temporary table generation module 2011 extraction temporary tables, rebuild temporary table, and the number of times that material occurs at subitem in the record temporary table.In an exemplary scenario, father's item and the overlapping material of subitem are positioned at the subordinate relation data of father's item among the temporary table generation module 2011 extraction table 1-1, rebuild temporary table shown in table 1-2, the number of times that material occurs at subitem among the record sheet 1-2, as in table 1-2, material B, material C and material D occur 1 time at subitem.
Get back to step S702, whether father's item and the overlapping material of subitem are arranged in the circulation searching temporary table,, then continue to extract the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item if exist, rebuild temporary table, and the number of times that material occurs at subitem in the record temporary table.In one embodiment, rebuild temporary table shown in table 1-2 and table 1-3, record material B and occur 1 time at subitem, material C and material D occur 2 times at subitem.So circulation does not exist father's item and the overlapping material of subitem up to temporary table, shown in table 1-4, at this moment, recorded material A in the temporary table, material M and material N and appeared as 0 time at subitem, material B goes out item 1 time at subitem, material C goes out item 2 times at subitem, and material C goes out item 3 times at subitem.Enter step S704.
In step S704, the number of times that computing module 2022 occurs at subitem according to material in the temporary table carries out computing to the Low Level Code of material.In a preferred embodiment, operational method is that the initial Low Level Code of material adds the number of times that material occurs at subitem in the temporary table, for example, to material B, initial Low Level Code is 1, subitem occurs 1 time in temporary table, and then the Low Level Code of material is that 2...... calculates successively, obtains the low level code table shown in table 2-4.
At step S705, obtain the Low Level Code of material, according to the ordinal relation of material Low Level Code Low Level Code is sorted.
After obtaining the Low Level Code of material, can calculate material requirement according to the ordinal relation of material Low Level Code, thereby determine MRP.The method of calculating material requirement according to material Low Level Code ordinal relation is a prior art, does not repeat them here.
The above only is preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of being done within the spirit and principles in the present invention, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (19)
1, a kind of system of definite MRP, comprise the database that is used for the storage products Bill of Material (BOM), the Low Level Code acquiring unit that is used to calculate the material Low Level Code, and be used for MRP unit according to the demand of the material of each level of order computation of material Low Level Code, it is characterized in that
Link to each other with described database and the MRP unit line data of going forward side by side of described Low Level Code acquiring unit is mutual, set up temporary table according to the material subordinate relation of from described Bill of Material (BOM), extracting, and described temporary table successively restrained, and the Low Level Code that obtains material based on the convergence process of described temporary table.
2, the system of definite MRP according to claim 1 is characterized in that, described Low Level Code acquiring unit comprises:
Tables of data makes up module, sets up temporary table and low level code table according to the material subordinate relation, and described temporary table is successively restrained;
Data processing module, to make up the link to each other line data of going forward side by side of module mutual with tables of data for it, based on the convergence process of described temporary table the low level code table carried out computing, obtains the Low Level Code of material.
3, the system of definite MRP according to claim 2 is characterized in that, described tables of data makes up module and comprises:
The temporary table generation module is set up temporary table according to the material subordinate relation, and extracts the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item, rebuilds temporary table;
The Low Level Code table generates module, and the line data of going forward side by side of linking to each other with the temporary table generation module is mutual, is used for setting up the low level code table according to described temporary table.
4, the system of definite MRP according to claim 2 is characterized in that, described data processing module comprises:
Search module, be used for searching temporary table father item and the overlapping material of subitem, lookup result is sent computing module;
Computing module, the link to each other line data of going forward side by side of module is mutual with searching, and according to described lookup result the low level code table is carried out computing.
5, the system of definite MRP according to claim 3 is characterized in that, described temporary table generation module is further used for, when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
6, a kind of method of definite MRP is characterized in that, said method comprising the steps of:
A. from database, extract Bill of Material (BOM), and extraction obtains the material subordinate relation from described Bill of Material (BOM);
B. set up temporary table according to described material subordinate relation, and described temporary table is successively restrained, and the Low Level Code that obtains material based on the convergence process of described temporary table;
C. calculate the demand of the material of each level according to the ordinal relation of Low Level Code, determine MRP.
7, the method for definite MRP according to claim 6 is characterized in that, described step B further comprises:
B1. according to the material subordinate relation of from described Bill of Material (BOM), extracting, set up temporary table and low level code table;
B2. search and determine father's item and the overlapping material of subitem in the temporary table, and extract the subordinate relation data that described material is positioned at father's item, rebuild temporary table;
B3. based on the process of reconstruction of temporary table the low level code table is carried out computing, obtain the Low Level Code of material.
8, the method for definite MRP according to claim 7 is characterized in that, described step B2 also comprises when rebuilding temporary table: the number of times that material occurs at subitem in the record temporary table.
9, the method for definite MRP according to claim 7 is characterized in that, described step B2 and step B3 are the parallel processing relations or successively deal with relationship.
10, the method for definite MRP according to claim 7 is characterized in that, also comprises after the described step B3: according to the ordinal relation of material Low Level Code, the Low Level Code of material is sorted.
11, a kind of equipment that obtains the material Low Level Code is characterized in that, comprising:
Tables of data makes up module, sets up temporary table and low level code table according to the material subordinate relation, and described temporary table is successively restrained;
Data processing module, to make up the link to each other line data of going forward side by side of module mutual with tables of data, based on the convergence process of described temporary table the low level code table carried out computing, obtains the Low Level Code of material.
12, the equipment that obtains the material Low Level Code according to claim 11 is characterized in that, described tables of data makes up module and comprises:
The temporary table generation module is used for setting up temporary table according to the material subordinate relation, and extracts the subordinate relation data that father's item and the overlapping material of subitem in the temporary table are positioned at father's item, rebuilds temporary table;
The Low Level Code table generates module, and the line data of going forward side by side of linking to each other with the temporary table generation module is mutual, is used for setting up the low level code table according to described temporary table;
13, the equipment that obtains the material Low Level Code according to claim 11 is characterized in that, described data processing module comprises:
Search module, be used for searching temporary table father item and the overlapping material of subitem, lookup result is sent computing module;
Computing module, the link to each other line data of going forward side by side of module is mutual with searching, and is used for according to described lookup result the low level code table being carried out computing.
14, the equipment that obtains the material Low Level Code according to claim 12 is characterized in that, described temporary table generation module is further used for, when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
15, a kind of method of obtaining the material Low Level Code is characterized in that, said method comprising the steps of:
A '. according to the material subordinate relation of from Bill of Material (BOM), extracting, set up temporary table and low level code table;
B '. described temporary table is successively restrained;
C '. the convergence process based on described temporary table is carried out computing to the low level code table, obtains the Low Level Code of material.
16, the method for obtaining the material Low Level Code according to claim 15, it is characterized in that, convergence among the described step B ' comprises: search and determine father's item and the overlapping material of subitem in the temporary table, and extract the subordinate relation data that described material is positioned at father's item, rebuild temporary table.
17, the method for obtaining the material Low Level Code according to claim 16 is characterized in that, described step B ' further comprises: when rebuilding temporary table, and the number of times that material occurs at subitem in the record temporary table.
18, the method for obtaining the material Low Level Code according to claim 15 is characterized in that, described step B ' and step C ' are the parallel processing relations or successively deal with relationship.
19, the method for obtaining the material Low Level Code according to claim 15 is characterized in that, described step C ' also comprises afterwards: according to the ordinal relation of material Low Level Code, the Low Level Code of material is sorted.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101312433A CN101339635A (en) | 2008-08-01 | 2008-08-01 | Method, system and equipment for determining material demand plan and obtaining material low level code |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008101312433A CN101339635A (en) | 2008-08-01 | 2008-08-01 | Method, system and equipment for determining material demand plan and obtaining material low level code |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101339635A true CN101339635A (en) | 2009-01-07 |
Family
ID=40213699
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008101312433A Pending CN101339635A (en) | 2008-08-01 | 2008-08-01 | Method, system and equipment for determining material demand plan and obtaining material low level code |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101339635A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411731A (en) * | 2010-09-21 | 2012-04-11 | 金蝶软件（中国）有限公司 | Method and device for automatically calculating low level codes |
| CN102467697A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Material demand generation method and system |
| CN105303359A (en) * | 2015-12-09 | 2016-02-03 | 金蝶软件（中国）有限公司 | Method and device of determining material requirement planning |
| CN105389653A (en) * | 2015-10-30 | 2016-03-09 | 广东石油化工学院 | Adaptive material requirement plan (MRP) calculation method |
| CN107506951A (en) * | 2017-10-11 | 2017-12-22 | 金蝶软件（中国）有限公司 | The computational methods and relevant apparatus of a kind of Material Cost |
| CN112381485A (en) * | 2020-11-24 | 2021-02-19 | 金蝶软件（中国）有限公司 | Material demand plan calculation method and related equipment |
| CN116071003A (en) * | 2023-01-28 | 2023-05-05 | 广州智造家网络科技有限公司 | Material demand plan calculation method, device, electronic equipment and storage medium |
-
2008
- 2008-08-01 CN CNA2008101312433A patent/CN101339635A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411731A (en) * | 2010-09-21 | 2012-04-11 | 金蝶软件（中国）有限公司 | Method and device for automatically calculating low level codes |
| CN102411731B (en) * | 2010-09-21 | 2014-02-26 | 金蝶软件（中国）有限公司 | Method and device for automatically calculating low level codes |
| CN102467697A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件（中国）有限公司 | Material demand generation method and system |
| CN105389653A (en) * | 2015-10-30 | 2016-03-09 | 广东石油化工学院 | Adaptive material requirement plan (MRP) calculation method |
| CN105303359A (en) * | 2015-12-09 | 2016-02-03 | 金蝶软件（中国）有限公司 | Method and device of determining material requirement planning |
| CN107506951A (en) * | 2017-10-11 | 2017-12-22 | 金蝶软件（中国）有限公司 | The computational methods and relevant apparatus of a kind of Material Cost |
| CN112381485A (en) * | 2020-11-24 | 2021-02-19 | 金蝶软件（中国）有限公司 | Material demand plan calculation method and related equipment |
| CN116071003A (en) * | 2023-01-28 | 2023-05-05 | 广州智造家网络科技有限公司 | Material demand plan calculation method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101339635A (en) | Method, system and equipment for determining material demand plan and obtaining material low level code | |
| CN108550007B (en) | Goods space optimization method and system for automatic stereoscopic warehouse of pharmaceutical enterprise | |
| CN105787595B (en) | Emergency logistics transfer station site selection method based on improved ant colony algorithm | |
| CN103927643B (en) | A kind of method that large-scale order form treatment optimizes with Distribution path | |
| Chan et al. | Improving the productivity of order picking of a manual-pick and multi-level rack distribution warehouse through the implementation of class-based storage | |
| CN110046865B (en) | Distributed inventory scheduling method | |
| CN110310057B (en) | Goods sorting and goods location processing method, device, equipment and storage medium thereof | |
| CN109886478A (en) | A kind of slotting optimization method of finished wine automatic stereowarehouse | |
| CN110084545A (en) | The integrated scheduling method of more tunnel automatic stereowarehouses based on mixed-integer programming model | |
| CN102663574A (en) | Multi-RGV dynamic scheduling method based on genetic algorithm | |
| CN102799745B (en) | Method for quickly and automatically assembling residual steel plates | |
| CN109636092B (en) | Warehouse goods space allocation method based on double-factor optimization | |
| Saranwong et al. | Product distribution via a bi-level programming approach: Algorithms and a case study in municipal waste system | |
| CN104835022B (en) | A kind of logistics center's dump intelligent decision control system and method based on RFID Yu batch Flow Technique | |
| CN110766194A (en) | Order processing method and device, warehousing system, computer equipment and storage medium | |
| CN102298737A (en) | Customer commitment-oriented order management system and method thereof | |
| CN110751441A (en) | Method and device for optimizing storage position in logistics storage system | |
| CN107146039A (en) | The customized type mixed-model assembly production method and device of a kind of multiple target Collaborative Control | |
| CN110674978A (en) | Task allocation and path planning method for unmanned workshop transportation system | |
| CN103927628A (en) | Order management system and order management method oriented to customer commitments | |
| CN103116641B (en) | Obtain method and the collator of the statistics of sequence | |
| CN110615226B (en) | Storage bit allocation method, device and computer readable storage medium | |
| CN102609830A (en) | Distributing method for logistic warehouse bin locations based on association rule | |
| CN103020767B (en) | Intelligence goes out steel assembly method and device thereof | |
| CN102609784A (en) | Collocation method of iron ores of steel raw material field |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20090107 |