Balances Last 31 Days

The AccountBalanceMonthTimeSeries table contains monthly records of account balance information for each account in the Account package. The table includes the account number, month, balance, and opening and closing times for the account. This information will be used to track changes in account balances over time for auditing and reporting purposes.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required
Body Params
int32

AccountId is an integer primary key in the AccountBalanceMonthTimeSeries table that uniquely identifies each account record in the series. It is used to link records related to the same account across all months.

double | null

The ClosingMinus31 field stores the closing account balance value for a particular account 31 days prior to the most current available record in the AccountBalanceMonthTimeSeries table. The values are stored as a decimal to allow for accuracy to the hundredths place.

string
required
length between 1 and 128

The AccountTypeId field in the AccountBalanceMonthTimeSeries table is an nvarchar field with a maximum length of 128 which holds the unique identifier for the account type associated with the account being tracked.

double | null

ChangeMinus31 in the AccountBalanceMonthTimeSeries table is a decimal field that stores the sum of the change in account balances over a 31-month window relative to the current month, allowing for the analysis of long-term trends.

string
required
length ≥ 1

The Reference field in the AccountBalanceMonthTimeSeries table is of data type nvarchar and used to store a unique reference identifier for a specific AccountBalanceMonthTimeSeries record. This reference number can be used to quickly lookup any record in the AccountBalanceMonthTimeSeries table.

double | null

The ClosingMinus30 field in the AccountBalanceMonthTimeSeries table is a decimal field that stores the account balance 30 days prior to the account closing date.

string
required
length ≥ 1

AccountIdentifier is a varchar data field in the AccountBalanceMonthTimeSeries table that uniquely identifies each account in the table. It is typically a unique code that is permanently associated with a single account.

double | null

The field ChangeMinus30 in the AccountBalanceMonthTimeSeries table stores the account balance amount at the end of the same month minus the account balance amount at the end of the previous month, in decimal form.

int32

OwnerId is an integer field that identifies the account holder associated with the account balance data stored in the AccountBalanceMonthTimeSeries table.

double | null

ClosingMinus29 is a decimal field in the AccountBalanceMonthTimeSeries table that contains the closing balance of an account at 29 days before the end date of the month.

string
required
length between 1 and 128

CurrencyId is an nvarchar field in the AccountBalanceMonthTimeSeries table that stores the ISO currency code (e.g. USD, EUR) for each of the entries in the table with a maximum length of 128 characters.

double | null

The ChangeMinus29 field in the AccountBalanceMonthTimeSeries table stores the percent change of the account balance from 29 months ago. The data type is decimal, expressed as a percentage.

string | null

The AccountStateId field of data type nvarchar in the table AccountBalanceMonthTimeSeries stores the status of an account at the time the data was entered. It can have one of three values: 'ACTIVE', 'INACTIVE', or 'CLOSED'.

double | null

The ClosingMinus28 field in the AccountBalanceMonthTimeSeries table is a decimal-type data field that stores the account balance measured at 28 days prior to the end of the month. This data can be used to show the rate of change in the account balance over time.

int32

InstitiuteId is an integer field that is used to link with the institiute table which contains all the institutes whose account balances are present in the AccountBalanceMonthTimeSeries table. It is used to uniquely identify each institute in the AccountBalanceMonthTimeSeries table.

double | null

The ChangeMinus28 field in the AccountBalanceMonthTimeSeries represents the change in the account balance compared to 28 months prior. It is a decimal data type in order to allow for more accurate precision in representing the change.

double | null

ClosingMinus27 is a decimal data field in the AccountBalanceMonthTimeSeries table. It holds the closing balance of the account 27 months ago from the current time entry. This can be used for time-series analysis or other accounting purposes.

string
required
length ≥ 1

OwnerName is a nvarchar data type field in the AccountBalanceMonthTimeSeries table that holds the name of the account owner associated with the balance, payment history, and other metrics associated with their account.

double | null

The AccountBalanceMonthTimeSeries table contains the change minus 27 field, of decimal data type, which records the difference between the total balance at the start of a given month (27 days prior) and the end of that month. This allows reporting and analysis on long-term account changes over time.

string | null

The OwnerLogoImage field in the AccountBalanceMonthTimeSeries table stores the file name of an image of the account owner's logo, stored as an nvarchar data type.

double | null

ClosingMinus26 is a decimal field in the AccountBalanceMonthTimeSeries table. It represents the account balance at the end of the 26th month prior to the most recent month.

string
required
length ≥ 1

InstituteName is an nvarchar field in the AccountBalanceMonthTimeSeries table that stores the name of the institute related to the account whose balance data is included in the table.

double | null

The ChangeMinus26 field in the AccountBalanceMonthTimeSeries table stores the difference in account balance for a particular month in the series relative to the account balance from the same month in the previous year. Values in this field are stored as decimals.

string | null

The LogoImage field in the AccountBalanceMonthTimeSeries table is a nvarchar data type that contains the URL of the account's logo image. This allows easy reference to the logo when needed.

double | null

ClosingMinus25 is a decimal field in the AccountBalanceMonthTimeSeries table that represents the account balance 25 months prior to the month of the closing balance.

string | null

CountryId is a nvarchar field with a length of 128 characters in the AccountBalanceMonthTimeSeries table, used to track the country code of a given account balance record in the table.

double | null

The field ChangeMinus25 of the table AccountBalanceMonthTimeSeries is used to store the difference in the account balance from the previous 25 months, calculated as the current month's balance minus the 25th month before the current month's balance. The data type for this field is decimal.

string | null

The CountryFlagImage field in the AccountBalanceMonthTimeSeries table is a nvarchar data type that stores the name of an image file that is associated with a particular country. This image is typically a flag file, used to display the national flag of a specific country.

double | null

The ClosingMinus24 field in the AccountBalanceMonthTimeSeries table stores the account balance for 24 months previously. The data type for this field is decimal.

double | null

ChangeMinus24 field in AccountBalanceMonthTimeSeries table stores the amount of change compared to the balance of the previous day, expressed in dollars.

double | null

ClosingMinus23 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the end-of-month balance for the account for 23 months prior to the month under evaluation.

double | null

The ChangeMinus23 field in the AccountBalanceMonthTimeSeries table is a type of decimal data which stores the amount of change between the 23rd month prior to the current month and the current month with respect to the Account Balance. This field is used to provide a historical measure of how the Account Balance has changed over time.

double | null

ClosingMinus22 is a decimal field in the AccountBalanceMonthTimeSeries table that contains the account balance at the end of the month from the prior period, minus the amount from 22 months before.

double | null

ChangeMinus22 is a field in the AccountBalanceMonthTimeSeries table which is of data type Decimal. This field is used to store changes in account balance over a period of 22 months. A positive value in this field denotes an increase in account balance and a negative value denotes a decrease in account balance.

double | null

ClosingMinus21 is a decimal field in the AccountBalanceMonthTimeSeries table that holds the account balance for 21 months prior to the closing of the account. It is used to measure the long-term performance of an account and/or the changes to its balance over a given period of time.

double | null

ChangeMinus21 is a decimal field that is part of the AccountBalanceMonthTimeSeries table. It stores the change in the account balance for the account for the last 21 months. It is calculated by subtracting the current balance from the balance 21 months ago and can be positive or negative.

double | null

ClosingMinus20: This field in the AccountBalanceMonthTimeSeries table records the closing balance of the account minus 20 points. It is represented as a decimal value.

double | null

The ChangeMinus20 field in the AccountBalanceMonthTimeSeries table stores the account balance for the current month, minus the value for the 20 months prior. It is a decimal data type to store the difference in two or more floating values accurately.

double | null

ClosingMinus19 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 19 months before the current month.

double | null

The field ChangeMinus19 in table AccountBalanceMonthTimeSeries stores the 19-month change in the value of an account, as a decimal. It can be used to easily spot trends or changes in the account balance over time.

double | null

ClosingMinus18 is a field of data type decimal found in the AccountBalanceMonthTimeSeries table that stores the account balance 18 months prior to the closing month.

double | null

ChangeMinus18 in the AccountBalanceMonthTimeSeries table is a decimal field that stores the change in the account balance from 18 months ago.

double | null

The ClosingMinus17 field in the AccountBalanceMonthTimeSeries table stores the monthly closing balance of any account subtracting 17 days of transactions in a decimal format.

double | null

The ChangeMinus17 field in the AccountBalanceMonthTimeSeries table stores the difference between the last 17 months of the account balance and the previous 17 months. It is represented as a decimal, with a positive number representing an increase in balance, and a negative number representing a decrease.

double | null

ClosingMinus16 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 16 months prior to the current month.

double | null

ChangeMinus16 is a decimal field in the AccountBalanceMonthTimeSeries table that indicates the change or delta in the balance from 16 months in the past, compared to the current month balance.

double | null

ClosingMinus15 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the balance at the close of the month 15 months in the past.

double | null

The field ChangeMinus15 represents the decrease in the AccountBalanceMonthTimeSeries table from the previous 15 months, represented as a decimal.

double | null

The ClosingMinus14 field in the AccountBalanceMonthTimeSeries table contains the closing account balance from 14 months prior to the current month total, recorded in a numeric decimal format.

double | null

ChangeMinus14 field in the AccountBalanceMonthTimeSeries table stores the difference between the balance of the account at the current month and the balance 14 months prior, expressed in decimal form.

double | null

ClosingMinus13 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the month-on-month closing balance of the account thirteen months prior.

double | null

The 'ChangeMinus13' field in the 'AccountBalanceMonthTimeSeries' table is a decimal that stores the change in account balance compared to 13 months prior.

double | null

