Jump to content

Quotations Charges Extract

From PBI Reporting Wiki

Overview

Captures all the different charges for all the jobs coming out of QMS.

Extract Data

Existing Extract

Column Description
quotation_id Link back to the main quotation/job
charge_code Charge type (e.g. LINEHAUL, FS, XB)
buy_min_cost Minimum buy-side cost
buy_rate Buy-side rate applied
cost_value Calculated buy-side cost value
cost_currency Currency for cost values
sale_min_cost Minimum sell-side cost
sale_rate Sell-side rate applied
sell_value Calculated sell-side revenue value
sell_currency Currency for sell values
business_type Business classification (e.g. LINEHAUL, undefined)
iata_code Optional IATA code for the charge line