CN105160510B - The method and apparatus of material in Auto-matching material just in time inventory - Google Patents
The method and apparatus of material in Auto-matching material just in time inventory Download PDFInfo
- Publication number
- CN105160510B CN105160510B CN201510526842.5A CN201510526842A CN105160510B CN 105160510 B CN105160510 B CN 105160510B CN 201510526842 A CN201510526842 A CN 201510526842A CN 105160510 B CN105160510 B CN 105160510B
- Authority
- CN
- China
- Prior art keywords
- target material
- field
- information
- weight
- position value
- 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.)
- Active
Links
- 239000000463 material Substances 0.000 title claims abstract description 175
- 238000000034 method Methods 0.000 title claims abstract description 20
- 239000013077 target material Substances 0.000 claims abstract description 135
- 238000010586 diagram Methods 0.000 description 5
- 230000000694 effects Effects 0.000 description 2
- 229910002056 binary alloy Inorganic materials 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of methods of material in Auto-matching material just in time inventory, comprising: obtains target material information；According to the weight of target material acquisition of information target material；The material that there is identical weight with target material is found out in material just in time inventory database；Target material is matched in the material that there is identical weight with target material found out；Update the quantity of the material in the material just in time inventory database being matched to.Using the method for material in the Auto-matching material just in time inventory database, it may not be necessary to match in material data library to all material informations, but directly be matched by weight, to reduce matching range, improve the recall precision of material.In addition, additionally providing a kind of device of material in Auto-matching material just in time inventory.
Description
Technical field
The present invention relates to computer application technologies, more particularly to material in a kind of Auto-matching material just in time inventory
Method and apparatus.
Background technique
Current more and more enterprises use ERP (Enterprise Resource Planning, Enterprise Resources Plan)
System carries out the management to material.And or portfolio biggish enterprise more for material variety, the material in ERP system
Data volume in just in time inventory database is also larger.The field that material in material just in time inventory database relates generally to is numerous,
It such as include: name of material, quantity, warehouse title, bin name, lot number, secondary attribute, supplier, storage code, location code
With secondary attribute code etc..
Traditional material matching process is needed to all materials and the progress of target material in material just in time inventory database
The matching of material information, to find out the target material in material just in time inventory database, recall precision is low.
Summary of the invention
Based on this, it is necessary in view of the above technical problems, provide a kind of Auto-matching that can be improved material recall precision
The method and apparatus of material in just in time inventory.
A kind of method of material in Auto-matching material just in time inventory database, which comprises obtain target material
Information；According to the weight of target material described in the target material acquisition of information；It is found out in material just in time inventory database
There is the material of identical weight with the target material；There is described in find out the object of identical weight with the target material
The target material is matched in material；Update the quantity of the material in the material just in time inventory database being matched to.
The target material information includes multiple fields and the corresponding information of each field in one of the embodiments,；Institute
The step of stating the weight of the target material according to the target material acquisition of information, comprising: obtain the target material information
In the corresponding power and position value of each field；The corresponding power and position value of each field that adds up obtains the corresponding weight of target material.
The step for obtaining the corresponding power and position value of each field in the target material information in one of the embodiments,
Suddenly, comprising: if the corresponding informance of the field in the target material information obtained is sky, the corresponding power and position value of the field
It is 0, if being not sky, obtains the corresponding power and position value of the field.
In one of the embodiments, the field with power and position value include rewinding warehouse, it is rewinding position in storehouse, lot number, auxiliary
Help attribute, validity period and supplier's field.
The step of acquisition target material information in one of the embodiments, comprising: scanning target material is corresponding
Two dimensional code reads each field and the corresponding information of each field in two dimensional code.
The device of material in a kind of Auto-matching material just in time inventory, described device include: that material information obtains module, are used
In obtaining target material information, according to the weight of target material described in the target material acquisition of information；Material matching module is used
In found out in material just in time inventory database with the target material have identical weight material, described in finding out
The target material is matched in the material with the target material with identical weight；Material update module, for updating matching
To the material just in time inventory database in material quantity.
The target material information includes multiple fields and the corresponding information of each field in one of the embodiments,；Institute
Stating target material data obtaining module includes: that material power and position value obtains module, each in the target material information for obtaining
The corresponding power and position value of field；Material weight obtains module, and for adding up, the corresponding power and position value of each field obtains target material
Corresponding weight.
If the material power and position value obtains target material letter of the module for acquisition in one of the embodiments,
The corresponding informance of field in breath is sky, then the corresponding power and position value of the field is 0, if being not sky, it is corresponding to obtain the field
Power and position value.
The field with power and position value includes rewinding warehouse, rewinding position in storehouse, lot number, auxiliary category in one of the embodiments,
Property, validity period and supplier's field.
The material information obtains module and is used to scan the corresponding two dimensional code of target material in one of the embodiments,
Read each field and the corresponding information of each field in two dimensional code.
The method and apparatus of material in above-mentioned Auto-matching just in time inventory, by obtaining target material information；According to described
The weight of target material described in target material acquisition of information, and find out in material just in time inventory database and to have and the mesh
Mark the material of the identical weight of material；Then in the material with weight identical with the target material described in finding out
Match the target material；Update the quantity of the material in the just in time inventory being matched to.This way it is not necessary in material data
All material informations are matched in library, but are directly matched by weight, to reduce matching range, are improved
The recall precision of material.
Detailed description of the invention
Fig. 1 is the flow diagram of the method for material in Auto-matching material just in time inventory database in one embodiment；
Fig. 2 is the schematic diagram of target material information and its two dimensional code in one embodiment；
Fig. 3 is the partial material information schematic diagram in one embodiment in material just in time inventory database；
Fig. 4 is the signal that the quantity of the material in the material just in time inventory database being matched to is updated in one embodiment
Figure；
The process of the step of Fig. 5 is in one embodiment according to the weight of target material acquisition of information target material is illustrated
Figure；
Fig. 6 is the structural block diagram of the device of material in Auto-matching material just in time inventory database in one embodiment；
Fig. 7 is the structural block diagram of target material data obtaining module in one embodiment.
Specific embodiment
In one embodiment, as shown in Figure 1, providing a kind of method of material in Auto-matching just in time inventory, the party
Method the following steps are included:
Step 102, target material information is obtained.
Specifically, target material is the material to obtain from material just in time inventory.Due to being stored in the timely inventory of material
There is material large number of, that type is flouring, therefore, it is necessary to one and the timely inventory couple of material are established by using ERP system
The timely inventory database of the material answered records the material information in the timely inventory of material by the database.Material information packet
Information corresponding to the field and field of material is included.Ordinary material includes multiple fields, as name of material, actual quantity received,
Rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, validity period and supplier etc..Correspondingly, further including letter corresponding with field
Breath, if name of material is mobile phone diode, actual quantity received 300, rewinding warehouse is finished bin, and lot number is 111 etc..
By obtaining target material information, it is known that the storage of the title of target material, target material in rewinding warehouse
Place and quantity required.
In one embodiment, the step of obtaining target material information, including the corresponding two dimensional code of scanning target material, read
Take each field and the corresponding information of each field in two dimensional code.
With the extensive use of two dimensional code, two dimensional code can be made in target material information, by scanning the two dimensional code, root
According to two dimensional code analytical algorithm, to obtain target material information.
For example, the field of obtained material is name of material, actual quantity received, rewinding by the two dimensional code on 2 right side of scanning figure
Warehouse, position in storehouse, lot number and secondary attribute；The obtained corresponding information of each field be respectively as follows: mobile phone diode,
300.0000, finished bin, SB113N finished bin, 111 and blue.Institute is obtained in this way, need to only scan the two dimensional code and can understand
Need the information of feeding.
Step 104, according to the weight of target material acquisition of information target material.
In the present embodiment, the weight that material can be preset assigns rule, and to different material informations, it is right therewith to assign
The weight answered.Specifically, different weights can be assigned to different classes of material, so that can distinguish according to the weight of imparting
Different classes of material.For example, the attributive classification that can use material to assign different weights to the material of different attribute；It can also
Different weights is assigned to the material for being stored in different warehouses.It, can be according to setting in advance in this way, after getting target material information
The weight set assigns rule, gets the weight of target material.
Step 106, the material that there is identical weight with target material is found out 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 difference
Rewinding warehouse, rewinding position in storehouse and the actual quantity received field of corresponding target material.Likewise, can also be according to above-mentioned identical weight
Rule is assigned, the weight of the material in material just in time inventory database is pre-set.
If there is no weights to arrange in the material just in time inventory database read, newly-increased for the material just in time inventory database
Weight column.Rule is assigned according to above-mentioned weight, calculates the weight of each material, and is written into the weight column of the material.
In the present embodiment, after getting the weight of target material, can be found out in material just in time inventory database with
Target material has the material of identical weight.Specifically, it is only necessary to go to match in the weight column of material just in time inventory database
The weight of target material, and all material informations need not all be matched.
If not going out the material that there is identical weight with target material in material just in time inventory database lookup, illustrate this
The target material is not present in just in time inventory database.At this point it is possible to show that there is no the prompt informations of target material.
Step 108, target material is matched in the material that there is identical weight with target material found out.
If what is found out in material just in time inventory database has the material of identical weight with target material, illustrate institute
The material needed is possibly comprised among the material with target material with identical weight found out.At this point, continuing to look at this
It finds out and matches target material in the material that there is identical weight with target material.In this way, material that can be different by weight therewith
It excludes, reduces matching range, improve recall precision.
If finding out among the material that there is identical weight with target material at this, it is not matched to target material, then together
Sample can show that there is no the prompt informations of target material.
Step 110, the quantity of the material in the material just in time inventory database being matched to is updated.
In the present embodiment, if being matched to target material in the material for having identical weight with target material, basis is obtained
The object that the corresponding information update material just in time inventory database matching for the actual quantity received for including in the target material taken arrives
The corresponding information of instant amount field in material.
For example, getting target material as shown in Figure 2, and rule and the target material information are assigned according to weight, obtained
Getting its weight is 111100.Then finding out weight in material just in time inventory database shown in Fig. 3 is also 111100
Material, and target material is matched in the material that weight is 111100, it updates in the material just in time inventory database being matched to
The quantity (as shown in Figure 4) of material.
By the method for material in above-mentioned Auto-matching just in time inventory, weight is assigned to each material in advance, so that when needing
It, can be advanced when finding out target material in material just in time inventory database, and be reduced according to requirement to it
The matching of row weight searches target material in the material for the identical weight being matched to.In this way, just reducing matching range, improve
The recall precision of material.
In one embodiment, the step of as shown in figure 5, according to the weight of target material acquisition of information target material, packet
It includes:
Step 502, the corresponding power and position value of each field in target material information is obtained.
It, can be in advance according to the field of material to assign weight for it in the present embodiment, and different fields is assigned not
Same power and position value.Specifically, can all distribute power and position value to all fields, power and position value only can also be assigned to part field.Such as
It can be the name of material field distribution binary weight place value 100 of all materials, be rewinding warehouse field distribution binary system power and position
Value 1000 etc..
Further, in one embodiment, if the corresponding informance of the field in the target material information obtained is sky,
Then the corresponding power and position value of the field is 0, if being not sky, obtains the corresponding power and position value of the field.
In the present embodiment, if in the target material obtained including a certain field, but the corresponding information of the field is sky,
The power and position value for thinking the field in the target material obtained is 0.By the way that the power and position value that corresponding informance is empty field is arranged
It is 0, so that facilitating the corresponding informance of field is that empty situation excludes, when searching target material using indexed mode to keep away
Exempt from index failure.
Step 504, the corresponding power and position value of each field that adds up obtains the corresponding weight of target material.
Specifically, power and position value corresponding to the field respectively with power and position value is added up, obtained accumulated value is should
The weight of target material.In this way, according to the weight you can learn which target material, which specifically contains, has been assigned power and position value
Field further improves the matching efficiency in material just in time inventory database to target material.
In one embodiment, the field with power and position value includes rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, has
Effect phase and supplier's field.
Preferably, the field to above-mentioned with power and position value assigns binary numeral as its power and position value.For example, can be right respectively
Rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, validity period and supplier's field imparting binary weight place value 100000,
10000,1000,100,10 and 1.If containing above-mentioned field in the target material information obtained, and the letter in corresponding field
Breath is not sky, then the field has the corresponding power and position value of above-mentioned imparting；If the field in the target material information obtained is 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,
You can learn that the power and position value of the target material is 111100.
Likewise, also assigning power and position value to the material in just in time inventory database according to the method described above, and adds up and obtain it
Weight is recorded among weight column.
Then the numerical value in all weight column need to be found out in instant inventory database only as 111100 material, and
Be not empty corresponding field information in the material that the numerical value in all weights column found out is 111100 and in target material into
Row matching, finds out required material, and 300 are reduced to it, as shown in Figure 4.
In one embodiment, as shown in fig. 6, providing material in a kind of Auto-matching material just in time inventory database
Device, the device include:
Material information obtains module 602, for obtaining target material information, according to target material acquisition of information target material
Weight.
Material matching module 604 has identical power with target material for finding out in material just in time inventory database
The material of value matches target material in the material for having identical weight with target material found out.
Material update module 606, for updating the quantity of the material in the material just in time inventory database being matched to.
In one embodiment, target material information includes multiple fields and the corresponding information of each field.In the present embodiment,
As shown in fig. 7, target material data obtaining module 602 includes:
Material power and position value obtains module 702, for obtaining the corresponding power and position value of each field in target material information.
Material weight obtains module 704, obtains the corresponding weight of target material for the corresponding power and position value of each field that adds up.
In one embodiment, if material power and position value obtains in the target material information that module 704 is also used to obtain
The corresponding informance of field is sky, then the corresponding power and position value of the field is 0, if being not sky, obtains the corresponding power and position of the field
Value.
In one embodiment, the field with power and position value includes rewinding warehouse, rewinding position in storehouse, lot number, secondary attribute, has
Effect phase and supplier's field.
In one embodiment, material information obtains module 602 and is also used to scan the corresponding two dimensional code of target material, reads
Each field and the corresponding information of each field in two dimensional code.
Each technical characteristic of embodiment described above can be combined arbitrarily, for simplicity of description, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention
Range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (6)
1. a kind of method of material in Auto-matching material just in time inventory, which comprises
Target material information is obtained, the target material information includes multiple fields and the corresponding information of each field；
According to the weight of the target material acquisition of information target material, comprising: obtain each word in the target material information
The corresponding power and position value of section；The corresponding power and position value of each field that adds up obtains the corresponding weight of target material；
The step of each field for obtaining in the target material information corresponding power and position value, comprising:
If the corresponding informance of the field in the target material information obtained is sky, the corresponding power and position value of the field is 0,
If being not sky, the corresponding power and position value of the field is obtained；
The material that there is identical weight with the target material is found out in material just in time inventory database；
The target material is matched in the material with the target material described in find out with identical weight；
Update the quantity of the material in the material just in time inventory database being matched to.
2. the method according to claim 1, wherein the field with power and position value includes rewinding warehouse, receiving warehouse
Position, lot number, secondary attribute, validity period and supplier's field.
3. the method according to claim 1, wherein the step of acquisition target material information, comprising:
The corresponding two dimensional code of target material is scanned, each field and the corresponding information of each field in two dimensional code are read.
4. the device of material in a kind of Auto-matching material just in time inventory, which is characterized in that described device includes:
Material information obtains module, and for obtaining target material information, the target material information includes multiple fields and each word
The corresponding information of section, according to the weight of the target material acquisition of information target material, the target material data obtaining module
It include: that material power and position value obtains module, for obtaining the corresponding power and position value of each field in the target material information, if obtained
The corresponding informance of the field in the target material information taken is sky, then the corresponding power and position value of the field is 0, if not being
Sky then obtains the corresponding power and position value of the field；Material weight obtains module, and for adding up, the corresponding power and position of each field is worth
To the corresponding weight of target material；
Material matching module has identical weight with the target material for finding out in material just in time inventory database
Material matches the target material in the material with the target material described in find out with identical weight；
Material update module, for updating the quantity of the material in the material just in time inventory database being matched to.
5. device according to claim 4, which is characterized in that the field with power and position value includes rewinding warehouse, receiving warehouse
Position, lot number, secondary attribute, validity period and supplier's field.
6. device according to claim 4, which is characterized in that the material information obtains module for scanning target material
Corresponding two dimensional code reads each field and the corresponding information of each field in two dimensional code.
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 CN105160510A (en) | 2015-12-16 |
| CN105160510B true 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) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107025241B (en) * | 2016-02-02 | 2019-09-03 | 济南兰光机电技术有限公司 | A kind of rapid screening method and system of packaging detection standard |
| CN107020248B (en) * | 2016-02-02 | 2019-02-15 | 济南兰光机电技术有限公司 | A kind of auto-screening method and system of packaging detection method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101159051A (en) * | 2007-11-23 | 2008-04-09 | 金蝶软件（中国）有限公司 | Reading board data processing method and reading board application integrating system |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4400286B2 (en) * | 2004-03-30 | 2010-01-20 | トヨタ自動車株式会社 | Packing specification determining apparatus and method |
| 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 |
| CN103761249B (en) * | 2013-12-24 | 2017-11-28 | 北京恒华伟业科技股份有限公司 | Data lead-in method and system based on Data Matching |
-
2015
- 2015-08-25 CN CN201510526842.5A patent/CN105160510B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101159051A (en) * | 2007-11-23 | 2008-04-09 | 金蝶软件（中国）有限公司 | Reading board data processing method and reading board application integrating system |
| CN104516979A (en) * | 2014-12-31 | 2015-04-15 | 北京锐安科技有限公司 | Data query method and data query system based on quadratic search |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105160510A (en) | 2015-12-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109872036B (en) | Task allocation method and device based on classification algorithm and computer equipment | |
| Basl | Analysis of industry 4.0 readiness indexes and maturity models and proposal of the dimension for enterprise information systems | |
| Gharehgozli et al. | A decision-tree stacking heuristic minimising the expected number of reshuffles at a container terminal | |
| CN106033460A (en) | Address data processing method and apparatus | |
| CN101452487B (en) | Data loading method and system, and data loading unit | |
| CN106055621A (en) | Log retrieval method and device | |
| CN103390258A (en) | Updating and inquiring method and management system of laboratory object information and based on information code | |
| CN103902702A (en) | Data storage system and data storage method | |
| CN1975772B (en) | Method and device for integrating information in multi-system | |
| US8843480B2 (en) | Server, information-management method, information-management program, and computer-readable recording medium with said program recorded thereon, for managing information input by a user | |
| CN107590123A (en) | Vehicle-mounted middle place context reference resolution method and device | |
| CN107577787B (en) | Method and system for storing associated data information | |
| CN109447549B (en) | Method for determining material position and related device | |
| CN103049473A (en) | Data querying method and device | |
| CN101963993B (en) | Method for fast searching database sheet table record | |
| CN109388644B (en) | Data updating method and device | |
| CN105160510B (en) | The method and apparatus of material in Auto-matching material just in time inventory | |
| US9971793B2 (en) | Database management system and database management method | |
| CN109146379A (en) | inventory management method and device | |
| CN105447064B (en) | Electronic map data making and using method and device | |
| CN111192015A (en) | Integrated data management system based on core object | |
| CN107291938A (en) | Order Query System and method | |
| CN105512313B (en) | A kind of method and apparatus of incremented data processing | |
| CN104679904A (en) | Position point query method and device for road network | |
| CN103761316A (en) | Data compression storage method and device based on sparse matrix |
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 |