WO2004092898A2 - Structure de donnees et systeme destine a un partage global de l'information - Google Patents

Structure de donnees et systeme destine a un partage global de l'information Download PDF

Info

Publication number
WO2004092898A2
WO2004092898A2 PCT/US2004/011163 US2004011163W WO2004092898A2 WO 2004092898 A2 WO2004092898 A2 WO 2004092898A2 US 2004011163 W US2004011163 W US 2004011163W WO 2004092898 A2 WO2004092898 A2 WO 2004092898A2
Authority
WO
WIPO (PCT)
Prior art keywords
data
shipper
characters
database
logistics
Prior art date
Application number
PCT/US2004/011163
Other languages
English (en)
Other versions
WO2004092898A3 (fr
Inventor
Allen E. Parkin
Original Assignee
Hal, Inc.
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Hal, Inc. filed Critical Hal, Inc.
Publication of WO2004092898A2 publication Critical patent/WO2004092898A2/fr
Publication of WO2004092898A3 publication Critical patent/WO2004092898A3/fr

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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21—Design, administration or maintenance of databases
    • 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/95—Retrieval from the web
    • G06F16/951—Indexing; Web crawling techniques

Definitions

  • Provisional Patent Application Serial Number 60/462,812 entitled “Data Structure and System for Global Sharing of Information,” filed on April 14, 2003, having attorney docket number 28552.08.02. Provisional Patent Application Serial Number 60/462,812 is herein incorporated by reference in its entirety.
  • Provisional Patent Application Serial Number 60/462,032 entitled “Data Structure and System for Global Sharing of Information,” filed on April 10, 2003, having attorney docket number 28552.08.01. Provisional Patent Application Serial Number 60/462,032 is herein incorporated by reference in its entirety.
  • This invention relates generally to data management systems, databases, database structures, and their methods of use.
  • a data management system and method include a database adapted to contain data associated with a unique identifier and a server connected to the database adapted to provide access to the data by to at least two users.
  • the disclosed data management system and method may be used to manage any type of data, including logistics data.
  • a logistics data management system in another embodiment, includes a database adapted to contain logistics data and a web server connected to the database adapted to transmit the logistics data to at least one user.
  • a method of managing logistics information for creating a plurality of data tables, linking each data table with at least one other data table, populating the plurality of data tables with logistics data, and providing access to the logistics data.
  • a system adapted to manage logistics data associated with a unique identifier for moving a package from a supplier to a customer, including a means to receive a purchase order from the customer, a means to receive the package from the supplier, a means to match the purchase order with the package, a means to group the package with other packages for shipping, and a means to ship the package.
  • the package associated with the unique identifier may be handled by several transporting entities.
  • a method is disclosed of managing logistics data from a plurality of suppliers to a customer, including a first supplier assigning a unique first supplier number to a unique identifier, the unique identifier applied to each package shipped from the first supplier to the customer, and a second supplier assigning a unique second supplier number to a unique identifier, the unique identifier applied to each package shipped from the second supplier to the customer.
  • a system adapted to manage logistics data involving one or more uniquely identified transporting entities which may be any entity that transports product, such as for example, a supplier, the shipper, the customer, or a freight forwarder, is disclosed for moving a product from one or more sources to a customer, including a means to receive a purchase order from the customer, a means to receive the product from the one or more sources, a means to match the purchase order with the product, a means to group the product with other products for shipping, and a means to ship the product.
  • FIG. 1 is a view of a logistics data management system.
  • FIG. 2 is a view of a database.
  • FIG. 3 is a view of a middleware component.
  • FIG. 4 is a view of a logistics supply chain.
  • FIG. 5 is a view of a method of creating a database.
  • FIG. 6 is a view of a method of using a shipper's destination profile.
  • FIG. 7 is a view of a logistics supply chain.
  • FIG. 8a is a view of a process of managing logistics data.
  • FIG. 8b is an alternate view of a process of managing logistics data.
  • FIG. 9 is a view of a purchase order.
  • FIG.10 s a view of a purchase order,
  • FIG.11 s a view of a purchase order item, [0022 FIG.12 s a view of a receiving entry, [0023; FIG.13 s a view of a receiving item entry, [0024; FIG.14 s a view of a material receipt, [0025; FIG.15 s a view of a material receipt, [0026; FIG.16 s a view of a material receipt, [0027; FIG.17 s a view of a material receipt item, [0028 FIG.18 s a view of a release to pack item, [0029; FIG.19 s a view of a release to pack item. [0030 FIG.20 s a view of a packing list entry. [0031 FIG.21 s a view of a packing list entry. [0032] FIG. 22 i s a view o a box entry.
  • FIG. 23 i s a view o a box entry.
  • FIG. 24 i s a view o a box entry.
  • FIG. 25 i s a view o a box entry.
  • FIG. 26 i s a view o' a delivery ticket entry.
  • FIG. 27 i s a view ⁇ ⁇ a delivery ticket entry.
  • FIG. 28 i s a view o a delivery ticket entry.
  • FIG. 29 i s a view o' a shipper's destination profile entry.
  • FIG. 30 i s a view o- a shipper's destination profile entry.
  • FIG. 31 i s a view o' a shipper's destination profile entry.
  • FIG. 32 i s a view o customer update flags.
  • FIG. 33 i s a view o a logistics supply chain.
  • FIG. 34 i s a view o a logistics supply chain.
  • FIG. 35 i s a view o' a logistics supply chain.
  • FIG. 36 i s a view o a logistics supply chain.
  • FIG. 37 i s a view o a logistics supply chain.
  • This invention relates generally to data management systems, databases, database structures, and their methods of use. It is understood, however, that the following disclosure provides many different embodiments or examples. Specific examples of components and arrangements are described below to simplify the present disclosure. These are, of course, merely examples and are not intended to be limiting. In addition, the present disclosure may repeat reference numerals and/or letters in the various examples. This repetition is for the purpose of simplicity and clarity and does not in itself dictate a relationship between the various embodiments and/or configurations discussed. [0049] Referring now to FIG.
  • data management system 100 which includes database 102, coupled to middleware 104, coupled to a server, such as for example a web server 106.
  • data management system 100 is designed to manage logistics data.
  • Database 102 is adapted to contain logistics data.
  • User 108, user 110, user 112, and user 14 are able to access system 100 and logistics data through web server 106 and/or through electronic data interchange 116.
  • Web server 106 is adapted to host one or more web pages containing logistics data from database 102.
  • users 108, 110, 112, and/or 114 can access the database 102 through web server 106 and middleware 104 to read and/or write to database 102.
  • User 114, and optionally, users 108, 110, and 112 are also able to access logistics data through electronic data interchange 116, through middleware 104 to database 102, or input logistics data to database 102 through electronic data interchange 116 and middleware 104.
  • FIG. 2 one embodiment of database 102 is illustrated in more detail.
  • Database 102 includes a number of data tables, for example at least 100 tables to 200 tables, or for example, 197 tables.
  • database 102 includes Table 1 201, Table 2 202, Table 3 203, Table 4 204, Table 5 205, Table 6 206, Table 7 207, Table 8 208, Table 9 209, and Tables 10-197 210-397.
  • Table 1 201 includes Data Record 1 400 to Data Record N 401 which each have Company Code 402, Location Code 404, Data Field 3 406, Data Field 4 408, Data Field 5 410, Data Field 6 412, and Data Field 7 414.
  • Table 2 202 to Table 197 397 may also have Company Code 402 and/or Location Code 404.
  • a unique identifier such as for example, Company Code 402 may be used to identify data incorporated into database 102 as coming from a source of the data.
  • Middleware 104 includes application server 502, report generator 504, program components 506, and print servers 508.
  • Application server 502 is connected to report generator 504, program components 506, and print servers 508.
  • Report generator 504 is connected to print servers 508.
  • Logistics supply chain 600 includes Supplier A 602, which gives product to Trucking Company A 604, which delivers product to Rail Company A 606, which delivers product to Trucking Company B 608, which delivers product to Customer A 610.
  • the product may be associated with a unique identifier representing the source of the product provided by Supplier A and such association is maintained throughout the delivery process until the product is delivered to Customer A 610.
  • Information on the movement of the product may be delivered to, stored, and/or accessed from System A 612, for example system 100. Information on the movement of the product may also be delivered to, stored, and/or accessed from System B 616, for example system 100.
  • Supplier A 602 is connected to System A 612 by Connection A 614.
  • Trucking Company A 604 is connected to Internet 614 by Connection 620.
  • Trucking Company A 604 may access System A 612 by Connection 628 and/or System B 616 by Connection 630.
  • Rail Company A 606 is connected to Internet 614 by Connection 622.
  • Rail Company A 606 may access System A 612 by Connection 628 and/or System B 616 by Connection 630.
  • Trucking Company B 608 is connected to Internet 614 by Connection 624.
  • Trucking Company B 608 may access System A 612 by Connection 628 and/or System B 616 by Connection 630.
  • Customer A 610 is connected to System B 616 by Connection 626.
  • System A 612 is able to synchronize with System B 616 and vice versa through Internet 614 by Connections 628 and 630, for example daily, hourly, each minute, or a "put and get" synchronization.
  • Connections 628 and 630 for example daily, hourly, each minute, or a "put and get" synchronization.
  • One or more of connections 618, 620, 622, 624, 626, 628, and/or 630 may be made over the Internet.
  • Supplier A 602 is able to track the movements of packages, each associated with a unique identifier representing the source of the package, to Customer A 610 and to other customers (not shown). Supplier A 602 may only make the movements of packages to Customer A 610 available to Trucking Company A 604, Rail Company A 606, Trucking Company B 608, and Customer A 610, and not make the movements of packages to other customers available.
  • Customer A 610 is able to track the movements of packages from Supplier A 602 and from other suppliers (not shown) using System B 616. Customer A 610 may only make the movements of packages from Supplier A 602 available to Supplier A 602, Trucking Company A 604, Rail Company A 606, and Trucking Company B 608, and not make the movements of packages from other suppliers available.
  • a plurality of data tables are created, for example Table 1 201 - Table 197 397 (from FIG. 2).
  • one or more common data fields between the tables are linked to each other to create a relational database, for example data fields 402 and/or 404 (from FIG. 2).
  • the tables are populated with data, for example record 1 400 to record N 401.
  • database 102 may be used to access the data from the tables.
  • a shipper's destination profile number is defined.
  • the shipper's destination profile is populated with information regarding the delivery location, for example manually or by electronic data interchange.
  • a purchase order may be entered into one or more tables of database 102.
  • the shipper's destination profile number is linked to the purchase order (P/O)
  • items on the P/O may be linked to the shipper's destination profile.
  • a shipper's destination profile is a unique combination of a shipper/customer's delivery location and packing specifications.
  • a shipper's destination profile may be provided for each logical grouping of materials per delivery location. For example, for a construction project, all of the cement, steel, and bricks may be grouped into a single shipper's destination profile to be delivered to the construction site, a second shipper's destination profile may be created for the delivery of all of the wiring, electrical, and electronic equipment, and a third shipper's destination profile may be created for the chemicals, and other hazardous materials. [0062] In one embodiment, shipper's destination profile 644 may be used to control the first level of packing, for example where shipments are supposed to go. Shipper's destination profile 644 may include one or more functional flags.
  • shipper's destination profile 644 includes a company code, customer number, an associated purchase order or purchase order prefix, an associated purchase order suffix, a request for quotation prefix/suffix, port of discharge/ destination, one or more special codes, associated rate charge, and/or ship to/notify.
  • web server 106 may be a conventional web server, for example a J2E application server commercially available from BEA Systems, Inc., under the trade name WebLogic Application Server, at http://www.bea.com.
  • web server 106 may be an Tomcat web server, commercially available from The Apache Software Foundation, at Apache.org, Project Jakarta.
  • electronic data interchange 116 may be a conventional electronic data interchange adapted to handle different formats of incoming data, such as for example, data received in system 100 format or data received in a non-system 100 format.
  • the system 100 formatted data may be passed through to middleware 104 without reformatting. Whereas the non-system 100 formatted data may require reformatting prior to being transferred to the middleware for storing in database 102.
  • electronic data interchange 116 may be adapted to convert data received from database 102 to any format other than system 100 format to accommodate any type of data source interfacing with system 100.
  • the unique identifier may also be transferred into system 100.
  • the unique identifier may be assigned by system 100.
  • users 108-114 may connect to web server 106 using a computer, an internet connection, and a commercially available web browser, for example Microsoft Internet Explorer or Netscape Navigator, commercially available from Netscape Communications Corp.
  • a commercially available web browser for example Microsoft Internet Explorer or Netscape Navigator, commercially available from Netscape Communications Corp.
  • database 102 may be any conventional database or storage medium.
  • database 102 is created and/or maintained on a SQL Server, for example SQL Server 2000 commercially available from Microsoft Corporation at http://www.microsoft.com/.
  • database 102 may be created and/or maintained on a Oracle Database Server, for example Oracle 9i commercially available from Oracle Database Server.
  • application server 502 of middleware 104 may be a conventional application server, for example an application server commercially available from BEA Systems, under the trade name WebLogic Application Server, at http://www.bea.com/.
  • report generator 504 of middleware 104 may be a conventional report generator, for example a Java-based report generator commercially available from Jinfonet Software, under the trade name JReports, at http://jinfonet.com.
  • report generator 504 may include one or more templates for reports.
  • program components 506 of middleware 104 are developed in Java to the J2EE 1.4 Specification, commercially available from Sun Microsystems at http://www.sun.com/.
  • program components 506 provide for interaction between different parts of system 100 and/or the users.
  • one program component could be an RF scanning interface to input data scanned from a barcode by a handheld scanning device into system 100 or a purchase order entry function to enter information from a purchase order in to system 100.
  • print servers 508 of middleware 104 may be conventional print servers, for example print servers commercially available from Loftware, under the trade name Loftware Enterprise Print Server, at http://www.loftware.com.
  • company code 402 is a three digit unique identifier made up of three letters and/or numbers selected from 0-9 and A-Z, for
  • company code 402 is a four digit unique identifier made up of four letters and/or numbers selected from 0-9 and A-Z, for greater than 1.6 million unique combinations.
  • location code 404 is a two digit unique identifier made up of two letters and/or numbers selected from 0-9 and A-Z, for 1296 unique combinations, which may be used to identify different locations within each company.
  • one or more other tables 202-397 may also include a company code and a location code, for example company code 402 and location code 404, and also include at least one other data field.
  • system 900 is provided to manage information on the flow of products from supplier/vendor 902 to a transportation entity 904, such as for example, a third-party logistics provider/freight forwarder, carrier, or freight handler, by ship 906 to shipper/customer 908.
  • a transportation entity 904 such as for example, a third-party logistics provider/freight forwarder, carrier, or freight handler
  • ship 906 to shipper/customer 908.
  • supplier/vendor 902 and third-party logistics provider/freight forwarder 904 are located in country A 910
  • shipper/customer 908 are located in country B 912
  • ship 906 traverses ocean 914 to deliver products to shipper/customer 908.
  • system 900 could also be used to manage information on the domestic flow of products, or for any number of international variations.
  • shipper/customer 908 hires third-party logistics provider/freight forwarder 904 to manage the logistics of supply movements, for example to expedite materials, group materials, send materials to the desired locations, pack materials, arrange for shipments, and track shipments.
  • shipper/customer 908 issues a purchase order (P/O) which is received by supplier/vendor 902 and third-party logistics provider/freight forwarder 904.
  • shipper/customer 908 may issue the purchase order directly to third-party logistics provider/freight forwarder 904 by electronic data interchange ("EDI"), and in another embodiment the purchase order may be issued on paper.
  • EDI electronic data interchange
  • third- party logistics provider/freight forwarder 904 creates a record in system 900 including the P/O information.
  • shipper/customer 908 may be working on a project which has a master requisition or bill of materials to cover all of the materials needed for the project. From this "master" multiple purchase orders may be issued to various suppliers and third-party logistics providers to ship all the materials to the desired location. [0078] Also at step 1002, third-party logistics provider/freight forwarder 904 assigns the purchase order to a shipper's destination profile within relevant P/O record within system 900.
  • a shipper's destination profile is a unique combination of shipper/customer's 908 delivery location and packing specifications. In one embodiment, a shipper's destination profile may be provided for each logical grouping of materials per delivery location.
  • all of the cement, steel, and bricks may be grouped into a single shipper's destination profile to be delivered to the construction site, a second shipper's destination profile may be created for the delivery of all of the wiring, electrical, and electronic equipment, and a third shipper's destination profile may be created for the chemicals, and other hazardous materials.
  • third-party logistics provider/freight forwarder 904 receives freight shipped from supplier/vendor 902.
  • Third-party logistics provider/freight forwarder 904 supplies a unique identifier to the freight, for example a barcode.
  • a barcode including a unique identifier is applied to the smallest identifiable unit received as a part of the shipment.
  • the barcode may include the following: a unique company code of the company that applied the barcode; a location code to identify the location of the company applying the barcode; and a package identifier to identify which package at the company location received the barcode.
  • the freight is checked by verifying the product received at step 1004 with the purchase order received at step 1002 by accessing purchase order within system 900.
  • the boxes received and/or the documents associated with the shipment received may be labeled with the unique identifier and a purchase order or requisition number, which can be used to associate each box received with a purchase order.
  • step 1006 the purchase order product line items and quantities within system 900 are compared to the contents of the boxes received that are associated with the purchase order, by accessing purchase order within system 900.
  • a material receipt is issued from system 900.
  • the material receipt is an official statement of what was received in the shipment.
  • steps 1006 and 1008 are done at the same time.
  • the associated purchase order is pulled up on a computer (not shown) from system 900, and available items in the purchase order that have not yet been received are highlighted. The highlighted items are identified in the shipment, then the barcode of the shipment item is scanned to identify that one or more of the highlighted items has been received in the shipment, and the item is no longer highlighted on the purchase order.
  • the shipper's destination profile of the purchase order is associated within system 900 with each product that is received on that purchase order.
  • the quantities are compared between the items received and the purchase order items. If the received items match the quantities for the purchase order items, then there are no problems. If there were too many items received as compared to the purchase order, then an overage error is generated for that purchase order by system 900, for example to the worker who is receiving the shipment. If there were too few items received as compared to the purchase order, then an underage or shortage error is generated for the purchase order by system 900. If some of the items were damaged as received, then a damage error is generated for the purchase order by system 900.
  • any such errors within system 900 must be resolved prior to proceeding to 1010, for example by removing the excess items from the purchase order, receiving additional items to add to the purchase order, or by receiving replacement items to replace damaged items.
  • one or more products are grouped together and associated within system 900 and released to pack (RTP).
  • RTP released to pack
  • a pick ticket and/or a packing list are generated from system 900.
  • step 1012 all of the products on each pick ticket and/or packing list from 1010 are marshaled together into one area at third-party logistics provider/freight forwarder's 904 warehouse, for example a pull to pack step (PTP).
  • PTP pull to pack step
  • step 1014 all of the marshaled products from 1012 are overpacked, for example, boxed together.
  • the warehouse worker scans or otherwise inputs the release to pack job (RTP) or pick ticket from 1010, then places a barcode with a unique identifier on the box or other container in which the products will be placed, to associate this pick ticket with the appropriate box in system 900.
  • RTP release to pack job
  • the barcode is scanned to ensure that the product belongs on the appropriate pick ticket with the other products being placed in the box, and system 900 is updated with each barcode is scanned, for example by a batch update or a continuous update.
  • a forwarder reference is provided by system 900, including, for example, a file number, a shipment number, or a house or consolidator number.
  • system 900 including, for example, a file number, a shipment number, or a house or consolidator number.
  • all the routing and route information, and/or the documentation for a route to move the product from third-party logistics provider 904 to shipper/customer 908 may be provided.
  • the containers are released to deliver and a delivery ticket is printed from system 900.
  • the delivery ticket may contain such information as: supplier/vendor 902, third-party logistics provider/freight forwarder 904, shipment method, shipper/customer 908, shipper's destination profile (where the products are to be delivered), how many containers there are in the shipment, identification of the smaller packages within the containers, and items contained in each of the smaller packages. This information allows an employee at shipper/customer 908 to easily locate a specific item out of all of the containers and packages.
  • the delivery ticket from 1016 is verified as the containers to be shipped are loaded onto ship 906.
  • the delivery ticket is scanned, then as each container is loaded, the container is scanned to associate the container with the delivery ticket and to verify that the container has been shipped, within delivery ticket record in system 900.
  • the delivery ticket is verified when all of the containers on the ticket have been scanned and placed on ship 906.
  • the containers on the delivery ticket are in transit on ship 906 crossing ocean 914 from third-party logistics provider/freight forwarder 904 to shipper/customer 908.
  • shipper/customer 908 takes delivery of the containers. Shipper/customer 908 may then unpackage the containers as desired to get the items, overpack the containers into larger containers to be shipped somewhere else, and/or repackage the containers to be shipped somewhere else. In one embodiment, shipper/customer 908 scans the containers as they arrive, and updates system 900 to show that the containers are now at shipper/customer's 908 location.
  • barcodes including the unique identifier may be utilized in the logistics process.
  • barcodes may be used in the following labels: a unique box ID label; an inventory location label; markings label; or a delivery ticket label.
  • FIGS. 9-11 different views of a purchase order record that may be stored in system 900 and/or system 100, accessed by a web browser, for example Internet Explorer, and received by third-party logistics provider/freight forwarder 904 at step 1002 are illustrated.
  • a web browser for example Internet Explorer
  • the details screen of purchase order 1100 includes the following: unique purchase order number 1101 assigned by system 900 as purchase order 1100 is received, in this case be BU030804B; company code field 1102 referring to the third-party logistics provider/freight forwarder 904, in this case Dragon; destination 1104 for the products, in this case Rio de Janeiro; transportation method 1106 for the products, in this case air freight; supplier/vendor 1108 for the products, in this case Abco; customer name 1110 of shipper/customer 908 who will receive the products, in this case Excel; and products 1112 that will be shipped.
  • Several different view tabs 1114 may be provided to allow a user to toggle between the screens details, such as, for example, haz/other, xref/rem/ship via, and SDP/expedite.
  • the SDP/expedite screen of purchase order 1100 includes the following: unique purchase order number 1101 assigned by system 900 as purchase order 1100 is received, in this case be BU030804B; company code field 1102 referring to the third-party logistics provider/freight forwarder 904, in this case Dragon; destination 1104 for the products, in this case Rio de Janeiro; customer name 1110 of shipper/customer 908 who will receive the products, in this case Excel; products 1112 that will be shipped; and shipper's destination profile 1116, a unique product grouping, destination, transportation type combination for products 1112, in this case Rio 182-D. [0095] Referring now to FIG. 11, purchase order item 1120 detail is presented.
  • Purchase order item 1120 includes purchase order number 1101 , company code field 1102, transportation method 1106, vendor 1108, products 1112, purchase order item number 1122, product quantity 1124, and product price 1126. Purchase order item 1120 provides additional detail concerning one of products 1112 from purchase order 1100.
  • FIGS. 12-13 different views of a receiving entry record that may be stored in system 900 and/or system 100, accessed by a web browser, for example Internet Explorer, and generated by third-party logistics provider/freight forwarder 904 at step 1004 are illustrated.
  • receiving entry record 1200 includes unique receiving entry information 1202 assigned by system 900 as receiving entry record 1200 is received.
  • receiving entry information 1202 is illustrated as DRG HO 2004 03 08 0007, where DRG is the three digit company code representing Dragon, HO is the two digit location code representing Dragon's Houston location, 2004 03 08 is the date March 8, 2004 identifying the date the shipment is received, and 0007 represents the number shipment of the day, in this case, the seventh shipment of the day that DRG's Houston location received.
  • Receiving entry information 1202 also includes the information that three packages were received in this shipment.
  • Receiving date 1204 represents the date the shipment was received, in this case March 8, 2004.
  • Supplier 1208 is the entity that shipped the shipment, this case Acme, Inc.
  • receiving entry record 1200 Also included on receiving entry record 1200 are customer name 1210 of shipper/customer 908 for whom the packages are received, in this case Excel and packages 1212 that were received, in this case three packages. Packages 1212 are sequentially numbered as they arrive, and are then or later associated with a purchase order, in this case purchase order number 1101. Several different view tabs 1214 are provided to allow a user to toggle between the screens details, apply to packages, intransit information, and charges. [0099] Referring now to FIG. 13, receiving item entry 1220 is illustrated, for the second package of the three package receiving entry record 1200. Receiving item entry record 1220 includes receiving entry number 1202, receiving date 1204, supplier number 1208, package type 1222, and barcode number 1224. Purchase order number 1101 is also provided to associate this package with a particular purchase order. Several different view tabs 1214 are provided to allow a user to toggle between general information, additional information, intransit information, and charges.
  • a first tab of material receipt entry 1300 includes the following: material receipt number 1302, in this case 2004 030 8007; associated barcode number 1224, in this case 04000088A; carrier 1306, in this case Great Transportation Services Inc.; and material receipt items 1308, in this case nine staplers.
  • a second tab of material receipt entry 1300 includes material receipt number 1302, in this case 2004 030 8007; associated barcode number 1224, in this case 04000088A; and material receipt items 1308, in this case nine staplers, checked date 1310, material receipt date 1312, released to pack date 1314, packed date 1316, delivered date 1318, and delivery ticket number 1320. Also part of this tab of material receipt entry 1300 are purchase order number 1101, customer 1210, and receiving date 1204 (from purchase order 1100 and/or receiving entry 1200).
  • a third tab of material receipt entry 1300 includes: material receipt number 1302, in this case 2004 030 8007; associated barcode number 1224, in this case 04000088A; and material receipt items 1308, in this case nine staplers. Also part of this tab of material receipt entry 1300 are purchase order number 1101, customer 1210, and shipper's destination profile 1116, in this case Rio 182 - D. [00103] Referring now to FIG. 17, material receipt item entry 1330 is illustrated.
  • Material receipt item entry 1330 includes: material receipt number 1302, in this case 2004 030 8007; associated barcode number 1224, in this case 04000088A; material receipt items 1308, in this case nine staplers; and tabs 1332 which allow a user to switch between screens of material receipt item entry 1330. Also included are purchase order number 1101 , customer 1210, transportation method 1106, and supplier 1208.
  • a first tab of release to pack item entry 1400 includes: release to pack job number 1402, in this case DRGHOHOR15 00195; packing due date on 1404, in this case March 8, 2004 at 16:00; hazardous material indicator 1406, in this case no hazardous materials; packing and handling instructions 1408, in this case "keep dry” and “do not stack”; and packing list number 1410, in this case PHO 0402683.
  • release to pack item entry 1400 includes the following: release to pack job number 1402, in this case DRGHOHOR15 00195; and assigned material receipt packages 1412.
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • customer 1210 in this case Excel
  • transportation method 1106 in this case air freight A
  • shipper's destination profile 1116 in this case Rio 182 - D
  • associated purchase order number 1101 in this case BU0300804B.
  • FIGS. 20-21 different views of a packing list entry record that would be stored in system 900 and/or system 100 and accessed by a web browser, for example Internet Explorer, and generated by third-party logistics provider/freight forwarder 904 at step 1012 are illustrated.
  • a web browser for example Internet Explorer
  • Packing list entry 1500 includes packing list number 1502 and package markings 1504.
  • packing list entry 1500 includes the following: packing list number 1502, boxes 1510 associated with a packing list, in this case only one box; packing list box numbers 1512, in this case only box number 1 ; and box numbers 1514 associated with each packing list box number 1512. Also part of packing list entry 1500 is third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location (from purchase order 100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400).
  • box entry 1600 includes the following: package type 1602, in this case book; package markings 1604; delivery ticket number 1606, in this case DD4000009; and box weights and dimensions 1608.
  • box entry 1600 Also part of box entry 1600 is third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; release to pack job number 1402, in this case 00195; packing list number 1502, in this case PHO 0402683; packing list box number 1512, in this case box number 1 ; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • release to pack job number 1402 in this case 00195
  • packing list number 1502 in this case PHO 0402683
  • packing list box number 1512 in this case box number 1
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • Box entry 1600 includes the following: delivery ticket number 1606, in this case DD4000009; hazardous material notes 1610; and customs notes 1612. Also part of box entry 1600 is third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; release to pack job number 1402, in this case 00195; packing list number 1502, in this case PHO 0402683; packing list box number 1512, in this case box number 1 ; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • release to pack job number 1402 in this case 00195
  • packing list number 1502 in this case PHO 0402683
  • packing list box number 1512 in this case box number 1
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or
  • Box entry 1600 includes the following: delivery ticket number 1606, in this case DD4000009; and packing hierarchy 1614, in this case packed to level 1. Also part of box entry 1600 is third- party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; release to pack job number 1402, in this case 00195; packing list number 1502, in this case PHO 0402683; packing list box number 1512, in this case box number 1; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • third- party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • release to pack job number 1402 in this case 00195
  • packing list number 1502 in this case PHO 0402683
  • packing list box number 1512 in this case box number 1
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or
  • Box entry 1600 includes the following: delivery ticket number 1606, in this case DD4000009; and packed packages 1616 associated with this box, in this case DRGHO 2004 030 8000 7000 2 and DRGHO 2004 030 8000 7000 3.
  • box entry 1600 Also part of box entry 1600 is third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; release to pack job number 1402, in this case 00195; packing list number 1502, in this case PHO 0402683; packing list box number 1512, in this case box number 1 ; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • release to pack job number 1402 in this case 00195
  • packing list number 1502 in this case PHO 0402683
  • packing list box number 1512 in this case box number 1
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500).
  • Delivery ticket entry 1700 includes the following: package details 1702; delivery ticket number 1606, in this case DD4000009; carrier 1704, in this case Varco; origin 1706, in this case Bush Intercontinental Airport in Houston; and delivery type 1708, in this case standard delivery.
  • Delivery ticket entry 1600 includes the following: third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600).
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600).
  • FIG. 27 a second tab of delivery ticket entry 1700 is illustrated.
  • Delivery ticket entry 1700 includes the following: delivery ticket number 1606, in this case DD4000009; delivery type 1708, in this case standard delivery; and package assignment 1710.
  • Also part of delivery ticket entry 1600 includes the following: third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; box number 1514, in this case DRGHOHOR 1500286; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600).
  • third-party logistics provider/freight forwarder 1102 in this case Dragon's Houston location
  • box number 1514 in this case DRGHOHOR 1500286
  • customer 1210 in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600).
  • Delivery ticket entry 1700 includes the following: delivery ticket number 1606, in this case DD4000009; delivery type 1708, in this case standard delivery; and load costs 1712. Also part of delivery ticket entry 1600 includes the following: third-party logistics provider/freight forwarder 1102, in this case Dragon's Houston location; and customer 1210, in this case Excel having customer number 781903 (from purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600).
  • FIGS. 29-31 different views of a shipper's destination profile that would be stored in system 900 and/or system 100, and generated by third-party logistics provider/freight forwarder 904 for use with process 1000, and which may be used with purchase order 1100 and/or receiving entry 1200 and/or material receipt entry 1300 and/or release to pack item entry 1400 and/or packing list entry 1500 and/or box entry 1600 and/or delivery ticket entry 1700, is illustrated.
  • FIG. 29 general information regarding a shipper's destination profile is illustrated.
  • Shipper's destination profile entry 1800 includes the following: third-party logistics provider/freight forwarder 1102, in this case Dragon; customer 1210, in this case Excel having customer number 781903; shipper's destination profile 1116, in this case Rio 182 - D; and flags 1802 which may be turned on or off for this shipper's destination profile. [00116] Referring now to FIG. 30, marking information regarding a shipper's destination profile is illustrated.
  • Shipper's destination profile entry 1800 includes the following: third- party logistics provider/freight forwarder 1102, in this case Dragon; customer 1210, in this case Excel having customer number 781903; shipper's destination profile 1116, in this case Rio 182 - D; and package markings 1504 which are provided on each package associated with this shipper's destination profile 1116.
  • Shipper's destination profile entry 1800 includes the following: third-party logistics provider/freight forwarder 1102, in this case Dragon; customer 1210, in this case Excel having customer number 781903; shipper's destination profile 1116, in this case Rio 182 - D; and group box identification 1804, to group packages together sharing common characteristics within this shipper's destination profile 1116.
  • third-party logistics provider/freight forwarder 1102 in this case Dragon
  • customer 1210 in this case Excel having customer number 781903
  • shipper's destination profile 1116 in this case Rio 182 - D
  • group box identification 1804 to group packages together sharing common characteristics within this shipper's destination profile 1116.
  • Customer update flags 1900 includes customer 1210, in this case Excel and packing flags 1902 which may be turned on or off for shipments to this customer.
  • system 900 is available to third-party logistics provider/freight forwarder 904, and optionally supplier/vendor 902 and/or shipper/customer 908, as a web-based Java application.
  • system 900 is available to third-party logistics provider/freight forwarder 904, and optionally supplier/vendor 902 and/or shipper/customer 908, as a terminal-based mainframe application.
  • the barcode and/or data associated with the barcode may be in any format sufficient to identify a company.
  • the barcode and/or a data entry associated with the barcode begins with a three digit company unique identifier to identify third-party logistics provider/freight forwarder 904 as receiving the freight, followed by a two digit location code, which identify the specific location of third-party logistics provider/freight forwarder 904 which received the freight.
  • barcode may include, the data entry associated with the barcode such as the date, the shipment of the day, and the package of the shipment. For example, a barcode having characters "123 HO 2004 03 11 017 003" represents the information of:
  • Company X having company code 123; at Company X's Houston location having location code HO; on the date March 11 , 2004 represented as 2004 03 11 ; for the 17th shipment received in the morning represented as 017; and that Company X received the third box of the 17th shipment.
  • one or more barcodes having characters "123 HO 2004 03 11 017 000" representing the "zero box" of the 17th shipment may be applied to the shipping and receiving documents to associate the boxes received and the shipment with the shipping and receiving documents. This allows the persons processing the paperwork to scan the papers, and associate all the boxes in the shipment with one or more purchase orders received at step 1002.
  • freight may be received at step 1004 prior to receiving a purchase order at step 1002, and in another embodiment, the purchase order may be received at step 1002 prior to receiving the freight at step 1004.
  • multiple products are grouped by shipper's destination profile, transportation method, and/or hazardous or nonhazardous materials.
  • all of the hazardous materials traveling to shipper/customer 908 by ship 906 may be grouped onto one packing list/pick ticket, while the non-hazardous materials traveling to shipper/customer 908 by airfreight may be grouped onto a different packing list/pick ticket.
  • multiple boxes from one pick ticket may be consolidated into a single larger container. This larger container is also supplied with a barcode with a unique identifier to create an association in system 900 between the larger container, the boxes within the larger container, and the products from the pick ticket within the boxes.
  • packages may be overpacked up to eight times. For example, multiple items in a bag, multiple bags packed into a carton, multiple cartons into a case, multiple cases into a box, and multiple boxes into a container, for five times over packing.
  • logistics supply chain 2000 is shown.
  • Product a 2002 has Barcode a 2004 attached thereto.
  • Product a 2002 is packed with other products, for example product b, product c, and product d (not shown), into Box 1 2006, and Box 1 2006 is closed and sealed.
  • Box 1 2006 has Barcode 1 2008. Box 1 2006 is then packed with other boxes, for example box 2, box 3, and box 4 (not shown), into
  • Container A 2010, and Container A 2010 is closed and sealed.
  • Container A 2010 has
  • Container A 2010 is then placed on Truck I 2014 with other containers.
  • Barcode I 2016 is attached to Truck I 2014.
  • Truck I 2014 is then moved to a first desired location, where Container A 2010 is transferred to Railcar 2018 with other containers. Railcar Barcode 2020 is attached to
  • Railcar 2018 is then moved to a second desired location, where Container A
  • Barcode II 2024 is attached to Truck II 2022 with other containers.
  • Truck II 2022 is then move to a third desired location where Container A 2010 is opened and unloaded.
  • Box 1 2006 is removed from Container A 2010 along with other boxes in Container A 2010.
  • Box 1 2006 is opened and unloaded.
  • Product a 2002 is removed from Box 1 2006 along with other products in Box 1 2006.
  • a scanner is directly connected, for example by wire, to a system which tracks logistical information of the products, which can be used to scan the barcodes of the products.
  • a scanner may be used which has a memory device to store the scanned barcodes, which may then transmit by radio frequency or store the data for later connection to a system which tracks logistical information of the products.
  • logistics supply chain 2100 includes Supplier A 2102, which gives product to Supplier A 2102.
  • Trucking Company A 2104 which delivers product to Rail Company A 2106, which delivers product to Trucking Company B 2108, which delivers product to Customer A 2110.
  • Information on the movement of the product may be delivered to, stored, and/or accessed from System A 2112, for example system 100.
  • Supplier A 2102 is connected to
  • Trucking Company B 2108 is connected to System A 2112 by
  • Connection D 2120 Customer A 2110 is connected to System A 2112 by Connection E
  • connections 2114, 2116, 2118, 2120, and/or 2122 may be made over the Internet, or for example with a wireless connection.
  • Supplier A 2102 receives a purchase order (not shown) from
  • Barcode A 2012 is also scanned to create a record in System A 2112 that associates Box 1 2006 with Container A 2010. This association will show the location of Product a 2002 having the same location as Box 1 2006 until such time as Box 1 2006 is unpacked at a destination, and will show the location of Box 1 2006 having the same location as Container A 2010 until such time as Container A 2010 is unpacked at a destination.
  • the information regarding the packing of Product a 2002 into Box 1 2006, and the packing of Box 1 2006 into Container A 2010 by Supplier A 2102 is transmitted to System A 2112 by Connection A 2114.
  • the information is inputted by a scanner, for example a hand-held RF scanner.
  • information is entered by hand on a keyboard.
  • one or more of Product a 2002, Box 1 2006, and/or Container A 2010 have an identifying tag or transmitter which can be read by readers located at one or more of Supplier A 2102, Trucking Company A 2104, Rail Company A 2106, Trucking Company B 2108, and/or Customer A 2110, to provide the location of Product a 2002, Box 1 2006, and/or Container A 2010 to System A 2112.
  • Supplier A 2102 then delivers Container A 2010 to Trucking Company A 2104, which puts Container A 2010 onto Truck I 2014, and creates a record in System A 2112 associating Container A 2010 with Truck I 2014 until such time as Container A 2010 is unloaded from Truck I 2014.
  • Trucking Company A 2104 updates the loading time and information, current location, and/or estimated time of arrival of Truck I 2014 to System A 2112 by Connection B 2116, for example by scanning Barcode I 2016, or by other suitable means. This information regarding Truck I 2014 allows the other companies in logistics supply chain 2100 to plan accordingly and monitor the progress.
  • Trucking Company A 2104 then delivers Container A 2010 to Rail Company A 2106, and creates a record in System A 2112 associating Container A 2010 with Railcar 2018 until such time as Container A 2010 is unloaded from Railcar 2018.
  • Rail Company A 2106 updates the loading time and information, current location, and/or estimated time of arrival of Railcar 2018 to System A 2112 by Connection C 2118, for example by scanning Railcar Barcode 2020, or by other suitable means. This information regarding Railcar 2018 allows the other companies in logistics supply chain 2100 to plan accordingly and monitor the progress.
  • Rail Company A 2106 then delivers Container A 2010 to Trucking Company B 2108, which puts Container A 2010 onto Truck II 2022, and creates a record in System A 2112 associating Container A 2010 with Truck II 2022 until such time as Container A 2010 is unloaded from Truck II 2022.
  • Trucking Company B 2108 updates the loading time and information, current location, and/or estimated time of arrival of Truck II 2022 to System A 2112 by Connection D 2120, for example by scanning Barcode II 2024, or by other suitable means. This information regarding Truck II 2022 allows the other companies in logistics supply chain 2100 to plan accordingly and monitor the progress.
  • Trucking Company B 2108 then delivers Container A 2010 to Customer A 2110, and creates a record in System A 2112 associating Container A 2010 with Customer A 2110 until such time as Container A 2010 leaves the site of Customer A 2110.
  • Customer A 2110 then proceeds to unpack Container A 2010 by removing Box 1 2006.
  • Customer A 2110 scans Barcode 1 2008 while unpacking to disassociate Box 1 2006 from Container A 2010.
  • Customer A 2110 then proceeds to unpack Box 1 2006 by removing Product a 2002.
  • Customer A 2110 scans Barcode a 2004 while unpacking to disassociate Product a 2002 from Box 1 2006.
  • Customer A 2110 updates System A 2112 with all this information by Connection E 2122, so that the other companies in logistics supply chain 2100 can see that Product a 2002 has successfully reached its destination.
  • System A 2112 may be owned and/or maintained by Supplier A 2102. In another embodiment, System A 2112 may be owned and/or maintained by Trucking Company A 2104. In another embodiment, System A 2112 may be owned and/or maintained by Rail Company A 2106. In another embodiment, System A 2112 may be owned and/or maintained by Trucking Company B 2108. In another embodiment, System A 2112 may be owned and/or maintained by Customer A 2110. In another embodiment, System A 2112 may be owned and/or maintained by a third-party provider, which provides data services regarding logistics supply chain 2100 to one or more of Supplier A 2102, Trucking Company A 2104, Rail Company A 2106, Trucking Company B 2108, and/or Customer A 2110.
  • one or more other systems may be provided and optionally connected to System A 2112 and each other; these one or more other systems may be owned and/or maintained by a third-party provider, Supplier A 2102, Trucking Company A 2104, Rail Company A 2106, Trucking Company B 2108, and/or Customer A 2110.
  • Logistics supply chain 2200 includes Supplier A 2202, which gives product to Trucking Company A 2204, which delivers product to Rail Company A 2206, which delivers product to Trucking Company B 2208, which delivers product to Customer A 2210. Information on the movement of the product may be delivered to, stored, and/or accessed from System A 2212, System B 2214, System C 2216, System D 2218, and/or System E 2220, each of which may be configured substantially the same as System 100.
  • Supplier A 2202 is connected to System A 2212 by Connection 2221.
  • Trucking Company A 2204 is connected to System B 2214 by Connection 2222.
  • Rail Company A 2206 is connected to System C 2216 by Connection 2223.
  • Trucking Company B is connected to System D 2218 by Connection 2224.
  • Customer A 2210 is connected to System E 2220 by Connection 2225.
  • System A 2212 is connected to Internet 2260 by Connection 2251.
  • System B 2214 is connected to Internet 2260 by Connection 2252.
  • System C 2216 is connected to Internet 2260 by Connection 2253.
  • System D 2218 is connected to Internet 2260 by Connection 2254.
  • System E 2220 is connected to Internet 2260 by Connection 2255. Connections 2251-2255 allow Systems 2212-2220 to synch data with one another, for example using standard synchronization techniques known in the art.
  • Supplier A 2202 receives a purchase order (not shown) from Customer A 2210 for Product a 2002.
  • Supplier A 2202 then generates a packing slip (not shown) which is sent to the warehouse to pick Product a 2002 off the shelf. As Product a 2002 is picked of the shelf, Barcode a 2004 is scanned to indicate that Product a 2002 has been pulled and is being prepared for shipment.
  • Barcode 1 2008 is also scanned to create a record in System A 2212 that associates Product a 2002 with Box 1 2006. This association will show the location of Product a 2002 having the same location of Box 1 2006 until such time as Box 1 2006 is unpacked at a destination. Box 1 2006 is scanned to indicate that Box 1 2006 has been assembled and is being prepared for shipment. Box 1 2006 is then packed with other boxes into Container A 2010.
  • Barcode A 2012 is also scanned to create a record in one or more of System A 2212, System B 2214, System C 2216, System D 2218, and/or System E 2220 that associates Box 1 2006 with Container A 2010.
  • This association will show the location of Product a 2002 having the same location as Box 1 2006 until such time as Box 1 2006 is unpacked at a destination, and will show the location of Box 1 2006 having the same location as Container A 2010 until such time as Container A 2010 is unpacked at a destination.
  • the information regarding the packing of Product a 2002 into Box 1 2006, and the packing of Box 1 2006 into Container A 2010 by Supplier A 2202 is transmitted to System 2212 by Connection 2221.
  • the information is nputted by a scanner, for example a hand-held RF scanner.
  • nformation is entered by hand on a keyboard.
  • System 2212 may then transmit this nformation to Internet 2260 by Connection 2251 , which may then be transmitted to Systems 2214-2220, to provide the information to Trucking Company A 2204, Rail Company A 2206, Trucking Company B 2208, and/or Customer A 2210, for example by a daily, hourly, or put and get (continuous/real time) synchronization.
  • one or more of Product a 2002, Box 1 2006, and/or Container A 2010 have an identifying tag or transmitter which can be read by readers located at one or more of Supplier A 2202, Trucking Company A 2204, Rail Company A 2206, Trucking Company B 2208, and/or Customer A 2210, to provide the location of Product a 2002, Box 1 2006, and/or Container A 2010 to Systems 2212-2220.
  • Supplier A 2202 then delivers Container A 2010 to Trucking Company A 2204, which puts Container A 2010 onto Truck I 2014, and creates a record in System 2214 associating Container A 2010 with Truck I 2014 until such time as Container A 2010 is unloaded from Truck I 2014.
  • Trucking Company A 2204 updates the loading time and information, current location, and/or estimated time of arrival of Truck I 2014 to System 2214 by Connection 2222, for example by scanning Barcode I 2016, or by other suitable means. This information regarding Truck I 2014 is then synchronized with Systems 2212 and 2216-2220 through Internet 2216, which allows the other companies in logistics Supply Chain 2200 to plan accordingly and monitor the progress of the product movement, for example by a daily, hourly, or put and get (continuous/real time) synchronization. [00152] Trucking Company A 2204 then delivers Container A 2010 to Rail Company A 2206, and creates a record in System 2216 associating Container A 2010 with Railcar 2018 until such time as Container A 2010 is unloaded from Railcar 2018.
  • Rail Company A 2206 updates the loading time and information, current location, and/or estimated time of arrival of Railcar 2018 to System C 2216 by Connection C 2223, for example by scanning Railcar Barcode 2020, or by other suitable means (which may be synchronized with systems 2212-2214 and 2218-2220 as above). This information regarding Railcar 2018 allows the other companies in logistics supply chain 2200 to plan accordingly and monitor the progress of the product movement. [00153] Rail Company A 2206 then delivers Container A 2010 to Trucking Company B 2208, which puts Container A 2010 onto Truck II 2022, and creates a record in System 2218 associating Container A 2010 with Truck II 2022 until such time as Container A 2010 is unloaded from Truck II 2022.
  • Trucking Company B 2208 updates the loading time and information, current location, and/or estimated time of arrival of Truck II 2022 to System 2218 (which may be synchronized with systems 2212-2216 and 2220 as above), for example by scanning Barcode II 2024, or by other suitable means. This information regarding Truck II 2022 allows the other companies in logistics supply chain 2200 to plan accordingly and monitor the progress of the product movement.
  • Trucking Company B 2208 then delivers Container A 2010 to Customer A 2210, and creates a record in System 2220 associating Container A 2010 with Customer A 2210 until such time as Container A 2010 leaves the site of Customer A 2210.
  • Customer A 2210 then proceeds to unpack Container A 2010 by removing Box 1 2006.
  • Customer A 2210 scans Barcode 1 2008 while unpacking to disassociate Box 1 2006 from Container A 2010.
  • Customer A 2210 then proceeds to unpack Box 1 2006 by removing Product a 2002.
  • Customer A 2210 scans Barcode a 2004 while unpacking to disassociate Product a 2002 from Box 1 2006.
  • Customer A 2210 updates System 2220 with all this information (which may be synchronized with systems 2212-2218 as above), so that the other companies in logistics supply chain 2200 can see that Product a 2002 has successfully reached its destination.
  • Systems 2212-2220 may be owned and/or maintained by one or more of Supplier A 2202, Trucking Company A 2204, Rail Company A 2206, Trucking Company B 2208, Customer A 2210, and/or maintained by a third-party provider, which provides data services regarding logistics supply chain 2200 to one or more of Supplier A 2202, Trucking Company A 2204, Rail Company A 2206, Trucking Company B 2208, and/or Customer A 2210.
  • Supplier A 2202 updates System A 2212 by Connection 2221 , and Systems 2212-2220 are connected to each other through Internet 2260 by Connections 2251-2255.
  • System A 2212 is synchronized with the data in Systems 2214-2220 so that Supplier A 2202 does not need to be directly connected to Systems 2214-2220.
  • logistics supply chain 2400 includes Engine Corp. 2402, Al's Engine Shop 2406, Global Logistics Company 2410, Engine Corp. Warehouse 2414, Car Corp. 2416, and Airplane Corp. 2414.
  • Engine Corp 2402 is connected to System A 2404, for example system 100.
  • Engine Corp Warehouse 2414 is connected to System A 2404.
  • Global Logistics Company 2410 is connected to System B 2412, for example system 100.
  • Corp. 2414 is connected to System C 2418, for example system 100.
  • Engine Corp. 2402 sells engines to Car Corp. 2416 and Airplane Corp. 2414.
  • Engine Shop 2406 is connected to Internet 2408, which enables Al's Engine Shop 2406 to access System A 2404. As Al's Engine Shop 2406 manufactures an engine, a barcode or other unique identifier is applied to the engine, which information is inputted into System A
  • the barcode or other unique identifier is unique within logistics supply chain 2400 to Al's Engine Shop 2406, so that anyone who receives the engine and inputs the barcode or other unique identifier into one of Systems 2404, 2412, and/or 2418 will know that the engine originated from Al's Engine Shop 2406.
  • System A 2404 is synchronized with System B 2412 and System C 2418 so that
  • Engine Corp. 2402 Al's Engine Shop 2406, Global Logistics Company 2410, Engine Corp.
  • Warehouse 2414, Car Corp. 2416, and/or Airplane Corp. 2414 can monitor the status of the engines, for example by a daily, hourly, or put and get (continuous/real time) synchronization.
  • Al's Engine Shop 2406 then ships the engine to Global Logistics Company 2410, which scans the barcode or otherwise inputs the unique identifier to associate the engine with Global Logistics Company 2410. This information is then fed to System B 2412, which is synchronized with System A 2404 and System C 2418, as above.
  • the warehouse workers receive the engines and scan the barcode placed on by Al's Engine Shop 2406 to update Systems 2404, 2412, and
  • Airline Corp. 2414 as needed. When Airline Corp. 2414 receives an engine, it updates
  • System C 2418 with the delivery information.
  • Car Corp. 2416 receives an engine, it accesses and updates System B 2412 through Internet 2408 with the delivery information.
  • logistics supply chain 2500 includes Refinery 2502, Parts Supplier A 2506, Parts
  • Refinery 2502 is connected to System A 2504, for example system 100.
  • System A 2504 is also connected to Internet 2508, allowing Parts Supplier A 2506 and/or
  • Parts Supplier A 2506 and Parts Supplier B 2510 supply some of the exact same parts to Refinery 2502.
  • Parts Supplier A 2506 Prior to shipping parts to Refinery 2502, Parts Supplier A 2506 applies a unique identifier, for example a barcode, to the parts which identify that the parts originated from Parts Supplier A 2506.
  • Parts Supplier B 2510 Prior to shipping parts to Refinery 2502, Parts Supplier B 2510 applies a unique identifier, for example a barcode, to the parts which identify that the parts originated from Parts Supplier B 2510.
  • refinery workers may input the unique identifier to identify where the parts originated from.
  • Parts Supplier A 2506 and Parts Supplier B 2510 each have unique identifiers applied to every part they ship, there will never be data collisions at refinery 2502 even though some identical parts are shipped from Parts Supplier A 2506 and Parts Supplier B 2510.
  • a data management system including a database adapted to contain data, and a server connected to the database adapted to transmit the logistics data to at least one user.
  • the system also includes a middleware device connected between the database and the web server.
  • the system also includes an electronic data interchange adapted to transmit data from a user to the database.
  • the system also includes a report generator.
  • the system also includes a print server.
  • at least one table of the database comprises a shipper's destination profile.
  • at least one table of the database comprises a unique company code data field.
  • the company code data fields comprises about 1 to 50 characters; 2-25 characters; or 3-10 characters.
  • the company code data fields comprises three characters.
  • the company code data fields comprises four characters.
  • the data includes logistics data.
  • a method of managing information including creating a plurality of data tables, linking each data table with at least one other data table, populating the plurality of data tables with data, and providing access to the data.
  • providing access to the data comprises generating reports.
  • providing access to the data comprises connecting a web server to at least one of the data tables.
  • providing access to the data comprises providing access to the data to selected users over the Internet.
  • at least one of the data tables comprises a shipper's destination profile data field.
  • at least one of the data tables comprises a unique company code data field.
  • each of the data tables comprises a unique company code data field.
  • the company code data field comprises about 1 to 50 characters; 2- 25 characters; or 3-10 characters. In another embodiment, the company code data field comprises three characters or four characters. In another embodiment, at least one of the data tables also comprises a company location code data field. In another embodiment, the company location code data field comprises two characters. In another embodiment, the data includes logistics data.
  • a system adapted to manage logistics data for a product moving from an initial origin to a destination including a means to receive a requirement to move the product, a means to locate or receive the product, a means to match the requirement with the product, and a means to ship the product.
  • the means to receive the requirement comprises electronic data interchange, and wherein the requirement comprises a requisition order, a purchase order, a movement order, or an asset movement order.
  • the system also includes a means to generate a pick ticket.
  • the system also includes a means to generate shipping documents.
  • the system also includes a means to verify that the product being shipped is the same as the product requested on the requirement.
  • system also includes a means to monitor the product in transit after being shipped.
  • system also includes a means to share the data within the system with a plurality of users.
  • the means to share the data comprises a Web browser and the Internet.
  • system also includes a means to group the product with other products for shipping.
  • a method of managing logistics data from a plurality of shippers to a receiver including a first shipper assigning a unique first shipper number to a unique identifier, the unique identifier applied to each product shipped from the first shipper to the receiver, and a second shipper assigning a unique second shipper number to a unique identifier, the unique identifier applied to each product shipped from the second shipper to the receiver.
  • the method also includes at least one of the first shipper and the second shipper applying a barcode to a product.
  • the method also includes the receiver managing data concerning each product shipped from the first shipper to the receiver based on the unique first shipper number.
  • the method also includes the receiver managing data concerning each product shipped from the second shipper to the receiver based on the unique second shipper number. In another embodiment, the method also includes the receiver and the first shipper sharing access to a database containing logistics data concerning each product shipped from the first shipper to the receiver. In another embodiment, the method also includes the receiver and the second shipper sharing access to a database containing logistics data concerning each product shipped from the second shipper to the receiver. In another embodiment, the method also includes the first shipper shipping product to a first third-party logistics provider. In another embodiment, the method also includes assigning a unique first third-party logistics provider number to a unique identifier, the unique identifier applied to each product shipped from the first shipper to the first third-party logistics provider.
  • the method also includes the second shipper shipping product to a second third-party logistics provider. In another embodiment, the method also includes assigning a unique second third-party logistics provider number to a unique identifier, the unique identifier applied to each product shipped from the second shipper to the second third-party logistics provider. In another embodiment, the method also includes at least one of the first third-party logistics provider and the second third-party logistics provider shipper applying a barcode to a product. In another embodiment, the method also includes the receiver, the first third-party logistics provider, and the first shipper sharing access to a database containing logistics data concerning each product shipped from the first shipper to the first third-party logistics provider, to the receiver.
  • the method also includes the receiver, the second third-party logistics provider, and the second shipper sharing access to a database containing logistics data concerning each product shipped from the second shipper to the second third-party logistics provider, to the receiver.
  • a logistics data management system including a database adapted to contain logistics data and configured to be accessed by an internet connection.
  • the database is adapted to connect to a middleware device.
  • the database is adapted to connect to an electronic data interchange adapted to transmit data from a user to the database.
  • at least one database record comprises a shipper's destination profile.
  • at least one table of the database comprises a unique company code data field.
  • each table of the database comprises a unique company code data field.
  • the company code data fields comprises three characters.
  • the company code data fields comprises four characters.
  • the company code data fields comprises about 1 to 50 characters; 2-25 characters; or 3-10 characters.
  • at least one table of the database comprises a company location code data field.
  • the company location code data field comprises about 1 to 10 characters.
  • a supply chain including at least two members of the supply-chain selected from the group consisting of shippers, receivers, customers, suppliers, vendors, third-party logistics providers, and a database containing logistics data concerning the supply-chain, wherein the at least two members of the supply- chain are each assigned a unique identifier within the database.
  • the unique identifier comprises a company code data field.
  • the company code data fields comprises about 1 to 50 characters; 2-25 characters; or 3-10 characters.
  • at least one table of the database further comprises a company location code data field.
  • each table of the database comprises the unique identifier.
  • every member of the supply-chain is assigned a unique identifier within the database.
  • a method of managing a supply chain including providing at least two members of the supply-chain selected from the group consisting of shippers, receivers, customers, suppliers, vendors, third-party logistics providers, and assigning a unique identifier to the at least two members of the supply-chain.
  • the unique identifier comprises a company code data field within a logistics management data system.
  • the company code data fields comprises about 1 to 50 characters; 2-25 characters; or 3-10 characters.
  • the method also includes assigning a unique identifier to every member of the supply-chain.
  • the systems 100 and/or 900 may include a single network or may be a variety of different networks, such as an intranet and the Internet, and may include both wireline and wireless communication channels to connect the various components.
  • a data management system including a database adapted to contain data associated with a unique identifier, and a server connected to the database adapted to transmit the data to at least two users.
  • the system also includes a middleware device connected between the database and the web server.
  • the system also includes an electronic data interchange adapted to transmit data from a user to the database.
  • the system also includes a report generator.
  • the system also includes a print server.
  • at least one table of the database comprises a shipper's destination profile.
  • at least one table of the database comprises a unique company code data field.
  • the company code data fields comprises about 1 to 50 characters; 2-25 characters; or 3-10 characters.
  • the company code data fields comprises three characters. In another embodiment, the company code data fields comprises four characters. In another embodiment the data includes logistics data. [00176] In one embodiment, there is disclosed a method of managing information including creating a plurality of data tables each data table containing at least one field for a unique identifier, linking each data table with at least one other data table, populating the plurality of data tables with data including the unique identifiers, and providing access to the data. In another embodiment, providing access to the data comprises generating reports. In another embodiment, providing access to the data comprises connecting a web server to at least one of the data tables. In another embodiment, providing access to the data comprises providing access to the data to selected users over the Internet.
  • At least one of the data tables comprises a shipper's destination profile data field. In another embodiment, at least one of the data tables comprises a unique company code data field. In another embodiment, each of the data tables comprises a unique company code data field. In another embodiment, the company code data field comprises about 1 to 50 characters; 2- 25 characters; or 3-10 characters. In another embodiment, the company code data field comprises three characters or four characters. In another embodiment, at least one of the data tables also comprises a company location code data field. In another embodiment, the company location code data field comprises two characters. In another embodiment, the data includes logistics data.
  • system 100 and/or system 900 incorporate one or more elements of the technical disclosure located at http://www.hal-inc.com/. Http://www.hal-inc.com/ is herein incorporated by reference in its entirety.
  • system 100 and/or system 900 incorporate one or more elements of the technical disclosure located in the documentation regarding the product MEPAW®, commercially available from Hal, Inc. of Houston, Texas, at http://www.hal-inc.com.
  • the documentation regarding the product MEPAW® is herein incorporated by reference in its entirety.
  • system 100 and/or system 900 incorporate one or more elements of the technical disclosure located in Appendix A.
  • Appendix A is herein incorporated by reference in its entirety.
  • Numerous other variations and modifications can be made without departing from the spirit of the present invention.
  • the disclosed systems and methods may be used with any type of data, such as for example, logistic data, or in any environment where data management is required, such as for example, a logistics environment, a financial data environment, or an inventory control environment.
  • the disclosed logistics systems and methods may employ any type of transporting entities.
  • the present invention has been described relative to a preferred embodiment.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

un système de gestion des données incluant une base de données conçue pour contenir des données associées à un identifiant unique, et un serveur connecté à la base de données et conçu pour donner accès aux données à au moins un utilisateur.
PCT/US2004/011163 2003-04-10 2004-04-12 Structure de donnees et systeme destine a un partage global de l'information WO2004092898A2 (fr)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US46203203P 2003-04-10 2003-04-10
US60/462,032 2003-04-10
US46281203P 2003-04-14 2003-04-14
US60/462,812 2003-04-14

Publications (2)

Publication Number Publication Date
WO2004092898A2 true WO2004092898A2 (fr) 2004-10-28
WO2004092898A3 WO2004092898A3 (fr) 2006-05-04

Family

ID=33303062

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2004/011163 WO2004092898A2 (fr) 2003-04-10 2004-04-12 Structure de donnees et systeme destine a un partage global de l'information

Country Status (1)

Country Link
WO (1) WO2004092898A2 (fr)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6006200A (en) * 1998-05-22 1999-12-21 International Business Machines Corporation Method of providing an identifier for transactions
US6349298B1 (en) * 1993-02-25 2002-02-19 Massachusetts Institute Of Technology Computerized handbook of processes
US6401085B1 (en) * 1999-03-05 2002-06-04 Accenture Llp Mobile communication and computing system and method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6349298B1 (en) * 1993-02-25 2002-02-19 Massachusetts Institute Of Technology Computerized handbook of processes
US6006200A (en) * 1998-05-22 1999-12-21 International Business Machines Corporation Method of providing an identifier for transactions
US6401085B1 (en) * 1999-03-05 2002-06-04 Accenture Llp Mobile communication and computing system and method

Also Published As

Publication number Publication date
WO2004092898A3 (fr) 2006-05-04

Similar Documents

Publication Publication Date Title
US8510179B2 (en) Inventory transaction common object
Myerson RFID in the supply chain: a guide to selection and implementation
US5485369A (en) Logistics system for automating tansportation of goods
US7426484B2 (en) Consolidated shipping and distribution of multiple orders with returns
US8650132B2 (en) System and method for distribution of single-product-type unlabeled packages
US20070038673A1 (en) Method and apparatus for advanced shipping notification and EDI through web portal
US20030195784A1 (en) Intelligent authorized return systems and methods
US20080294536A1 (en) System and method for providing export services to merchants
US20050289020A1 (en) Methods and systems for managing stock transportation
CN101103360A (zh) 用于供应链管理的系统和方法
CN101027690A (zh) 整合全球追踪和虚拟库存系统
WO2002047048A2 (fr) Systeme de suivi dans une chaine d'approvisionnement, destine au suivi de marchandises en temps reel
EP1183626A2 (fr) Traitement de manutention speciale dans un systeme de transport de paquets ou de colis
WO2003030056A2 (fr) Procedes de creation de factures douanieres electroniques
MXPA04009954A (es) Sistemas y metodos de retorno autorizado inteligente.
JP4442595B2 (ja) 物品管理システム
WO2020166340A1 (fr) Procédés de tri de marchandises et de gestion d'emballage
JP2002109002A (ja) 戦略的提携情報管理システム、その運用方法、その管理用プログラム記録媒体、又は伝票類発行システム、貨物管理システム、物流管理システム及び商品管理方法
JPS63288804A (ja) ノックダウン生産用部品の管理方法
WO2004092898A2 (fr) Structure de donnees et systeme destine a un partage global de l'information
AU2003212308B2 (en) Supply chain fulfillment coordination
Mo Development of a national electronic product code network for the tracking of fast moving consumer goods
EP4033428A1 (fr) Système et procédé de gestion d'articles, de récipients et d'entités
JP7123183B2 (ja) 統合された通信スキームを使用してネットワークをインターフェースするためのシステムおよび方法
WO2016033673A1 (fr) Système et procédé de logistique pour chargements modulaires appliquant l'intermodalité et/ou la multimodalité

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NA NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): BW GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
DPEN Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed from 20040101)
122 Ep: pct application non-entry in european phase