One supplier whole

One supplier, whole: identity and address, currency, minimum order value, payment terms in days, the resolved lead time and its source, every contact with the primary one named separately, the email domains that route this supplier's mail, the OTIF, on-time and in-full rates, and two views of its warehouses.

location_lead_times is one entry per active warehouse carrying the RESOLVED lead time, the supplier × warehouse override if one is set, else the organisation default, with source saying which answered. lanes is the same warehouses stated whole: the lane's own override (lead_time null means no override), the container it names, what the ladder resolved to, basis naming the rung that answered (lane, supplier, organisation, or null for no container on file), the forwarder's quote per container in cents, and the inland leg's road limit in kg. Both lists come out of one statement, so they cannot disagree about a warehouse.

payment_terms_days null means nobody has recorded terms, which is read as no lag rather than as zero. container_type_id on the supplier is the middle rung: null means "use the organisation default", which is not the same as no container.

An id this organisation does not have is refused 404. get_supplier_overview is the door when only the five scorecard figures are wanted.

Scope: suppliers:read.