FFPB Data Dictionary

Tag__c

Label: Tag

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

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

Lookup
AutoNumber__c Tag AutoNumber Winter 2023 Auto Number for Tag

AutoNumber
Boolean1__c Boolean 1 Winter 2023 Checkbox false
Boolean2__c Boolean 2 Winter 2023 Checkbox false
Boolean3__c Boolean 3 Winter 2023 Checkbox false
Boolean4__c Boolean 4 Winter 2023 Checkbox false
Boolean5__c Boolean 5 Winter 2023 Checkbox false
Boolean6__c Boolean6 Winter 2023 Checkbox false
Date1__c Date1 Winter 2023 Date
Date2__c Date2 Winter 2023 Date
Date3__c Date3 Winter 2023 Date
Date4__c Date4 Winter 2023 Date
Date5__c Date5 Winter 2023 Date
DateTime1__c DateTime1 Winter 2023 DateTime
DatesAreValid__c DatesAreValid Winter 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 Winter 2023 Number(18,2)
Decimal11__c Decimal11 Winter 2023 Number(18,2)
Decimal12__c Decimal12 Winter 2023 Number(18,2)
Decimal1__c Decimal1 Winter 2023 Number(18,2)
Decimal2__c Decimal2 Winter 2023 Number(18,2)
Decimal3__c Decimal3 Winter 2023 Number(18,2)
Decimal4__c Decimal4 Winter 2023 Number(18,2)
Decimal5__c Decimal5 Winter 2023 Number(18,2)
Decimal6__c Decimal6 Winter 2023 Number(18,2)
Decimal7__c Decimal7 Winter 2023 Number(18,2)
Decimal8__c Decimal8 Winter 2023 Number(18,2)
Decimal9__c Decimal9 Winter 2023 Number(18,2)
DimensionName__c Dimension Name Winter 2023 Formula:
Dimension__r.Name
Text
DimensionPageHeader__c Dimension Page Header Winter 2023 Formula:
Dimension__r.PageHeader__c
Text
Dimension__c Dimension Winter 2023 Looks up to: Dimension__c
Lookup
DrillDownLong__c Drill Down Long Winter 2023 LongTextArea(32768)
DrillDown__c Drill Down Winter 2023 Text(255)
End__c End Winter 2023 Date
ExtId__c External Id Winter 2023 Text(18)
Extension__c Extension Winter 2023 Looks up to: Tag__c
Lookup
Folder__c Folder Winter 2023 Looks up to: Folder__c
Lookup
Headcount__c Headcount Winter 2023 Field that links a budget to its related headcount lines.

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

Text(255)
OrderNumber__c Order Number Winter 2023 Number(7,0)
PostingRuleTemplateRelated__c Posting Rule Template Winter 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 Winter 2023 Looks up to: Pricebook2

Lookup
Product__c Product Winter 2023 Looks up to: Product2

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

Text(255) 'Open'
Tag10Name__c Tag10Name Winter 2023 Formula:
Tag10__r.Name
Text
Tag10__c Tag10 Winter 2023 Looks up to: Tag__c
Lookup
Tag1Name__c Tag1Name Winter 2023 Formula:
Tag1__r.Name
Text
Tag1__c Tag1 Winter 2023 Looks up to: Tag__c
Lookup
Tag2Name__c Tag2Name Winter 2023 Formula:
Tag2__r.Name
Text
Tag2__c Tag2 Winter 2023 Looks up to: Tag__c
Lookup
Tag3Name__c Tag3Name Winter 2023 Formula:
Tag3__r.Name
Text
Tag3__c Tag3 Winter 2023 Looks up to: Tag__c
Lookup
Tag4Name__c Tag4Name Winter 2023 Formula:
Tag4__r.Name
Text
Tag4__c Tag4 Winter 2023 Looks up to: Tag__c
Lookup
Tag5Name__c Tag5Name Winter 2023 Formula:
Tag5__r.Name
Text
Tag5__c Tag5 Winter 2023 Looks up to: Tag__c
Lookup
Tag6Name__c Tag6Name Winter 2023 Formula:
Tag6__r.Name
Text
Tag6__c Tag6 Winter 2023 Looks up to: Tag__c
Lookup
Tag7Name__c Tag7Name Winter 2023 Formula:
Tag7__r.Name
Text
Tag7__c Tag7 Winter 2023 Looks up to: Tag__c
Lookup
Tag8Name__c Tag8Name Winter 2023 Formula:
Tag8__r.Name
Text
Tag8__c Tag8 Winter 2023 Looks up to: Tag__c
Lookup
Tag9Name__c Tag9Name Winter 2023 Formula:
Tag9__r.Name
Text
Tag9__c Tag9 Winter 2023 Looks up to: Tag__c
Lookup
TagLabel__c Tag Label Winter 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 Winter 2023 Text(255)
Text1__c Text1 Winter 2023 Text(255)
Text2__c Text2 Winter 2023 Text(255)
Text3__c Text3 Winter 2023 Text(255)
Text4__c Text4 Winter 2023 Text(255)
Text5__c Text5 Winter 2023 Text(255)
Text6__c Text6 Winter 2023 Text(255)
Text7__c Text7 Winter 2023 Text(255)
Text8__c Text8 Winter 2023 Text(255)
Text9__c Text9 Winter 2023 Text(255)
TextLong10__c TextLong10 Winter 2023 LongTextArea(131072)
TextLong1__c TextLong1 Winter 2023 LongTextArea(131072)
TextLong2__c TextLong2 Winter 2023 LongTextArea(131072)
TextLong3__c TextLong3 Winter 2023 LongTextArea(131072)
TextLong4__c TextLong4 Winter 2023 LongTextArea(131072)
TextLong5__c TextLong5 Winter 2023 LongTextArea(131072)
TextLong6__c TextLong6 Winter 2023 LongTextArea(131072)
TextLong7__c TextLong7 Winter 2023 LongTextArea(131072)
TextLong8__c TextLong8 Winter 2023 LongTextArea(131072)
TextLong9__c TextLong9 Winter 2023 LongTextArea(131072)
UserName__c User Name Winter 2023 Outdated!

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

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


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