Jump to content

Quotations Charges Extract

From PBI Reporting Wiki
Revision as of 13:27, 17 September 2025 by David.weller (talk | contribs) (Created page with "== Overview == Captures all the different charges for all the jobs coming out of QMS. == Extract Data == === Existing Extract === {| class="wikitable" |+ !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_mi...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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