CN106408235A - Method for realizing material unit composite metering in supply chain system - Google Patents
Method for realizing material unit composite metering in supply chain system Download PDFInfo
- Publication number
- CN106408235A CN106408235A CN201610817342.1A CN201610817342A CN106408235A CN 106408235 A CN106408235 A CN 106408235A CN 201610817342 A CN201610817342 A CN 201610817342A CN 106408235 A CN106408235 A CN 106408235A
- Authority
- CN
- China
- Prior art keywords
- metering
- unit
- measurement unit
- compound
- supply chain
- 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
- 238000000034 method Methods 0.000 title claims abstract description 63
- 239000000463 material Substances 0.000 title claims abstract description 57
- 239000002131 composite material Substances 0.000 title abstract 8
- 238000006243 chemical reaction Methods 0.000 claims abstract description 44
- 238000005259 measurement Methods 0.000 claims description 65
- 150000001875 compounds Chemical class 0.000 claims description 47
- 241001347978 Major minor Species 0.000 claims description 8
- 238000004364 calculation method Methods 0.000 claims description 4
- 230000001360 synchronised effect Effects 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000001747 exhibiting effect Effects 0.000 description 2
- 238000012856 packing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Theoretical Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Entrepreneurship & Innovation (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for realizing material unit composite metering in a supply chain system. The realizing process includes firstly adding a composite metering starting identifier to identify the material metering method used currently, creating a table to record information needed during composite metering, defining an interface used for composite metering conversion method, converting a source metering unit to a target metering unit through a prefabricated SQL means, and setting a composite metering display means to display composite metering unit and quantity. Compared with the prior art, the method employs bi-integer combined display of composite metering conversion and display method, and prevents occurrence of unlimited decimal in application of elementary arithmetic in computer. The method is highly practical and has high application value.
Description
Technical field
The present invention relates to field of computer technology, realize material unit in specifically a kind of supply chain system and be combined meter
The method of amount.
Background technology
In pitch-concrete supply chains system, typically can there are multiple measurement units in order in each service link in a material
Counted and shown, but be because that computer system cannot store fraction, so the conversion process in each measurement unit is worked as
In the situation that result of calculation is unlimited decimal usually occurs, cause, in the middle of follow-up quantity is shown, long string of numeral occur, both
The readability reducing, also can reduce the degree of accuracy of subsequent calculations, tail poor.
Based on this, the present invention provides in a kind of supply chain system and realizes the method that material unit is combined metering, by double whole
Number combines cooperation material measuring accuracy and carries out material quantity displaying, while increasing readable, also ensure that subsequent calculations
Degree of accuracy.And original supply chain system can be incorporated on the premise of not damaging legacy data structure, this invention is applied to
All supply chain systems having many measurement units material.
Content of the invention
The technical assignment of the present invention is for above weak point, provides and realizes material unit in a kind of supply chain system again
The method of total amount.
The method that material unit is combined metering is realized, it implements process and is in a kind of supply chain system:
Add compound metering first and enable mark, the metering method currently used to distinguish material;
Establishment table is in order to record the information needing during compound metering;
The interface that definition compound metering conversion method uses, is completed to source measurement unit to mesh by way of prefabricated SQL
The conversion of mark measurement unit;
Setting compound metering exhibition method, completes the displaying of compound measurement unit and quantity.
Described compound metering enables in the material master meter that mark is added on supply chain system, and its storage value is enumerated value, and
Whether enable the compound metering conversion method of definition when identifying whether that material converts between measurement unit with this value, deposited by this
Stored Value is distinguished during material conversion using original system conversion method or compound metering material conversion method.
The information needing during the compound metering of record includes material ID, major-minor measurement unit ID and both coefficient of conversions, in note
Record the compound metering mark in synchronous material master meter during this information.
The interface procedure that described definition compound metering conversion method uses is:Material ID, major-minor metering list are obtained by SQL
Position coefficient of conversion, target measurement unit precision information, calculate target measurement unit quantity and target by way of division remainder
Submeter Board Lot, the two is connected by arithmetic point indications, and by submeter Board Lot according to main metering
Unit precision formats, and interface returns numeric type data.
The process of above-mentioned calculating target measurement unit quantity and target submeter Board Lot is:First according to coefficient of conversion to
Under round the integer amount calculating target measurement unit, calculate the quantity of source measurement unit further according to remainder, finally according to
Target measurement unit precision is attached in target measurement unit quantity.
Compound measurement unit to distinguish main metering unit and submeter unit when showing using arithmetic point, is combined metering
Board Lot to distinguish main metering Board Lot and submeter Board Lot when showing using arithmetic point, that is, be combined metering single
Position show when using " main metering unit. submeter unit " in the form of, compound measurement unit quantity show when employing " analytic accounting
Amount unit. submeter unit " form, submeter Board Lot formats according to main metering unit precision.
Realize material unit in a kind of supply chain system of the present invention and be combined the method for metering compared to the prior art, have
Following beneficial effect:
The method that material unit is combined metering is realized, the method allows user not in a kind of supply chain system of the present invention
In the case of changing original measurement unit and coefficient of conversion definition, major-minor metering is realized by compound measurement unit conversion interface single
The non-decimal metering conversion of interdigit;And the quantity after conversion and measurement unit unit are entered to user by way of can read
Row is shown, the method has good portability, is not limited to single platform, in multiple programs language database language all
Achievable the method, practical, there is good application value.
Brief description
Accompanying drawing 1 realizes schematic diagram for the present invention's.
Specific embodiment
Below in conjunction with the accompanying drawings and specific embodiment the invention will be further described.
As shown in Figure 1, the present invention provides in a kind of supply chain system and realizes the method that material unit is combined metering, specifically
For refer to, how by a kind of method, make supply chain system not use traditional ten when carrying out material metering unit conversion
System division, but combine compound metering conversion and the methods of exhibiting of display using DI, thus having evaded basic four fundamental rules fortune
Calculate the situation that unlimited decimal occurs in computer utility.
It implements process:
First, it is combined the interpolation that metering enables mark.In supply chain system master meter, prefabricated compound metering enables identification field,
Storage value is enumerated value, can be distinguished during material conversion using original system conversion method or the conversion of compound metering material with this value
Method.
2nd, table record material ID, major-minor measurement unit ID and both coefficient of conversions are provided, simultaneously answering in synchronous material master meter
Total amount identifies.
3rd, it is combined the definition of metering conversion method interface.Material ID, major-minor measurement unit coefficient of conversion, mesh are obtained by SQL
The information such as mark measurement unit precision, calculate target measurement unit quantity according to platform using the mode of division remainder and target are auxiliary
Help measurement unit quantity, the two is connected by arithmetic point indications, and by submeter Board Lot according to the list of main metering
Position precision formats, and interface returns numeric type data.
4th, it is combined the definition of metering methods of exhibiting.According to conversion relation, main metering unit and submeter unit are utilized
The mode of arithmetic point combines, and returns compound measurement unit character string.It is particularly well-suited to carry wrapped material.As case. bucket,
Bag. bag etc..
Specifically, in above-mentioned steps:
Increase compound metering and enable mark CompFlag in material master meter, identify whether that material converts between measurement unit
When whether enable compound metering conversion method.
Material master meter adds the CompFlag mark metering method currently used in order to distinguish material, compound metering method with
Add optional mode to exist, simultaneously the original materia metering method of compatible supply chain system.
Add compound metering conversion method:First rounded downwards according to coefficient of conversion during conversion and calculate the whole of target measurement unit
Number quantity, calculates the quantity of source measurement unit, is attached to target meter finally according to target measurement unit precision further according to remainder
In amount Board Lot.
Removed using non-simple decimal scale when being changed from the little measurement unit of granularity to the big measurement unit of granularity
Method, but using the mode divided by remainder after coefficient of conversion by major-minor measurement unit compound storage.
Compound measurement unit to distinguish main metering unit and submeter unit when showing using arithmetic point (.), is combined
Measurement unit quantity to distinguish main metering Board Lot and submeter Board Lot when showing using arithmetic point (.), auxiliary
Measurement unit quantity formats according to main metering unit precision.
When compound measurement unit is shown using " main metering unit. submeter unit " in the form of, compound measurement unit number
Amount show when using " main metering unit. submeter unit " in the form of.Auxiliary measurement unit quantity display format is according to analytic accounting
Amount unit precision formats.
The method has good portability, supports C#, the kinds of platform such as Java, Oracle, SQL Server simultaneously.
Below in conjunction with accompanying drawing to technical scheme detailed description in addition.
1) increase compound measurement unit and enable identification field.
The structure of modification material master meter Materials, adds field CompFlag:
Field number | Field name | Field type | Explanation |
CompFlag | Compound metering mark | char(1) | Compound metering enables mark |
2) establishment table is combined, in order to record, the information needing during metering, to reduce the visit capacity of material master meter, thus improving
Method performance itself.
3) it is combined the content that measurement unit quantity converts in interface.
Compound measurement unit quantity conversion interface is the key content of material thing and metering method, and it can pass through prefabricated
The mode of SQL completes the conversion to source measurement unit to female mausoleum measurement unit.
Code is as follows.
4) obtain compound measurement unit, intercept partial code as follows:
A represents supply chain system in order to record the document of material information from table;MeasureUnits is in supply chain system
Material metering unit table.
The core of the method be exactly according to material conversion type and coefficient of conversion calculate the compound measurement unit of material
And return to system, the compound increased number of readability of measurement unit quantity of cooperation.
By using this present invention, in manufacturing class enterprise, when converting if there is packing material, can be can not be whole
In the case of removing, the main metering Board Lot of accurate display packing thing and the measurement unit quantity of subpack thing.
By specific embodiment above, described those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, described technical field
Technical staff can the different technical characteristic of combination in any, thus realizing different technical schemes.
In addition to technical characteristic described in except description, it is the known technology of those skilled in the art.
Claims (6)
1. realize material unit in a kind of supply chain system and be combined the method for metering it is characterised in that it implements process is:
Add compound metering first and enable mark, the metering method currently used to distinguish material;
Establishment table is in order to record the information needing during compound metering;
The interface that definition compound metering conversion method uses, is completed to source measurement unit to target meter by way of prefabricated SQL
The conversion of amount unit;
Setting compound metering exhibition method, completes the displaying of compound measurement unit and quantity.
2. realize, in a kind of supply chain system according to claim 1, the method that material unit is combined metering, its feature exists
In, described compound metering enables in the material master meter that mark is added on supply chain system, and its storage value is enumerated value, and with this value
Whether enable the compound metering conversion method of definition when identifying whether that material converts between measurement unit, that is, pass through this storage value area
Divide during material conversion using original system conversion method or compound metering material conversion method.
3. realize, in a kind of supply chain system according to claim 1, the method that material unit is combined metering, its feature exists
In the information needing during the compound metering of record includes material ID, major-minor measurement unit ID and both coefficient of conversions, is recording this letter
Compound metering mark in synchronous material master meter during breath.
4. realize, in a kind of supply chain system according to claim 1, the method that material unit is combined metering, its feature exists
In the interface procedure that described definition compound metering conversion method uses is:Material ID is obtained by SQL, major-minor measurement unit is changed
Calculation rate, target measurement unit precision information, calculate target measurement unit quantity and target auxiliary by way of division remainder
Measurement unit quantity, the two is connected by arithmetic point indications, and by submeter Board Lot according to the unit of main metering
Precision formats, and interface returns numeric type data.
5. realize, in a kind of supply chain system according to claim 4, the method that material unit is combined metering, its feature exists
In the process of above-mentioned calculating target measurement unit quantity and target submeter Board Lot is:First taken downwards according to coefficient of conversion
The whole integer amount calculating target measurement unit, calculates the quantity of source measurement unit, finally according to target further according to remainder
Measurement unit precision is attached in target measurement unit quantity.
6. realize, in a kind of supply chain system according to claim 1, the method that material unit is combined metering, its feature exists
In compound measurement unit to distinguish main metering unit and submeter unit, compound measurement unit when showing using arithmetic point
Quantity to distinguish main metering Board Lot and submeter Board Lot when showing using arithmetic point, that is, be combined measurement unit exhibition
When showing using " main metering unit. submeter unit " in the form of, compound measurement unit quantity show when adopt " main metering list
Position. submeter unit " form, submeter Board Lot formats according to main metering unit precision.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610817342.1A CN106408235A (en) | 2016-09-12 | 2016-09-12 | Method for realizing material unit composite metering in supply chain system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610817342.1A CN106408235A (en) | 2016-09-12 | 2016-09-12 | Method for realizing material unit composite metering in supply chain system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106408235A true CN106408235A (en) | 2017-02-15 |
Family
ID=57999032
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610817342.1A Pending CN106408235A (en) | 2016-09-12 | 2016-09-12 | Method for realizing material unit composite metering in supply chain system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106408235A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107705070A (en) * | 2017-09-28 | 2018-02-16 | 金蝶蝶金云计算有限公司 | Material information input method, device, computer equipment in ERP system |
CN109345173A (en) * | 2018-09-30 | 2019-02-15 | 金蝶软件(中国)有限公司 | A kind of method and relevant apparatus that materiel warehouse-out data are determining |
CN110413619A (en) * | 2019-07-31 | 2019-11-05 | 中国南方电网有限责任公司 | Measurement unit method of automatic configuration, device and the terminal device of statistical graph |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101645007A (en) * | 2009-09-07 | 2010-02-10 | 浪潮集团山东通用软件有限公司 | Interface processing method of general quality inspection management software |
CN102063417A (en) * | 2010-12-29 | 2011-05-18 | 东莞宇龙通信科技有限公司 | Unit conversion method, unit conversion system and communication terminal thereof |
CN104574024A (en) * | 2015-01-20 | 2015-04-29 | 宜昌永鑫精工科技有限公司 | ERP remote zero inventory supply chain management system |
-
2016
- 2016-09-12 CN CN201610817342.1A patent/CN106408235A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101645007A (en) * | 2009-09-07 | 2010-02-10 | 浪潮集团山东通用软件有限公司 | Interface processing method of general quality inspection management software |
CN102063417A (en) * | 2010-12-29 | 2011-05-18 | 东莞宇龙通信科技有限公司 | Unit conversion method, unit conversion system and communication terminal thereof |
CN104574024A (en) * | 2015-01-20 | 2015-04-29 | 宜昌永鑫精工科技有限公司 | ERP remote zero inventory supply chain management system |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107705070A (en) * | 2017-09-28 | 2018-02-16 | 金蝶蝶金云计算有限公司 | Material information input method, device, computer equipment in ERP system |
CN109345173A (en) * | 2018-09-30 | 2019-02-15 | 金蝶软件(中国)有限公司 | A kind of method and relevant apparatus that materiel warehouse-out data are determining |
CN109345173B (en) * | 2018-09-30 | 2021-06-08 | 金蝶软件(中国)有限公司 | Method for determining material ex-warehouse data and related device |
CN110413619A (en) * | 2019-07-31 | 2019-11-05 | 中国南方电网有限责任公司 | Measurement unit method of automatic configuration, device and the terminal device of statistical graph |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103853820B (en) | Data processing method and data processing system | |
CN101908039B (en) | Report template customizing system | |
US9058370B2 (en) | Method, system and program product for defining imports into and exports out from a database system using spread sheets by use of a control language | |
US20120072464A1 (en) | Systems and methods for master data management using record and field based rules | |
CN102999506B (en) | A kind of method and apparatus obtaining user's independent access number | |
CN102024062B (en) | Device and method for realizing data dynamic cache | |
CN103559323B (en) | Database implementation method | |
CN103577590A (en) | Data query method and system | |
CN103365998B (en) | A kind of similar character string search method | |
CN101140562A (en) | Method for realizing user-defined report forms | |
CN106408235A (en) | Method for realizing material unit composite metering in supply chain system | |
CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
CN106547841A (en) | A kind of data automatic switching method of Excel XML mappings | |
CN100589101C (en) | Data access method based on the Oracle relational database of routine call interface | |
CN106372044A (en) | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form | |
CN101777073A (en) | Data conversion method based on XML form | |
CN105354272A (en) | Indicator calculating method and system based on dimension combinations | |
CN108416137B (en) | Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing | |
CN103198141A (en) | Data record access control method and device in hierarchical relationship | |
Homeyer et al. | Punched card and calculating machine methods for analyzing lattice experiments including lattice squares and the cubic lattice | |
CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
CN108053225A (en) | A kind of embedded encoded platform and method | |
CN103793784A (en) | Method for leading in organizational structure for position value evaluation system | |
CN103942634A (en) | Group consolidated statement offset number data processing 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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170215 |
|
RJ01 | Rejection of invention patent application after publication |