Senior-authored Markdown
# Conclusion `TargetArchitecture_Partial.xlsx` declares the selected target at field level. The authoritative declaration within the workbook is the `Target Fields` sheet. It contains 13 rows, and every row is marked `Required = Yes`. ## Declared fields | Entity | Target field | Type | Business definition | Declared source | |---|---|---|---|---| | `Account` | `AccountKey` | Int64 | Stable account identifier | Existing Power BI semantic model | | `Account` | `AccountName` | String | Finance account display name | Existing Power BI semantic model | | `Account` | `AccountType` | String | Revenue or expense classification | Existing Power BI semantic model | | `Account` | `AccountGroup` | String | Management reporting group above account type | Account master / embedded mapping | | `Calendar` | `DateKey` | Int64 | Integer date key in YYYYMMDD form | Existing Power BI semantic model | | `Calendar` | `Date` | DateTime | Posting calendar date | Existing Power BI semantic model | | `Calendar` | `FiscalMonth` | Int64 | Fiscal month number | Existing Power BI semantic model | | `Ledger` | `DateKey` | Int64 | Posting date foreign key | Existing Power BI semantic model | | `Ledger` | `AccountKey` | Int64 | Account foreign key | Existing Power BI semantic model | | `Ledger` | `SignedAmount` | Decimal | Signed ledger amount in reporting currency | Existing Power BI semantic model | | `Ledger` | `IsAdjustment` | Boolean | Identifies late or manual adjustments | Existing Power BI semantic model | | `Ledger` | `CostCentre` | String | Management cost-centre code | Finance posting source / embedded reference data | | `Ledger` | `CurrencyCode` | String | ISO reporting currency code | Finance posting source | ## Workbook interpretation boundary The workbook's `Instructions` sheet states that `Target Fields` declares the target architecture. Other sheets may contain mapping rules, validation formulas, reference data or sample inputs and must not automatically become target fields. The hidden `Reference Data` sheet contains example values: | CostCentre | AccountGroup | CurrencyCode | |---|---|---| | CC100 | Operations | AUD | | CC200 | Commercial | AUD | | CC300 | Corporate | NZD | These values may illustrate an enrichment approach, but the workbook does not establish that they are complete, approved, keyed correctly or governed as production reference data. ## Completeness limitation The workbook does not declare measures, semantic relationships, security roles, refresh policy, deployment topology, gateway configuration or detailed presentation metadata. It is unknown whether those areas are intentionally out of target scope or require further target artefacts.