Financial Account Performance Snapshot DMO

Financial account performance snapshot showing returns and balances across various time periods

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

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

• AsOfDate
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• FinancialAccountId
• FiveYearCurrentBalanceAmt
• FiveYearReturnNetAmt
• Id
• InceptionToDateReturnNetAmt
• IncepToDateAnnlCurrBalAmt
• IncepToDateAnnNetAmt
• IncepToDateCurrentBalAmt
• IncepToDateRtrnAnnualizedAmt
• InternalOrganizationId
• KQ_FinancialAccountId
• KQ_Id
• MonthToDateCurrentBalAmt
• MonthToDateReturnNetAmt
• OneYearCurrentBalanceAmt
• OneYearReturnNetAmt
• QuarterToDateCurrentBalAmt
• QuarterToDateReturnNetAmt
• ThreeYearCurrentBalanceAmt
• ThreeYearReturnNetAmt
• YearToDateCurrentBalanceAmt
• YearToDateReturnNetAmt

• Field API Name: AsOfDate__c
• Data Type: DATEONLY
• Description: The date the financial account performance snapshot was calculated.

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

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

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

• Field API Name: FinancialAccountId__c
• Data Type: TEXT
• Description: The ID of the financial account related to the performance record.

• Field API Name: FiveYearCurrentBalanceAmt__c
• Data Type: DOUBLE
• Description: The 5-year current balance amount for the account.

• Field API Name: FiveYearReturnNetAmt__c
• Data Type: DOUBLE
• Description: The trailing 5-year annualized net return amount for the account, expressed as a decimal percentage.

• Field API Name: Id__c
• Data Type: TEXT
• Description: The unique identifier for the financial account performance snapshot.

• Field API Name: InceptionToDateReturnNetAmt__c
• Data Type: DOUBLE
• Description: The inception-to-date cumulative net return amount for the account, expressed as a decimal percentage.

• Field API Name: IncepToDateAnnlCurrBalAmt__c
• Data Type: DOUBLE
• Description: The annualized inception-to-date current balance amount for the account.

• Field API Name: IncepToDateAnnNetAmt__c
• Data Type: DOUBLE
• Description: The annualized inception-to-date net amount for the account.

• Field API Name: IncepToDateCurrentBalAmt__c
• Data Type: DOUBLE
• Description: The inception-to-date current balance amount for the account.

• Field API Name: IncepToDateRtrnAnnualizedAmt__c
• Data Type: DOUBLE
• Description: The annualized inception-to-date return amount, provided when the account has more than 1 year of data.

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

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

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

• Field API Name: MonthToDateCurrentBalAmt__c
• Data Type: DOUBLE
• Description: The account market value as of the snapshot date, used as the AUM weight for composite return calculations across accounts.

• Field API Name: MonthToDateReturnNetAmt__c
• Data Type: DOUBLE
• Description: The month-to-date net return amount for the account, expressed as a decimal.

• Field API Name: OneYearCurrentBalanceAmt__c
• Data Type: DOUBLE
• Description: The 1-year current balance amount for the account.

• Field API Name: OneYearReturnNetAmt__c
• Data Type: DOUBLE
• Description: The trailing 1-year net return amount for the account, expressed as a decimal percentage.

• Field API Name: QuarterToDateCurrentBalAmt__c
• Data Type: DOUBLE
• Description: The quarter-to-date current balance amount for the account.

• Field API Name: QuarterToDateReturnNetAmt__c
• Data Type: DOUBLE
• Description: The quarter-to-date net return amount for the account, expressed as a decimal percentage.

• Field API Name: ThreeYearCurrentBalanceAmt__c
• Data Type: DOUBLE
• Description: The 3-year current balance amount for the account.

• Field API Name: ThreeYearReturnNetAmt__c
• Data Type: DOUBLE
• Description: The trailing 3-year annualized net return amount for the account, expressed as a decimal percentage.

• Field API Name: YearToDateCurrentBalanceAmt__c
• Data Type: DOUBLE
• Description: The year-to-date current balance amount for the account.

• Field API Name: YearToDateReturnNetAmt__c
• Data Type: DOUBLE
• Description: The year-to-date net return amount for the account, expressed as a decimal.