FFPB Data Dictionary

Tag__c

Label: Tag

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccessDimension__c Access Dimension February 2023 If true Tag access should be specified

Formula:
NOT(Dimension__r.WithoutSharing__c)
 Checkbox
AccessTag__c Access Tag February 2023 Text(255)
AccountCRM__c Account CRM February 2023 Looks up to: Account

 Lookup
AutoNumber__c Tag AutoNumber February 2023 Auto Number for Tag

 AutoNumber
Boolean1__c Boolean 1 February 2023 Checkbox false
Boolean2__c Boolean 2 February 2023 Checkbox false
Boolean3__c Boolean 3 February 2023 Checkbox false
Boolean4__c Boolean 4 February 2023 Checkbox false
Boolean5__c Boolean 5 February 2023 Checkbox false
Boolean6__c Boolean6 February 2023 Checkbox false
Date1__c Date1 February 2023 Date
Date2__c Date2 February 2023 Date
Date3__c Date3 February 2023 Date
Date4__c Date4 February 2023 Date
Date5__c Date5 February 2023 Date
DateTime1__c DateTime1 February 2023 DateTime
DatesAreValid__c DatesAreValid February 2023 Returns "true" if current date is in between start and end date.

Formula:
(today() > Start__c && today() < End__c) || ( ISBLANK(Start__c) && today() < End__c) || (today() > Start__c && ISBLANK(End__c)) || (ISBLANK(Start__c) && ISBLANK(End__c))
 Checkbox
Decimal10__c Decimal10 February 2023 Number(18,2)
Decimal11__c Decimal11 February 2023 Number(18,2)
Decimal12__c Decimal12 February 2023 Number(18,2)
Decimal1__c Decimal1 February 2023 Number(18,2)
Decimal2__c Decimal2 February 2023 Number(18,2)
Decimal3__c Decimal3 February 2023 Number(18,2)
Decimal4__c Decimal4 February 2023 Number(18,2)
Decimal5__c Decimal5 February 2023 Number(18,2)
Decimal6__c Decimal6 February 2023 Number(18,2)
Decimal7__c Decimal7 February 2023 Number(18,2)
Decimal8__c Decimal8 February 2023 Number(18,2)
Decimal9__c Decimal9 February 2023 Number(18,2)
DimensionName__c Dimension Name February 2023 Formula:
Dimension__r.Name
 Text
DimensionPageHeader__c Dimension Page Header February 2023 Formula:
Dimension__r.PageHeader__c
 Text
Dimension__c Dimension February 2023 Looks up to: Dimension__c
 Lookup
DrillDownLong__c Drill Down Long February 2023 LongTextArea(32768)
DrillDown__c Drill Down February 2023 Text(255)
End__c End February 2023 Date
ExtId__c External Id February 2023 Text(18)
Extension__c Extension February 2023 Looks up to: Tag__c
 Lookup
Folder__c Folder February 2023 Looks up to: Folder__c
 Lookup
Headcount__c Headcount February 2023 Field that links a budget to its related headcount lines.

Looks up to: Headcount__c
 Lookup
Index__c Index February 2023 Text(255)
LabelName__c Label Name February 2023 DEPRICATED

 Text(255)
OrderNumber__c Order Number February 2023 Number(7,0)
PostingRuleTemplateRelated__c Posting Rule Template February 2023 When selected, the posting rule template is automatically selected when creating a new budget template.

Looks up to: PostingRule__c
 Lookup
PriceBook__c Price Book February 2023 Looks up to: Pricebook2

 Lookup
Product__c Product February 2023 Looks up to: Product2

 Lookup
RelatedDimension1__c RelatedDimension1 February 2023 Formula:
Dimension__r.RelatedDimension1__c
 Text
RelatedDimension2__c RelatedDimension2 February 2023 Formula:
Dimension__r.RelatedDimension2__c
 Text
RelatedDimension3__c RelatedDimension3 February 2023 Formula:
Dimension__r.RelatedDimension3__c
 Text
Start__c Start February 2023 Date
StatusChangeDate__c StatusChangeDate February 2023 Date Today()
Status__c Status February 2023 Status of Tag can be "Open" by default or any other

 Text(255) 'Open'
Tag10Name__c Tag10Name February 2023 Formula:
Tag10__r.Name
 Text
Tag10__c Tag10 February 2023 Looks up to: Tag__c
 Lookup
