Financial Planning & Analysis Data Dictionary

Tag__c

Label: Tag

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

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

 Lookup
AutoNumber__c Tag AutoNumber Spring 2023 Auto Number for Tag

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

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

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

 Lookup
Product__c Product Spring 2023 Looks up to: Product2

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

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

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

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


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