Known gaps

These are the remaining gaps in the catalog. A Work Item is named where one exists in Systems Central.

Not built yet

• The proposal that Products & Services is the only writer of what the business sells is not yet adopted. Work Item: “Accept Products ownership and decide when Vendor Quote moves”.
• Vendor Quote has not moved; vendor prices stay as Cost in Inventory.
• Fintable does not read Offer; Service [SV] has not retired into this base. Inventory does not read Product; Items has not split.
• The Communication “For Products” sync of Message is pending: each consumer base is to read Message through its own synced view of Communication, one mirror per base. Work Item: “Sync Message to consumer bases and link Relationship Messages”.
• Campaign-specific offers and targets are deferred after CRM v1. Work Item: “Set up campaign offers, targets and aggregations”.
• Proposal packages, discount conditions and approvers are undefined. Work Item: “Define proposal packages, discount conditions and approvers” (waiting).
• Creation intakes exist for the six native tables. Active-record review is still manual; checks do not prevent activation or enforce single-link rules.
• No automations exist; Offer and Product Component names are typed, not formulas.
• No portable identifier: rows are identified by Airtable record ID and local auto-numbers.

Rules the configuration does not enforce

• Every link field accepts several records, including those whose rule is “exactly one”: Product*, Seller* and Price List° on Offer; Brand° and Category° on Product; Product* and Includes* on Product Component.
• Offer Check does not flag a second product or seller, an offer currency that differs from its list, or an expired Active offer.
• Component Check catches only an identical whole and part; it misses partial overlaps and loops.
• Nothing ensures one Is Default° list per channel and currency.
• Price* is formatted with $ for USD and BRL alike.

Mirrors and syncs

• Check the mapping and refresh of all eight Core mirrors in Airtable. Organization (mirror) currently presents an internal-company subset; it is not the complete Core organization catalog. Work Item: “Write the mirror sync contract per domain (writer, freshness, conflicts)”.
• Check in the CRM’s sync settings whether archived offers reach its Offer mirror.

Leftover columns

Services - OLD on Product Category, Currency - OLD and Owner - OLD on Price List, and Services (Provider) - OLD and Price Lists (Owner) - OLD on Organization (mirror) remain live. Work Item: “Remove leftover ’ - OLD’ attic fields after a dependency check”.

Documentation boundaries

These pages cover all 14 tables, their Data views, creation intakes and check formulas. They do not cover sync settings, permissions or Airtable Interfaces; Interfaces are not an operating path. Check sync settings and permissions in Airtable before relying on them.