...
Smart Marker | Note | |
---|---|---|
Model: &=vm.Loans (All existing Loans) | ||
LoanID | The public ID of the loan. Unique identifier of the loan that is visible to all users of the System. | |
DisbursementDate |
| |
CloseDate | Repaid, WrittenOff, Restructured, AgreementDeclined, AgreementExpired, Rejected | |
ApplicationDate | The Date when the application was created | |
LoanAmount | ||
AverageInstallment | Average Installment amount. (Sum of all installments according to the initial schedule) / ( number of installments). Grace period installments are not included Past due, late fee values are not included | |
DaysPastDue | The number of past due days of the overdue loan. | |
PastDueDebt | The current past due debt of the loan. It includes the sum of unpaid debt of all missed installments. | |
OutstandingBalance | Loan’s outstanding balance | |
OutstandingPrincipal | Loan’s outstanding principal. | |
Originator | The full name of the back-office user who created the loan. If the loan was created from the front-office, the value should be empty. | |
Underwriter | The full name of the back-office user the latest to interact with the loan (approve, reject or sent for reprocessing). If the loan was approved or rejected by System, the value should be empty. | |
LoanTermFull | Loan term in months. | |
RiskLevel | Low | Medium | High | Highest | Default | |
SystemDecision | Approve | Refer | Reject | |
UnderwritterDecision | Approve | Reject | |
Status | Loan status on the current system (in a human-readable format). | |
LoanBranch | ||
InterestRate | The interest rate value of the relevant credit product settings | |
TotalContract | Total accrued amount for the loan schedule calculated for the moment of the disbursement date. | |
InterestContract | Total accrued amount for the loan schedule calculated for the moment of the disbursement date. | |
CommissionContract | Total accrued amount for the loan schedule calculated for the moment of the disbursement date. | |
LeasingContract | Total accrued fees with Fee type = 'Leasing' on the disbursement state. | |
MaturityDate | Loan maturity date by the contract(the date when Loan should be fully paid by the loan schedule from the contract, excluding possible Rollovers). | |
WrittenOffAmount | For loans that were written off, this value contains the total write-off amount. For other loans contains 0. | |
OverpaidAmount | Overpayment is the rest part of the paid amount after all missed and current installments are closed. | |
ContractDate | The date when the contract was signed. If Loan agreement e-signing is enabled, the date when Customer signed Loan agreement. If e-signing is disabled, the date is an empty field If the loan signed manually, the date when the back-office user signed manually | |
Store | Store name | |
Store Address | Store's Address | |
Vendor | Vendor name | |
VendorAddress | Vendor's Address | |
PurchaseAmount | 'Purchase amount' value. Set by the Borrower or the Originator when a loan is created/modified | |
DownPaymentAmount | Sum of all accrued 'Down payment' fees | |
PreApprovalFeesAmount | Sum of all accrued 'Pre-approval' fees | |
PreDisbursementFeesAmount | Sum of all accrued 'Pre-disbursement' fees (including Down payments) | |
FirstDisbursementAmount | First Funds Tranche | |
TotalDisbursedAmount | Sum of all successful disbursement transactions | |
EqualPayment | Equal payment | |
RepaymenPeriod | Repayment period. Credit Product settings | |
Model: &=vm.Transactions (Only Loan disbursements and Loan Repayments) | ||
TransactionDate | Date/time of the transaction | |
Amount | DisbursementAmount | PaymentAmount | |
Type | Disbursement | Payment | |
PaymentType | Cash | Check | Bank Transfer | Card | |
Reference | ||
Comments | ||
Principal | Principal amount | |
Interest | Interest amount | |
Leasing | Leasing amount | |
Past Due | Past Due amount with Fee Type = 'PastDue' | |
Fee | Fee amount with Fee Type = 'Fee' | |
Penalty | Penalty amount with Fee Type = 'Penalty' | |
Model: &=vm.ExpectedPayments (The dataset should be grouped by the same rule as in the current software version for Export > Expected Payments) | ||
NextPaymentDate | ||
ExpectedAmount | NextPaymentAmount | Debt | |
Status | Scheduled | Late Grace | Past due | |
Model: &=vm.Customers | ||
FullName | Customer's Full name | |
Phone | ||
State | State Name from the Application form, Customer's address | |
City | ||
Street | ||
ZipCode | ||
ResidentialStatus | SSN | |
BorrowerBankAccountTypeBankAccountType | Type of account (Saving | Checking) | |
Model: &=vm.Cashflow | ||
AccruedInterest | Total accrued Interest amount for the period specified in the time filtering | |
AccruedPastDue | Sum of all accrued fees with Fee Type = 'PastDue' | |
AccruedFee | Sum of all accrued fees with Fee Type = 'Fee' | |
AccruedPenalty | Sum of all accrued fees with Fee Type = 'Penalty' | |
AccruedAdminFee | Sum of all accrued Administration Fees created with the basic view template | |
AccruedOriginationFee | Sum of all accrued Origination Fees created with the basic view template | |
AccruedLateFee | Sum of all accrued LateFee created with the basic view template | |
AccruedNSF | Sum of all accrued NSF created with the basic view template | |
AccruedPastDueInterest | Sum of all accrued PastDueInterest created with the basic view template | |
RepaidPrincipal | Total repaid principal amount for the period specified in the time filtering | |
RepaidInterest | Total repaid interest amount for the period specified in the time filtering | |
RepaidFee | Sum of all repaid fees with Fee Type = 'Fee' | |
RepaidPastDue | Sum of all repaid fees with Fee Type = 'PastDue' | |
RepaidPenalty | Sum of all repaid fees with Fee Type = 'Penalty' | |
RepaidAdminFee | Sum of all repaid Administration Fees created with the basic view template | |
RepaidOriginationFee | Sum of all repaid Origination Fees created with the basic view template | |
RepaidLateFee | Sum of all repaid LateFee created with the basic view template | |
RepaidNSF | Sum of all repaid NSF created with the basic view template | |
RepaidPastDueInterest | Sum of all repaid PastDueInterest created with the basic view template | |
RepaidLeasing | Sum of all repaid fees with Fee type = 'Leasing' |