Senior-authored Markdown
# Conclusion `TargetArchitecture_Partial.xlsx` declares the selected target at field level. The workbook's `Instructions` sheet states that `Target Fields` is the target declaration. The sheet contains 13 rows, all 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 contains five sheets: `Instructions`, `Target Fields`, `Mapping Rules`, hidden `Reference Data` and `Validation`. The instructions explicitly prevent treating non-target sheets automatically as target fields. The hidden `Reference Data` sheet contains illustrative rows: | CostCentre | AccountGroup | CurrencyCode | |---|---|---| | CC100 | Operations | AUD | | CC200 | Commercial | AUD | | CC300 | Corporate | NZD | The workbook does not establish that these values are complete, approved, keyed correctly or governed for production use. ## Attributes not declared by this target `Ledger.JournalSource` and `Ledger.ApprovalStatus` are described by a separate consultant source, but neither appears in `Target Fields`. Their absence from this workbook is not a decision that they are unnecessary; it means their target status is unresolved. ## Completeness limitation The workbook does not declare measures, semantic relationships, security roles, refresh policy, gateway configuration, deployment topology or complete presentation metadata. It is unknown whether those areas are intentionally outside target scope or require further target artefacts.