How can we help?

Context engine glossary – date range


This section is meant to provide examples of how to use each available date range variable. For a better explanation on how the date range variables work see the Date-Range Variables section of the working with variables article.

 

The context engine is a large database of retrievable variables, available for use throughout LoanPro software. 

Payments

Here's an example of the payments variable:

[[query('payments-total', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total paid for a specific date range.

Name Variable Description
All [[query('payments-total', 'date.range.all')]] Displays the total paid on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-total', 'date.range.customDays', 5,15)]] Displays the total paid on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-total', 'date.range.customFuture', 15)]] Displays the total amount paid to an account within the next 15 days.
Custom (last X days) [[query('payments-total', 'date.range.customPast', 15)]] Displays the total amount paid to an account within the last 15 days.
Last Month [[query('payments-total', 'date.range.lastMonth')]] Displays the total amount paid to an account last month.
Last Week [[query('payments-total', 'date.range.lastWeek')]] Displays the total amount paid to an account last week.
Last Year [[query('payments-total', 'date.range.lastYear')]] Displays the total amount paid to an account last year.
Month To Date [[query('payments-total', 'date.range.monthToDate')]] Displays the total amount paid to an account from the beginning of the month to the current date.
This Month [[query('payments-total', 'date.range.thisMonth')]] Displays the total amount paid to an account within the current month.
This Week [[query('payments-total', 'date.range.thisWeek')]] Displays the total amount paid to an account within the current week.
Today [[query('payments-total', 'date.range.today')]] Displays the total amount paid to an account today.
Year To Date [[query('payments-total', 'date.range.yearToDate')]] Displays the total amount paid to an account from the beginning of the year to the current date.
Yesterday [[query('payments-total', 'date.range.yesterday')]] Displays the total amount paid to an account yesterday.

 

Payments - interest paid

Here's an example of the payments - interest paid variable:

[[query('payments-interest', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of interest paid within a specific date range.

Name Variable Description
All [[query('payments-interest', 'date.range.all')]] Displays the total amount of interest paid on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-interest', 'date.range.customDays',5,15)]] Displays the total amount of interest paid on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-interest', 'date.range.customFuture', 15)]] Displays the total amount of interest paid to an account within the next 15 days.
Custom (last X days) [[query('payments-interest', 'date.range.customPast', 15)]] Displays the total amount of interest paid to an account within the last 15 days.
Last Month [[query('payments-interest', 'date.range.lastMonth')]] Displays the total amount of interest paid to an account last month.
Last Week [[query('payments-interest', 'date.range.lastWeek')]] Displays the total amount of interest paid to an account last week.
Last Year [[query('payments-interest', 'date.range.lastYear')]] Displays the total amount of interest paid to an account last year.
Month To Date [[query('payments-interest', 'date.range.monthToDate')]] Displays the total amount of interest paid to an account from the beginning of the month to the current date.
This Month [[query('payments-interest', 'date.range.thisMonth')]] Displays the total amount of interest paid to an account within the current month.
This Week [[query('payments-interest', 'date.range.thisWeek')]] Displays the total amount of interest paid to an account within the current week.
Today [[query('payments-interest', 'date.range.today')]] Displays the total amount of interest paid to an account today.
Year To Date [[query('payments-interest', 'date.range.yearToDate')]] Displays the total amount of interest paid to an account from the beginning of the year to the current date.
Yesterday [[query('payments-interest', 'date.range.yesterday')]] Displays the total amount of interest paid to an account yesterday.

 

Payments - principal paid

Here's an example of the payments - principal paid variable:

