Financial Planning & Analysis Data Dictionary

Balance__c

Label: Balance

Stores the aggregated records from tags of different dimensions used in the Reporting application. The record is aggregated according to the respective balance rules.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccessTag__c AccessTag Spring 2023 Text(255)
Amount1YTD__c Amount 1 YTD Spring 2023 Number(18,2)
Amount1__c Amount 1 Spring 2023 Number(18,2)
Amount2YTD__c Amount 2 YTD Spring 2023 Number(18,2)
Amount2_1YTD__c Amount2_1YTD Spring 2023 Formula:
Amount1YTD__c - Amount2YTD__c
Number(18,2)
Amount2_1__c Amount 2-1 Spring 2023 Formula:
Amount1__c - Amount2__c
Number(18,2)
Amount2__c Amount 2 Spring 2023 Number(18,2)
Amount3YTD__c Amount 3 YTD Spring 2023 Number(18,2)
Amount3__c Amount 3 Spring 2023 Number(18,2)
Amount4YTD__c Amount 4 YTD Spring 2023 Number(18,2)
Amount4__c Amount 4 Spring 2023 Number(18,2)
Amount5YTD__c Amount 5 YTD Spring 2023 Number(18,2)
Amount5__c Amount 5 Spring 2023 Number(18,2)
BalanceRuleName__c Balance Rule Name Spring 2023 Formula:
BalanceRule__r.Label__c
Text
BalanceRule__c Balance Rule Spring 2023 Looks up to: BalanceRule__c
Lookup
Column__c Period Spring 2023 Looks up to: Tag__c
Lookup
DrillDown__c Drill Down Spring 2023 LongTextArea(131072)
Key__c Key Spring 2023 Text(255)
Lvl1Name__c Lvl1Name Spring 2023 Formula:
Lvl1__r.TagLabel__c
Text
Lvl1__c Lvl1 Spring 2023 Looks up to: Tag__c
Lookup
Lvl2Name__c Lvl2Name Spring 2023 Formula:
Lvl2__r.TagLabel__c
Text
Lvl2__c Lvl2 Spring 2023 Looks up to: Tag__c
Lookup
Lvl3Name__c Lvl3Name Spring 2023 Formula:
Lvl3__r.TagLabel__c
Text
Lvl3__c Lvl3 Spring 2023 Looks up to: Tag__c
Lookup
Lvl4Name__c Lvl4Name Spring 2023 Formula:
Lvl4__r.Name
Text
Lvl4__c Lvl4 Spring 2023 Looks up to: Tag__c
Lookup
Lvl5Name__c Lvl5Name Spring 2023 Formula:
Lvl5__r.Name
Text
Lvl5__c Lvl5 Spring 2023 Looks up to: Tag__c
Lookup
Lvl6Name__c Lvl6Name Spring 2023 Formula:
Lvl6__r.Name
Text
Lvl6__c Lvl6 Spring 2023 Looks up to: Tag__c
Lookup
Lvl7Name__c Lvl7Name Spring 2023 Formula:
Lvl7__r.Name
Text
Lvl7__c Lvl7 Spring 2023 Looks up to: Tag__c
Lookup
Percent1__c Percent1 Spring 2023 Number(18,2)


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.