List of Smart Markers
To see the full list of Smart Markers, go to Tools → Excel Report. Click the “Report builder” button in the top right corner.
When the “Report builder” window opens, click the Smar markers” button.
Click the “Export full list” button to see the list of Smart Markers available for your project.
Below is an example of the list of smart markers available for a box project
Name | Description | Copy to file |
---|---|---|
Accrued admin fee | Sum of all accrued Administration Fees created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_AccruedAdminFee |
Accrued fee | Sum of all accrued fees with Fee Type = 'Fee' for the period specified in the time filtering | &=vm.Cashflow_AccruedFee |
Accrued interest | Total accrued interest amount for the period specified in the time filtering | &=vm.Cashflow_AccruedInterest |
Accrued late fee | Sum of all accrued LateFee created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_AccruedLateFee |
Accrued NSF | Sum of all accrued NSF created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_AccruedNSF |
Accrued origination fee | Sum of all accrued Origination Fees created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_AccruedOriginationFee |
Accrued past due | Sum of all accrued fees with Fee Type = 'PastDue' for the period specified in the time filtering | &=vm.Cashflow_AccruedPastDue |
Accrued past due interest | Sum of all accrued PastDueInterest created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_AccruedPastDueInterest |
Accrued penalty | Sum of all accrued fees with Fee Type = 'Penalty' for the period specified in the time filtering | &=vm.Cashflow_AccruedPenalty |
Repaid admin fee | Sum of all repaid Administration Fees created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_RepaidAdminFee |
Repaid fee | Sum of all repaid fees with Fee Type = 'Fee' for the period specified in the time filtering | &=vm.Cashflow_RepaidFee |
Repaid interest | Total repaid interest amount for the period specified in the time filtering for the period specified in the time filtering | &=vm.Cashflow_RepaidInterest |
Repaid late fee | Sum of all repaid LateFee created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_RepaidLateFee |
Repaid leasing | Sum of all repaid fees with Fee type = 'Leasing' for the period specified in the time filtering | &=vm.Cashflow_RepaidLeasing |
Repaid NSF | Sum of all repaid NSF created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_RepaidNSF |
Repaid origination fee | Sum of all repaid Origination Fees created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_RepaidOriginationFee |
Repaid past due | Sum of all repaid fees with Fee Type = 'PastDue' for the period specified in the time filtering | &=vm.Cashflow_RepaidPastDue |
Repaid past due interest | Sum of all repaid PastDueInterest created with the basic view template for the period specified in the time filtering | &=vm.Cashflow_RepaidPastDueInterest |
Repaid penalty | Sum of all repaid fees with Fee Type = 'Penalty' for the period specified in the time filtering | &=vm.Cashflow_RepaidPenalty |
Repaid principal | Total repaid principal amount for the period specified in the time filtering for the period specified in the time filtering | &=vm.Cashflow_RepaidPrincipal |
Customer flags | All active customer's flags | &=vm.Customers_Flags |
Customer's bank account type | Type of account (Saving; Checking) | &=vm.Customers_BankAccountType |
Customer's city | The city as defined the customer’s address | &=vm.Customers_City |
Customer's email | Customer’s Email | &=vm.Customers_Email |
Customer's First Name | Customer's First Name | &=vm.Customers_FirstName |
Customer's full name | Full name of the customer | &=vm.Customers_FullName |
Customer's income type | Customer's income type (depends on the edition) | &=vm.Customers_IncomeType |
Customer's Last Name | Customer's Last Name | &=vm.Customers_LastName |
Customer's Middle Name | Customer's Middle Name | &=vm.Customers_MiddleName |
Customer's phone | Customer’s phone | &=vm.Customers_Phone |
Customer's public id | Public customer ID | &=vm.Customers_PublicId |
Customer's SSN | Customer’s SSN | &=vm.Customers_SSN |
Customer's state | The state as defined the customer’s address | &=vm.Customers_State |
Customer's street | The street as defined the customer’s address | &=vm.Customers_Street |
Customer's zip code | The zip code as defined the customer’s address | &=vm.Customers_ZipCode |
Expected payment amount | Amount of the nearest exptected payment or debt | &=vm.ExpectedPayments_ExpectedAmount |
Expected payment status | Status of the next expected payemnt (scheduled; late; grace; past due) | &=vm.ExpectedPayments_Status |
Next payment date | Date of the nearest expected payment | &=vm.ExpectedPayments_NextPaymentDate |
Accrued unpaid interest | Total unpaid Interest by the reporting date | &=vm.Loans_AccruedUnpaidInterest |
Applicant Credit Bureau Score | Applicant Credit Bureau Score | &=vm.Loans_CreditBureauScore |
Application date | Date the application was created | &=vm.Loans_ApplicationDate |
Average installment | 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 | &=vm.Loans_AverageInstallment |
Close date | Date the loan was closed (repaid, written off, restructured, rejected, agreement declined or expired) | &=vm.Loans_CloseDate |
Co-Applicant Credit Bureau Score | Co-Applicant Credit Bureau Score | &=vm.Loans_CoApplicantCreditBureauScore |
Contract date | The date when the contract was signed.
If the loan is e-signing, it is the date when Customer signed the loan agreement.
If the is loan signed manually, it is the date when the back-office registered manual signing | &=vm.Loans_ContractDate |
Contract leasing amount | Total amount of all the fees of Fee type = 'Leasing' to be accrued according to the schedule as it was on the disbursement state. | &=vm.Loans_LeasingContract |
Credit product | Credit Product Name | &=vm.Loans_CreditProduct |
Days past due | Number of days past due for an overdue loan | &=vm.Loans_DaysPastDue |
Disbursement date | The date when the transaction of Loan Disbursement was done.
For the Loan Agreement where the loan has not been disbursed - the Current date | &=vm.Loans_DisbursementDate |
Down-payment | Sum of all accrued 'Down payment' fees | &=vm.Loans_DownPaymentAmount |
Equal payment | Equal payment. Applicable if 'Enable equal payments'=ON | &=vm.Loans_EqualPayment |
First disbursement amount | First funds tranche. Applicable if 'Enabled multiple disbursement'=ON | &=vm.Loans_FirstDisbursementAmount |
First payment date | The first due date according to the initial schedule | &=vm.Loans_FirstPaymentDate |
Full loan term | Loan term in months, (e.g. “12 months”) | &=vm.Loans_LoanTermFull |
Interest rate | Interest rate for the loan; is set in the given credit product | &=vm.Loans_InterestRate |
Last payment date | The date of the most recent successful payment transaction the client made towards the account | &=vm.Loans_LastPaymentDate |
Loan amount | Loan amount value. Set by the Borrower or Originator when a the loan application was created | &=vm.Loans_LoanAmount |
Loan auto-decision date | Date when the loan was auto-processed and then moved into the Underwriting workspace or auto-decisioned | &=vm.AutoDecisionDate |
Loan branch | Lowest-level branch to which the loan is assigned | &=vm.Loans_LoanBranch |
Loan Cancellation Reason | Loan Cancellation Reason | &=vm.Loans_CancellationReason |
Loan ID | Unique identifier of the loan that is visible to all users of the System. | &=vm.Loans_LoanID |
Loan Rejection Reason | Loan Rejection Reason | &=vm.Loans_RejectionReason |
Loan status | Loan status on the current system (in a human-readable format). | &=vm.Loans_Status |
Maturity date | Loan maturity date according to the contract (date when Loan should be fully paid according to its initial schedule. (Rollovers are not taken into account). | &=vm.Loans_MaturityDate |
Next payment date | The nearest future due date according to the actual payment schedule | &=vm.Loans_NextPaymentDate |
Oldest missed due date | For accounts that are past due, this is the date of the first missed payment. Due date of the oldest installment with status 'Missed' | &=vm.Loans_OldestMissedDueDate |
Originator | Full name of the back-office user who created the loan. If the loan was created from the front-office, the value is empty. | &=vm.Loans_Originator |
Outstanding balance | Current outstanding balance of the loan | &=vm.Loans_OutstandingBalance |
Outstanding principal | Current outstanding principal of the loan | &=vm.Loans_OutstandingPrincipal |
Overpaid amount | Total amount of overpayment for the loan | &=vm.Loans_OverpaidAmount |
Paid fees | Total Paid Fees from the Loan Start date to the Current date (except the Initial fees!) | &=vm.Loans_PaidFees |
Paid initial fees | Total Initial Fees paid on this loan | &=vm.Loans_PaidInitialFees |
Paid total | Amount paid. Sum of all successful payment transactions | &=vm.Loans_PaidTotal |
Past due debt | Current past due debt of the loan. The sum of unpaid debt for all missed installments. | &=vm.Loans_PastDueDebt |
Payment amount | Scheduled monthly payment. Total amount of the installment #1 from the Initial schedule. Used in annuity loan type without origination fee over equal payment | &=vm.Loans_PaymentAmount |
Payoff amount | Payoff amount on the reporting date (can only be calculated on the current date!) | &=vm.Loans_PayOffAmount |
Pre-approval fees | Sum of all accrued 'Pre-approval' fees | &=vm.Loans_PreApprovalFeesAmount |
Pre-disbursement fees | Sum of all accrued 'Pre-disbursement' fees (including Down payments) | &=vm.Loans_PreDisbursementFeesAmount |
Purchase amount | Purchase amount' value. Set by the Borrower or the Originator when a loan is created/modified | &=vm.Loans_PurchaseAmount |
Repayment period | Repayment period as defined in the Credit Product settings | &=vm.Loans_RepaymentPeriod |
Risk level | Risk level calculated following the loan assessment by the System (Low; Medium; High; Highest; Default) | &=vm.Loans_RiskLevel |
Sent for signing date | Date when the loan agreement is generated and sent to the customer for signing | &=vm.SentForSigningDate |
Store | Name of the store | &=vm.Loans_Store |
Store address | Address of the store | &=vm.Loans_StoreAddress |
System decision | Automatic decision suggested by the system (Approve; Refer; Reject) | &=vm.Loans_SystemDecision |
Total contract amount | Total amount to be accrued according to the loan schedule as it was at the moment of disbursement | &=vm.Loans_TotalContract |
Total contract commission | Total comission accrued according to the loan schedule as it was at the moment of disbursement | &=vm.Loans_CommissionContract |
Total contract interest | Total interest to be accrued according to the loan schedule as it was at the moment of disbursement | &=vm.Loans_InterestContract |
Total disbursed amount | Sum of all successful disbursement transactions | &=vm.Loans_TotalDisbursedAmount |
Total written off amount | The remaining outstanding balance on the account when it was written off | &=vm.Loans_WrittenOffTotal |
Underwriter | Full name of the back-office user 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. | &=vm.Loans_Underwriter |
Underwriter's decision | Decision made by a back-office user (Approve; Reject) | &=vm.Loans_UnderwriterDecision |
Vendor | Name of the vendor | &=vm.Loans_Vendor |
Vendor address | Address of the vendor | &=vm.Loans_VendorAddress |
Written off amount | For loans that were written off it is the total write-off amount. For other loans the value is 0. | &=vm.Loans_WrittenOffAmount |
Written off interest | Written Off Interest amount (current value) | &=vm.Loans_WrittenOffInterest |
Written off principal | Written Off Principal amount (current value) | &=vm.Loans_WrittenOffPrincipal |
Written-off fees | Written off fee amount (current value). Sum of all fees except principal and interest | &=vm.Loans_WrittenOffFees |
Comment on failure | Comments from the person who reversed this transaction (Manager) or an error from a payment provider | &=vm.Transactions_FailComment |
Created by | Name of the person who created this transaction (Client or Manager) or 'System' | &=vm.Transactions_Creator |
Failure date | The date when a transaction became reversed / failed | &=vm.Transactions_FailDate |
Fee | Fee amount (total of all the fees with Fee Type = 'Fee') | &=vm.Transactions_Fee |
Interest | Interest amount | &=vm.Transactions_Interest |
Leasing | Leasing amount | &=vm.Transactions_Leasing |
Past due | Past Due amount (total off all the fees with Fee Type = 'PastDue') | &=vm.Transactions_PastDue |
Payment type | Pament type (Cash; Check; Bank Transfer; Card) | &=vm.Transactions_PaymentType |
Penalty | Penalty amount (total off all the fees with Fee Type = 'Penalty') | &=vm.Transactions_Penalty |
Principal | Principal amount | &=vm.Transactions_Principal |
Repayment mode | Repayment mode of the transaction | &=vm.Transactions_RepaymentMode |
Reversed by | Name of the person who created this transaction (Client or Manager) or 'System' | &=vm.Transactions_FailCreator |
Transaction amount | Amount of the transaction | &=vm.Transactions_Amount |
Transaction comments | Comments added to the transaction by a back-office user | &=vm.Transactions_Comments |
Transaction date | Date/time of the transaction | &=vm.Transactions_TransactionDate |
Transaction reference | Reference ID provided for the transaction by a back-office user | &=vm.Transactions_Reference |
Transaction status | Transaction status (Successful; Reversed; Failed) | &=vm.Transactions_Status |
Transaction type | Type of the transaction (Disbursement or Payment) | &=vm.Transactions_Type |
Undistributed amount | A part of the repayment amount that was not allocated to the principal, interest or any fees | &=vm.Transactions_UndistributedAmount |