LoanApplicationFinancial

Represents transaction details for a loan application. This object is available in API version 47.0 and later.

Supported Calls

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

Fields

BorrowerClosingCostAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total closing costs due from borrower, including prepaid and initial escrow payments.

CashFromOrToBorrowerAmt

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Cash the borrower pays or receives at closing, not including reserves or other funds that may still require lender verification.
  • Formula:
    1PurchasePriceAmount + RemodelAndRepairsAmount + LandAcquiredSeparatelyAmount + OutstandingLoanAmount + TotalDebtPaidOffAmount + BorrowerClosingCostAmt + DiscountPointCostAmount - LoanExclFinMortInsAmt - FinancedMortgageInsAmt - CreditFromSeller - OtherCredit

CounselingAgencyName

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Counseling provider's name if agency isn't HUD approved or if Housing Counseling Agency ID is unknown

CounselingAgencyProvName

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Education provider's name if agency isn't HUD-approved or if Housing Counseling Agency ID is unknown.

CounselingComplBorrName

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of borrower or borrowers who completed housing counseling.

CounselingCompletionDate

  • Type: dateTime
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Date borrower completed housing counseling.

CreditFromSeller

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of closing costs due from seller.

DiscountPointCostAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total cost of discount points purchased by the borrower due at closing.

EdCompletedBorrowerName

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Name of borrower or borrowers who completed homeownership education.

EstFirstMortgagePmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed monthly first mortgage payment for loan application property, including principal and interest.

EstHomeownersInsPmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed monthly payment for homeowners insurance on application property.

EstMortgageInsPmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed monthly mortgage insurance payment on application property.

EstOtherDuesPaymentAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed total monthly payment on application property for payments like homeowners association, co-op, condo, or planned unit development dues.

EstOtherPaymentAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed total monthly payment for other housing expenses on application property.

EstPropertyTaxesPmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed monthly payment for real estate taxes on application property.

EstSubordinateLienPmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed total monthly payment for other mortgages or liens on loan application property, including principal and interest.

EstSuppPropertyInsPmtAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Proposed monthly payment for supplemental property insurance like flood, earthquake, or umbrella policies on application property.

FinancedMortgageInsAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of financed mortgage insurance or financed mortgage insurance equivalent.

FinancialExtIdentifier

  • Type: string
  • Properties: Create, Filter, Group, idLookup, Nillable, Sort, Update
  • Description: ID that uniquely identifies imported data in an external data source (if applicable). This field is unique within your organization.

HasCompletedCounseling

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether one or more borrowers completed housing counseling within the last 12 months.

HasHoEducation

  • Type: boolean
  • Properties: Create, Defaulted on create, Filter, Group, Sort, Update
  • Description: Indicates whether one or more borrowers completed homeownership education within the last 12 months.

HoEducationCompletedDate

  • Type: dateTime
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Date borrower completed homeownership education.

HoEducationFormat

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Indicates the format of homeownership education attended by borrower.
  • Possible values:
    • Attended Workshop in Person
    • Completed Web-Based Workshop

HousingCounselingFormat

  • Type: picklist
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Indicates the format of the housing counseling completed by borrower.
  • Possible values:
    • Face-to-Face
    • Internet
    • Telephone

HudApprAgencyIdentifier

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Home counseling provider's Housing Counseling Agency ID if agency is HUD-approved.

HudApprovedProvIdentifier

  • Type: string
  • Properties: Create, Filter, Group, Nillable, Sort, Update
  • Description: Homeownership education provider's Housing Counseling Agency ID if agency is HUD-approved.

LandAcquiredSeparatelyAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Price of land if purchased separately from the building or structure.

LastReferencedDate

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

LastViewedDate

  • Type: dateTime
  • Properties: Filter, Nillable, Sort
  • Description: The timestamp for when the current user last viewed this record. If this value is null, it’s possible that this record was referenced (LastReferencedDate) and not viewed.

LoanAmount

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Total amount of loan including financed mortgage insurance or mortgage insurance equivalent.
  • Formula:
    1LoanExclFinMortInsAmt + FinancedMortgageInsAmt

LoanApplicationId

  • Type: reference
  • Properties: Create, Filter, Group, Sort
  • Description: ID of the loan application associated with this loan transaction.

LoanExclFinMortInsAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Loan amount excluding financed mortgage insurance or financed mortgage insurance equivalent.

Name

  • Type: string
  • Properties: Create, Filter, Group, idLookup, Sort, Update
  • Description: Name of the loan application financial.

OtherCredit

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of all purchase credits like borrower credits, credits from third parties, and non-cash seller credits.

OtherNewMortgageLoanAmt

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of other new borrower mortgages, both first lien and subordinate lien, on the application property.

OutstandingLoanAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of all mortgage loans on application property to be paid off by refinance loan.

PurchasePriceAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Purchase price for the property.

RemodelAndRepairsAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Cost of any alterations, improvements, and repairs on the property.

TotalCashDueFromBorrower

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Total cash due from borrower at closing.
  • Formula:
    1PurchasePriceAmount + RemodelAndRepairsAmount + LandAcquiredSeparatelyAmount + OutstandingLoanAmount + TotalDebtPaidOffAmount + BorrowerClosingCostAmt + DiscountPointCostAmount

TotalCredit

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Total borrower credits.
  • Formula:
    1CreditFromSeller + OtherCredit

TotalDebtPaidOffAmount

  • Type: currency
  • Properties: Create, Filter, Nillable, Sort, Update
  • Description: Total amount of all non-application property liabilities borrower indicated would be paid off on or before closing.

TotalEstPaymentAmt

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Proposed total monthly payment for application property.
  • Formula:
    1EstFirstMortgagePmtAmt + EstSubordinateLienPmtAmt + EstHomeownersInsPmtAmt + EstSuppPropertyInsPmtAmt + EstPropertyTaxesPmtAmt + EstMortgageInsPmtAmt + EstOtherDuesPaymentAmt + EstOtherPaymentAmt

TotalMortgageLoanAndCreditAmt

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Total mortgage loans plus total credits.
  • Formula:
    1LoanExclFinMortInsAmt + FinancedMortgageInsAmt + CreditFromSeller + OtherCredit

TotalMortgageLoansAmount

  • Type: currency
  • Properties: Filter, Nillable, Sort
  • Description: Total amount of loan.
  • Formula:
    1LoanExclFinMortInsAmt + FinancedMortgageInsAmt

Associated Objects

This object has the following associated objects. Unless noted, they are available in the same API version as this object.

LoanApplicationFinancialChangeEvent
Change events are available for the object.
LoanApplicationFinancialFeed
Feed tracking is available for the object.
LoanApplicationFinancialHistory
History is available for tracked fields of the object.