Salesforce Docs Portal

FinServ_FinancialAccount__c

Represents a financial account such as an investment account, bank account, or insurance policy.

Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Fields

AccrualFrequency__c

  • Type: picklist
  • Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update
  • Description: The frequency the interest is accrued on the financial account.
  • Default value: Daily
  • Possible values:
    • Annual
    • Daily
    • Monthly
    • Quarterly

AccruedInterest__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The interest accrued on the financial account in the current statement period.

Address1__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Street address line 1 for mailing address.

Address2__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Street address line 2 for mailing address.

ApplicationDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date when this individual submitted the financial account application.

APY__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Annual percentage yield. (Can be fractional.)

AssetRebalance__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Sort, Update
  • Description: Indicates whether automatic portfolio rebalancing applies to this financial account (true) or not (false).

AvailableCredit__c

  • Type: currency
  • Properties: Create, , Filter, Nillable, Sort, Update
  • Description: Total current available credit for this financial account.

AverageBalance__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Average amount of money in the financial account, over a time period.

Balance__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Amount of money in the financial account.

BalanceLastStatement__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Account balance posted on last statement.

BookedDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date charge or credit booked to account.

BranchCode__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The branch code of the financial account.

BranchName__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The branch name of the financial account.

CashBalance__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Cash available in the financial account.

CashLimit__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Maximum cash withdrawal or advance amount.

City__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: City for mailing address.

CloseDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date when this financial account was closed.

CollateralDesc__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Description of collateral provided for loan.

Country__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Country for mailing address.

CurrencyIsoCode

  • Type: picklist
  • Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update
  • Description: If multiple currencies is enabled, contains the currency ISO code associated with the record.

CurrentPostedBalance__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Current posted balance in account.

DailyWithdrawalLimit__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Amount that can be withdrawn in one day.

Description__c

  • Type: textarea
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Description of the financial account.

Discretionary__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether the advisor has discretionary trading authority for this financial account (true) or not (false).

DrawPeriodMonths__c

  • Type: double
  • Properties: CreateFilter, Nillable, Sort, Update
  • Description: Number of months an individual can withdraw funds from a credit account.

EscrowBalance__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Current balance in escrow account.

ExpectedCloseDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Expected date when the debit account or loan closes.

FinancialAccountChargesAndFees__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Reference to Charges and Fees record for the account.

FinancialAccountNumber__c

  • Type: string
  • Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: ID that uniquely identifies the financial account in an external data source. Label is Account Number.

FinancialAccountSource__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Data source. Label is Source. Valid values:
    • Integrator
    • Manual Entry
    • Pending

FinancialAccountType__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Type of financial account. Label is Type. Valid values:
    • 401(a)
    • 401(k)
    • 403(b)
    • 529 Plan
    • Brokerage
    • Cash Management Account
    • CD
    • Checking
    • Credit Card
    • Discount Brokerage
    • Fixed Annuity
    • Individual Life
    • IRA
    • Mutual Fund
    • Profit Sharing
    • Rollover IRA
    • Roth IRA
    • Savings
    • Term Life
    • Variable Life
    • Whole Life

HardwareSerial__c

  • Type: string
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: The serial number of hardware associated with the account.

HeldAway__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether this financial account is managed or administered externally (true) or in-house (false).

HoldingCount__c

  • Type: double
  • Properties: Filter, Nillable, Sort
  • Description: Number of holdings within this financial account. Calculated by roll-up summary. Label is Number of Holdings.

Household__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Household that this financial account rolls up to.

IncomingVolume__c

  • Type: double
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: The volume of transactions coming in through the service.

InsurancePaidYearToDate__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The total amount of insurance paid in the current tax year.

InsuredAmount__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The insured value that an insurance policy covers.

InterestBalance__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The interest balance on the financial account.

InterestPaidYearToDate__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The total amount of interest paid in the current tax year.

InsurancePolicy__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The insurance policy associated with this financial account.

InterestRate__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Interest rate as a percent.

InvestmentObjectives__c

  • Type: multipicklist
  • Properties: Create, Filter, Nillable, Update
  • Description: Purpose of this financial account. Valid values:
    • Safety
    • Income
    • Growth
    • Tax Optimization
    • Liquidity

JointOwner__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Joint owner of this financial account.

LastActivityDate

  • Type: date
  • Properties: Filter, Group, Nillable, Sort
  • Description: Timestamp for when this financial account last had a task or event action associated with the record.

LastReferencedDate

  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: Timestamp for when the current user last viewed a record related to this record.

LastTransactionDate

  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: Timestamp for the last transaction on the account.

LastUpdated__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Timestamp for when data for the financial account was last updated by an external data source.

LastViewedDate

  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: Timestamp for when the current user last viewed this record.

LienHolder__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of lien holder on the financial account.

LoanAmount__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Amount of the loan.

LoanEndDate

  • Type: date
  • Properties: Filter, Group, Nillable, Sort
  • Description: End date for the loan.

LoanTermMonths__c

  • Type: double
  • Properties: CreateFilter, Nillable, Sort, Update
  • Description: Loan term in months.

