Idea

Name	Label	Type	Description
Id	Idea ID	ID
IsDeleted	Deleted	CHECKBOX
Title	Title	TEXT(255)
RecordTypeId	Record Type ID	LOOKUP
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
CommunityId	Zone ID	MASTER-DETAIL
Body	Idea Body	TEXT AREA (RICH)(32000)
NumComments	Number of Comments	ROLL-UP SUMMARY
VoteScore	Vote Score	NUMBER(14,4)
VoteTotal	Vote Total	NUMBER(18,0)
Categories	Categories	PICKLIST (MULTI-SELECT)
Status	Status	PICKLIST
LastCommentDate	Last Idea Comment Date	ROLL-UP SUMMARY
LastCommentId	Idea Comment ID	LOOKUP
ParentIdeaId	Idea ID	LOOKUP
IsHtml	IsHtml	CHECKBOX
IsMerged	Is Merged	CHECKBOX
CreatorFullPhotoUrl	Url of Creator's Profile Photo	TEXT(255)
CreatorSmallPhotoUrl	Url of Creator's Thumbnail Photo	TEXT(255)
CreatorName	Name of Creator	TEXT(121)

Name	Id
Label	Idea ID
Type	ID
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Title
Label	Title
Type	TEXT(255)
Required	Yes

Name	RecordTypeId
Label	Record Type ID
Type	LOOKUP
Foreign key	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	CommunityId
Label	Zone ID
Type	MASTER-DETAIL
Foreign key	Yes
Required	Yes

Name	Body
Label	Idea Body
Type	TEXT AREA (RICH)(32000)

Name	NumComments
Label	Number of Comments
Type	ROLL-UP SUMMARY

Name	VoteScore
Label	Vote Score
Type	NUMBER(14,4)

Name	VoteTotal
Label	Vote Total
Type	NUMBER(18,0)

Name	Categories
Label	Categories
Type	PICKLIST (MULTI-SELECT)

Name	Status
Label	Status
Type	PICKLIST

Name	LastCommentDate
Label	Last Idea Comment Date
Type	ROLL-UP SUMMARY

Name	LastCommentId
Label	Idea Comment ID
Type	LOOKUP
Foreign key	Yes

Name	ParentIdeaId
Label	Idea ID
Type	LOOKUP
Foreign key	Yes

Name	IsHtml
Label	IsHtml
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsMerged
Label	Is Merged
Type	CHECKBOX
Required	Yes
Default value	false

Name	CreatorFullPhotoUrl
Label	Url of Creator's Profile Photo
Type	TEXT(255)

Name	CreatorSmallPhotoUrl
Label	Url of Creator's Thumbnail Photo
Type	TEXT(255)

Name	CreatorName
Label	Name of Creator
Type	TEXT(121)

Name	Parent object	Child object	Parent object field	Child object field
RelatedRecord	Idea	FlowOrchestrationWorkItem	Id	RelatedRecordId
ParentIdea	Idea	Idea	Id	ParentIdeaId
Idea	Idea	IdeaComment	Id	IdeaId

Name	Parent object	Child object	Parent object field	Child object field
RecordType	RecordType	Idea	Id	RecordTypeId
CreatedBy	User	Idea	Id	CreatedById
LastModifiedBy	User	Idea	Id	LastModifiedById
Community	Community	Idea	Id	CommunityId
LastComment	IdeaComment	Idea	Id	LastCommentId
ParentIdea	Idea	Idea	Id	ParentIdeaId

Label	Value