Search Customer objects (A customer of the merged company). All filter fields are optional and match by equality. Results are scoped by the model-attached visibility policy for this session.

Fetch a single Customer by primary key (id).

Group Customer objects by a property, counting each group and optionally summing a numeric property. Query-time aggregation — nothing is precomputed.

Search Order objects (A sales order, unified across both legacy systems). All filter fields are optional and match by equality. Results are scoped by the model-attached visibility policy for this session.

Fetch a single Order by primary key (id).

Group Order objects by a property, counting each group and optionally summing a numeric property. Query-time aggregation — nothing is precomputed.

Search Product objects (An item from the ERP item master). All filter fields are optional and match by equality. Results are scoped by the model-attached visibility policy for this session.

Fetch a single Product by primary key (id).

Group Product objects by a property, counting each group and optionally summing a numeric property. Query-time aggregation — nothing is precomputed.

Search Note objects (A triage note — state no source system has a table for). All filter fields are optional and match by equality. Results are scoped by the model-attached visibility policy for this session.

Fetch a single Note by primary key (id).

Group Note objects by a property, counting each group and optionally summing a numeric property. Query-time aggregation — nothing is precomputed.

Traverse the Customer → Order link "customerOrders" (one-to-many). direction=forward: pass a Customer pk, get linked Order objects. direction=reverse: pass a Order pk, get linked Customer objects.

Traverse the Order → Product link "orderProducts" (many-to-many). direction=forward: pass a Order pk, get linked Product objects. direction=reverse: pass a Product pk, get linked Order objects.

Traverse the Order → Note link "orderNotes" (one-to-many). direction=forward: pass a Order pk, get linked Note objects. direction=reverse: pass a Note pk, get linked Order objects.

Cancel an order. Shipped orders cannot be cancelled. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

Assign a pending order to a person for fulfilment. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

File a triage note against an order. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

Read the append-only audit log: every applied and rejected action, with actor and params. This is an unscoped administrative view — entries are not filtered by visibility (fail-open, declared).