[[query('payments-principal', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of principal paid within a specific date range.

Name Variable Description
All [[query('payments-principal', 'date.range.all')]] Displays the total amount of principal paid on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-principal', 'date.range.customDays',5,15)]] Displays the total amount of principal paid on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-principal', 'date.range.customFuture', 15)] Displays the total amount of principal paid to an account within the next 15 days.
Custom (last X days) [[query('payments-principal', 'date.range.customPast', 15)]] Displays the total amount of principal paid to an account within the last 15 days.
Last Month [[query('payments-principal', 'date.range.lastMonth')] Displays the total amount of principal paid to an account last month.
Last Week [[query('payments-principal', 'date.range.lastWeek')]] Displays the total amount of principal paid to an account last week.
Last Year [[query('payments-principal', 'date.range.lastYear')]] Displays the total amount of principal paid to an account last year.
Month To Date [[query('payments-principal', 'date.range.monthToDate')]] Displays the total amount of principal paid to an account from the beginning of the month to the current date.
This Month [[query('payments-principal', 'date.range.thisMonth')]] Displays the total amount of principal paid to an account within the current month.
This Week [[query('payments-principal', 'date.range.thisWeek')]] Displays the total amount of principal paid to an account within the current week.
Today [[query('payments-principal', 'date.range.today')]] Displays the total amount of principal paid to an account today.
Year To Date [[query('payments-principal', 'date.range.yearToDate')]] Displays the total amount of principal paid to an account from the beginning of the year to the current date.
Yesterday [[query('payments-principal', 'date.range.yesterday')]] Displays the total amount of principal paid to an account yesterday.

 

Payments - discount paid

Here's an example of the payments - discount paid variable:

 [[query('payments-discount', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of discount paid on an account within a specific date range.

Name Variable Description
All [[query('payments-discount', 'date.range.all')]] Displays the total amount paid towards discount on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-discount', 'date.range.customDays',5,15)]] Displays the total amount paid towards discount on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-discount', 'date.range.customFuture', 15)]] Displays the the total amount of discount paid on an account within the next 15 days.
Custom (last X days) [[query('payments-discount', 'date.range.customPast', 15)]] Displays the the total amount of discount paid on an account within the last 15 days.
Last Month [[query('payments-discount', 'date.range.lastMonth')]] Displays the the total amount of discount paid on an account last month.
Last Week [[query('payments-discount', 'date.range.lastWeek')]] Displays the the total amount of discount paid on an account last week.
Last Year [[query('payments-discount', 'date.range.lastYear')]] Displays the the total amount of discount paid on an account last year.
Month To Date [[query('payments-discount', 'date.range.monthToDate')]] Displays the the total amount of discount paid on an account from the beginning of the month to the current date.
This Month [[query('payments-discount', 'date.range.thisMonth')]] Displays the the total amount of discount paid on an account within the current month.
This Week [[query('payments-discount', 'date.range.thisWeek')]] Displays the the total amount of discount paid on an account within the current week.
Today [[query('payments-discount', 'date.range.today')]] Displays the the total amount of discount paid on an account today.
Year To Date [[query('payments-discount', 'date.range.yearToDate')]] Displays the the total amount of discount paid on an account from the beginning of the year to the current date.
Yesterday [[query('payments-discount', 'date.range.yesterday')]] Displays the the total amount of discount paid on an account yesterday.

 

Payments - fees paid

Here's an example of the payments - fees paid variable:

[[query('payments-fees', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount paid towards fees on an account within a specific date range.

Name Variable Description
All [[query('payments-fees', 'date.range.all')]] Displays the total amount paid towards fees on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-fees', 'date.range.customDays',5,15)]] Displays the total amount paid towards fees on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-fees', 'date.range.customFuture', 15)]] Displays the total amount paid towards fees on an account within the next 15 days.
Custom (last X days) [[query('payments-fees', 'date.range.customPast', 15)]] Displays the total amount paid towards fees on an account within the last 15 days.
Last Month [[query('payments-fees', 'date.range.lastMonth')]] Displays the total amount paid towards fees on an account last month.
Last Week [[query('payments-fees', 'date.range.lastWeek')]] Displays the total amount paid towards fees on an account last week.
Last Year [[query('payments-fees', 'date.range.lastYear')]] Displays the total amount paid towards fees on an account last year.
Month To Date [[query('payments-fees', 'date.range.monthToDate')]] Displays the total amount paid towards fees on an account from the beginning of the month to the current date.
This Month [[query('payments-fees', 'date.range.thisMonth')]] Displays the total amount paid towards fees on an account within the current month.
This Week [[query('payments-fees', 'date.range.thisWeek')]] Displays the total amount paid towards fees on an account within the current week.
Today [[query('payments-fees', 'date.range.today')]] Displays the total amount paid towards fees on an account today.
Year To Date [[query('payments-fees', 'date.range.yearToDate')]] Displays the total amount paid towards fees on an account from the beginning of the year to the current date.
Yesterday [[query('payments-fees', 'date.range.yesterday')]] Displays the total amount paid towards fees on an account yesterday.

 

Payments - escrow paid

Here's an example for payments - escrow paid variable:

[[query('payments-escrow', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount paid towards escrow on an account within a specific date range.

Name Variable Description
All [[query('payments-escrow', 'date.range.all')]] Displays the total amount paid towards escrow on an account.
Custom (X Days Ago & Y Days Ago) [[query('payments-escrow', 'date.range.customDays',5,15)]] Displays the total amount paid towards escrow on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('payments-escrow', 'date.range.customFuture', 15)]] Displays the total amount paid towards escrow on an account within the next 15 days.
Custom (last X days) [[query('payments-escrow', 'date.range.customPast', 15)]] Displays the total amount paid towards escrow on an account within the last 15 days.
Last Month [[query('payments-escrow', 'date.range.lastMonth')]] Displays the total amount paid towards escrow on an account last month.
Last Week [[query('payments-escrow', 'date.range.lastWeek')]] Displays the total amount paid towards escrow on an account last week.
Last Year [[query('payments-escrow', 'date.range.lastYear')]] Displays the total amount paid towards escrow on an account last year.
Month To Date [[query('payments-escrow', 'date.range.monthToDate')]] Displays the total amount paid towards escrow on an account from the beginning of the month to the current date.
This Month Displays the total amount paid towards escrow on an account from the beginning of the month to the current date. Displays the total amount paid towards escrow on an account within the current month.
This Week [[query('payments-escrow', 'date.range.thisWeek')]] Displays the total amount paid towards escrow on an account within the current week.
Today [[query('payments-escrow', 'date.range.today')]] Displays the total amount paid towards escrow on an account today.
Year To Date [[query('payments-escrow', 'date.range.yearToDate')]] Displays the total amount paid towards escrow on an account from the beginning of the year to the current date.
Yesterday [[query('payments-escrow', 'date.range.yesterday')]] Displays the total amount paid towards escrow on an account yesterday.

 

Credits - total

Here's an example of the credits - total variable:

[[query('credits-total', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to an account within a specific date range.

Name Variable Description
All [[query('credits-total', 'date.range.all')]] Displays the total amount of credit applied to an account.
Custom (X Days Ago & Y Days Ago) [[query('credits-total', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-total', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to an account within the next 15 days.
Custom (last X days) [[query('credits-total', 'date.range.customPast', 15)]] Displays the total amount of credit applied to an account within the last 15 days.
Last Month [[query('credits-total', 'date.range.lastMonth')]] Displays the total amount of credit applied to an account last month.
Last Week [[query('credits-total', 'date.range.lastWeek')]] Displays the total amount of credit applied to an account last week.
Last Year [[query('credits-total', 'date.range.lastYear')]] Displays the total amount of credit applied to an account last year.
Month To Date [[query('credits-total', 'date.range.monthToDate')]] Displays the total amount of credit applied to an account from the beginning of the month to the current date.
This Month [[query('credits-total', 'date.range.thisMonth')]] Displays the total amount of credit applied to an account within the current month.
This Week [[query('credits-total', 'date.range.thisWeek')]] Displays the total amount of credit applied to an account within the current week.
Today [[query('credits-total', 'date.range.today')]] Displays the total amount of credit applied to an account today.
Year To Date [[query('credits-total', 'date.range.yearToDate')]] Displays the total amount of credit applied to an account from the beginning of the year to the current date.
Yesterday [[query('credits-total', 'date.range.yesterday')]] Displays the total amount of credit applied to an account yesterday.

 

Credits - interest

Here's an example of the credits - interest variable:

[[query('credits-interest', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to interest on an account within a specific date range.

Name Variable Description
All [[query('credits-interest', 'date.range.all')]] Displays the total amount of credit applied to interest on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('credits-interest', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to interest on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-interest', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to interest on an account within the next 15 days.
Custom (last X days) [[query('credits-interest', 'date.range.customPast', 15)]] Displays the total amount of credit applied to interest on an account within the last 15 days.
Last Month [[query('credits-interest', 'date.range.lastMonth')]] Displays the total amount of credit applied to interest on an account last month.
Last Week [[query('credits-interest', 'date.range.lastWeek')]] Displays the total amount of credit applied to interest on an account last week.
Last Year [[query('credits-interest', 'date.range.lastYear')]] Displays the total amount of credit applied to interest on an account last year.
Month To Date [[query('credits-interest', 'date.range.monthToDate')]] Displays the total amount of credit applied to interest on an account from the beginning of the month to the current date.
This Month [[query('credits-interest', 'date.range.thisMonth')]] Displays the total amount of credit applied to interest on an account within the current month.
This Week [[query('credits-interest', 'date.range.thisWeek')]] Displays the total amount of credit applied to interest on an account within the current week.
Today [[query('credits-interest', 'date.range.today')]] Displays the total amount of credit applied to interest on an account today.
Year To Date [[query('credits-interest', 'date.range.yearToDate')]] Displays the total amount of credit applied to interest on an account from the beginning of the year to the current date.
Yesterday [[query('credits-interest', 'date.range.yesterday')]] Displays the total amount of credit applied to interest on an account yesterday.

 

Credits - principal

Here's an example of the credits - principal variable:

[[query('credits-principal', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to principal on an account within a specific date range.

Name Variable Description
All [[query('credits-principal', 'date.range.all')]] Displays the total amount of credit applied to principal on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('credits-principal', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to principal on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-principal', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to principal on an account within the next 15 days.
Custom (last X days) [[query('credits-principal', 'date.range.customPast', 15)]] Displays the total amount of credit applied to principal on an account within the last 15 days.
Last Month [[query('credits-principal', 'date.range.lastMonth')]] Displays the total amount of credit applied to principal on an account last month.
Last Week [[query('credits-principal', 'date.range.lastWeek')]] Displays the total amount of credit applied to principal on an account last week.
Last Year [[query('credits-principal', 'date.range.lastYear')]] Displays the total amount of credit applied to principal on an account last year.
Month To Date [[query('credits-principal', 'date.range.monthToDate')]] Displays the total amount of credit applied to principal on an account from the beginning of the month to the current date.
This Month [[query('credits-principal', 'date.range.thisMonth')]] Displays the total amount of credit applied to principal on an account within the current month.
This Week [[query('credits-principal', 'date.range.thisWeek')]] Displays the total amount of credit applied to principal on an account within the current week.
Today [[query('credits-principal', 'date.range.today')]] Displays the total amount of credit applied to principal on an account today.
Year To Date [[query('credits-principal', 'date.range.yearToDate')]] Displays the total amount of credit applied to principal on an account from the beginning of the year to the current date.
Yesterday [[query('credits-principal', 'date.range.yesterday')]] Displays the total amount of credit applied to principal on an account yesterday.

 

Credits - discount

Here's an example of the credits - discount variable:

[[query('credits-discount', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to the discount on an account within a specific date range.

Name Variable Description
All [[query('credits-discount', 'date.range.all')]] Displays the total amount of credit applied to the discount on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('credits-discount', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to the discount on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-discount', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to the discount on an account within the next 15 days.
Custom (last X days) [[query('credits-discount', 'date.range.customPast', 15)]] Displays the total amount of credit applied to the discount on an account within the last 15 days.
Last Month [[query('credits-discount', 'date.range.lastMonth')]] Displays the total amount of credit applied to the discount on an account last month.
Last Week [[query('credits-discount', 'date.range.lastWeek')]] Displays the total amount of credit applied to the discount on an account last week.
Last Year [[query('credits-discount', 'date.range.lastYear')]] Displays the total amount of credit applied to the discount on an account last year.
Month To Date [[query('credits-discount', 'date.range.monthToDate')]] Displays the total amount of credit applied to the discount on an account from the beginning of the month to the current date.
This Month [[query('credits-discount', 'date.range.thisMonth')]] Displays the total amount of credit applied to the discount on an account within the current month.
This Week [[query('credits-discount', 'date.range.thisWeek')]] Displays the total amount of credit applied to the discount on an account within the current week.
Today [[query('credits-discount', 'date.range.today')]] Displays the total amount of credit applied to the discount on an account today.
Year To Date [[query('credits-discount', 'date.range.yearToDate')]] Displays the total amount of credit applied to the discount on an account from the beginning of the year to the current date.

 

Credits - fees

Here's an example of the credits - fees variable:

[[query('credits-fees', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to fees on an account within a specific date range.

Name Variable Description
All [[query('credits-fees', 'date.range.all')]] Displays the total amount of credit applied to fees on an account to date.
Cusom (X Days Ago & Y Days Ago) [[query('credits-fees', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to fees on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-fees', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to fees on an account within the next 15 days.
Custom (last X days) [[query('credits-fees', 'date.range.customPast', 15)]] Displays the total amount of credit applied to fees on an account within the last 15 days.
Last Month [[query('credits-fees', 'date.range.lastMonth')]] Displays the total amount of credit applied to fees on an account last month.
Last Week [[query('credits-fees', 'date.range.lastWeek')]] Displays the total amount of credit applied to fees on an account last week.
Last Year [[query('credits-fees', 'date.range.lastYear')]] Displays the total amount of credit applied to fees on an account last year.
Month To Date [[query('credits-fees', 'date.range.monthToDate')]] Displays the total amount of credit applied to fees on an account from the beginning of the month to the current date.
This Month [[query('credits-fees', 'date.range.thisMonth')]] Displays the total amount of credit applied to fees on an account within the current month.
This Week [[query('credits-fees', 'date.range.thisWeek')]] Displays the total amount of credit applied to fees on an account within the current week.
Today [[query('credits-fees', 'date.range.today')]] Displays the total amount of credit applied to fees on an account today.
Year To Date [[query('credits-fees', 'date.range.yearToDate')]] Displays the total amount of credit applied to fees on an account from the beginning of the year to the current date.
Yesterday [[query('credits-fees', 'date.range.yesterday')]] Displays the total amount of credit applied to fees on an account yesterday. 

 

Credits - escrow

Here's an example of the credits - escrow variable:

[[query('credits-escrow', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of credit applied to escrow on an account within a specific date range.

Name Variable Description
All [[query('credits-escrow', 'date.range.all')]] Displays the total amount of credit applied to escrow on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('credits-escrow', 'date.range.customDays',5,15)]] Displays the total amount of credit applied to escrow on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('credits-escrow', 'date.range.customFuture', 15)]] Displays the total amount of credit applied to escrow on an account within the next 15 days.
Custom (Last X days) [[query('credits-escrow', 'date.range.customPast', 15)]] Displays the total amount of credit applied to escrow on an account within the last 15 days.
Last Month [[query('credits-escrow', 'date.range.lastMonth')]] Displays the total amount of credit applied to escrow on an account last month.
Last Week [[query('credits-escrow', 'date.range.lastWeek')]] Displays the total amount of credit applied to escrow on an account last week.
Last Year [[query('credits-escrow', 'date.range.lastYear')]] Displays the total amount of credit applied to escrow on an account last year.
Month To Date [[query('credits-escrow', 'date.range.monthToDate')]] Displays the total amount of credit applied to escrow on an account from the beginning of the month to the current date.
This Month [[query('credits-escrow', 'date.range.thisMonth')]] Displays the total amount of credit applied to escrow on an account within the current month.
This Week [[query('credits-escrow', 'date.range.thisWeek')]] Displays the total amount of credit applied to escrow on an account within the current week.
Today [[query('credits-escrow', 'date.range.today')]] Displays the total amount of credit applied to escrow on an account today.
Year To Date [[query('credits-escrow', 'date.range.yearToDate')]] Displays the total amount of credit applied to escrow on an account from the beginning of the year to the current date.
Yesterday [[query('credits-escrow', 'date.range.yesterday')]] Displays the total amount of credit applied to escrow on an account yesterday.

 

Fees

Here's an example of the fees variable:

[[query('fees-total', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total value of fees applied to an account within a specific date range.

Name Variable Description
All [[query('fees-total', 'date.range.all')]] Displays the total value of fees applied to an account to date.
Custom (X Days Ago & Y Days Ago) [[query('fees-total', 'date.range.customDays',5,15)] Displays the total value of fees applied to an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('fees-total', 'date.range.customFuture', 15)]] Displays the total value of fees applied to an account within the next 15 days.
Custom (last X days) [[query('fees-total', 'date.range.customPast', 15)]] Displays the total value of fees applied to an account within the last 15 days.
Last Month [[query('fees-total', 'date.range.lastMonth')]] Displays the total value of fees applied to an account last month.
Last Week [[query('fees-total', 'date.range.lastWeek')]] Displays the total value of fees applied to an account last week.
All [[query('fees-total', 'date.range.all')]] Displays the total value of fees applied to an account to date.
Custom (X Days Ago & Y Days Ago) [[query('fees-total', 'date.range.customDays',5,15)]] Displays the total value of fees applied to an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('fees-total', 'date.range.customFuture', 15)]] Displays the total value of fees applied to an account within the next 15 days.
Custom (last X days) [[query('fees-total', 'date.range.customPast', 15)]] Displays the total value of fees applied to an account within the last 15 days.
Last Month [[query('fees-total', 'date.range.lastMonth')]] Displays the total value of fees applied to an account last month.
Last Week [[query('fees-total', 'date.range.lastWeek')]] Displays the total value of fees applied to an account last week.
Last Year [[query('fees-total', 'date.range.lastYear')]] Displays the total value of fees applied to an account last year.
Month To Date [[query('fees-total', 'date.range.monthToDate')]] Displays the total value of fees applied to an account from the beginning of the month to the current date.
This Month [[query('fees-total', 'date.range.thisMonth')]] Displays the total value of fees applied to an account within the current month.
This Week [[query('fees-total', 'date.range.thisWeek')]] Displays the total value of fees applied to an account within the current week.
Today [[query('fees-total', 'date.range.today')]] Displays the total value of fees applied to an account today.
Year To Date [[query('fees-total', 'date.range.yearToDate')]] Displays the total value of fees applied to an account from the beginning of the year to the current date.
Yesterday [[query('fees-total', 'date.range.yesterday')]] Displays the total value of fees applied to an account yesterday.

 

 

Advancements

Here's an example of the advancements variable:

[[query('advancements-total', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total value of advancements applied to an account within a specific date range.

Name Variable Description
All [[query('advancements-total', 'date.range.all')]] Displays the total value of advancements applied to an account to date.
Custom (X Days Ago & Y Days Ago) [[query('advancements-total', 'date.range.customDays',5,15)]] Displays the total value of advancements applied to an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('advancements-total', 'date.range.customFuture', 15)]] Displays the total value of advancements applied to an account within the next 15 days.
Custom (last X days) [[query('advancements-total', 'date.range.customPast', 15)]] Displays the total value of advancements applied to an account within the last 15 days.
Last Month [[query('advancements-total', 'date.range.lastMonth')]] Displays the total value of advancements applied to an account last month.
Last Week [[query('advancements-total', 'date.range.lastWeek')]] Displays the total value of advancements applied to an account last week.
Last Year [[query('advancements-total', 'date.range.lastYear')]] Displays the total value of advancements applied to an account last year.
Month To Date [[query('advancements-total', 'date.range.monthToDate')]] Displays the total value of advancements applied to an account from the beginning of the month to the current date.
This Month [[query('advancements-total', 'date.range.thisMonth')]] Displays the total value of advancements applied to an account within the current month.
This Week [[query('advancements-total', 'date.range.thisWeek')]] Displays the total value of advancements applied to an account within the current week.
Today [[query('advancements-total', 'date.range.today')]] Displays the total value of advancements applied to an account today.
Year To Date [[query('advancements-total', 'date.range.yearToDate')]] Displays the total value of advancements applied to an account from the beginning of the year to the current date.
Yesterday [[query('advancements-total', 'date.range.yesterday')]] Displays the total value of advancements applied to an account yesterday.

 

Scheduled payments total

Here's an example of the scheduled payments variable:

[[query('scheduled-payments-total', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total value of scheduled payments coming due on an account within a specific date range.

Name Variable Description
All [[query('scheduled-payments-total', 'date.range.all')]] Displays the total value of scheduled payments coming due on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('scheduled-payments-total', 'date.range.customDays',5,15)]] Displays the total value of scheduled payments coming due on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('scheduled-payments-total', 'date.range.customFuture', 15)]] Displays the total value of scheduled payments coming due on an account within the next 15 days.
Custom (last X days) [[query('scheduled-payments-total', 'date.range.customPast', 15)]] Displays the total value of scheduled payments coming due on an account within the last 15 days.
Last Month [[query('scheduled-payments-total', 'date.range.lastMonth')]] Displays the total value of scheduled payments coming due on an account last month.
Last Week [[query('scheduled-payments-total', 'date.range.lastWeek')]] Displays the total value of scheduled payments coming due on an account last week.
Last Year [[query('scheduled-payments-total', 'date.range.lastYear')]] Displays the total value of scheduled payments coming due on an account last year.
Month To Date [[query('scheduled-payments-total', 'date.range.monthToDate')]] Displays the total value of scheduled payments coming due on an account from the beginning of the month to the current date.
This Month [[query('scheduled-payments-total', 'date.range.thisMonth')]] Displays the total value of scheduled payments coming due on an account within the current month.
This Week [[query('scheduled-payments-total', 'date.range.thisWeek')]] Displays the total value of scheduled payments coming due on an account within the current week.
Today [[query('scheduled-payments-total', 'date.range.today')]] Displays the total value of scheduled payments coming due on an account today.
Year To Date [[query('scheduled-payments-total', 'date.range.yearToDate')]] Displays the total value of scheduled payments coming due on an account from the beginning of the year to the current date.
Yesterday [[query('scheduled-payments-total', 'date.range.yesterday')]] Displays the total value of scheduled payments coming due on an account yesterday.

 

 

Scheduled payments - interest

Here's an example of the scheduled payments - interest:

[[query('scheduled-payments-interest', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of scheduled interest coming due on an account within a specific date range.

Name Variable Description
All [[query('scheduled-payments-interest', 'date.range.all')]] Displays the total amount of scheduled interest coming due on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('scheduled-payments-interest', 'date.range.customDays',5,15)]] Displays the total amount of scheduled interest coming due on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('scheduled-payments-interest', 'date.range.customFuture', 15)]] Displays the total amount of scheduled interest coming due on an account within the next 15 days.
Custom (last X days) [[query('scheduled-payments-interest', 'date.range.customPast', 15)]] Displays the total amount of scheduled interest coming due on an account within the last 15 days.
Last month [[query('scheduled-payments-interest', 'date.range.lastMonth')]] Displays the total amount of scheduled interest coming due on an account last month.
Last Week [[query('scheduled-payments-interest', 'date.range.lastWeek')]] Displays the total amount of scheduled interest coming due on an account last week.
Last year [[query('scheduled-payments-interest', 'date.range.lastYear')]] Displays the total amount of scheduled interest coming due on an account last year.
Month To Date [[query('scheduled-payments-interest', 'date.range.monthToDate')]] Displays the total amount of scheduled interest coming due on an account from the beginning of the month to the current date.
This Month [[query('scheduled-payments-interest', 'date.range.thisMonth')]] Displays the total amount of scheduled interest coming due on an account within the current month.
This Week [[query('scheduled-payments-interest', 'date.range.thisWeek')]] Displays the total amount of scheduled interest coming due on an account within the current week.
Today [[query('scheduled-payments-interest', 'date.range.today')]] Displays the total amount of scheduled interest coming due on an account today.
Year To Date  [[query('scheduled-payments-interest', 'date.range.yearToDate')]] Displays the total amount of scheduled interest coming due on an account from the beginning of the year to the current date.
Yesterday [[query('scheduled-payments-interest', 'date.range.yesterday')]] Displays the total amount of scheduled interest coming due on an account yesterday.

 

Scheduled payments - principal

Here's an example of the scheduled payments - principal variable:

[[query('scheduled-payments-principal', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of principal scheduled to come due on an account within a specific date range.

Name Variable Description
All [[query('scheduled-payments-principal', 'date.range.all')]] Displays the total amount of principal scheduled to come due on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('scheduled-payments-principal', 'date.range.customDays',5,15)]] Displays the total amount of principal scheduled to come due on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('scheduled-payments-principal', 'date.range.customFuture', 15)]] Displays the total amount of principal scheduled to come due on an account within the next 15 days.
Custom (last X days) [[query('scheduled-payments-principal', 'date.range.customPast', 15)]] Displays the total amount of principal scheduled to come due on an account within the last 15 days.
Last Month  [[query('scheduled-payments-principal', 'date.range.lastMonth')]] Displays the total amount of principal scheduled to come due on an account last month.
Last Week [[query('scheduled-payments-principal', 'date.range.lastWeek')]] Displays the total amount of principal scheduled to come due on an account last week.
Last year [[query('scheduled-payments-principal', 'date.range.lastYear')]] Displays the total amount of principal scheduled to come due on an account last year.
Month To Date [[query('scheduled-payments-principal', 'date.range.monthToDate')]] Displays the total amount of principal scheduled to come due on an account from the beginning of the month to the current date.
This Month [[query('scheduled-payments-principal', 'date.range.thisMonth')]] Displays the total amount of principal scheduled to come due on an account within the current month.
This Week [[query('scheduled-payments-principal', 'date.range.thisWeek')]] Displays the total amount of principal scheduled to come due on an account within the current week.
Today [[query('scheduled-payments-principal', 'date.range.today')]] Displays the total amount of principal scheduled to come due on an account today.
Year To Date [[query('scheduled-payments-principal', 'date.range.yearToDate')]] Displays the total amount of principal scheduled to come due on an account from the beginning of the year to the current date.
Yesterday [[query('scheduled-payments-principal', 'date.range.yesterday')]] Displays the total amount of principal scheduled to come due on an account yesterday.

 

Scheduled payments - discount

Here's an example of the scheduled payments - discount:

[[query('scheduled-payments-discount', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of discount scheduled to be paid on an account within a specific date range.

Name Variable Description
All [[query('scheduled-payments-discount', 'date.range.all')]] Displays the total amount of discount scheduled to be paid on an account to date.
Custom (X Days Ago & Y Days Ago) [[query('scheduled-payments-discount', 'date.range.customDays',5,15)]] Displays the total amount of discount scheduled to be paid on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('scheduled-payments-discount', 'date.range.customFuture', 15)]] Displays the total amount of discount scheduled to be paid on an account within the next 15 days.
Custom (last X days) [[query('scheduled-payments-discount', 'date.range.customPast', 15)]] Displays the total amount of discount scheduled to be paid on an account within the last 15 days.
Last month [[query('scheduled-payments-discount', 'date.range.lastMonth')]] Displays the total amount of discount scheduled to be paid on an account last month.
Last Week [[query('scheduled-payments-discount', 'date.range.lastWeek')]] Displays the total amount of discount scheduled to be paid on an account last week.
Last year [[query('scheduled-payments-discount', 'date.range.lastYear')]] Displays the total amount of discount scheduled to be paid on an account last year.
Month To Date [[query('scheduled-payments-discount', 'date.range.monthToDate')]] Displays the total amount of discount scheduled to be paid on an account from the beginning of the month to the current date.
This Month [[query('scheduled-payments-discount', 'date.range.thisMonth')]] Displays the total amount of discount scheduled to be paid on an account within the current month.
This Week [[query('scheduled-payments-discount', 'date.range.thisWeek')]] Displays the total amount of discount scheduled to be paid on an account within the current week.
Today [[query('scheduled-payments-discount', 'date.range.today')]] Displays the total amount of discount scheduled to be paid on an account today.
Year To Date [[query('scheduled-payments-discount', 'date.range.yearToDate')]] Displays the total amount of discount scheduled to be paid on an account from the beginning of the year to the current date.
Yesterday [[query('scheduled-payments-discount', 'date.range.yesterday')]] Displays the total amount of discount scheduled to be paid on an account yesterday.

 

Scheduled payments - escrow

Here's an example of the scheduled payments - escrow variable:

[[query('scheduled-payments-escrow', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of escrow scheduled to come due on an account within a specific date range.

Name Variable Description
All [[query('scheduled-payments-escrow', 'date.range.all')]] Displays the total amount of escrow scheduled to come due on an account to date.
Custom (X Days & Y Days Ago) [[query('scheduled-payments-escrow', 'date.range.customDays',5,15)]] Displays the total amount of escrow scheduled to come due on an account within the range of 5 to 15 days ago.
Custom (next X days) [[query('scheduled-payments-escrow', 'date.range.customFuture', 15)]] Displays the total amount of escrow scheduled to come due on an account within the next 15 days.
Custom (last X days) [[query('scheduled-payments-escrow', 'date.range.customPast', 15)]] Displays the total amount of escrow scheduled to come due on an account within the last 15 days.
Last Month [[query('scheduled-payments-escrow', 'date.range.lastMonth')]] Displays the total amount of escrow scheduled to come due on an account last month.
Last Week [[query('scheduled-payments-escrow', 'date.range.lastWeek')]] Displays the total amount of escrow scheduled to come due on an account last week.
Last Year [[query('scheduled-payments-escrow', 'date.range.lastYear')]] Displays the total amount of escrow scheduled to come due on an account last year.
Month To Date [[query('scheduled-payments-escrow', 'date.range.monthToDate')]] Displays the total amount of escrow scheduled to come due on an account from the beginning of the month to the current date.
This Month [[query('scheduled-payments-escrow', 'date.range.thisMonth')]] Displays the total amount of escrow scheduled to come due on an account within the current month.
This Week [[query('scheduled-payments-escrow', 'date.range.thisWeek')]] Displays the total amount of escrow scheduled to come due on an account within the current week.
Today [[query('scheduled-payments-escrow', 'date.range.today')] Displays the total amount of escrow scheduled to come due on an account today.
Year To Date [[query('scheduled-payments-escrow', 'date.range.yearToDate')]] Displays the total amount of escrow scheduled to come due on an account from the beginning of the year to the current date.
Yesterday [[query('scheduled-payments-escrow', 'date.range.yesterday')]] Displays the total amount of escrow scheduled to come due on an account yesterday.

 

Forecast payments - total

Here's an example of the forecast payments - total variable:

[[query('forecast-payments-total', 'date.range.selection')]]

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total value of forecasted payments coming due on an account within a specific date range.

Name Variable Description
Custom (next X days) [[query('forecast-payments-total', 'date.range.customFuture', 15)]] Displays the total value of forecasted payments coming due on an account within the next 15 days.
This Month [[query('forecast-payments-total', 'date.range.thisMonth')]] Displays the total value of forecasted payments coming due on an account within the current month.
This Week [[query('forecast-payments-total', 'date.range.thisWeek')]] Displays the total value of forecasted payments coming due on an account within the current week.

 

Forecast payments - interest

Here's an example of the forecast payments - interest variable:

[[query('forecast-payments-interest', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of forecasted interest coming due on an account within a specific date range.

Name Variable Description
Custom (next X days) [[query('forecast-payments-interest', 'date.range.customFuture', 15)]] Displays the total amount of forecasted interest coming due on an account within the next 15 days.
This Month [[query('forecast-payments-interest', 'date.range.thisMonth')]] Displays the total amount of forecasted interest coming due on an account within the current month.
This Week [[query('forecast-payments-interest', 'date.range.thisWeek')]] Displays the total amount of forecasted interest coming due on an account within the current week.

 

Forecast payments - principal

Here's an example of the forecast payments - principal variable:

[[query('forecast-payments-principal', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of principal forecasted to come due on an account within a specific date range.

Name Variable Description
Custom (next X days) [[query('forecast-payments-principal', 'date.range.customFuture', 15)]] Displays the total amount of principal forecasted to come due on an account within the next 15 days.
This Month  [[query('forecast-payments-principal', 'date.range.thisMonth')]] Displays the total amount of principal forecasted to come due on an account within the current month.
This Week [[query('forecast-payments-principal', 'date.range.thisWeek')]] Displays the total amount of principal forecasted to come due on an account within the current week.

 

Forecast payments - discount 

Here's an example of the forecast payments - discount variable:

[[query('forecast-payments-discount', 'date.range.selection')]] 

Replace “selection” with a date range setting. Once the change has been made, this variable will display the total amount of discount forecasted to be paid on an account within a specific date range.

Name Variable Description
Custom (next X days) [[query('forecast-payments-discount', 'date.range.customFuture', 15)]] Displays the total amount of discount forecasted to be paid on an account within the next 15 days.
This Month [[query('forecast-payments-discount', 'date.range.thisMonth')]] Displays the total amount of discount forecasted to be paid on an account within the current month.
This Week [[query('forecast-payments-discount', 'date.range.thisWeek')]] Displays the total amount of discount forecasted to be paid on an account within the current week.