Skip to main content

Transportation (freight)

Pack file: catalog/industries/transportation in ambient-core.

Workspace demo (screenshots) · Catalog consumption

Industry summary​

Industry code

ISIC Rev.4 4923

28 metrics · 19 data options

NAICS 2022
484110 (also 484122, 483111)
NACE Rev.2
49.41 (also 50.20)
GICS 2023
203040

Taxonomy tags from ambient-core pack.yaml / manifest v3 (analysis lens, not legal-entity self-classification). Coverage notes: catalog-industry-coverage.md.

Data options (19)​

Vehicle telematics data​

Catalog key 5tZAB2WLZbRDQdj6l7X6

Fields

date
date
vehicle_id
id
telematics_date
date
engine_performance
string
fuel_efficiency
string
maintenance_alerts
string
driver_behavior
string

Accounts payable aging​

Catalog key Alltransportationds-ap-aging

Fields

date
date
supplier_name
string
bill_id
id
bill_date
date
due_date
date
amount_due
decimal
days_outstanding
string
aging_bucket
string
accounts_payable
decimal
cogs
string
days
string
days_inventory_outstanding
string

Accounts receivable aging​

Catalog key Alltransportationds-ar-aging

Fields

date
date
customer_name
string
invoice_id
id
invoice_date
date
due_date
date
amount_due
decimal
days_outstanding
string
aging_bucket
string
accounts_receivable
decimal
total_credit_sales
decimal
days
string
days_inventory_outstanding
string

Balance sheet​

Catalog key Alltransportationds-balance-sheet

Fields

date
date
period_end_date
date
inventory
string

Bank statements​

Catalog key Alltransportationds-bank-statements

Fields

date
date
transaction_date
date
account_id
id
description
string
amount
decimal
direction
string
balance
string
currency
currency
net_income
string
non_cash_charges
string
increase_in_working_capital
string
cash_out
string
cash_in
string
current_cash_balance
string

General ledger​

Catalog key Alltransportationds-general-ledger

Fields

date
date
account_code
id
account_name
decimal
journal_entry_id
id
debit
string
credit
string
period
enum
currency
currency

Trial balance​

Catalog key Alltransportationds-trial-balance

Fields

date
date
account_code
id
account_name
decimal
debit_balance
string
credit_balance
string
period
enum

Maintenance logs​

Catalog key DclVZaLbyz6Pwxt5Ctr1

Fields

date
date
vehicle_id
id
maintenance_date
date
maintenance_type
enum
total_maintenance_costs
decimal
total_miles
decimal
odometer_reading
decimal
work_order_id
id

Fleet management systems​

Catalog key Ta6fK4eo9bymVVQGYEpl

Fields

date
date
fleet_id
id
vehicle_ids
string
maintenance_schedule
string
fuel_logs
string
insurance_details
string
fleet_time_in_use
string
fleet_available_time
string

Delivery logs​

Catalog key i0N19s7GpHi9QTyG5dhM

Fields

date
date
delivery_date
date
vehicle_id
id
route_id
id
delivery_status
enum
delivery_address
string
customer_name
string
delivery_time
string

GPS tracking data​

Catalog key jHscrlnM67xOUF1IXfos

Fields

date
date
vehicle_id
id
tracking_date
date
start_location
string
end_location
string
distance_travelled
string
average_speed
string
route_taken
string

Accounting Software​

Catalog key transportation.core.accounting_software

Fields

date
date
period_start_date
date
period_end_date
date
revenue
decimal
cogs
decimal
cost_of_goods
decimal
operating_expenses
decimal
net_income
decimal
produce_revenue
decimal
total_production_cost
decimal
total_operational_cost
decimal

Financial statements​

Catalog key transportation.core.financial_statements

Fields

date
date
statement_type
enum
period_start_date
date
period_end_date
date

HR records​

Catalog key transportation.core.hr_records

Fields

date
date
headcount
decimal

Payroll records​

Catalog key transportation.core.payroll_records

Fields

date
date
period_start_date
date
period_end_date
date
headcount
decimal
gross_pay
decimal
net_pay
decimal
employer_taxes
decimal
labor_cost
decimal
revenue
decimal
net_income
decimal
total_labor_costs
decimal
total_harvested_kg
decimal
total_production_cost
decimal
total_operational_cost
decimal
drivers_left
decimal
total_drivers
decimal
total_maintenance_costs
decimal
total_miles
decimal

Freight forwarding operations summary​

Catalog key transportation.freight_forwarding.operations_summary

Fields

date
date
shipments_handled
string
on_time_shipments
string
total_shipments
decimal

Maritime fleet operations summary​

Catalog key transportation.maritime.operations_summary

Fields

date
date
operating_days
string
available_days
string
voyage_revenue
decimal
voyage_costs
decimal
on_hire_days
string
on_schedule_voyages
string
total_voyages
decimal

Rail freight operations summary​

Catalog key transportation.rail_freight.operations_summary

Fields

date
date
loaded_train_miles
string
available_train_miles
string
total_operating_cost
decimal
ton_miles_moved
string
on_time_shipments
string
total_shipments
decimal

Fuel logs​

Catalog key uRTkFZUmJC2BLwoRtJxL

Fields

date
date
vehicle_id
id
fuel_type
enum
fuel_date
date
fuel_quantity
string
fuel_cost
decimal
odometer_reading
string

Metrics (28)​

Driver Turnover Rate​

  • ID: 14
  • Type: Operational
  • Unit: %
  • Description: The percentage of drivers that leave the company within a specific period.
  • Inputs: drivers_left, total_drivers
  • Methodology: (Number of drivers who left / Total number of drivers) * 100
  • Calculation: drivers_left / total_drivers * 100
  • Catalog key: DtBqsvp9S9HBlcxsvAgd

Fuel Efficiency​

  • ID: 10
  • Type: Operational
  • Unit: Miles per Gallon (MPG)
  • Description: Average miles per gallon for the fleet.
  • Inputs: total_miles, total_fuel
  • Methodology: Total miles driven / Total fuel used
  • Calculation: total_miles / total_fuel
  • Catalog key: SAZkxRxYFtf1EIxBXWMk

On-Time Delivery Rate​

  • ID: 12
  • Type: Operational
  • Unit: %
  • Description: The percentage of deliveries made on or before the scheduled delivery time.
  • Inputs: on_time_deliveries, total_deliveries
  • Methodology: (Number of on-time deliveries / Total deliveries) * 100
  • Calculation: on_time_deliveries / total_deliveries * 100
  • Catalog key: biA3oIK816fwfInBKg2e

Fleet Utilization Rate​

  • ID: 11
  • Type: Operational
  • Unit: Percentage
  • Description: The percentage of time the fleet is actively in use.
  • Inputs: fleet_time_in_use, fleet_available_time
  • Methodology: (Total time fleet in use / Total available fleet time) * 100
  • Calculation: fleet_time_in_use / fleet_available_time * 100
  • Catalog key: iIaKhCCf0BGvHX1W1i7n

Monthly Burn Rate​

  • ID: 1000
  • Type: Financial
  • Unit: Currency/month
  • Description: Net cash consumed per month (negative net operating cash flow).
  • Inputs: cash_out, cash_in
  • Methodology: Net Burn = Cash Out − Cash In (per month)
  • Calculation: cash_out - cash_in
  • Catalog key: transportation.core.burn_rate

Cash Conversion Cycle​

  • ID: 988
  • Type: Financial
  • Unit: Days
  • Description: Days to convert investments in inventory and receivables back into cash.
  • Inputs: days_inventory_outstanding
  • Methodology: CCC = DSO + Days Inventory Outstanding − DPO
  • Calculation: dso + days_inventory_outstanding - dpo
  • Catalog key: transportation.core.ccc

Current Ratio​

  • ID: 928
  • Type: Financial
  • Unit: Ratio
  • Description: Short-term liquidity: ability to cover current liabilities with current assets.
  • Inputs: current_assets, current_liabilities
  • Methodology: Current Ratio = Current Assets / Current Liabilities
  • Calculation: current_assets / current_liabilities
  • Catalog key: transportation.core.current_ratio

Days Payable Outstanding (DPO)​

  • ID: 982
  • Type: Financial
  • Unit: Days
  • Description: Average number of days the business takes to pay its suppliers.
  • Inputs: accounts_payable, cogs, days
  • Methodology: DPO = (Accounts Payable / COGS) × Number of Days
  • Calculation: accounts_payable / cogs * days
  • Catalog key: transportation.core.dpo

Days Sales Outstanding (DSO)​

  • ID: 976
  • Type: Financial
  • Unit: Days
  • Description: Average number of days to collect cash after a sale.
  • Inputs: accounts_receivable, total_credit_sales, days
  • Methodology: DSO = (Accounts Receivable / Total Credit Sales) × Number of Days
  • Calculation: accounts_receivable / total_credit_sales * days
  • Catalog key: transportation.core.dso

