FFPB Data Dictionary

Balance__c

Label: Balance

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

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


© Copyright 2009–2022 FinancialForce.com, inc. All rights reserved. Various trademarks held by their respective owners.