CN111506782B - Enterprise material purchasing and receiving matching method and system - Google Patents
Enterprise material purchasing and receiving matching method and system Download PDFInfo
- Publication number
- CN111506782B CN111506782B CN202010189440.1A CN202010189440A CN111506782B CN 111506782 B CN111506782 B CN 111506782B CN 202010189440 A CN202010189440 A CN 202010189440A CN 111506782 B CN111506782 B CN 111506782B
- Authority
- CN
- China
- Prior art keywords
- information
- purchase order
- data
- order contract
- waybill
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F18/00—Pattern recognition
- G06F18/20—Analysing
- G06F18/22—Matching criteria, e.g. proximity measures
-
- 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/083—Shipping
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Computational Linguistics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Artificial Intelligence (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Bioinformatics & Computational Biology (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Evolutionary Biology (AREA)
- Evolutionary Computation (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a system for matching material purchasing and receiving of enterprises, wherein the method comprises the following steps: acquiring waybill information sent by a railway information system; acquiring purchase order contract information sent by an internal purchase information system of a buyer; acquiring the vehicle receiving information of the vehicles entering the factory; matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information; and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information. The invention realizes the automatic matching of the iron transport of the purchased goods and materials into the factory for receiving the car.
Description
Technical Field
The invention relates to the technical field of transportation, in particular to a method and a system for matching material purchasing and receiving of enterprises.
Background
In metallurgical enterprises, after raw materials, fuel and other materials needing railway transportation are purchased, a supplier handles railway transportation and carrying procedures, and after loading and unloading, information such as a waybill, vehicle in-transit and the like is generated in a national railway information system. After the road bureau vehicle arrives, the road bureau vehicle enters the travelling factory to be connected in a manual matching mode by using the information of the iron transport and connection of the purchasing materials. The specific flow is as follows: and acquiring vehicle number information through technical equipment such as vehicle number identification and the like, transmitting the vehicle number information to an enterprise internal information system, simultaneously inquiring purchase order contract information by an operator according to a railway on-vehicle paper ticket and taking a material variety and a delivery unit as conditions, manually checking and matching the delivery unit, a departure station, purchase order contract and the like with the railway vehicle number in the enterprise internal information system, manually inputting information such as vehicle departure ticket time, factory entering arrival handover time and the like, and generating a factory entering quality inspection batch number. The manual matching mode of the information of the iron transport and receiving of the purchasing materials has the defects of high error rate of manual information matching, low efficiency of receiving the iron transport and receiving of the purchasing materials, and the like, and has adverse effects on the follow-up quality inspection, metallurgical production, purchasing settlement, local stop pressure drop and other works.
It can be seen that in the process of solving the problems, although enterprises realize intercommunication with a national railway information system to acquire information such as a waybill, a vehicle in-transit and the like, the information of purchasing materials, transporting the materials into a factory and receiving the vehicles is not automatically matched.
Disclosure of Invention
In view of the problems, the application provides a method and a system for matching the purchasing and receiving of the materials of enterprises, which realize the automatic matching of the purchasing and receiving of the materials of the enterprises.
In a first aspect, the present application provides, according to an embodiment of the present application, the following technical solutions:
a method for matching material purchasing and receiving of enterprises comprises the following steps:
acquiring waybill information sent by a railway information system;
acquiring purchase order contract information sent by an internal purchase information system of a buyer;
acquiring the vehicle receiving information of the vehicles entering the factory;
matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information;
and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information.
Preferably, the matching the waybill information with the purchase order contract information to obtain the carrier information of each waybill in the waybill information includes:
Obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
and matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill.
Preferably, after matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrier information of the waybill, the method further comprises:
obtaining second data related to materials, suppliers, carriers, shipments and purchase order contract expiration dates based on the purchase order contract information;
acquiring target carrier data; wherein the target carrier data is any one of the carrier information;
matching in the second data based on the target carrier data to obtain a target purchase order contract; wherein the target purchase order contract is any one of the purchase order contract information;
Judging whether the departure time in the target carrier data is within the valid period of the purchase order contract of the target purchase order contract or not;
if yes, determining that the target carrier data is valid;
if not, feedback is sent to the buyer corresponding to the target purchase order contract, so that the buyer can reproduce the target purchase order contract until the target carrier data are determined to be valid.
Preferably, the matching the carrier information with the pickup information, and confirming the carrier vehicle corresponding to the carrier information includes:
based on the car receiving information, obtaining the car number of the car entering the factory;
matching the car number in the target carrier data with the car number of the factory entering car, and confirming whether the matching is successful or not;
if the car numbers are matched, determining a purchase settlement basis corresponding to the target purchase order contract;
if the purchasing settlement basis is shipping time settlement, determining a vehicle entering a factory matched with the vehicle number in the target carrier data as the carrier vehicle;
and if the purchase settlement basis is the arrival time settlement, and the arrival time of the arrival vehicle is within the effective period of the purchase order contract, determining the arrival vehicle matched with the vehicle number in the target carrier data as the carrier vehicle.
Preferably, the obtaining second data related to materials, suppliers, carriers, shipments, and purchase order contract validity period based on the purchase order contract information includes:
based on the purchase order contract information, obtaining a purchase order contract number, a product name code, a material code, a supplier, a carrier, an issuing station, a purchase order contract effective period and a purchase settlement basis of each contract;
constructing a purchase order basic data table based on the purchase order contract number, the name code, the material code, the supplier, the carrier, the departure station, the purchase order contract effective period and the purchase settlement basis; wherein the purchase order base data table is the second data.
Preferably, the obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information includes:
acquiring supplier, shipper, carrier and material codes of each contract based on the purchase order contract information;
constructing a comparison relation static data table based on the supplier, the shipper, the carrier and the material codes; wherein the control relationship static data table is the first data.
Preferably, the matching between the supplier and the departure station based on the same waybill in the first data to obtain the carrying information of the waybill includes:
matching the suppliers and the departure stations of the same waybill in the first data to obtain dynamic relations of the suppliers, the carriers, the departure stations, the material codes, the departure time and the train numbers corresponding to the waybill; wherein the dynamic relationship indicates that each supplier corresponds to a launch site, and one or more carriers;
acquiring the dynamic relation data table based on the dynamic relation corresponding to the waybill information; wherein the dynamic relationship data table is the carrier information.
According to the second aspect, based on the same inventive concept, the present application provides the following technical solutions according to an embodiment of the present application:
an enterprise material procurement pickup matching system, comprising:
the railway information acquisition module is used for acquiring the waybill information sent by the railway information system;
the purchase information acquisition module is used for acquiring purchase order contract information sent by an internal purchase information system of a buyer;
the railway vehicle number information acquisition module is used for acquiring the vehicle receiving information of the vehicles entering the factory;
The supplier information matching module is used for matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information;
and the automatic matching module of the factory-entering and vehicle-receiving information is used for matching the carrying information with the vehicle-receiving information and confirming the carrying vehicle corresponding to the carrying information.
Preferably, the vendor information matching module is further specifically configured to:
obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
and matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill.
In a third aspect, based on the same inventive concept, the present application provides, through an embodiment of the present application, the following technical solutions:
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of any of the first aspects above.
According to the enterprise material purchasing and receiving matching method and device, the freight bill information sent by the railway information system is obtained, the purchase order contract information sent by the internal purchase information system of a buyer is obtained, and the receiving information of the in-factory vehicle is obtained; matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information; and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information. By matching the waybill information and the purchase order contract information and matching the receiving information with the carrying information, the automatic matching of the receiving of the purchasing material iron transportation into the factory is realized, the quick communication response among suppliers, carriers and buyers is realized, the operation efficiency is improved, and the communication cost between the checking of the receiving of the factory and enterprises is greatly reduced.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:
FIG. 1 is a flow chart of a method for matching a material purchase pickup of an enterprise according to a first embodiment of the present invention;
FIG. 2 is a functional block diagram of an enterprise material procurement pickup matching system according to a second embodiment of the invention;
FIG. 3 is a schematic diagram showing a waybill information processing flow in a second embodiment of the invention;
FIG. 4 is a schematic diagram showing a vendor information matching process according to a second embodiment of the present invention;
fig. 5 shows a schematic diagram of a matching flow of a vehicle entering and receiving in a second embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
First embodiment
Referring to fig. 1, a method flowchart of an enterprise material purchasing pickup matching method according to a first embodiment of the present invention is shown.
Specifically, the method comprises the following steps:
step S10: acquiring waybill information sent by a railway information system;
step S20: acquiring purchase order contract information sent by an internal purchase information system of a buyer;
step S30: acquiring the vehicle receiving information of the vehicles entering the factory;
step S40: matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information;
step S50: and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information.
It should be noted that the execution sequence of steps S10 to S30 in this embodiment is not limited.
Step S10: and acquiring the waybill information sent by the railway information system.
In step S10, the railroad information system includes the waybill information of each railroad vehicle and the in-transit information of the vehicle. The waybill information includes a plurality of waybills. The bill information comprises information such as a car number, a car model, a goods name, a departure time, a departure station, a delivery unit, a receiving unit, a shipper record item and the like; the railway vehicle includes information such as a car number, a car model, a departure station, a current station, a goods name, a delivery unit (supplier), a receiving unit, and the like.
Specifically, an information interface may be established with a railway information system. After the railway vehicles are carried and sent, the waybill information is generated in the railway information system, and the vehicle in-transit information is generated every time the railway vehicles pass through one station. The information such as the waybill, the vehicle in transit and the like on the railway information system can be updated or actively pushed to the user.
In addition, in the embodiment, the on-road information of the railway vehicle can be obtained from the railway information system, so that a user can conveniently inquire the specific on-road information of the vehicle according to the departure station, the current station and the vehicle number.
Step S20: and acquiring the contract information of the purchase order sent by the internal purchase information system of the buyer.
In step S20, the purchase order contract information specifically includes information such as a purchase order contract number, a product name and product name code, a material code, a supplier name and code, a carrier name and code, a departure, a purchase order contract expiration date, a purchase settlement basis, and the like. Wherein the purchase order contract information may include one or more contracts. Specifically, an information interface for sharing data externally can be established in the enterprise internal purchasing information system.
Step S30: and acquiring the receiving information of the vehicles entering the factory.
In step S30, the pick-up information of the in-plant vehicle may be acquired in a field manner. Specifically, information such as the number of the railway vehicles entering the factory, the time of entering the factory and the like is collected at the junction of the metallurgical enterprise and the national railway through image recognition technical equipment. The storage may be performed after the pickup information is collected, which may include information of one or more vehicles.
Step S40: and matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information.
In step S40, specifically, the method includes:
step S41: obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
step S42: based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
step S43: and matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill.
In step S43, when matching is performed, the first data of the same suppliers and stops are obtained by searching in the first data according to the suppliers and stops corresponding to each waybill, that is, the carrier data corresponding to each waybill is obtained, specifically, n suppliers correspond to m carrier cases (n, m=1, 2, 3 …), and the carrier cases include specific material codes, departure time, train number, purchase settlement basis, and the like.
Further, in order to improve the matching efficiency, a static data table with a comparison relationship may be constructed as the first data before step S43 in this embodiment, where each data in the data table has uniqueness. The method comprises the following steps:
firstly, acquiring a supplier, a shipper, a carrier and a material code of each contract based on the purchase order contract information; the vendor may include a vendor name and code, the carrier may include a carrier name and code, and further may include a material name or a product name, etc.
Then, based on the supplier, the departure station, the carrier and the material codes, constructing a comparison relation static data table; wherein the control relationship static data table is the first data. The first data table may be updated based on changes in the purchase order contract information.
Further, in step S43, the following preferred embodiments are specifically included:
step S431: matching the suppliers and the departure stations of the same waybill in the first data to obtain dynamic relations of the suppliers, the carriers, the departure stations, the material codes, the departure time and the train numbers corresponding to the waybill; wherein the dynamic relationship indicates that each supplier corresponds to a launch site, and one or more carriers; the dynamic relationship indicates that a plurality of carriers are matched at a supplier and a corresponding departure station for selection, and specifically includes a plurality of carriers, a plurality of material codes, a plurality of departure times, a plurality of car numbers and the like.
Step S432: acquiring the dynamic relation data table based on the dynamic relation corresponding to the waybill information; wherein the dynamic relationship data table is the carrier information.
The dynamic relationship data table can realize flexible determination of target purchase order contracts required to be supplied by suppliers. The processing sequence is realized, and the delivery quality is ensured.
In the carrier information, each piece of data may be matched for an order contract. Before order contract matching is performed, a supplier can determine any item of data in the carrier data as target data through a dynamic relation data table, and before actual delivery is performed, contract time limit judgment needs to be performed to confirm whether the delivery meets the requirement, and the specific implementation process is as follows:
step S401: second data relating to materials, suppliers, carriers, shipments, and purchase order contract expiration dates is obtained based on the purchase order contract information.
In step S401, specifically, based on the purchase order contract information, a purchase order contract number, a name code, a material code, a supplier, a carrier, an issue station, a purchase order contract validity period, and a purchase settlement basis of each contract are obtained; constructing a purchase order basic data table based on the purchase order contract number, the name code, the material code, the supplier, the carrier, the departure station, the purchase order contract effective period and the purchase settlement basis; wherein the purchase order base data table is the second data. Each piece of data in the purchase order base data table has uniqueness. Index lookup of the target purchase order contract can be performed through the purchase order contract number, and all order contract related data are contained in the purchase order basic data table.
Step S402: acquiring target carrier data; wherein the target carrier data is any one of the carrier information. The specific acquisition process may be a search selection for the vendor in the system to which the method is applied. I.e., select a determined supplier, departure, carrier, material code, departure time, and number.
Step S403: matching in the second data based on the target carrier data to obtain a target purchase order contract; wherein the target purchase order contract is any one of the purchase order contract information.
Step S404: and judging whether the departure time in the target carrier data is within the valid period of the purchase order contract of the target purchase order contract.
Step S405: if yes, the target carrier data is determined to be valid. And the target carrier data is proved to be effective in the effective period of the purchase order contract, so that the next step factory vehicle receiving matching can be performed.
Step S406: if not, feedback is sent to the buyer corresponding to the target purchase order contract, so that the buyer can reproduce the target purchase order contract until the target carrier data are determined to be valid. At this time, other carrier data can be selected to match the vehicle receiving of the travelling factory, so that the matching efficiency of the vehicle receiving of the travelling factory is improved, and meanwhile, the manual misoperation is avoided.
Step S50: and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information.
In step S50, matching of the car numbers is mainly adopted when matching is performed, and a purchasing settlement basis is judged. It should be noted that, the purchase settlement basis in the purchase contract is time-efficient, that is, is one purchase settlement basis in a period of time (e.g., the first month), and is another purchase settlement basis in a next period of time (e.g., the second month), which may be the same as or different from the previous month. The purchasing settlement basis is divided into two forms: firstly, taking the delivery time as the standard according to the purchase contract, namely taking a settlement basis (settlement price) corresponding to the time period in which the delivery time is positioned as the settlement basis after receiving the goods, and irrespective of the arrival time; and secondly, taking the arrival time as the standard according to the purchase contract, namely taking a settlement basis (settlement price) corresponding to the time period of the arrival time as the settlement basis after receiving the goods, and irrespective of the delivery time.
Further, the step S50 specifically includes:
step S51: based on the car receiving information, obtaining the car number of the car entering the factory;
step S52: matching the car number in the target carrier data with the car number of the factory entering car, and confirming whether the matching is successful or not;
Step S53: if the car numbers are matched, determining a purchase settlement basis corresponding to the target purchase order contract;
step S54: if the purchasing settlement basis is shipping time settlement, determining a vehicle entering a factory matched with the vehicle number in the target carrier data as the carrier vehicle;
step S55: and if the purchase settlement basis is the arrival time settlement, and the arrival time of the arrival vehicle is within the effective period of the purchase order contract, determining the arrival vehicle matched with the vehicle number in the target carrier data as the carrier vehicle.
After step S52, if the information of "purchase order contract number, supplier, carrier, departure station, material code, departure time, number, purchase settlement basis" is inconsistent with the number check of the incoming vehicle, the correct number cannot be matched. Data errors may occur, and the vehicle number can be manually checked and corrected, and matching is completed after confirmation.
Through steps S53-S55, corresponding carrying information can be obtained according to the contract number information of the purchase order aiming at settlement according to the delivery time, and automatic matching of the in-factory receiving information is completed.
For the settlement according to the arrival time, it is necessary to check whether the time of the arrival of the vehicle meets the expiration date of the purchase order contract. If yes, determining that the contract number of the purchase order is correct, and completing automatic matching of the vehicle entering and receiving factory; if the time of the railway vehicle entering the factory exceeds the effective period of the purchase order contract, alarm information containing information such as a supplier, a carrier, a departure, a material code, a departure time, a purchase settlement basis and the like is fed back to the buyer, and the purchase order contract information of the railway vehicle entering the factory is covered by the effective period of the purchase order contract adjusted in an enterprise internal purchase information system of the buyer, namely, the target purchase order contract is replaced or modified, so that automatic matching of the vehicle entering and taking information is completed.
In this embodiment, the departure time is matched with the valid period of the purchase order contract, and the valid period of the purchase order contract is matched and judged according to the purchase settlement basis when the departure time and the purchase order contract are received, so that the confusion of time management in the process of supplying goods and purchasing is avoided, the operation efficiency among suppliers, carriers and buyers is improved, the quick response is realized, and the checking and communication cost is greatly reduced.
According to the enterprise material purchasing and receiving matching method provided by the embodiment, the freight bill information sent by the railway information system is obtained, the purchase order contract information sent by the internal purchase information system of the buyer is obtained, and the receiving information of the in-factory vehicle is obtained; matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information; and matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information. By matching the waybill information and the purchase order contract information and matching the receiving information with the carrying information, the automatic matching of the receiving of the purchasing material iron transportation into the factory is realized, the quick communication response among suppliers, carriers and buyers is realized, the operation efficiency is improved, and the communication cost between the checking of the receiving of the factory and enterprises is greatly reduced.
Second embodiment
Based on the same inventive concept, a second embodiment of the present invention provides an enterprise material procurement pickup matching system 300. Fig. 2 shows a functional block diagram of an enterprise material procurement pickup matching system 300.
The system 300 includes:
the railway information acquisition module 301 is configured to acquire waybill information sent by a railway information system;
the purchase information acquisition module 302 is configured to acquire purchase order contract information sent by an internal purchase information system of a buyer;
the railway vehicle number information acquisition module 303 is used for acquiring the vehicle receiving information of the factory entering vehicle;
a supplier information matching module 304, configured to match the manifest information with the purchase order contract information, and obtain carrier information of each manifest in the manifest information;
and the factory-entering and car-receiving information automatic matching module 305 is used for matching the carrier information with the car-receiving information and confirming the carrier corresponding to the carrier information.
As an optional implementation manner, the vendor information matching module 304 is further specifically configured to:
obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
Based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
and matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill.
The operation of the system 300 is described in detail below by way of an example.
The enterprise material purchasing and receiving matching system 300 in the embodiment may further include a railway vehicle in-transit information query module in addition to the railway information acquisition module 301, the purchasing information acquisition module 302, the supplier information matching module 304, the railway vehicle number information acquisition module 303 and the factory entering and receiving information automatic matching module 305.
Specifically, the railway information collection module 301 establishes an information interface with a railway information system. After the railway vehicles are carried and sent, the waybill information is generated in the railway information system, and the vehicle in-transit information is generated every time the railway vehicles pass through one station. The railway information system transmits the waybill information, the vehicle in-transit information, and the like to the railway information collection module 301 in real time. After the railway information acquisition module 301 normally receives the waybill and the vehicle in-transit information, the information is stored, and meanwhile, the waybill information is respectively sent to the supplier information matching module 304 and the automatic factory-entering and vehicle-receiving information matching module 305, and the vehicle in-transit information is sent to the railway vehicle in-transit information query module.
Further, the manifest information includes information such as a car number, a car model, a cargo name, departure time, departure stations, shipping units (suppliers), receiving units (buyers), shippers, and records; the railway vehicle in transit includes information such as a car number, a car model, a departure station, a current station, a goods name, a delivery unit (supplier), a receiving unit (buyer), and the like, and the processing procedure of the waybill information can refer to the flow shown in fig. 3.
The procurement information collection module 302 interfaces with an intra-enterprise procurement information system, such as a procurement information system within a metallurgical enterprise. After the new purchase order contract is signed, the purchase order contract information is generated in the enterprise internal purchase information system. The in-enterprise purchase information system sends purchase order contract information to the purchase information collection module 302 in real time. After the purchase information acquisition module 302 normally receives the purchase order contract information, information storage is performed, and simultaneously the purchase order contract information is sent to the supplier information matching module 304 and the in-factory vehicle receiving information automatic matching module 305.
Further, the purchase order contract information includes information such as a purchase order contract number, a product name and code, a material code, a supplier name and code, a carrier name and code, a start station, a purchase order contract expiration date, a purchase settlement basis, and the like.
The railway vehicle number information acquisition module 303 is used for acquiring information such as a factory-entering railway vehicle number, factory-entering time and the like at a junction between an enterprise and a railway (such as a national railway junction) through image recognition technology equipment. After the information such as the car number and the time of entering the factory is collected and stored, the railway car number information collection module 303 sends the railway car number and the time of entering the factory to the automatic matching module 305 of the information of receiving the car in the factory.
The railway vehicle on-road information inquiry module is used for receiving the vehicle on-road information sent by the railway information acquisition module 301. After the vehicle in-transit information is normally received, the railway vehicle in-transit information inquiry module provides a vehicle in-transit information inquiry function.
Further, the vehicle in-transit information inquiry function sets inquiry screening conditions such as departure, current station, railway vehicle number and the like, and after the screening conditions are selected, the vehicle in-transit information inquiry function is realized.
The supplier information matching module 304 is configured to receive the waybill information sent by the railway information collection module 301 and the purchase order contract information sent by the purchase information collection module 302. And establishing a supplier login authorization and authority auditing function according to the name and the code of the supplier in the purchase order contract information, and generating a supplier login account. After the supplier logs in according to the authorized account, the information such as the carrier, the departure, the material code, the departure time, the car number and the like is determined by a selection mode item by item, the system 300 determines the purchase order contract number according to the purchase settlement basis information, and simultaneously sends matching information (namely, the carrier information in the first embodiment) of the purchase order contract number-the supplier-the carrier-the departure-the material code-the departure time-the car number-the purchase settlement basis to the automatic matching module 305 of the in-factory car receiving information. In this embodiment, a specific vendor and carrier matching process is shown in the flowchart of fig. 4.
Further, the item-by-item selection mode can be a drop-down frame selection mode, and the next operation can be performed after all information selection is completed. Specifically, there are m carrier cases (n, m=1, 2, 3 …) for n suppliers, such as the "supplier" column selecting the a supplier, the "carrier" column drop-down box displaying only carrier information related to the a supplier, and so on.
Further, in order to solve the problem that the information is not normally received, the supplier confirms that the railway vehicle is carried and sent, but the information of the waybill such as the train number is not inquired after logging in, the supplier information matching module 304 can trigger the button of 'the received waybill information', the information is fed back to the railway information acquisition module 301 by the supplier information matching module 304, the railway information acquisition module 301 sends an email alarm to the railway information system, and the 'the waybill information' is manually triggered until the waybill information is normally received.
The automatic matching module 305 for receiving the freight list information sent by the railway information acquisition module 301, the purchase order contract information sent by the purchase information acquisition module 302, the railway vehicle number and the time information of the factory entering sent by the railway vehicle number information acquisition module 303, and the matching information of the purchase order contract number, the supplier, the carrier, the departure, the material code, the departure time, the vehicle number and the purchase settlement basis sent by the supplier information matching module 304. In the case that the matching information sent by the supplier information matching module 304 is received before the railway vehicle enters the factory (the railway vehicle number information acquisition module 303 sends the railway vehicle number and the time of entering the factory), the system 300 checks the freight list and the order information and then completes the automatic matching of the information of receiving the railway transportation and the factory. In the case where the matching information transmitted from the supplier information matching module 304 is not received after the railway vehicle enters the factory (the railway vehicle number information acquisition module 303 transmits the railway vehicle number and the time of entering the factory), the system 300 has a function of performing manual information complement and information matching. In this embodiment, a specific matching flow of the incoming and outgoing vehicles is shown in fig. 5.
Further, the manual information complement and information matching function refers to matching the "purchase order contract number-supplier-carrier-departure-material code-departure time-number-purchase settlement basis" information in the system 300 according to the waybill information sent by the railway information acquisition module 301, the purchase order contract information sent by the purchase information acquisition module 302, the railway vehicle number sent by the railway vehicle number information acquisition module 303, and the time-in-factory information or the information complement manner by a manual manner.
It should be noted that, the specific implementation and the technical effects of the apparatus 300 provided in the embodiment of the present invention are the same as those of the embodiment of the foregoing method, and for brevity, reference may be made to the corresponding content in the embodiment of the foregoing method for the part of the embodiment of the apparatus that is not mentioned.
The functional modules integrated with the apparatus provided by the present invention may be stored in a computer readable storage medium if implemented in the form of software functional modules and sold or used as a stand-alone product. Based on such understanding, the present invention may implement all or part of the flow of the method of the above-described embodiments, or may be implemented by a computer program to instruct related hardware, where the computer program may be stored in a computer readable storage medium, and the computer program may implement the steps of the above-described method embodiments when executed by a processor. Wherein the computer program comprises computer program code which may be in source code form, object code form, executable file or some intermediate form etc. The computer readable medium may include: any entity or device capable of carrying the computer program code, a recording medium, a U disk, a removable hard disk, a magnetic disk, an optical disk, a computer Memory, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), an electrical carrier signal, a telecommunications signal, a software distribution medium, and so forth. It should be noted that the computer readable medium contains content that can be appropriately scaled according to the requirements of jurisdictions in which such content is subject to legislation and patent practice, such as in certain jurisdictions in which such content is subject to legislation and patent practice, the computer readable medium does not include electrical carrier signals and telecommunication signals.
The algorithms and displays presented herein are not inherently related to any particular computer, virtual system, or other apparatus. Various general-purpose systems may also be used with the teachings herein. The required structure for a construction of such a system is apparent from the description above. In addition, the present invention is not directed to any particular programming language. It will be appreciated that the teachings of the present invention described herein may be implemented in a variety of programming languages, and the above description of specific languages is provided for disclosure of enablement and best mode of the present invention.
In the description provided herein, numerous specific details are set forth. However, it is understood that embodiments of the invention may be practiced without these specific details. In some instances, well-known methods, structures and techniques have not been shown in detail in order not to obscure an understanding of this description.
Similarly, it should be appreciated that in the foregoing description of exemplary embodiments of the invention, various features of the invention are sometimes grouped together in a single embodiment, figure, or description thereof for the purpose of streamlining the disclosure and aiding in the understanding of one or more of the various inventive aspects. However, the disclosed method should not be construed as reflecting the intention that: i.e., the claimed invention requires more features than are expressly recited in each claim. Rather, as the following claims reflect, inventive aspects lie in less than all features of a single foregoing disclosed embodiment. Thus, the claims following the detailed description are hereby expressly incorporated into this detailed description, with each claim standing on its own as a separate embodiment of this invention.
Those skilled in the art will appreciate that the modules in the apparatus of the embodiments may be adaptively changed and disposed in one or more apparatuses different from the embodiments. The modules or units or components of the embodiments may be combined into one module or unit or component and, furthermore, they may be divided into a plurality of sub-modules or sub-units or sub-components. Any combination of all features disclosed in this specification (including any accompanying claims, abstract and drawings), and all of the processes or units of any method or apparatus so disclosed, may be used in combination, except insofar as at least some of such features and/or processes or units are mutually exclusive. Each feature disclosed in this specification (including any accompanying claims, abstract and drawings), may be replaced by alternative features serving the same, equivalent or similar purpose, unless expressly stated otherwise.
Furthermore, those skilled in the art will appreciate that while some embodiments herein include some features but not others included in other embodiments, combinations of features of different embodiments are meant to be within the scope of the invention and form different embodiments. For example, in the following claims, any of the claimed embodiments can be used in any combination.
Various component embodiments of the invention may be implemented in hardware, or in software modules running on one or more processors, or in a combination thereof. Those skilled in the art will appreciate that some or all of the functions of some or all of the components in a system according to embodiments of the present invention may be implemented in practice using a microprocessor or Digital Signal Processor (DSP). The present invention can also be implemented as an apparatus or device program (e.g., a computer program and a computer program product) for performing a portion or all of the methods described herein. Such a program embodying the present invention may be stored on a computer readable medium, or may have the form of one or more signals. Such signals may be downloaded from an internet website, provided on a carrier signal, or provided in any other form.
It should be noted that the above-mentioned embodiments illustrate rather than limit the invention, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The invention may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The use of the words first, second, third, etc. do not denote any order. These words may be interpreted as names.
Claims (7)
1. The enterprise material purchasing and receiving matching method is characterized by comprising the following steps of:
acquiring waybill information sent by a railway information system;
acquiring purchase order contract information sent by an internal purchase information system of a buyer;
acquiring the vehicle receiving information of the vehicles entering the factory;
obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill;
obtaining second data related to materials, suppliers, carriers, shipments and purchase order contract expiration dates based on the purchase order contract information;
acquiring target carrier data; wherein the target carrier data is any one of the carrier information;
Matching in the second data based on the target carrier data to obtain a target purchase order contract; wherein the target purchase order contract is any one of the purchase order contract information;
judging whether the departure time in the target carrier data is within the valid period of the purchase order contract of the target purchase order contract or not;
if yes, determining that the target carrier data is valid;
if not, feedback is sent to the buyer corresponding to the target purchase order contract, so that the buyer can reproduce the target purchase order contract until the target carrier data are determined to be valid; matching the carrying information with the receiving information, and confirming a carrying vehicle corresponding to the carrying information;
the matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information comprises the following steps:
based on the car receiving information, obtaining the car number of the car entering the factory;
matching the car number in the target carrier data with the car number of the factory entering car, and confirming whether the matching is successful or not;
if the car numbers are matched, determining a purchase settlement basis corresponding to the target purchase order contract;
If the purchasing settlement basis is shipping time settlement, determining a vehicle entering a factory matched with the vehicle number in the target carrier data as the carrier vehicle;
and if the purchase settlement basis is the arrival time settlement, and the arrival time of the arrival vehicle is within the effective period of the purchase order contract, determining the arrival vehicle matched with the vehicle number in the target carrier data as the carrier vehicle.
2. The method of claim 1, wherein the obtaining second data related to materials, suppliers, carriers, shipments, and purchase order contract expiration dates based on the purchase order contract information comprises:
based on the purchase order contract information, obtaining a purchase order contract number, a product name code, a material code, a supplier, a carrier, an issuing station, a purchase order contract effective period and a purchase settlement basis of each contract;
constructing a purchase order basic data table based on the purchase order contract number, the name code, the material code, the supplier, the carrier, the departure station, the purchase order contract effective period and the purchase settlement basis; wherein the purchase order base data table is the second data.
3. The method of claim 1, wherein the obtaining first data related to materials, suppliers, carriers, and shipments based on the purchase order contract information comprises:
acquiring supplier, shipper, carrier and material codes of each contract based on the purchase order contract information;
constructing a comparison relation static data table based on the supplier, the shipper, the carrier and the material codes; wherein the control relationship static data table is the first data.
4. The method of claim 1, wherein the matching of the supplier and the departure station in the first data based on the same manifest to obtain the carrier information for the manifest comprises:
matching the suppliers and the departure stations of the same waybill in the first data to obtain dynamic relations of the suppliers, the carriers, the departure stations, the material codes, the departure time and the train numbers corresponding to the waybill; wherein the dynamic relationship indicates that each supplier corresponds to a launch site, and one or more carriers;
acquiring a dynamic relation data table based on the dynamic relation corresponding to the waybill information; wherein the dynamic relationship data table is the carrier information.
5. An enterprise material procurement pickup matching system, comprising:
the railway information acquisition module is used for acquiring the waybill information sent by the railway information system;
the purchase information acquisition module is used for acquiring purchase order contract information sent by an internal purchase information system of a buyer; obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill;
obtaining second data related to materials, suppliers, carriers, shipments and purchase order contract expiration dates based on the purchase order contract information;
acquiring target carrier data; wherein the target carrier data is any one of the carrier information;
Matching in the second data based on the target carrier data to obtain a target purchase order contract; wherein the target purchase order contract is any one of the purchase order contract information;
judging whether the departure time in the target carrier data is within the valid period of the purchase order contract of the target purchase order contract or not;
if yes, determining that the target carrier data is valid;
if not, feedback is sent to the buyer corresponding to the target purchase order contract, so that the buyer can reproduce the target purchase order contract until the target carrier data are determined to be valid;
the railway vehicle number information acquisition module is used for acquiring the vehicle receiving information of the vehicles entering the factory;
the supplier information matching module is used for matching the waybill information with the purchase order contract information to obtain the carrying information of each waybill in the waybill information;
the automatic matching module of the factory-entering car receiving information is used for matching the carrying information with the car receiving information and confirming the carrying vehicle corresponding to the carrying information;
the matching the carrying information with the receiving information, and confirming the carrying vehicle corresponding to the carrying information comprises the following steps:
Based on the car receiving information, obtaining the car number of the car entering the factory;
matching the car number in the target carrier data with the car number of the factory entering car, and confirming whether the matching is successful or not;
if the car numbers are matched, determining a purchase settlement basis corresponding to the target purchase order contract;
if the purchasing settlement basis is shipping time settlement, determining a vehicle entering a factory matched with the vehicle number in the target carrier data as the carrier vehicle;
and if the purchase settlement basis is the arrival time settlement, and the arrival time of the arrival vehicle is within the effective period of the purchase order contract, determining the arrival vehicle matched with the vehicle number in the target carrier data as the carrier vehicle.
6. The system of claim 5, wherein the vendor information matching module is further specifically configured to:
obtaining first data related to materials, suppliers, carriers and shipments based on the purchase order contract information; wherein each piece of data in the first data corresponds to each purchase order contract in the purchase order contract information one by one;
based on the waybill information, acquiring suppliers and stops in the waybill information; wherein each of the waybills in the waybill information corresponds to one of the suppliers and the departure station;
And matching the suppliers and the departure stations of the same waybill in the first data to obtain the carrying information of the waybill.
7. A computer readable storage medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the steps of the method according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010189440.1A CN111506782B (en) | 2020-03-18 | 2020-03-18 | Enterprise material purchasing and receiving matching method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010189440.1A CN111506782B (en) | 2020-03-18 | 2020-03-18 | Enterprise material purchasing and receiving matching method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111506782A CN111506782A (en) | 2020-08-07 |
| CN111506782B true CN111506782B (en) | 2023-09-08 |
Family
ID=71864025
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010189440.1A Active CN111506782B (en) | 2020-03-18 | 2020-03-18 | Enterprise material purchasing and receiving matching method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111506782B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112668972B (en) * | 2020-12-30 | 2023-05-12 | 四川全网运通物流科技有限公司 | Logistics waybill service side recommendation system |
| CN112686606B (en) * | 2020-12-30 | 2023-05-12 | 四川全网运通物流科技有限公司 | Tab service side recommendation method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008204130A (en) * | 2007-02-20 | 2008-09-04 | Funai Electric Co Ltd | Merchandise information provision system, on-vehicle information terminal and computer program |
| CN103455907A (en) * | 2013-09-24 | 2013-12-18 | 济钢集团有限公司 | Iron and steel enterprise in-coming logistics management system based on internet of things and achievement method |
| CN107153940A (en) * | 2017-05-04 | 2017-09-12 | 湖南润安危物联科技发展有限公司 | Order processing method and apparatus |
| CN110580606A (en) * | 2019-09-12 | 2019-12-17 | 东方钢铁电子商务有限公司 | matching method of railway transportation data |
-
2020
- 2020-03-18 CN CN202010189440.1A patent/CN111506782B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2008204130A (en) * | 2007-02-20 | 2008-09-04 | Funai Electric Co Ltd | Merchandise information provision system, on-vehicle information terminal and computer program |
| CN103455907A (en) * | 2013-09-24 | 2013-12-18 | 济钢集团有限公司 | Iron and steel enterprise in-coming logistics management system based on internet of things and achievement method |
| CN107153940A (en) * | 2017-05-04 | 2017-09-12 | 湖南润安危物联科技发展有限公司 | Order processing method and apparatus |
| CN110580606A (en) * | 2019-09-12 | 2019-12-17 | 东方钢铁电子商务有限公司 | matching method of railway transportation data |
Non-Patent Citations (1)
| Title |
|---|
| 李佳状 ; .武钢运输管理信息化整合系统设计研究.宝钢技术.2020,(第01期),第48-51页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111506782A (en) | 2020-08-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6148291A (en) | Container and inventory monitoring methods and systems | |
| US6304856B1 (en) | Freight information management method and freight management system using electronic tags | |
| US20160180274A1 (en) | Method and system for monitoring deliveries | |
| US7299125B2 (en) | In-transit package location tracking and reporting | |
| CN111506782B (en) | Enterprise material purchasing and receiving matching method and system | |
| CN111091322A (en) | Management method of intelligent warehousing platform based on RFID | |
| CN105637545A (en) | Method and system for monitoring deliveries | |
| US20150039362A1 (en) | Allocation system and method of deploying resources | |
| US8949148B2 (en) | Goods receipt preparation | |
| WO2005086038A2 (en) | Systems and methods for managing product returns using return authorization numbers | |
| US20190279142A1 (en) | VinVerifEye | |
| WO2021026174A1 (en) | Systems for supply chain event data capture | |
| US20230351316A1 (en) | Method and system for automated vehicle transportation | |
| US6789729B1 (en) | Method for receiving and shipping items | |
| KR100984799B1 (en) | System and method for electronic service of marine manifest consolidation | |
| US8099371B1 (en) | Electronically enabled clearance methodology for improved processing at border crossings | |
| CN112417917A (en) | Value-added tax invoice checking and deducting method and system | |
| US20050071247A1 (en) | Integrated transportation method and system | |
| KR102167995B1 (en) | System and method for certifying trading related companies | |
| US20080189146A1 (en) | Computerized System for Transporting Cargo | |
| US20020082880A1 (en) | Computerized system for transporting cargo | |
| CN111461847B (en) | Method for solving customization of SAP (application and data processing) general service | |
| US6739507B2 (en) | Method of automated rail loading of automotive vehicles | |
| CN113988976A (en) | Concrete online transaction method, platform, equipment and storage medium | |
| JP2002312517A (en) | Super-short time automobile inspection and general automobile inspection and maintenance system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |