SecuritiesHolding

Name	Label	Type	Description
Id	Securities Holding ID	ID
OwnerId	Owner ID	LOOKUP
IsDeleted	Deleted	CHECKBOX
Name	Name	TEXT(255)
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
PrimaryOwnerId	Account ID	LOOKUP
InsurancePolicyId	Insurance Policy ID	LOOKUP
AssetClass	Asset Class	PICKLIST
AssetCategory	Asset Category	PICKLIST
AssetCategoryName	Asset Category Name	PICKLIST
Shares	Shares	NUMBER(10,4)
PurchasePrice	Purchase Price	CURRENCY(10,2)
Price	Price	CURRENCY(10,2)
MarketValue	Market Value	CURRENCY(16,2)
PercentChange	Percent Change	PERCENT(14,2)
LastUpdated	Last Updated	DATETIME
HouseholdId	Account ID	LOOKUP
GainLoss	Gain/Loss	CURRENCY(16,2)
SourceSystemIdentifier	Source System Identifier	TEXT(255)
SourceSystem	Source System	TEXT(255)

Name	Id
Label	Securities Holding ID
Type	ID
Required	Yes

Name	OwnerId
Label	Owner ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Name
Label	Name
Type	TEXT(255)
Required	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	PrimaryOwnerId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	InsurancePolicyId
Label	Insurance Policy ID
Type	LOOKUP
Foreign key	Yes

Name	AssetClass
Label	Asset Class
Type	PICKLIST
Picklist values	Equities Fixed Income Cash Equivalents Alternative Investments

Name	AssetCategory
Label	Asset Category
Type	PICKLIST
Picklist values	U.S. Equity Sector Equity Allocation International Equity Alternative Commodities Taxable Bond Municipal Bond

Name	AssetCategoryName
Label	Asset Category Name
Type	PICKLIST
Picklist values	Large Growth Large Value Large Blend Small Growth Small Value Small Blend Mid-Cap Growth Mid-Cap Value Mid-Cap Blend

Name	Shares
Label	Shares
Type	NUMBER(10,4)

Name	PurchasePrice
Label	Purchase Price
Type	CURRENCY(10,2)

Name	Price
Label	Price
Type	CURRENCY(10,2)

Name	MarketValue
Label	Market Value
Type	CURRENCY(16,2)

Name	PercentChange
Label	Percent Change
Type	PERCENT(14,2)

Name	LastUpdated
Label	Last Updated
Type	DATETIME

Name	HouseholdId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	GainLoss
Label	Gain/Loss
Type	CURRENCY(16,2)

Name	SourceSystemIdentifier
Label	Source System Identifier
Type	TEXT(255)
Unique	Yes

Name	SourceSystem
Label	Source System
Type	TEXT(255)

Name	Parent object	Child object	Parent object field	Child object field
ForecastContext	SecuritiesHolding	AdvAcctForecastSetUse	Id	ForecastContextId
ContentContext	SecuritiesHolding	AssessmentTaskContentDocument	Id	ContentContextId
FirstPublishLocation	SecuritiesHolding	ContentVersion	Id	FirstPublishLocationId
ReferenceObject	SecuritiesHolding	DocumentEnvelope	Id	ReferenceObjectId
RelatedTo	SecuritiesHolding	EmailMessage	Id	RelatedToId
What	SecuritiesHolding	Event	Id	WhatId
RelatedRecord	SecuritiesHolding	FlowOrchestrationWorkItem	Id	RelatedRecordId
ReferenceObject	SecuritiesHolding	GeneratedDocument	Id	ReferenceObjectId
Context	SecuritiesHolding	GenericVisitTaskContext	Id	ContextId
What	SecuritiesHolding	Task	Id	WhatId
Relation	SecuritiesHolding	TaskRelation	Id	RelationId

Name	Parent object	Child object	Parent object field	Child object field
Owner	User	SecuritiesHolding	Id	OwnerId
CreatedBy	User	SecuritiesHolding	Id	CreatedById
LastModifiedBy	User	SecuritiesHolding	Id	LastModifiedById
PrimaryOwner	Account	SecuritiesHolding	Id	PrimaryOwnerId
InsurancePolicy	InsurancePolicy	SecuritiesHolding	Id	InsurancePolicyId
Household	Account	SecuritiesHolding	Id	HouseholdId

Label	Value