CN105160510A - Method and apparatus for automatically matching materials in material instant stock - Google Patents
Method and apparatus for automatically matching materials in material instant stock Download PDFInfo
- Publication number
- CN105160510A CN105160510A CN201510526842.5A CN201510526842A CN105160510A CN 105160510 A CN105160510 A CN 105160510A CN 201510526842 A CN201510526842 A CN 201510526842A CN 105160510 A CN105160510 A CN 105160510A
- Authority
- CN
- China
- Prior art keywords
- target material
- field
- information
- weights
- power
- 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.)
- Granted
Links
Abstract
The present invention provides a method for automatically matching materials in a material instant stock. The method comprises: acquiring information of a target material; acquiring a weight of the target material according to the information of the target material; finding out materials that have the same weight as the target material in a material instant stock database; matching the target material among the found materials that have the same weight as the target material; and updating the number of matched materials in the material instant stock database. With adoption of the method for automatically matching the materials in the material instant stock database, matching is directly performed by means of the weight without the need for performing matching on all material information in the material database, so that the matching range is reduced, and the search efficiency of the materials is improved. Furthermore, the present invention further provides an apparatus for automatically matching the materials in the material instant stock.
Description
Technical field
The present invention relates to Computer Applied Technology field, particularly relate to the method and apparatus of material in a kind of Auto-matching material just in time inventory.
Background technology
Current increasing enterprise use ERP (EnterpriseResourcePlanning, Enterprise Resources Plan) system carries out the management to material.And more for material variety or that portfolio is larger enterprise, the data volume in the material just in time inventory database in its ERP system is also larger.The field that material in material just in time inventory database relates generally to is numerous, as comprised: name of material, quantity, warehouse title, bin name, lot number, secondary attribute, supplier, storage code, location code and secondary attribute code etc.
Traditional material matching process, need to carry out mating of material information to all materials in material just in time inventory database with target material, to find out the target material in material just in time inventory database, its recall precision is low.
Summary of the invention
Based on this, be necessary for above-mentioned technical matters, a kind of method and apparatus that can improve material in the Auto-matching just in time inventory of material recall precision is provided.
A method for material in Auto-matching material just in time inventory database, described method comprises: obtain target material information; The weights of target material according to described target material acquisition of information; The material with described target material with identical weights is found out in material just in time inventory database; Mate described target material having in the material of identical weights with described target material described in finding out; Upgrade the quantity of the material in the described material just in time inventory database matched.
Wherein in an embodiment, described target material packets of information draws together multiple field and information corresponding to each field; The step of the weights of described target material according to described target material acquisition of information, comprising: obtain the power and position value that each field in described target material information is corresponding; Power and position value corresponding to cumulative described each field obtains weights corresponding to target material.
Wherein in an embodiment, the step of the power and position value that each field in described acquisition described target material information is corresponding, comprise: if the corresponding informance of the field in the described target material information obtained is for empty, the power and position value that then this field is corresponding is 0, if be not empty, then obtain the power and position value that this field is corresponding.
Wherein in an embodiment, described in there is power and position value field comprise rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
Wherein in an embodiment, the step of described acquisition target material information, comprising: the Quick Response Code that scanning target material is corresponding, reads each field in Quick Response Code and information corresponding to each field.
A device for material in Auto-matching material just in time inventory, described device comprises: material information acquisition module, for obtaining target material information, the weights of target material according to described target material acquisition of information; Material matching module, for finding out the material with described target material with identical weights in material just in time inventory database, mates described target material having in the material of identical weights with described target material described in finding out; Material update module, for upgrading the quantity of the material in the described material just in time inventory database that matches.
Wherein in an embodiment, described target material packets of information draws together multiple field and information corresponding to each field; Described target material data obtaining module comprises: material power and position value acquisition module, for obtaining power and position value corresponding to each field in described target material information; Material weights acquisition module, the power and position value corresponding for cumulative described each field obtains weights corresponding to target material.
Wherein in an embodiment, if the described material power and position value acquisition module corresponding informance of field be used in the described target material information obtained be empty, then the power and position value that this field is corresponding is 0, if be not sky, then obtains the power and position value that this field is corresponding.
Wherein in an embodiment, the field with power and position value comprises rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
Wherein in an embodiment, described material information acquisition module, for scanning Quick Response Code corresponding to target material, reads each field in Quick Response Code and information corresponding to each field.
The method and apparatus of material in above-mentioned Auto-matching just in time inventory, by obtaining target material information; The weights of target material according to described target material acquisition of information, and in material just in time inventory database, find out the material with the weights identical with described target material; Then in the material described in finding out with the weights identical with described target material, described target material is mated; Upgrade the quantity of the material in the described just in time inventory matched.Like this, do not need to mate all material informations in material data storehouse, but directly mated by weights, thus reduce matching range, improve the recall precision of material.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the method for material in Auto-matching material just in time inventory database in an embodiment;
Fig. 2 is the schematic diagram of target material information and Quick Response Code thereof in an embodiment;
Fig. 3 is the partial material information schematic diagram in an embodiment in material just in time inventory database;
Fig. 4 is the schematic diagram of the quantity of the material upgraded in an embodiment in the material just in time inventory database that matches;
Fig. 5 is the schematic flow sheet according to the step of the weights of target material acquisition of information target material in an embodiment;
Fig. 6 is the structured flowchart of the device of material in Auto-matching material just in time inventory database in an embodiment;
Fig. 7 is the structured flowchart of target material data obtaining module in an embodiment.
Embodiment
In one embodiment, as shown in Figure 1, provide the method for material in a kind of Auto-matching just in time inventory, the method comprises the following steps:
Step 102, obtains target material information.
Concrete, target material is the material treating to obtain from material just in time inventory.Due to the material storing One's name is legion in the timely stock of material, kind grows prosperity, therefore, need, by using ERP system to set up a material timely inventory database corresponding with the timely stock of material, to record the material information in the timely stock of material by this database.Material information includes the field of material, and the information corresponding to field.Ordinary material comprises multiple field, as name of material, actual quantity received, rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier etc.Accordingly, also comprise the information corresponding with field, if name of material is mobile phone diode, actual quantity received is 300, and rewinding warehouse is finished bin, and lot number is 111 etc.
By obtaining target material information, storage location in rewinding warehouse of the title of target material, target material and quantity required can be known.
In one embodiment, obtain the step of target material information, comprise the Quick Response Code that scanning target material is corresponding, read each field in Quick Response Code and information corresponding to each field.
Along with the widespread use of Quick Response Code, target material information can being made Quick Response Code, by scanning this Quick Response Code, according to Quick Response Code analytical algorithm, obtaining target material information.
Such as, by the Quick Response Code on the right side of scintigram 2, the field of the material obtained is name of material, actual quantity received, rewinding warehouse, position in storehouse, lot number and secondary attribute; Information corresponding to each field obtained is respectively: mobile phone diode, 300.0000, finished bin, SB113N finished bin, 111 and blue.Like this, only need scan this Quick Response Code and can know the information obtaining required feeding.
Step 104, according to the weights of target material acquisition of information target material.
In the present embodiment, the weights that can pre-set material give rule, to different material informations, give weights corresponding with it.Concrete, different weights can being given to different classes of material, making the weights according to giving can distinguish different classes of material.Such as, the material of the attributive classification of material to different attribute can be utilized to give different weights; Also different weights can be given to the material being stored in different warehouse.Like this, after getting target material information, rule can be given according to the weights pre-set, get the weights of target material.
Step 106, finds out the material with target material with identical weights in material just in time inventory database.
As shown in Figure 3, the warehouse title of the material in material just in time inventory database, bin name and amount field be the rewinding warehouse of corresponding target material, rewinding position in storehouse and actual quantity received field respectively.Same, also can give rule according to above-mentioned identical weights, pre-set the weights of the material in material just in time inventory database.
If there are not weights row in the material just in time inventory database read, then for this material just in time inventory database increases weights row newly.Give rule according to above-mentioned weights, calculate the weights of each material, and write the weights row of this material.
In the present embodiment, when after the weights getting target material, the material with target material with identical weights can be found out in material just in time inventory database.Concrete, only need the weights removing to mate target material in the weights row of material just in time inventory database, and need not all material informations all be mated.
If do not go out the material with target material with identical weights at material just in time inventory database lookup, then illustrate in this just in time inventory database there is not this target material.Now, the information that there is not target material can be shown.
Step 108, mates target material having in the material of identical weights with target material of finding out.
If what find out in material just in time inventory database has the material of identical weights with target material, then what illustrate that required material may be included in that this finds out has among the material of identical weights with target material.Now, continue to find out to have in the material of identical weights with target material mate target material at this.Like this, materials different for weights with it can be got rid of, reduce matching range, improve recall precision.
If find out and have among the material of identical weights at this with target material, do not match target material, then can show the information that there is not target material equally.
Step 110, upgrades the quantity of the material in the material just in time inventory database matched.
In the present embodiment, if match target material having in the material of identical weights with target material, then according to the information updating material just in time inventory database matching of the correspondence of the actual quantity received comprised in the target material obtained to target material in information corresponding to instant amount field.
Such as, get target material as shown in Figure 2, and give rule and this target material information according to weights, getting its weights is 111100.Then in the material just in time inventory database shown in Fig. 3, the material that weights are also 111100 is found out, and be mate target material in the material of 111100 at weights, upgrade the quantity (as shown in Figure 4) of the material in the material just in time inventory database matched.
By the method for material in above-mentioned Auto-matching just in time inventory, weights are given in advance to each material, make when needing to find out target material in material just in time inventory database, and when it being reduced according to requirement, first can carry out weights coupling, search target material at the material of the identical weights matched.Like this, just reduce matching range, improve the recall precision of material.
In one embodiment, as shown in Figure 5, according to the step of the weights of target material acquisition of information target material, comprising:
Step 502, the power and position value that each field in acquisition target material information is corresponding.
In the present embodiment, can come for it gives weights according to the field of material in advance, and give different power and position values to different fields.Concrete, to all fields all right of distribution place values, also only can give power and position value to part field.As being the name of material field distribution binary weight place value 100 of belongings material, for rewinding warehouse field distributes binary weight place value 1000 etc.
Further, in one embodiment, if the corresponding informance of the field in the target material information obtained is empty, then the power and position value that this field is corresponding is 0, if be not empty, then obtains the power and position value that this field is corresponding.
In the present embodiment, if include a certain field in the target material obtained, but information corresponding to this field be empty, namely think acquisition target material in the power and position value of this field be 0.Being set to 0 by the power and position value of the field by corresponding informance being sky, making when adopting indexed mode to search target material, convenient is that empty situation is got rid of by the corresponding informance of field, loses efficacy to avoid index.
Step 504, power and position value corresponding to cumulative each field obtains weights corresponding to target material.
Concrete, the power and position value corresponding to the field respectively with power and position value added up, the accumulated value obtained is the weights of this target material.Like this, can know that target material specifically contains the field which has been endowed power and position value according to these weights, further increase the matching efficiency to target material in material just in time inventory database.
In one embodiment, the field with power and position value comprises rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
Preferably, binary numeral is given as its power and position value to the above-mentioned field with power and position value.Such as, binary weight place value 100000,10000,1000,100,10 and 1 can be given to rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field respectively.If contain above-mentioned field in the target material information obtained, and the information in corresponding field is not empty, then this field has the power and position value of the correspondence of above-mentioned imparting; If the field in the target material information obtained does not belong to above-mentioned imparted power and position value, then its value is similarly empty.According to the method described above, for target material as shown in Figure 2, can know that the power and position value of this target material is 111100.
Same, also give power and position value to the material in just in time inventory database according to the method described above, and cumulatively obtain its weights, be recorded among weights row.
Then the numerical value that only need find out in instant inventory database in all weights row is the material of 111100, and the numerical value in all weights row found out is in the material of 111100 and is not that empty corresponding field information is mated in target material, find out required material, and 300 are reduced to it, as shown in Figure 4.
In one embodiment, as shown in Figure 6, provide the device of material in a kind of Auto-matching material just in time inventory database, this device comprises:
Material information acquisition module 602, for obtaining target material information, according to the weights of target material acquisition of information target material.
Material matching module 604, for finding out the material with target material with identical weights in material just in time inventory database, mates target material having in the material of identical weights with target material of finding out.
Material update module 606, for upgrading the quantity of the material in the material just in time inventory database that matches.
In one embodiment, target material packets of information draws together multiple field and information corresponding to each field.In the present embodiment, as shown in Figure 7, target material data obtaining module 602 comprises:
Material power and position value acquisition module 702, for obtaining power and position value corresponding to each field in target material information.
Material weights acquisition module 704, the power and position value corresponding for cumulative each field obtains weights corresponding to target material.
In one embodiment, if material power and position value acquisition module 704 be also empty for the corresponding informance of field in the target material information that obtains, then the power and position value that this field is corresponding is 0, if be not sky, then obtains the power and position value that this field is corresponding.
In one embodiment, the field with power and position value comprises rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
In one embodiment, material information acquisition module 602, also for scanning Quick Response Code corresponding to target material, reads each field in Quick Response Code and information corresponding to each field.
Each technical characteristic of the above embodiment can combine arbitrarily, for making description succinct, the all possible combination of each technical characteristic in above-described embodiment is not all described, but, as long as the combination of these technical characteristics does not exist contradiction, be all considered to be the scope that this instructions is recorded.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. the method for material in Auto-matching material just in time inventory, described method comprises:
Obtain target material information;
The weights of target material according to described target material acquisition of information;
The material with described target material with identical weights is found out in material just in time inventory database;
Mate described target material having in the material of identical weights with described target material described in finding out;
Upgrade the quantity of the material in the described material just in time inventory database matched.
2. method according to claim 1, is characterized in that, described target material packets of information draws together multiple field and information corresponding to each field;
The step of the weights of described target material according to described target material acquisition of information, comprising:
Obtain the power and position value that each field in described target material information is corresponding;
Power and position value corresponding to cumulative described each field obtains weights corresponding to target material.
3. method according to claim 2, is characterized in that, the step of the power and position value that each field in described acquisition described target material information is corresponding, comprising:
If the corresponding informance of the field in the described target material information obtained is empty, then the power and position value that this field is corresponding is 0, if be not empty, then obtains the power and position value that this field is corresponding.
4. according to the method in claim 2 or 3, it is characterized in that, the field with power and position value comprises rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
5. method according to claim 1, is characterized in that, the step of described acquisition target material information, comprising:
The Quick Response Code that scanning target material is corresponding, reads each field in Quick Response Code and information corresponding to each field.
6. the device of material in Auto-matching material just in time inventory, it is characterized in that, described device comprises:
Material information acquisition module, for obtaining target material information, the weights of target material according to described target material acquisition of information;
Material matching module, for finding out the material with described target material with identical weights in material just in time inventory database, mates described target material having in the material of identical weights with described target material described in finding out;
Material update module, for upgrading the quantity of the material in the described material just in time inventory database that matches.
7. device according to claim 6, is characterized in that, described target material packets of information draws together multiple field and information corresponding to each field; Described target material data obtaining module comprises:
Material power and position value acquisition module, for obtaining power and position value corresponding to each field in described target material information;
Material weights acquisition module, the power and position value corresponding for cumulative described each field obtains weights corresponding to target material.
8. device according to claim 7, it is characterized in that, if the described material power and position value acquisition module corresponding informance of field be used in the described target material information obtained be sky, then the power and position value that this field is corresponding is 0, if be not empty, then obtain the power and position value that this field is corresponding.
9. the device according to claim 7 or 8, is characterized in that, the field with power and position value comprises rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, the term of validity and supplier's field.
10. device according to claim 6, is characterized in that, described material information acquisition module, for scanning Quick Response Code corresponding to target material, reads each field in Quick Response Code and information corresponding to each field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510526842.5A CN105160510B (en) | 2015-08-25 | 2015-08-25 | The method and apparatus of material in Auto-matching material just in time inventory |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510526842.5A CN105160510B (en) | 2015-08-25 | 2015-08-25 | The method and apparatus of material in Auto-matching material just in time inventory |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105160510A true CN105160510A (en) | 2015-12-16 |
| CN105160510B CN105160510B (en) | 2019-04-05 |
Family
ID=54801361
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510526842.5A Active CN105160510B (en) | 2015-08-25 | 2015-08-25 | The method and apparatus of material in Auto-matching material just in time inventory |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105160510B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107020248A (en) * | 2016-02-02 | 2017-08-08 | 济南兰光机电技术有限公司 | The auto-screening method and system of a kind of packaging detection method |
| CN107025241A (en) * | 2016-02-02 | 2017-08-08 | 济南兰光机电技术有限公司 | The rapid screening method and system of a kind of packaging detection standard |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005284996A (en) * | 2004-03-30 | 2005-10-13 | Toyota Motor Corp | Packing specification determination system and method |
| CN101159051A (en) * | 2007-11-23 | 2008-04-09 | 金蝶软件（中国）有限公司 | Reading board data processing method and reading board application integrating system |
| CN101430778A (en) * | 2008-11-14 | 2009-05-13 | 金蝶软件（中国）有限公司 | Method and apparatus for automatically generating material base data information |
| CN101470860A (en) * | 2007-12-28 | 2009-07-01 | 鸿富锦精密工业（深圳）有限公司 | Warehouse management system and method |
| CN101702219A (en) * | 2009-12-08 | 2010-05-05 | 金蝶软件（中国）有限公司 | Method for generating material information and device thereof |
| CN103761249A (en) * | 2013-12-24 | 2014-04-30 | 北京恒华伟业科技股份有限公司 | Data importing method and system based on data matching |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
-
2015
- 2015-08-25 CN CN201510526842.5A patent/CN105160510B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005284996A (en) * | 2004-03-30 | 2005-10-13 | Toyota Motor Corp | Packing specification determination system and method |
| CN101159051A (en) * | 2007-11-23 | 2008-04-09 | 金蝶软件（中国）有限公司 | Reading board data processing method and reading board application integrating system |
| CN101470860A (en) * | 2007-12-28 | 2009-07-01 | 鸿富锦精密工业（深圳）有限公司 | Warehouse management system and method |
| CN101430778A (en) * | 2008-11-14 | 2009-05-13 | 金蝶软件（中国）有限公司 | Method and apparatus for automatically generating material base data information |
| CN101702219A (en) * | 2009-12-08 | 2010-05-05 | 金蝶软件（中国）有限公司 | Method for generating material information and device thereof |
| CN103761249A (en) * | 2013-12-24 | 2014-04-30 | 北京恒华伟业科技股份有限公司 | Data importing method and system based on data matching |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107020248A (en) * | 2016-02-02 | 2017-08-08 | 济南兰光机电技术有限公司 | The auto-screening method and system of a kind of packaging detection method |
| CN107025241A (en) * | 2016-02-02 | 2017-08-08 | 济南兰光机电技术有限公司 | The rapid screening method and system of a kind of packaging detection standard |
| CN107020248B (en) * | 2016-02-02 | 2019-02-15 | 济南兰光机电技术有限公司 | A kind of auto-screening method and system of packaging detection method |
| CN107025241B (en) * | 2016-02-02 | 2019-09-03 | 济南兰光机电技术有限公司 | A kind of rapid screening method and system of packaging detection standard |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105160510B (en) | 2019-04-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102760258B (en) | The grain storage means of blocking circulation and system | |
| US8589257B2 (en) | Method, system and apparatus for managing inventory | |
| CN103813295B (en) | A kind of method and device for automatically configuring and updating APN parameter | |
| CN102915382A (en) | Method and device for carrying out data query on database based on indexes | |
| CN103745333A (en) | Furniture safe circulation source tracing system and method based on cloud computing | |
| CN1975772B (en) | Method and device for integrating information in multi-system | |
| CN107577787B (en) | Method and system for storing associated data information | |
| CN103605776A (en) | Method and device for processing data of information database | |
| CN104376431A (en) | Engineering project management method and system | |
| CN103064908B (en) | A kind of method by the quick duplicate removal list of internal memory | |
| CN110389890B (en) | Updating and maintaining method and device for public use case library and computer equipment | |
| CN105160510A (en) | Method and apparatus for automatically matching materials in material instant stock | |
| CN109146379A (en) | inventory management method and device | |
| CN103902595A (en) | Method and device for establishing database | |
| CN111104476A (en) | Archive data generation method, archive data generation device, and readable storage medium | |
| CN104484640A (en) | Method of two-dimension code reading end for managing number of reading times of current two-dimension code | |
| CN109388644B (en) | Data updating method and device | |
| CN112001679B (en) | Method and system for improving warehousing cargo allocation efficiency | |
| CN103065106A (en) | Radio frequency identification device (RFID) label scanning recognition method and system | |
| CN110457332B (en) | Information processing method and related equipment | |
| CN108197877A (en) | A kind of improved object scan method | |
| Wanjura et al. | New technologies for managing cotton modules and harvest information | |
| CN109710570B (en) | Nuclear power plant production preparation file management method and system | |
| CN105956815A (en) | Automobile logistics time estimation method and system | |
| CN106022930A (en) | Logistic insurance premium claim settlement method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |