TargetArchitecture_CompleteMiss.xlsx
7 sheets · compared 2026-07-30T13:23:49.465Z
- Source input Original workbook bytes · 7 sheets Source input detail
- XLSX.evidence 12 categories accounted for XLSX.evidence detail
- Current gold promoted build Current gold detail
- Model walk codex Model walk detail
- Your decisions 0 of 8 answered Your decisions detail
- Scope / SOW blocked · 0 items Scope / SOW detail
The model says
8 findings
You say
0 of 8 answered
The gap is the outstanding work. Context-only findings are excluded — they describe the estate rather than propose it.
Target Fields
9 × 10 · 0 formulas · 8 findings cite this sheet
Needs your call 8
Each becomes a final, immutable disposition.
Customer.CustomerIdentifier column Not found in this gold boundary · Target Fields!A2:J2 99% Decide
How the model read it
The authoritative register requires a String customer identity sourced from the CRM customer master. The current-gold model has no Customer table or customer identifier. AccountKey is an accounting key and is not evidence of enterprise customer identity.
What is the governed customer key, and is it stable and unique across all CRM records?
Must source-system identifiers be retained alongside an enterprise customer identifier?
Customer.CustomerSegment column Not found in this gold boundary · Target Fields!A3:J3 · Reference Data!A2:C4 99% Decide
How the model read it
The required commercial segment and its illustrative ENT/MID/SMB domain are not present in the observed finance-ledger model. AccountType is not a supported equivalent because it describes accounting accounts rather than customers.
Are Enterprise, Mid-market and Small business the complete governed segment domain?
Is segmentation current-state only, or must historical segment changes be analysed?
Customer.RelationshipOwner column Not found in this gold boundary · Target Fields!A4:J4 99% Decide
How the model read it
No customer entity or accountable relationship-owner attribute was observed in current gold.
Should the model retain owner identifiers as well as display names?
How should reassignment history, vacancies and shared ownership be represented?
SalesOrder.OrderIdentifier column Not found in this gold boundary · Target Fields!A5:J5 99% Decide
How the model read it
No SalesOrder table or customer-order identifier was observed in the current model. Ledger keys and finance entries do not establish order identity.
What defines a unique order across order-management systems or legal entities?
Are revisions, split orders and cancelled orders represented by the same identifier or separate records?
SalesOrder.OrderGrossValue column Not found in this gold boundary · Target Fields!A6:J6 · Sales Orders!A1:D3 99% Decide
How the model read it
The workbook requires gross order value before discounts at order grain. Current gold contains Ledger.SignedAmount at finance-ledger grain, which is not a semantic or structural match to gross booked order value.
Does gross value include tax, freight or other charges?
Which currency fields and conversion rules are required?
How are cancellations, returns and subsequent order amendments reflected?
SalesOrder.SalesChannel column Not found in this gold boundary · Target Fields!A7:J7 · Reference Data!A5:C7 99% Decide
How the model read it
No sales-order acquisition-channel attribute was observed. The workbook's Direct, Partner and Online values are illustrative reference data, not a current-gold implementation.
Are Direct, Partner and Online exhaustive governed channels?
Can an order have multiple contributing channels, and if so what attribution rule applies?
SalesMetrics.Customer Lifetime Value measure Not found in this gold boundary · Target Fields!A8:J8 · Sales KPI Prototype!A5:C5 +1 99% Decide
How the model read it
No Customer Lifetime Value measure or supporting customer/order structure was observed. The current model's four finance measures are differently named and have unknown exact DAX. The workbook prototype's 3.2 frequency multiplier is illustrative and does not establish a production definition.
What forecast horizon and expected-order-frequency method should production CLV use?
Should CLV use gross order value, net revenue, gross margin or contribution margin?
How should churn, returns, discounts and customer tenure affect the calculation?
Evidence
Cited current gold
SalesMetrics.Gross Order Intake measure Not found in this gold boundary · Target Fields!A9:J9 · Sales KPI Prototype!A4:C4 +1 99% Decide
How the model read it
The required sum of OrderGrossValue and its prototype formula have no observed counterpart in current gold. Actual Revenue cannot be assumed equivalent to gross booked order value, particularly because exact DAX and production semantics for current measures were not returned.
What event makes an order count as booked intake, and which date drives reporting?
Should cancelled or amended orders restate prior periods?
Are intake values reported before discounts, tax and currency conversion in all views?
Evidence
Cited current gold
This project defines the next engagement. It does not assert that the target has been implemented.