EBITDA Margin​

  • ID: 952
  • Type: Financial
  • Unit: %
  • Description: Core operating cash profitability before interest, tax, depreciation and amortization.
  • Inputs: ebitda, revenue
  • Methodology: EBITDA Margin = (EBITDA / Revenue) × 100
  • Calculation: ebitda / revenue * 100
  • Catalog key: transportation.core.ebitda_margin

Gross Profit Margin​

  • ID: 940
  • Type: Financial
  • Unit: %
  • Description: Share of revenue retained after the direct cost of goods sold.
  • Inputs: revenue, cogs
  • Methodology: Gross Margin = ((Revenue − COGS) / Revenue) × 100
  • Calculation: (revenue - cogs) / revenue * 100
  • Catalog key: transportation.core.gross_margin

Headcount (FTE)​

  • ID: 1084
  • Type: Operational
  • Unit: Count
  • Description: Period-end count of active full-time-equivalent employees. A directly measured input, not a derived ratio.
  • Methodology: Period-end count of active employees expressed as full-time equivalents (directly measured, not calculated).
  • Calculation: No machine-readable calc — directly reported or qualitative.
  • Catalog key: transportation.core.headcount

Net Profit Margin​

  • ID: 958
  • Type: Financial
  • Unit: %
  • Description: Bottom-line profitability after all costs, interest and tax.
  • Inputs: net_income, revenue
  • Methodology: Net Profit Margin = (Net Income / Revenue) × 100
  • Calculation: net_income / revenue * 100
  • Catalog key: transportation.core.net_margin

Operating Cash Flow​

  • ID: 994
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Cash generated by core operations during the period.
  • Inputs: net_income, non_cash_charges, increase_in_working_capital
  • Methodology: Operating Cash Flow = Net Income + Non-Cash Charges − Increase in Working Capital
  • Calculation: net_income + non_cash_charges - increase_in_working_capital
  • Catalog key: transportation.core.operating_cash_flow

Operating Margin (EBIT)​

  • ID: 946
  • Type: Financial
  • Unit: %
  • Description: Operating profitability after operating expenses (EBIT margin).
  • Inputs: operating_income, revenue
  • Methodology: Operating Margin = (Operating Income / Revenue) × 100
  • Calculation: operating_income / revenue * 100
  • Catalog key: transportation.core.operating_margin

Quick Ratio (Acid Test)​

  • ID: 934
  • Type: Financial
  • Unit: Ratio
  • Description: Acid-test liquidity excluding inventory — most conservative short-term solvency view.
  • Inputs: current_assets, inventory, current_liabilities
  • Methodology: Quick Ratio = (Current Assets − Inventory) / Current Liabilities
  • Calculation: (current_assets - inventory) / current_liabilities
  • Catalog key: transportation.core.quick_ratio

Revenue Growth Rate​

  • ID: 964
  • Type: Financial
  • Unit: %
  • Description: Period-over-period revenue growth rate.
  • Inputs: revenue, revenue_prior
  • Methodology: Revenue Growth = ((Current Period Revenue − Prior Period Revenue) / Prior Period Revenue) × 100
  • Calculation: (revenue - revenue_prior) / revenue_prior * 100
  • Catalog key: transportation.core.revenue_growth

Cash Runway​

  • ID: 1006
  • Type: Financial
  • Unit: Months
  • Description: Number of months of cash remaining at the current net burn rate.
  • Inputs: current_cash_balance
  • Methodology: Runway (months) = Current Cash Balance / Monthly Net Burn
  • Calculation: current_cash_balance / burn_rate
  • Catalog key: transportation.core.runway

Working Capital​

  • ID: 970
  • Type: Financial
  • Unit: Currency (e.g., USD)
  • Description: Operating liquidity available to fund day-to-day operations.
  • Inputs: current_assets, current_liabilities
  • Methodology: Working Capital = Current Assets − Current Liabilities
  • Calculation: current_assets - current_liabilities
  • Catalog key: transportation.core.working_capital

Gross Margin per Shipment​

  • ID: 1871
  • Type: Financial
  • Unit: Currency
  • Description: Average gross profit per shipment handled by the forwarder (aggregated).
  • Inputs: gross_profit, shipments_handled
  • Methodology: Margin per Shipment = Gross Profit / Shipments Handled
  • Calculation: gross_profit / shipments_handled
  • Catalog key: transportation.freight_forwarding.gross_margin_per_shipment

