Mappings
Every data point across projects
The dimensions, objects, and derivations the organization consolidates from every connection, how source values reconcile into them, and where each one comes from.
Where each data point comes from and how they relate: connections feed dimensions and objects, derivations build on them, and automations use the result. Select a node to lay out its tree.
10 source systems7 dimensions10 business objects8 derivations6 automations
Approved / healthyDraft / needs attentionSuggested / runningAction needed
Inputs sit above the node, uses below. Hover any node to see its path to the selected one.
Tree for Bank Reconciliation Exceptions
Drag to pan · scroll to move · ⌘ or Ctrl + scroll to zoom
Bank Reconciliation Exceptions
DerivationBANK_REC_EXCEPTIONSapproved
Unmatched or ambiguous bank transactions and Sage cash entries with a reason and an owner.
Built from6
Source systems
Dimensions
Business objects
Feeds1
Logic
BANK_TRANSACTIONS FULL OUTER JOIN Sage cash entries ON bank_account, amount, value_date ± 3d, reference; keep rows without an exact or composite match
- Neither control total is changed. Matches are proposed, not posted, until Controller approval.
Details
- Owner
- Tom Okafor
- Approved
- 2026-07-22