Invoices: This table stores detailed information about shipping invoices. It includes fields such as tracking ID, bill to account number, invoice date, invoice number, calculated rate, surcharge, total amount, payer details, service type, shipment and delivery dates, packaging details, dimensional measurements, weight estimations, commodity descriptions, zone codes, declared values, recipient and shipper details, sort hub information, delivery confirmation status, and records of creation and modification. This comprehensive data allows for efficient tracking and management of shipping transactions and financial records.
Surcharges: This table records additional charges applied to shipping invoices. It includes fields for surcharge ID, description, amount, and links to the corresponding tracking ID from the invoices table. This enables tracking of specific surcharges associated with shipping transactions, facilitating accurate billing and financial reporting.
Rates & Markups: This table manages the rates and markups applied to shipping services. It includes fields for effective date, envelope/package type, weight thresholds, zone codes, base rates, markup percentages, markup amounts, final rates, and details for checking duplicates. This data is crucial for calculating shipping costs accurately based on various factors such as package type, weight, and destination zone.
Calculation of Rates: This table stores the detailed calculations used to determine final shipping rates. It includes fields for envelope/package type, weight details, zone codes, last base rates, markup percentages, markup amounts, final rates, and records of creation and modification. This information supports transparency and accuracy in rate calculations for shipping services.
In summary, the "Logistics: Shipping Service" database facilitates efficient management of shipping operations by maintaining comprehensive records of invoices, surcharges, rates, and rate calculations. It enables logistics managers to track shipping transactions, apply appropriate charges, calculate accurate shipping rates, and ensure compliance with customer billing requirements. This database plays a critical role in enhancing operational efficiency and financial management within shipping and logistics services.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.