Lanes freight exceptions
World clock Tue 18:00:00 UTC held · 120×

Definitions

The definitions the operator and Ask both run on. Each has an owner, a version, SQL and tests. Edits make a new version.

Demurrage

demurrage unit: USD canonical: finance

What the terminals charge, per day, for containers left after their free time; billed by the carrier. Counted from the end of free time to gate-out (or to now while the box is still there).

financeFinance Controller · finance v1canonical

Demurrage charges whose free time ended in the period and at or before now.

latest change: First version.

  • pass value_betweenobserved 13920.0, expected between 0.0 and 500000.0
SQL, rendered for now
SELECT g.id AS charge_id, g.shipment_id, g.container_id, g.days, g.amount_usd, g.accrued_from, g.accepted_at
FROM charges g
WHERE g.kind = 'demurrage' AND g.accrued_from <= TIMESTAMP 'Tue 18:00:00'
  AND g.accrued_from >= TIMESTAMP 'Sun 18:00:00 (30 days ago)' AND g.accrued_from < TIMESTAMP 'Tue 18:00:00'
ORDER BY g.accrued_from, g.id

History

append-only; nothing is edited in place
  1. definitionFinance Controller finance v1 First version.