[Sheet:Target Fields]
::text_cells
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Business Owner
H1:Calculation
I1:Planned Source
J1:Implementation Notes
A2:column
B2:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Financial Control
I2:Chart of accounts master
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Financial Control
I3:Chart of accounts master
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Financial Control
I4:Chart of accounts master
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Enterprise Data
I5:Enterprise fiscal calendar
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Enterprise Data
I6:Enterprise fiscal calendar
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Enterprise Data
I7:Enterprise fiscal calendar
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Financial Control
I8:General ledger postings
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Financial Control
I9:General ledger postings
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Financial Control
I10:General ledger postings
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Financial Control
I11:General ledger postings
A12:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:FP&A
H12:Actual Revenue plus signed expense balances
I12:Finance semantic calculation layer
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:FP&A
I13:Finance semantic calculation layer
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:FP&A
I14:Finance semantic calculation layer
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:FP&A
H15:Actual Net minus Budget Net
I15:Finance semantic calculation layer
::sheet_structure
state:visible
used-range:A1:J15
freeze-panes:A2
auto-filter:A1:J15
::tables_names
table:TargetFields;range=A1:J15;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Business Owner,Calculation,Planned Source,Implementation Notes
::package_security
sheet-protection:not-found