Managed__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether this financial account is managed or administered (true), or not (false).

MinimumBalance__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Minimum balance requirement for this financial account.

MinimumPayment__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Minimum monthly payment on account.

ModelPortfolio__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Model asset allocation for the financial account. Valid values:
    • Conservative
    • Moderate
    • Balanced
    • Growth
    • Aggressive

Name

  • Type: string
  • Properties: Create, Defaulted on create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: Name of the financial account.

NickName__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Nickname of the financial account.

OpenDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date when the financial account was opened.

OutgoingVolume__c

  • Type: double
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: The volume of transactions going out through the service.

OverDraftAllowed__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether the financial account allows an overdraft (true) or not (false).

OverDraftLinkedAccount__c

  • Type: reference
  • Properties: Create, Filter, Group, Sort, Update
  • Description: Reference to the linked overdraft account.

OverdraftProtection__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether the customer accepts overdraft protection and its associated fees.

OwnerId

  • Type: reference
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: ID of the user who created the financial account record.

Ownership__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Type of ownership for the account. Valid values:
    • Individual
    • Joint
    • Trust

OwnerType__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Individual’s ownership role (primary or joint) for the account.

PaperlessDelivery__c

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Account owner elects to receive electronic delivery of financial account documents (true) or not (false).

PaymentAmount__c

  • Type: currency
  • Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
  • Description: Minimum monthly payment on account.

PaymentDueDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date when payment due on the account.

PaymentFrequency__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Frequency of payments on the account. Valid values:
    • Weekly
    • Biweekly
    • Monthly
    • Quarterly
    • Semiannually
    • Annually

PendingDeposits__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Deposits pending on the account.

PendingWithdrawals__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: WIthdrawals pending on the account.

Performance1Yr__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Performance measured over the past year.

Performance3Yr__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Performance measured over the past three years.

PerformanceMTD__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Performance measured over the past month-to-date.

PerformanceQTD__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Performance measured over the past quarter-to-date.

PerformanceYTD__c

  • Type: percent
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Performance measured over the past calendar year-to-date.

PolicyTerm__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The period of coverage provided by the policy.

PostalCode__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Postal code for mailing address.

Premium__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Amount paid to the insurer for insurance policy coverage.

PrimaryBankerIdentifier__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The unique identifier of the primary banker who manages the financial account.

PrimaryBankerName__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The name of the primary banker who manages the financial account.

PrimaryOwner__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Primary owner of the financial account.

PrincipalBalance__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Principal balance on the loan account.

PrincipalPaidYearToDate__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The total amount paid against the principal in the current tax year.

ProductName__c

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Policy product name.

PropTaxPaidYearToDate__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The total amount of property tax paid in the current tax year.

RebalanceFrequency__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Frequency of portfolio rebalancing for this financial account. Valid values:
    • Monthly
    • Quarterly
    • Semiannually
    • Annually

RecordTypeId

  • Type: reference
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: ID of the record type associated with this financial account.

RecordTypeName__c

  • Type: string
  • Properties: Filter, Nillable, Sort
  • Description: Record type for this financial account. The value is copied from RecordType.Name and can’t be changed. Label is Record Type.

RenewalDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Date when insurance policy renewal is due.

RepaymentPeriodMonths__c

  • Type: double
  • Properties: CreateFilter, Nillable, Sort, Update
  • Description: Repayment period in months.

RoutingNumber__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Bank routing number.

SecondaryBankerIdentifier__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The unique identifier of the secondary banker who manages the financial account.

SecondaryBankerName__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The name of the secondary banker who manages the financial account.

ServiceProvider__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Custodian or recordkeeper of this financial account.

ServiceType__c

  • Type: picklist
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: The type of service undertaken.

SourceSystemId__c

  • Type: string
  • Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: ID that uniquely identifies the financial account in an external data source.

State__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: State for mailing address.

StatementFrequency__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Frequency statements are issued. Valid values:
    • Monthly
    • Biweekly
    • Quarterly
    • Annually

Status__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Status of this financial account. Valid values:
    • Open
    • Closed
    • On Hold
    • Pending

TargetLimit__c

  • Type: double
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: The limit on items or value that the service processes.

TaxID__c

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Tax Identification Number associated with this financial account.

TaxStatus__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Type of tax treatment this financial account qualifies for. Valid values:
    • Nonqualified
    • Qualified

TermDepositMaturityDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The date a fixed term deposit matures.

TimeHorizon__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Investment time frame for this financial account. Valid values:
    • Long Term
    • Medium Term
    • Short Term

TotalCreditLimit__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total credit limit.

TotalHoldAmountAsOfDate__c

  • Type: date
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: The date the total hold amount is relevant.

TotalHoldAmount__c

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: The total hold amount on the financial account.

Type__c

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Type of account. Valid values:
    • Brokerage
    • Discount Brokerage
    • CD
    • Checking
    • Cash Management Account
    • Credit Card
    • Savings
    • Mutual Fund, Fixed Annuity
    • Variable Annuity
    • Managed Account
    • Individual Life
    • Term Life
    • Variable Life
    • Whole Life