On-Time Delivery (Shipper SLA)​

  • ID: 1872
  • Type: Operational
  • Unit: %
  • Description: Share of forwarder-managed shipments delivered within customer SLA (aggregated).
  • Inputs: on_time_shipments, total_shipments
  • Methodology: OTD = (On-Time Shipments / Total Shipments) × 100
  • Calculation: on_time_shipments / total_shipments * 100
  • Catalog key: transportation.freight_forwarding.on_time_delivery_shipper

Schedule Reliability​

  • ID: 1867
  • Type: Operational
  • Unit: %
  • Description: Share of port calls or voyages completed within published schedule window (aggregated).
  • Inputs: on_schedule_voyages, total_voyages
  • Methodology: Reliability = (On-Schedule Voyages / Total Voyages) × 100
  • Calculation: on_schedule_voyages / total_voyages * 100
  • Catalog key: transportation.maritime_shipping.schedule_reliability

Time Charter Equivalent (TCE)​

  • ID: 1866
  • Type: Financial
  • Unit: Currency per day
  • Description: Daily revenue net of voyage costs per day chartered (aggregated).
  • Inputs: voyage_revenue, voyage_costs, on_hire_days
  • Methodology: TCE = (Voyage Revenue − Voyage Costs) / On-Hire Days
  • Calculation: (voyage_revenue - voyage_costs) / on_hire_days
  • Catalog key: transportation.maritime_shipping.time_charter_equivalent

Vessel Utilization​

  • ID: 1865
  • Type: Operational
  • Unit: %
  • Description: Operating days at sea or laden days relative to available vessel days (aggregated).
  • Inputs: operating_days, available_days
  • Methodology: Vessel Utilization = (Operating Days / Available Days) × 100
  • Calculation: operating_days / available_days * 100
  • Catalog key: transportation.maritime_shipping.vessel_utilization

Cost per Ton-Mile​

  • ID: 1861
  • Type: Financial
  • Unit: USD per ton-mile
  • Description: Total rail freight operating cost per ton-mile moved (aggregated).
  • Inputs: total_operating_cost, ton_miles_moved
  • Methodology: Cost per Ton-Mile = Total Operating Cost / Ton-Miles Moved
  • Calculation: total_operating_cost / ton_miles_moved
  • Catalog key: transportation.rail_freight.cost_per_ton_mile

On-Time Train Performance​

  • ID: 1862
  • Type: Operational
  • Unit: %
  • Description: Share of rail shipments arriving within contractual or service window (aggregated).
  • Inputs: on_time_shipments, total_shipments
  • Methodology: OTP = (On-Time Shipments / Total Shipments) × 100
  • Calculation: on_time_shipments / total_shipments * 100
  • Catalog key: transportation.rail_freight.on_time_train_performance

Train Utilization​

  • ID: 1860
  • Type: Operational
  • Unit: %
  • Description: Loaded train-miles or tonnage moved relative to available train capacity (aggregated).
  • Inputs: loaded_train_miles, available_train_miles
  • Methodology: Train Utilization = (Loaded Train-Miles / Available Train-Miles) × 100
  • Calculation: loaded_train_miles / available_train_miles * 100
  • Catalog key: transportation.rail_freight.train_utilization

Maintenance Cost per Mile​

  • ID: 13
  • Type: Operational
  • Unit: USD/mile
  • Description: Total maintenance costs divided by total miles driven.
  • Inputs: total_maintenance_costs, total_miles
  • Methodology: Total maintenance costs / Total miles driven
  • Calculation: total_maintenance_costs / total_miles
  • Catalog key: vXlB5QC3mZJw1auWaIfK

Data engineering pipeline​

Ambient Core ships the catalog (typed data options and metrics) and ambient_pipeline helpers. Lakehouse jobs and schedules live in the application repository that pins a core tag.

Canonical order: map columns → coerce types → unpivot → stamp lineage → (optional Silver validate) → contract assert → write. Gold vertical products evaluate catalog formulas with ambient_calc after Silver.

How this pack feeds the pipeline​

Further reading: Catalog consumption · Pipeline governance helpers

Generated from ambient-core ref 22b6089 (digest f5bca892574e3e28). Regenerate: npm run sync:catalog-wiki.