CN1549172A - Sold file management system and method - Google Patents
Sold file management system and method Download PDFInfo
- Publication number
- CN1549172A CN1549172A CNA031265243A CN03126524A CN1549172A CN 1549172 A CN1549172 A CN 1549172A CN A031265243 A CNA031265243 A CN A031265243A CN 03126524 A CN03126524 A CN 03126524A CN 1549172 A CN1549172 A CN 1549172A
- Authority
- CN
- China
- Prior art keywords
- shipment
- information
- basic
- database
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The shipment file management system and method can obtain basic shipment data automatically from several producer data bases to create serial shipment files and deliver shipment notice automatically via combining with the management of the shipper. The shipment file management system includes data base server, several client computers, several producer work stations and one application server. Each of the producer work stations includes one producer data base for storing basic goods information, shipper information, shipment line information and other basic shipment information. The application server is connected to the producer work stations to obtain basic shipment data, create serial shipment files, shipment notice sent to the recipient and daily reports. The shipment file management system has raised work efficiency and accuracy, saving in running cost and raised client serving level.
Description
[technical field]
The present invention relates to a kind of logistics operation system and method, relate in particular to a kind of logistics operation system and method for shipment file management.
[background technology]
Under the overall background of economic globalization, the develop rapidly of modern logistics industry brings profound influence to the global supply chain of enterprise procurement globalization, production globalization and market globalization, and the infosystem of modern logistics has become an indispensable important document of Inner Logistics Management and operation.Stream I T (Information Technology) system can make the reduction of operation cost of enterprises, the raising of efficiency of operation and the raising of level of customer service.
In traditional shipment file management system, the supplier relies on manually-operated that distributed and saved is inputed to a series of forms that preestablish form in the computing machine in basic documents such as the goods of personal computer and common carriers, to generate various shipment file.'s 518496 patent as Republic of China Patent Office in the notification number of on January 21st, 2003 bulletin, this patent name is the Taiwan patent of " management method of product turnout and system ", this system of system is used for enterprise is positioned at the affiliate of various places via the management system of network connections to product turnout, see through this management system and control the flow direction of achievement and surplus for enterprise, this system carries out the management of shipment and file according to the order data after the purchase order data that receives the client.The existing not enough system of the disclosed technology of this patent: the order for the Hard copy form still relies on manually-operated, expends cost in a large number, and makes that logistics end work flow is slow; The not enough system of another of this patent: can't in time provide the shipment relevant information to the consignee,, consequently reduce the level of customer service as sending a shipment advice with lettergram mode to the consignee.
[summary of the invention]
The object of the present invention is to provide a kind of shipment file management system and method, it can obtain basic shipment information automatically from a plurality of manufacturing side databases, and generates the shipment file automatically according to this basic shipment information; It also can send shipment advice automatically in conjunction with common carrier management information.
The invention provides a kind of shipment file management system, it comprises a database server, a plurality of client computers, an a plurality of manufacturing side workstations and an application server.Each manufacturing side workstation comprises that one produces a management server and a production client database server.Application server links to each other with a plurality of manufacturing side workstations via an internal network, visits the manufacturing side database server of a plurality of manufacturing side workstations via this internal network, to obtain basic shipment information.Application server links to each other with a plurality of client computers via a network, sends a series of forms or shipment advice to client computer via this network, and receives goods trace information and unusual condition information from client computer.Database server is used to preserve basic goods information, common carrier information, address book, shipment file and cargo tracking record.Application server comprises that a basic document module is used to visit a plurality of manufacturing side workstations obtaining basic shipment information, and is saved to database; One tracing module is used to obtain goods trace information and unusual condition information; One shipment document management module is used to generate shipment file, form and shipment advice; And one communication module be used to receive shipment advice and form, and be sent to the addressee.
The present invention also provides a kind of shipment file management method, and it includes following steps: (a) system manager is via a time control module setting-up time parameter; (b) provide the manufacturing side database of a plurality of manufacturing side workstations of basic document module timer access every day, to obtain basic shipment information; (c) provide a basic document module that the basic shipment information of obtaining is stored in database; (c) provide a shipment document management module accessing database,, generate a series of shipment files and cargo tracking record to obtain basic shipment information, and with shipment file and cargo tracking recorded and stored to database; (d) provide a tracing module to receive goods trace information and unusual condition information, and described goods trace information and unusual condition information are saved to the cargo tracking record of database; (e) the shipment document management module generates a shipment advice, and is sent to communication module; (f) address book that a communication module accessing database is provided to be obtaining addressee information, and according to described addressee information shipment advice is sent to the addressee; (g) the shipment document management module regularly generates a series of forms every day, and is sent to communication module; (h) address book of communication module accessing database to be obtaining addressee information, and regularly form is sent to the addressee every day according to described addressee information.
This shipment file management system and method can reach improves repeatability input operation, but raising data keeping quality and accuracy thereof are increased work efficiency the purpose of saving operation cost and reduction error rate.
[description of drawings]
Fig. 1 is the hardware structure figure of shipment file management system of the present invention and method.
Fig. 2 is the functional block diagram of shipment file management system of the present invention and method.
Fig. 3 is the operation process chart of shipment file management system of the present invention and method.
[embodiment]
As shown in Figure 1, be the hardware structure figure of shipment file management system of the present invention and method.This system comprises a plurality of manufacturing side workstation1 0, one database server 12, one application servers 14, and a plurality of client computer 16.Wherein manufacturing side workstation1 0 comprises a manufacturing side Information Service device 100 and a production management server 101, and the two links to each other via a connection 11.Connecting 11 is that a database connects, as the open type data storehouse connect (Open Database Connectivity, ODBC), perhaps the Java database connect (Java Database Connectivity, JDBC) etc.A plurality of manufacturing side workstation1s 0 link to each other with application server 14 via an internal network 13.Internal network 13 can be an intranet (Intranet), and application server 14 can be via a plurality of manufacturing side workstation1s 0 of internal network 13 visits to obtain essential informations such as goods basic document, common carrier data and freightways data.Database server 12 connects 11 via one and links to each other with application server 14.Client computer 16 links to each other with application server 14 via network 15.Network 15 can be an intranet (Intranet), also can be Internet (Internet) or other type communication network, application server 14 can send shipment advice (shippingadvice) to each common carrier via network 15, and can the form that regularly generates every day be sent to the addressee with authority via network 15; Described shipment advice is some essential informations that system sends goods and notifies the consignee to receive, it comprises: information such as basic goods information, route and time of arrival, flight number, storehouse number, bill of landing number comprises appended document: shipment files such as bill of sales, proforma invoice and the bill of lading simultaneously; Described form comprises: in-transit goods form, unusual condition form and order are safeguarded form.Wherein, the in-transit goods form is used to describe the Shipping Information of the part from the factory to the destination, to reflect goods information in transit; The unusual condition form is used to add up the goods of goods each evening website time of actual arrival and estimated time; Order safeguards that form is divided into two classes, and a class is for safeguarding, a class is used to reflect the performance of order for not safeguarding.
As shown in Figure 2, be the functional block diagram of shipment file management system of the present invention and method.Manufacturing side Information Service device 100 comprises a production client database 1000, is stored with basic goods information, basic shipment information such as common carrier information and shipment line information.Production management server 101 comprises that an authority management module 1010 is used to define the rights of using of user capture manufacturing side database 1000, control user job scope.Database server 12 comprises a database 120, is stored with basic goods information, common carrier information, address book, shipment file and cargo tracking record.Described address book is used to write down the consignee of every ticket goods, the addressee of i.e. shipment notice, and write down the addressee that authority is arranged who generates form every day, wherein, the cargo tracking record comprises fields such as article No., shipment line information, goods trace information, unusual condition information and proof of delivery.Described goods trace information comprises: every ticket goods is by way of the actual time of arrival and the information such as Actual Departure Time, system state, shipment status and goods current location of each website, wherein, system state means the treatment situation of every ticket goods in this goods automatic tracking system; Shipment status means the concrete freight information of the goods that system is handling; Unusual condition is because weather or shipping that human factor caused postpone situation.Client computer 16 includes a user interface 161 and an output unit 162.User interface 161 provides an interactive user interface, is convenient to have user's executable operations of authority, comprise to basic document increase newly, revise, upkeep operation such as deletion.
As shown in Figure 3, be the operation process chart of shipment file management system of the present invention and method.At first, the system manager sets three time parameters via time control module 142, and it is respectively: set a plurality of manufacturing side workstation1s 0 of basic document module timer access 141 every day, to obtain the time of basic shipment information in the manufacturing side database 1000; Set shipment document management module timer access database 144 every day 120 to generate the time of a series of forms; And the time (step S10) of a series of forms of setting communication module timed sending 145 every day.Basic document module 141 is via a plurality of manufacturing side workstation1s 0 of internal network timer access 13 every day, to obtain basic shipment information in the manufacturing side database 1000 (step S11), described basic shipment information comprises basic goods information, data such as common carrier information and shipment line information.Basic document module 141 is stored in database 120 (step S12) with the basic shipment information of obtaining.Shipment document management module 144 accessing databases 120, to obtain basic shipment information, generate a series of shipment files, address book and cargo tracking record, and with the shipment file, address book and the cargo tracking recorded and stored that generate to database 120 (step S13).Goods trace information and unusual condition information that tracing module 143 receives from client computer 16, and described goods trace information and unusual condition information are saved to the cargo tracking record of database 120, wherein, goods trace information comprises: every ticket goods is by way of the actual time of arrival and the information (step S14) such as Actual Departure Time, system state, shipment status and goods current location of each website.After cargo tracking finishes, shipment document management module 144 accessing databases 120 are with time of arrival of obtaining basic goods information, shipment line information, cargo tracking record, flight number, storehouse number and bill of landing number information and a series of shipment file, generate a shipment advice, and described shipment advice is sent to communication module 145 (step S15).Communication module 145 receives the shipment advice that shipment document management module 144 sends, simultaneously, obtaining addressee information, and described shipment advice is sent to addressee (step S16) via the address book that connects 11 accessing databases 120 according to described addressee information.The timing 144 every days of shipment document management module is via information such as cargo tracking record that connects 11 accessing databases 120 and basic shipment information, to generate a series of forms, and described form is sent to communication module 145, described a series of forms comprise: in-transit goods form, unusual condition form and order are safeguarded form (step S17).Communication module 145 receives a series of forms that shipment document management modules 144 send, and via the address book that connects 11 accessing databases 120 obtaining addressee information, and regularly form is sent to addressee (step S18) every day according to described addressee information.
Claims (10)
1. shipment file management system, this system include many manufacturing side workstations and remember an application server, it is characterized in that:
Each manufacturing side workstation comprises:
One production client database server, it comprises a production client database, is used for the storage base
This shipment information, described basic shipment information comprises basic goods information, common carrier information reaches
The shipment line information data;
One database server, it comprises a database, its be used for storing basic goods information,
Common carrier information, address book, shipment file and cargo tracking record, wherein shipment file
Comprise bill of sales, proforma invoice and the bill of lading;
Application server, it links to each other with a plurality of manufacturing side workstations via an internal network, and obtains basic shipment information via internal network, and this application server comprises:
One basic document module is used to visit the manufacturing side database of a plurality of manufacturing side workstations,
Obtaining basic shipment information, and be saved to database;
One tracing module is used to obtain goods trace information and unusual condition information, and is stored in
The cargo tracking record of database;
One shipment document management module is used for accessing database to obtain basic shipment information, gives birth to
Become shipment file, address book and cargo tracking record, also can be used for accessing database, to obtain
Get the related data and the shipment of basic goods information, shipment line information, cargo tracking record
File generates a shipment advice, and sends this shipment advice automatically;
One communication module is used to receive the shipment advice that the shipment document management module sends, and
The address book of accessible database will according to addressee information to obtain corresponding addressee information
Described shipment advice is sent to the addressee.
2. shipment file management system according to claim 1, it is characterized in that described shipment advice is some essential informations that system sends goods and notifies the consignee to receive, it comprises: information such as basic goods information, route and time of arrival, flight number, storehouse number, bill of landing number comprise additional a series of shipment files simultaneously.
3. shipment file management system according to claim 1, it is characterized in that described shipment document management module also can be used for timer access database every day, to generate a series of forms, the concurrent table of delivering newspaper, wherein, described a series of form comprises: in-transit goods form, unusual condition form and order are safeguarded form.
4. as shipment file management system as described in the claim 3, it is characterized in that described communication module also can be used for receiving a series of forms that the shipment document management module sends, and can be, and form be sent to the addressee according to addressee information via the address book of accessing database obtaining addressee information.
5. as shipment file management system as described in claim 1 or 4, it is characterized in that described application server also comprises a time control module, it is used for:
Set the manufacturing side database of a plurality of manufacturing side workstations of basic document module timer access every day of application server, to obtain the time of basic shipment information;
Set the time of the shipment document management module timer access every day database of application server, to generate a series of forms;
Set the time of a series of forms of communication module timed sending every day.
6. shipment file management system according to claim 1, it is characterized in that described manufacturing side workstation comprises that also one produces management server, comprise in it that authority management module is used to define the rights of using of user capture manufacturing side database, control user job scope.
7. shipment file management method, it can obtain basic shipment information automatically generating a series of shipment files from a plurality of manufacturing side databases, and can manage in conjunction with common carrier, sends shipment advice automatically, and it comprises the steps:
(a) provide the manufacturing side database of a basic document module via a plurality of manufacturing side workstations of an internal network timer access, to obtain basic shipment information, described basic shipment information comprises basic goods information, common carrier information and shipment line information;
(b) the data module is stored in a database with the basic shipment information of obtaining;
(c) provide a shipment document management module accessing database, obtaining basic shipment information, the shipment file of generation, address book and cargo tracking record, and with shipment file, address book and cargo tracking recorded and stored to database;
(d) provide a tracing module to receive goods trace information and unusual condition information, and described goods trace information and unusual condition information are saved to the cargo tracking record of database from client computer;
(e) shipment document management module accessing database to obtain the related data and the shipment file of basic goods information, shipment line information, cargo tracking record, generates a shipment advice, and sends described shipment advice;
(f) provide a communication module to receive the shipment advice that the shipment document management module sends, simultaneously, the address book of accessing database to be obtaining addressee information, and according to described addressee information described shipment advice is sent to the addressee.
8. as shipment file management method as described in the claim 7, it is characterized in that described step (a) also comprises the steps:
(a1) provide a time control module, the system manager is via this module settings:
One time parameter, the basic document module that is used to set application server is regularly visited every day
Ask the manufacturing side database of a plurality of manufacturing side workstations, to obtain the time of basic shipment information;
One time parameter, the shipment document management module that is used to set application server is fixed every day
The time accessing database, to generate the time of a series of forms;
One time parameter, be used to set a series of forms of communication module timed sending every day the time
Between.
9. as shipment file management method as described in the claim 7, it is characterized in that also comprising the steps:
(g) information such as the cargo tracking of shipment document management module timer access every day database record and basic shipment information generating a series of forms, and are sent to communication module with described a series of forms;
(h) communication module receives a series of forms that the shipment document management module sends, and the address book of accessing database to be obtaining addressee information simultaneously, and regularly form is sent to the addressee every day according to described addressee information.
10. as shipment file management method as described in the claim 7, it is characterized in that described shipment advice is some essential informations that system sends goods and notifies the consignee to receive, it comprises: information such as basic goods information, route and time of arrival, flight number, storehouse number, bill of landing number comprise additional a series of shipment files simultaneously.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA031265243A CN1549172A (en) | 2003-05-05 | 2003-05-05 | Sold file management system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA031265243A CN1549172A (en) | 2003-05-05 | 2003-05-05 | Sold file management system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1549172A true CN1549172A (en) | 2004-11-24 |
Family
ID=34321907
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA031265243A Pending CN1549172A (en) | 2003-05-05 | 2003-05-05 | Sold file management system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1549172A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243727A (en) * | 2010-05-12 | 2011-11-16 | 上海宝康电子控制工程有限公司 | System and method for automatically generating delivery list of goods and materials based on manufacturing execution unit |
| CN110321979A (en) * | 2019-06-21 | 2019-10-11 | 上海翊视皓瞳信息科技有限公司 | A kind of management method and system applied to wisdom factory |
-
2003
- 2003-05-05 CN CNA031265243A patent/CN1549172A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243727A (en) * | 2010-05-12 | 2011-11-16 | 上海宝康电子控制工程有限公司 | System and method for automatically generating delivery list of goods and materials based on manufacturing execution unit |
| CN110321979A (en) * | 2019-06-21 | 2019-10-11 | 上海翊视皓瞳信息科技有限公司 | A kind of management method and system applied to wisdom factory |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Ramaa et al. | Impact of warehouse management system in a supply chain | |
| US6889106B2 (en) | Master production scheduling management system and method | |
| US20010051905A1 (en) | Inventory control system and methods | |
| CA2402350A1 (en) | Inventory control system and methods | |
| CN112036803B (en) | Method for generating general cross-border logistics distribution list | |
| CN111882275A (en) | Trade big data management method and system based on industrial identification analysis | |
| CN108038617A (en) | A kind of intellectual property operating service plateform system | |
| CN1501304A (en) | Management system and method for integrating inventory | |
| CN101676939A (en) | Maintenance management platform system | |
| CN102073940A (en) | Station platform dynamic distribution method and system during on-line reservation of supplier | |
| US7711612B1 (en) | Replenishment management system and method | |
| CN109146369A (en) | It stores in a warehouse outside a kind of committee based on lean production intelligent control method | |
| US20030004839A1 (en) | Computerized automatic management system and method for logistics control | |
| CN111339259B (en) | Method for pre-packaging materials to be delivered in SAP | |
| US20040117227A1 (en) | Production capability simulating system and method | |
| CN1549172A (en) | Sold file management system and method | |
| CN100357969C (en) | Automatic tracking system of goods and its method | |
| TWI490794B (en) | Purchase managing system and method | |
| CN1469285A (en) | Logistics managing and controlling system and method | |
| US20040128213A1 (en) | Material requirement planning system and method for re-scheduling purchase orders of materials | |
| TWI289802B (en) | System and method for managing export files | |
| TW200422890A (en) | System and method for managing outbound logistics | |
| TW200422897A (en) | System and method for distributing outbound materials | |
| US20040122749A1 (en) | System and method for managing manufacturing orders | |
| CN1368810A (en) | Distributed information switch and processing system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20041124 |