...
Smart Marker | Note |
---|---|
Model: &=vm.Loans (All existing Loans) | |
LoanID | The public ID of the loan. Unique Unique identifier of the loan that is visible to all users of the System. |
DisbursementDate | The date loans were disbursed. |
CloseDate | Repaid, WrittenOff, Restructured, AgreementDeclined, AgreementExpired, Rejected |
ApplicationDate | The Date when when the transaction of Loan Disbursement was done For the Loan Agreement where the loan has not been disbursed - the Current date |
CloseDate | Date the loan was closed (repaid, written off, restructured, rejected, agreement declined or expired) |
ApplicationDate | Date the application was created |
LoanAmount | Loan amount value. Set by the Borrower or Originator when a the loan application was created |
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 Number of days past due days of the for an overdue loan. |
PastDueDebt | The current Current past due debt of the loan. It includes the The sum of unpaid debt of for all missed installments. |
OutstandingBalance | Loan’s Current outstanding balance of the loan |
OutstandingPrincipal | Loan’s Current outstanding principal .of the loan |
Originator | The full Full name of the back-office user who created the loan. If the loan was created from the front-office, the value should be is empty. |
Underwriter | The full 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, (e.g. “12 months”) |
RiskLevel | Low | Medium | High | Highest | Default |
SystemDecision | Approve | Refer | Reject |
UnderwritterDecision | Approve | RejectRisk level calculated following the loan assessment by the System (Low; Medium; High; Highest; Default) |
SystemDecision | Automatic decistion suggested by the System (Approve; Refer; Reject) |
UnderwritterDecision | Decision made by a back-office user (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 | |
SSN | |
BankAccountType | 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' |