LoanAccount
Represents loan accounts used to track lending arrangements, including origination details, repayment schedule, interest rate, and outstanding balance information.
Columns
| Name | Type | ReadOnly | Description |
| attachment_Id | String | False |
The Id of the attachment associated with this loan account. |
| attachment_Key | String | False |
The system-assigned key of the attachment associated with this loan account. |
| attachment_Name | String | True |
The name of the attachment associated with this loan account. |
| auditCreatedBy | String | True |
The user who created the loan account. |
| auditCreatedDateTime | Datetime | True |
The date and time when the loan account was created. |
| auditModifiedBy | String | True |
The user who last modified the loan account. |
| auditModifiedDateTime | Datetime | True |
The date and time when the loan account was last modified. |
| balancesAccruedInterest | Decimal | False |
The total interest accrued but not yet paid on this loan account. |
| balancesFeeDue | Decimal | False |
The total fees currently due on this loan account. |
| balancesInterestBalance | Decimal | False |
The outstanding interest balance on this loan account. |
| balancesInterestDue | Decimal | False |
The total interest currently due on this loan account. |
| balancesLoanBalance | Decimal | False |
The total outstanding balance on this loan account. |
| balancesPaymentsRemaining | Int | False |
The number of scheduled payments remaining on this loan account. |
| balancesPrincipalBalance | Decimal | False |
The outstanding principal balance on this loan account. |
| balancesPrincipalDue | Decimal | False |
The total principal currently due on this loan account. |
| createSchedule | Bool | False |
Indicates whether a repayment schedule should be automatically created for this loan account. |
| customer_Id | String | False |
The Id of the customer associated with this loan account. |
| customer_Key | String | False |
The system-assigned key of the customer associated with this loan account. |
| customer_Name | String | True |
The name of the customer associated with this loan account. |
| description | String | False |
The description of this loan account. |
| emailStatement | Bool | False |
Indicates whether loan statements are sent by email for this loan account. |
| entity_Id | String | True |
The Id of the entity associated with this loan account. |
| entity_Key | String | True |
The system-assigned key of the entity associated with this loan account. |
| entity_Name | String | True |
The name of the entity associated with this loan account. |
| firstPaymentDate | Date | False |
The date of the first scheduled payment for this loan account. |
| id | String | False |
The unique identifier of the loan account record. |
| isExistingLoanAccount | Bool | False |
Indicates whether this loan account represents a pre-existing loan being entered into the system. |
| isPaidToDate | Bool | False |
Indicates whether this loan account has been paid in full to date. |
| key [KEY] | String | True |
The system-assigned key that uniquely identifies the loan account record. |
| loanCategory_Id | String | False |
The Id of the loan category associated with this loan account. |
| loanCategory_Key | String | False |
The system-assigned key of the loan category associated with this loan account. |
| loanCategory_Name | String | True |
The name of the loan category associated with this loan account. |
| loanHistoryFirstPaymentDate | Date | False |
The date of the first payment recorded in the loan history for this account. |
| loanHistoryGeneratedInterestAmount | Decimal | False |
The total interest generated over the history of this loan account. |
| loanHistoryLoanAmount | Decimal | False |
The original loan amount recorded in the loan history for this account. |
| loanHistoryOriginationDate | Date | False |
The origination date recorded in the loan history for this account. |
| loanHistoryTermInMonths | Int | False |
The loan term in months recorded in the loan history for this account. |
| loanInterestRate_Id | String | False |
The Id of the loan interest rate associated with this loan account. |
| loanInterestRate_Key | String | False |
The system-assigned key of the loan interest rate associated with this loan account. |
| loanInterestRate_Name | String | True |
The name of the loan interest rate associated with this loan account. |
| loanSchedule_Id | String | False |
The Id of the loan schedule associated with this loan account. |
| loanSchedule_Key | String | False |
The system-assigned key of the loan schedule associated with this loan account. |
| loanType_AmortizationType | String | False |
The amortization type of the loan type associated with this loan account. |
| loanType_Id | String | False |
The Id of the loan type associated with this loan account. |
| loanType_Key | String | False |
The system-assigned key of the loan type associated with this loan account. |
| loanType_Name | String | True |
The name of the loan type associated with this loan account. |
| name | String | False |
The name of the loan account. |
| originationAmount | Decimal | False |
The original loan amount at the time of origination. |
| originationDate | Date | False |
The date on which this loan account was originated. |
| payToBillNumber | String | False |
The bill number to which payments for this loan account are applied. |
| payToVendor_Id | String | False |
The Id of the vendor to whom payments for this loan account are made. |
| payToVendor_Key | String | False |
The system-assigned key of the vendor to whom payments for this loan account are made. |
| payToVendor_Name | String | True |
The name of the vendor to whom payments for this loan account are made. |
| state | String | False |
The current state of this loan account, such as open or closed. |
| status | String | False |
The current status of the loan account, such as active or inactive. |
| termInMonths | Int | False |
The term of this loan account in months. |
| txnDefinition_Id | String | False |
The Id of the transaction definition associated with this loan account. |
| txnDefinition_Key | String | False |
The system-assigned key of the transaction definition associated with this loan account. |
| vendor_Id | String | False |
The Id of the vendor associated with this loan account. |
| vendor_Key | String | False |
The system-assigned key of the vendor associated with this loan account. |
| vendor_Name | String | True |
The name of the vendor associated with this loan account. |