Tag1Name__c Tag1Name February 2023 Formula:
Tag1__r.Name
 Text
Tag1__c Tag1 February 2023 Looks up to: Tag__c
 Lookup
Tag2Name__c Tag2Name February 2023 Formula:
Tag2__r.Name
 Text
Tag2__c Tag2 February 2023 Looks up to: Tag__c
 Lookup
Tag3Name__c Tag3Name February 2023 Formula:
Tag3__r.Name
 Text
Tag3__c Tag3 February 2023 Looks up to: Tag__c
 Lookup
Tag4Name__c Tag4Name February 2023 Formula:
Tag4__r.Name
 Text
Tag4__c Tag4 February 2023 Looks up to: Tag__c
 Lookup
Tag5Name__c Tag5Name February 2023 Formula:
Tag5__r.Name
 Text
Tag5__c Tag5 February 2023 Looks up to: Tag__c
 Lookup
Tag6Name__c Tag6Name February 2023 Formula:
Tag6__r.Name
 Text
Tag6__c Tag6 February 2023 Looks up to: Tag__c
 Lookup
Tag7Name__c Tag7Name February 2023 Formula:
Tag7__r.Name
 Text
Tag7__c Tag7 February 2023 Looks up to: Tag__c
 Lookup
Tag8Name__c Tag8Name February 2023 Formula:
Tag8__r.Name
 Text
Tag8__c Tag8 February 2023 Looks up to: Tag__c
 Lookup
Tag9Name__c Tag9Name February 2023 Formula:
Tag9__r.Name
 Text
Tag9__c Tag9 February 2023 Looks up to: Tag__c
 Lookup
TagLabel__c Tag Label February 2023 Formula:
IF(Index__c == null, IF(Dimension__r.ANPrefix__c == null, /* IF INDEX AND PREFIX ARE NOT SPECIFIED. EXAMPLE: SUBTYPE = "Travel" */ Name, /*IF INDEX IS NOT SPECIFIED. EXAMPLE: APP = "BA-0000548 Main App" */ IF(Dimension__r.needAutonumber__c, IF(Dimension__r.ANPrefix__c + AutoNumber__c == Name, Dimension__r.ANPrefix__c + AutoNumber__c, Dimension__r.ANPrefix__c + AutoNumber__c + ' ' + Name), Dimension__r.ANPrefix__c + Name ) ), /* IF INDEX IS SPECIFIED. EXAMPLE: PROJECT = "585655 : Moon Capture " */ /* IF WE NEED JUST NAME */ IF(Dimension__r.ANPrefix__c == '{NAME}', Name, /* IF WE NEED JUST NUMBER*/ IF(Dimension__r.ANPrefix__c == '{NUMBER}', Index__c, Index__c + ' ' + Dimension__r.ANPrefix__c + ' ' + Name) ) )
Text
Text10__c Text10 February 2023 Text(255)
Text1__c Text1 February 2023 Text(255)
Text2__c Text2 February 2023 Text(255)
Text3__c Text3 February 2023 Text(255)
Text4__c Text4 February 2023 Text(255)
Text5__c Text5 February 2023 Text(255)
Text6__c Text6 February 2023 Text(255)
Text7__c Text7 February 2023 Text(255)
Text8__c Text8 February 2023 Text(255)
Text9__c Text9 February 2023 Text(255)
TextLong10__c TextLong10 February 2023 LongTextArea(131072)
TextLong1__c TextLong1 February 2023 LongTextArea(131072)
TextLong2__c TextLong2 February 2023 LongTextArea(131072)
TextLong3__c TextLong3 February 2023 LongTextArea(131072)
TextLong4__c TextLong4 February 2023 LongTextArea(131072)
TextLong5__c TextLong5 February 2023 LongTextArea(131072)
TextLong6__c TextLong6 February 2023 LongTextArea(131072)
TextLong7__c TextLong7 February 2023 LongTextArea(131072)
TextLong8__c TextLong8 February 2023 LongTextArea(131072)
TextLong9__c TextLong9 February 2023 LongTextArea(131072)
UserName__c User Name February 2023 Outdated!

Formula:
''
 Text
User__c User February 2023 Looks up to: User

 Lookup
isLocked__c isLocked February 2023 Checkbox false
isUndeletable__c isUndeletable February 2023 Formula:
Dimension__r.isUndeletable__c
 Checkbox


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