Financial Holding Closed Position DMO

Represents the closed positions for a financial security related to a financial account.

Object Properties

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

Relationships

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

Fields

• AbsoluteClosedValueAmount
• cdp_sys_record_currency
• CloseDate
• DataSourceId
• DataSourceObjectId
• FinancialAccountId
• FinancialSecurityId
• FinancialSecuritySymbolCode
• GainLossAmount
• Id
• InternalOrganizationId
• KQ_FinancialAccountId
• KQ_FinancialSecurityId
• KQ_Id
• LongTermAmount
• LotSelectionMethodType
• SettlementDate
• ShortTermAmount
• SoldQuantityCount
• StatementDate

AbsoluteClosedValueAmount

• Field API Name: AbsoluteClosedValueAmount__c
• Data Type: DOUBLE
• Description: The absolute value of the closed amount.

cdp_sys_record_currency

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

CloseDate

• Field API Name: CloseDate__c
• Data Type: DATETIME
• Description: The trade date on which the position was sold.

DataSourceId

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

DataSourceObjectId

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

FinancialAccountId

• Field API Name: FinancialAccountId__c
• Data Type: TEXT
• Description: The related financial account.

FinancialSecurityId

• Field API Name: FinancialSecurityId__c
• Data Type: TEXT
• Description: The source ID of the financial security.

FinancialSecuritySymbolCode

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

GainLossAmount

• Field API Name: GainLossAmount__c
• Data Type: DOUBLE
• Description: The total gain or loss amount of the sold holdings.

Id

• Field API Name: Id__c
• Data Type: TEXT
• Description: The unique identifier for the financial holding closed position.

InternalOrganizationId

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

KQ_FinancialAccountId

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

KQ_FinancialSecurityId

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

KQ_Id

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

LongTermAmount

• Field API Name: LongTermAmount__c
• Data Type: DOUBLE
• Description: The portion of the realized gain or loss classified as long-term.

LotSelectionMethodType

• Field API Name: LotSelectionMethodType__c
• Data Type: TEXT
• Description: The method used to select which lot was sold.

SettlementDate

• Field API Name: SettlementDate__c
• Data Type: DATETIME
• Description: The settlement date when the sale proceeds were received.

ShortTermAmount

• Field API Name: ShortTermAmount__c
• Data Type: DOUBLE
• Description: The portion of the realized gain or loss classified as short-term.

SoldQuantityCount

• Field API Name: SoldQuantityCount__c
• Data Type: DOUBLE
• Description: The number of holdings closed.

StatementDate

• Field API Name: StatementDate__c
• Data Type: DATETIME
• Description: The date of the custodian statement covering the realized event.