Freight rate fields in every export
Each quote record carries origin and destination as ports or locations, the mode, the load type such as full container, less than container load, air or express, the container type or the dimensional and weight profile, and the incoterms basis where stated.
Price is decomposed rather than delivered as a single figure. Base freight, surcharges, origin and destination charges, and the total are kept apart, because a base rate that looks competitive and a total that does not is the most common pattern in freight quoting and it is invisible in a single number.
Transit time is captured as the estimated days in transit plus, where published, the routing including transhipment points. Direct and transhipped routings on the same lane are different products and should not be averaged together.
Validity is recorded. Freight quotes expire, and a rate without the date it was quoted for and the window it is valid in is not a usable observation. Every row carries the quote date, the requested shipping date and the validity period where given.
Currency is stored as quoted, with the conversion rate and date recorded separately if a client wants a common currency, so that exchange movement never gets mistaken for freight market movement.