SYSTEM AND METHOD FOR CAPTURING AND STORING SUPPLY CHAIN AND LOGISTICS SUPPORT INFORMATION IN A RELATIONAL DATABASE SYSTEM

摘要

A computer implemented method of and system for capturing, storing and organizing supply chain and logistics support information for a retail enterprise. Supply chain and logistics support information is stored and organized within a relational database in accordance with a logical data model comprising a plurality subject areas, and entities and relationships within the subject areas, defining the manner in which supply chain and logistics support information is stored and organized within the relational database. The relational database, populated with this information, provides a retail enterprise with detailed tracking and analysis support for shipping orders, freight bills, shipping order claims, and invoices; and detailed support for fleet tracking of shipments in the areas of legs, lanes and associated routes traveled, mode of transport, and specific equipment utilized in handling of shipments; allowing for improved supply chain efficiency through better informed decision making.