ClosingMinus12 is a decimal field in AccountBalanceMonthTimeSeries that stores the account balance from 12 months ago.

double | null

The ChangeMinus12 field in the AccountBalanceMonthTimeSeries table contains the change in account balance between the beginning of the current month and the corresponding period from 12 months ago expressed as a decimal value.

double | null

ClosingMinus11: This field stores the account balance of an account at the end of day 11 prior to the account's closing day. The data type will be decimal in the AccountBalanceMonthTimeSeries table.

double | null

ChangeMinus11 in the AccountBalanceMonthTimeSeries table is a decimal field that stores the change in the account balance for the period 11 months prior to the current period.

double | null

ClosingMinus10 is a decimal field located in the AccountBalanceMonthTimeSeries table. It stores the closing balance data 10 months prior to the start date of the current accounting period.

double | null

ChangeMinus10 is a decimal data type field in the AccountBalanceMonthTimeSeries table that stores the amount of change in the account balance from one month to the next, minus 10%. This field is used to compare past and current account balance levels.

double | null

ClosingMinus09 is a decimal data type field in the AccountBalanceMonthTimeSeries table that stores the total account balance at the end of the 9th month before the closing of the account.

double | null

ChangeMinus09 is a decimal field in the table AccountBalanceMonthTimeSeries that records the total change in the account balance from the previous month, with the previous two months factored into the calculation. This data can be used to calculate the average monthly change in account balance.

double | null

The ClosingMinus08 field in the AccountBalanceMonthTimeSeries table provides the account balance at the end of the month minus 8 months. It is a decimal value between 0 and the current account balance.

double | null

ChangeMinus08 is a decimal field in the AccountBalanceMonthTimeSeries table which tracks the difference in the account balance month-to-month compared to the month prior to it, i.e. the change in the account balance from -08 months to -09 months.

double | null

ClosingMinus07 is a decimal field in the AccountBalanceMonthTimeSeries table representing the account balance at the close of the time period 7 months prior.

double | null

The field ChangeMinus07 in the table AccountBalanceMonthTimeSeries stores the difference between the account balance for the current period and the account balance for the period seven months before. The data type is decimal.

double | null

ClosingMinus06 is a decimal field in the AccountBalanceMonthTimeSeries table. It records the account balance for the 6th month prior to the closing period, allowing for the comparison of current and past account performance.

double | null

The ChangeMinus06 field in the AccountBalanceMonthTimeSeries table is a decimal data type field storing the account balance from the corresponding time series month minus 6.

double | null

ClosingMinus05 is a field in the AccountBalanceMonthTimeSeries table that stores the closing balance for an account five months ago. It is stored as a decimal data type.

double | null

The field ChangeMinus05 in the AccountBalanceMonthTimeSeries table is a decimal data type field used to record the total amount that the account balance decreased from the same time in the month prior, to the same time in the current month.

double | null

ClosingMinus04 is a decimal field in a table called AccountBalanceMonthTimeSeries that holds the closing balance of the account four days prior to the last day of the month.

double | null

ChangeMinus04 is a field in the table AccountBalanceMonthTimeSeries whose data type is decimal. This field stores the balance change in a given month compared to the previous month, expressed as a negative percent. For example, a value of -0.04 would represent a 4% decrease in the balance compared to the previous month.

double | null

ClosingMinus03 is a decimal field in the AccountBalanceMonthTimeSeries table, which stores the account balance at the end of the month, three months prior to the current month.

double | null

The field ChangeMinus03 in the AccountBalanceMonthTimeSeries table stores the updated current balance of an account from the same account from 3 months ago, in decimal form.

double | null

ClosingMinus02 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the account balance two months prior to the closing balance.

double | null

The field ChangeMinus02 of data type decimal in the table AccountBalanceMonthTimeSeries is used to store the difference in account balance between the current month and the previous month, where a negative number indicates a decrease in the account balance.

double | null

ClosingMinus01 of data type decimal in AccountBalanceMonthTimeSeries is a field that holds ending balance data for one month prior as a decimal value. It is intended to represent the monthly balance of an account over an extended period of time, and can be used to analyze financial trends over time.

double | null

ChangeMinus01 field in AccountBalanceMonthTimeSeries table is a decimal type data field that stores the account balance changes for each month. This value reflects the difference between the current month account balance and the previous month balance. The stored value is computed by subtracting the previous month balance with the current month balance. This field is used to track and monitor monthly account balance changes at a granular level.

double | null

ClosingMinus00 is a decimal field in a table called AccountBalanceMonthTimeSeries which stores the ending balance for a specific account for the given month and year. This ending balance is calculated as the account balance minus any transactions that have occurred up to midnight on the last day of the month.

double | null

ChangeMinus00 is a decimal field in the AccountBalanceMonthTimeSeries table used to store the difference between the current and previous month's account balance.

Headers
string
enum
Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response
200

OK

Language
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here!