XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
category:text_cells
label:Literal text cells
status:found
inclusion:included
sensitivity:source_content
item-count:159
character-count:3116
omitted-item-count:0

[Sheet:Instructions]
A1:FDE Finance Target — Current-State Match
A3:Scenario
B3:Every declared target item has a deterministic current-model match.
A5:Interpretation
B5:The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.

[Sheet:Target Fields]
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Current Hint
H1:Formula
I1:Source
J1:Consultant Notes
A2:column
B2:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Account.AccountKey
I2:Existing Power BI semantic model
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Account.AccountName
I3:Existing Power BI semantic model
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Account.AccountType
I4:Existing Power BI semantic model
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Calendar.DateKey
I5:Existing Power BI semantic model
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Calendar.Date
I6:Existing Power BI semantic model
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Calendar.FiscalMonth
I7:Existing Power BI semantic model
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Ledger.DateKey
I8:Existing Power BI semantic model
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Ledger.AccountKey
I9:Existing Power BI semantic model
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Ledger.SignedAmount
I10:Existing Power BI semantic model
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Ledger.IsAdjustment
I11:Existing Power BI semantic model
A12:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:Metrics.Actual Net
H12:[Actual Revenue] - expenses
I12:Existing Power BI semantic model
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:Metrics.Actual Revenue
I13:Existing Power BI semantic model
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:Metrics.Budget Net
I14:Existing Power BI semantic model
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:Metrics.Net Variance
H15:[Actual Net] - [Budget Net]
I15:Existing Power BI semantic model

[Sheet:Mapping Rules]
A1:Rule
B1:Value
C1:Meaning
A2:Exact qualified name
C2:Safe deterministic candidate
A3:Declared current hint
C3:Candidate requiring semantic confirmation
A4:Same object name
C4:Candidate only; table context may differ
A5:No candidate
C5:Research or confirm absence

[Sheet:Reference Data]
A1:CostCentre
B1:AccountGroup
C1:CurrencyCode
A2:CC100
B2:Operations
C2:AUD
A3:CC200
B3:Commercial
C3:AUD
A4:CC300
B4:Corporate
C4:NZD

[Sheet:Validation]
A1:Check
B1:Formula
C1:Expected
A2:Target row count
C2:Number of declared target items
A3:Required rows
C3:All declared rows in these fixtures