Reference data

ISO countries, ocean SCAC identifiers, and airline IATA / AWB prefixes — shared across tariffs, logistics, and transport UIs.

Why this exists

Tariffs, RFQs, bookings, and Control Tower still store many lane and party fields as free text (for example originCode, carrier, countryCode). This catalog gives you a single place to normalize ISO countries, ocean SCACs, and airline IATA + AWB prefixes before we wire FKs and validation into each module.

  • Tariffs / geography: align TariffGeographyMember.memberCode and legal-entity countryCode with ISO alpha-2 from here.
  • Logistics: tenant LocationCode.countryCode and warehouse country fields should match these codes.
  • Next steps (not done in this pass): optional FK from ShipmentBooking to UN/LOCODE rows; carrier SCAC on contracts; AWB validation for air milestones.

Seeded counts — countries: 0, ocean carriers: 0, airlines: 0. Re-run npm run db:seed to refresh catalog rows (upserts).

View-only: ask for org.settings → edit to change catalog rows.

A2A3NameMacro regionActive