Reconcile one business measure across two order systems

Repair data-definition.sql. Return exactly booking_id, system, canonical_state, net_merch_cents, one row per distinct registry record. booking_id identifies a registry record; system/external_id together identify its authoritative source. External IDs may coincide across A and B. All imported copies that match in every field collapse; distinct variants with one header ID or one B line ID remain ambiguous, never arbitrarily selected. For A, CLOSED means FULFILLED, OPEN means PENDING and VOID means CANCELLED. For B, DONE means FULFILLED, PENDING means PENDING and CANCELLED means CANCELLED. Unknown codes mean UNKNOWN_STATE. A fulfilled A header's net merchandise cents = gross_cents - tax_cents - shipping_cents - service_cents. The gross field includes all those components. A fulfilled B order's net merchandise cents = sum(quantity * unit_dollars * 100) over distinct PRODUCT lines only. SERVICE lines are excluded; negative quantities are signed returns, never absolute purchases. Do not multiply order headers by line joins or subtract hypothetical B header taxes again. Missing authoritative headers mean SOURCE_MISSING; multiple distinct header variants mean AMBIGUOUS_HEADER, before interpreting status. An otherwise fulfilled B order with no lines means LINES_MISSING; conflicting variants of a B line ID mean AMBIGUOUS_LINES, before summing. A fulfilled service-only order genuinely has zero merchandise. Pending, unknown and unresolved records need NULL net merchandise; only CANCELLED has known zero independent of stored amounts. Registry systems other than A/B mean UNKNOWN_SOURCE and NULL. Preserve every registry record, including zero, negative and unresolved amounts. Choose pre-aggregated source views or correlated per-record reconciliation; validate unfamiliar IDs and repair one remaining definition without Reset.