Financial Holding DMO

Object API Name: ssot__FinancialHolding__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• AccountId has a FOREIGNKEY relationship with the Account DMO Id field.
• FinancialSecurityId has a FOREIGNKEY relationship with the Financial Security DMO Id field.
• FinancialAccountId has a FOREIGNKEY relationship with the Financial Account DMO Id field.

• AccountId
• cdp_sys_record_currency
• ChangePercent
• Currency
• DataSourceId
• DataSourceObjectId
• Description
• DisallowedLossAmount
• EquityCategory
• FinancialAccountId
• FinancialHoldingClass
• FinancialHoldingSubClass
• FinancialSecurityId
• FinancialSecuritySymbolCode
• GainLossAmount
• HoldingCount
• Id
• InternalOrganizationId
• IsWashSale
• KQ_AccountId
• KQ_FinancialAccountId
• KQ_FinancialSecurityId
• KQ_Id
• LotSelectionMethodType
• MarketValueAmount
• Name
• OrderDateTime
• PurchasePriceAmount
• SourceSystemIdentifier
• TotalCostBasisAmount
• UnrealizedGainLossAmount

• Field API Name: ssot__AccountId__c
• Data Type: TEXT
• Description: Reference to the associated Account.

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__ChangePercent__c
• Data Type: DOUBLE
• Description: Percentage change in price.

• Field API Name: ssot__Currency__c
• Data Type: TEXT
• Description: ISO 4217 currency code associated with the record.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Description__c
• Data Type: TEXT
• Description: Description of the Financial Holding.

• Field API Name: ssot__DisallowedLossAmount__c
• Data Type: DOUBLE
• Description: The dollar amount of loss disallowed due to the wash sale rule.

• Field API Name: ssot__EquityCategory__c
• Data Type: TEXT
• Description: Reference to the Financial Holding Category.

• Field API Name: ssot__FinancialAccountId__c
• Data Type: TEXT
• Description: Reference to the associated Financial Account.

• Field API Name: ssot__FinancialHoldingClass__c
• Data Type: TEXT
• Description: Reference to the Financial Holding Class.

• Field API Name: ssot__FinancialHoldingSubClass__c
• Data Type: TEXT
• Description: Reference to the Financial Holding Sub Class.

• Field API Name: ssot__FinancialSecurityId__c
• Data Type: TEXT
• Description: Reference to the associated Security.

• Field API Name: ssot__FinancialSecuritySymbolCode__c
• Data Type: TEXT
• Description: The symbol of the corresponding financial security.

• Field API Name: ssot__GainLossAmount__c
• Data Type: DOUBLE
• Description: Gain or Loss Amount.

• Field API Name: ssot__HoldingCount__c
• Data Type: DOUBLE
• Description: Number of holding purchased.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this FinancialHolding record. Maximum size is 15 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__IsWashSale__c
• Data Type: BOOLEAN
• Description: Indicates whether the holding is affected by a wash sale.

• Field API Name: KQ_AccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AccountId

• Field API Name: KQ_FinancialAccountId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FinancialAccountId

• Field API Name: KQ_FinancialSecurityId__c
• Data Type: TEXT
• Description: Key Qualifier system field for FinancialSecurityId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: ssot__LotSelectionMethodType__c
• Data Type: TEXT
• Description: The lot selection method.

• Field API Name: ssot__MarketValueAmount__c
• Data Type: DOUBLE
• Description: Market Value of the holding.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of the Financial Holding.

• Field API Name: ssot__OrderDateTime__c
• Data Type: DATETIME
• Description: The date the holding was opened.

• Field API Name: ssot__PurchasePriceAmount__c
• Data Type: DOUBLE
• Description: Purchase Price of the holding.

• Field API Name: ssot__SourceSystemIdentifier__c
• Data Type: TEXT
• Description: ID that uniquely identifies the holding in an external data source.

• Field API Name: ssot__TotalCostBasisAmount__c
• Data Type: DOUBLE
• Description: The total cost basis amount of all the shares.

• Field API Name: ssot__UnrealizedGainLossAmount__c
• Data Type: DOUBLE
• Description: The unrealized gain or loss amount.