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: financeWhat 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- definitionFinance Controller finance v1 First version.