Detail ownership
A root can have many charges, parties, milestones, packing lines, and other details. Each repeated detail stays in its own view and carries its root ID. Common shipment and quote dates are nullable columns on the root views. For example, severalshipment_charges rows can share one shipment_id. They are separate charges,
not duplicate shipments.
Root business dates keep the CargoWise operation-local value. Their PostgreSQL type is
timestamp without time zone. Analytics does not convert them to UTC. You do not need a separate
date join.
Relationship views
Analytics publishes a relationship only when the CargoWise source supports it.
There is no standalone reporting root for a consol or booking. The relationship views provide the
supported link and context. A missing row means the source did not prove the relationship.