FinanceKey · Schema
FinanceKey.Entity.AccountPkg.v_AccountBalanceMonthTimeSeries
FinanceTreasuryAIPaymentsCash Management
Properties
| Name | Type | Description |
|---|---|---|
| createdById | integernull | The identity of the account that created the initial record. |
| createdOn | string | The date and time the record was initially created. |
| updatedById | integernull | The identity of the account that last modified the record. |
| updateOn | string | The date and time the record was last modified. |
| closedById | integernull | The identity of the account that deactivated and closed the record. |
| closedOn | string | The date and time the record is to be considered as inactive and closed. |
| active | boolean | A flag that shows if the record is currently active. This values is calculated based on the current date and the record closed date. |
| rowVersion | stringnull | A unique version stamp of the record. |
| sessionId | stringnull | The identity of the session that last modified the record. |
| accountId | integer | 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 |
| closingMinus31 | numbernull | 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 |
| accountTypeId | string | 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 |
| changeMinus31 | numbernull | 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 |
| reference | string | 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 refere |
| closingMinus30 | numbernull | The ClosingMinus30 field in the AccountBalanceMonthTimeSeries table is a decimal field that stores the account balance 30 days prior to the account closing date. |
| accountIdentifier | string | 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 wi |
| changeMinus30 | numbernull | 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 |
| ownerId | integer | OwnerId is an integer field that identifies the account holder associated with the account balance data stored in the AccountBalanceMonthTimeSeries table. |
| closingMinus29 | numbernull | 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. |
| currencyId | string | 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 character |
| changeMinus29 | numbernull | 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. |
| accountStateId | stringnull | 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', ' |
| closingMinus28 | numbernull | 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 use |
| institiuteId | integer | 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 u |
| changeMinus28 | numbernull | 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 pre |
| closingMinus27 | numbernull | 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-seri |
| ownerName | string | 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 w |
| changeMinus27 | numbernull | 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) a |
| ownerLogoImage | stringnull | 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. |
| closingMinus26 | numbernull | 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. |
| institiuteName | string | 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. |
| changeMinus26 | numbernull | 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 |
| logoImage | stringnull | 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. |
| closingMinus25 | numbernull | ClosingMinus25 is a decimal field in the AccountBalanceMonthTimeSeries table that represents the account balance 25 months prior to the month of the closing balance. |
| countryId | stringnull | 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. |
| changeMinus25 | numbernull | 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 t |
| countryFlagImage | stringnull | 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 typicall |
| closingMinus24 | numbernull | The ClosingMinus24 field in the AccountBalanceMonthTimeSeries table stores the account balance for 24 months previously. The data type for this field is decimal. |
| changeMinus24 | numbernull | ChangeMinus24 field in AccountBalanceMonthTimeSeries table stores the amount of change compared to the balance of the previous day, expressed in dollars. |
| closingMinus23 | numbernull | 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. |
| changeMinus23 | numbernull | 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 w |
| closingMinus22 | numbernull | 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. |
| changeMinus22 | numbernull | 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 i |
| closingMinus21 | numbernull | 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 perfo |
| changeMinus21 | numbernull | 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 subtra |
| closingMinus20 | numbernull | ClosingMinus20: This field in the AccountBalanceMonthTimeSeries table records the closing balance of the account minus 20 points. It is represented as a decimal value. |
| changeMinus20 | numbernull | 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 dif |
| closingMinus19 | numbernull | ClosingMinus19 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 19 months before the current month. |
| changeMinus19 | numbernull | 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 balan |
| closingMinus18 | numbernull | 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. |
| changeMinus18 | numbernull | ChangeMinus18 in the AccountBalanceMonthTimeSeries table is a decimal field that stores the change in the account balance from 18 months ago. |
| closingMinus17 | numbernull | The ClosingMinus17 field in the AccountBalanceMonthTimeSeries table stores the monthly closing balance of any account subtracting 17 days of transactions in a decimal format. |
| changeMinus17 | numbernull | 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, w |
| closingMinus16 | numbernull | ClosingMinus16 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 16 months prior to the current month. |
| changeMinus16 | numbernull | 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. |
| closingMinus15 | numbernull | ClosingMinus15 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the balance at the close of the month 15 months in the past. |
| changeMinus15 | numbernull | The field ChangeMinus15 represents the decrease in the AccountBalanceMonthTimeSeries table from the previous 15 months, represented as a decimal. |
| closingMinus14 | numbernull | 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. |
| changeMinus14 | numbernull | 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. |
| closingMinus13 | numbernull | ClosingMinus13 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the month-on-month closing balance of the account thirteen months prior. |
| changeMinus13 | numbernull | The 'ChangeMinus13' field in the 'AccountBalanceMonthTimeSeries' table is a decimal that stores the change in account balance compared to 13 months prior. |
| closingMinus12 | numbernull | ClosingMinus12 is a decimal field in AccountBalanceMonthTimeSeries that stores the account balance from 12 months ago. |
| changeMinus12 | numbernull | 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 exp |
| closingMinus11 | numbernull | 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. |
| changeMinus11 | numbernull | 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. |
| closingMinus10 | numbernull | 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. |
| changeMinus10 | numbernull | 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 |
| closingMinus09 | numbernull | 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. |
| changeMinus09 | numbernull | 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 |
| closingMinus08 | numbernull | 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 |
| changeMinus08 | numbernull | 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 |
| closingMinus07 | numbernull | ClosingMinus07 is a decimal field in the AccountBalanceMonthTimeSeries table representing the account balance at the close of the time period 7 months prior. |
| changeMinus07 | numbernull | 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. |
| closingMinus06 | numbernull | 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 p |
| changeMinus06 | numbernull | 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. |
| closingMinus05 | numbernull | 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. |
| changeMinus05 | numbernull | 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 |
| closingMinus04 | numbernull | 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. |
| changeMinus04 | numbernull | 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 neg |
| closingMinus03 | numbernull | 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. |
| changeMinus03 | numbernull | 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. |
| closingMinus02 | numbernull | ClosingMinus02 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the account balance two months prior to the closing balance. |
| changeMinus02 | numbernull | 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 neg |
| closingMinus01 | numbernull | 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 o |
| changeMinus01 | numbernull | 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 m |
| closingMinus00 | numbernull | 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 |
| changeMinus00 | numbernull | ChangeMinus00 is a decimal field in the AccountBalanceMonthTimeSeries table used to store the difference between the current and previous month's account balance. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/financekey/main/json-schema/financekey-finance-key-entity-account-pkg-v-account-balance-month-time-series-schema.json",
"title": "FinanceKey.Entity.AccountPkg.v_AccountBalanceMonthTimeSeries",
"x-generated": "2026-10-21",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/financekey-api-openapi.yml#/components/schemas/FinanceKey.Entity.AccountPkg.v_AccountBalanceMonthTimeSeries",
"required": [
"accountIdentifier",
"accountTypeId",
"currencyId",
"institiuteName",
"ownerName",
"reference"
],
"type": "object",
"properties": {
"createdById": {
"type": [
"integer",
"null"
],
"description": "The identity of the account that created the initial record.",
"format": "int32",
"readOnly": true
},
"createdOn": {
"type": "string",
"description": "The date and time the record was initially created.",
"format": "date-time",
"readOnly": true
},
"updatedById": {
"type": [
"integer",
"null"
],
"description": "The identity of the account that last modified the record.",
"format": "int32",
"readOnly": true
},
"updateOn": {
"type": "string",
"description": "The date and time the record was last modified.",
"format": "date-time",
"readOnly": true
},
"closedById": {
"type": [
"integer",
"null"
],
"description": "The identity of the account that deactivated and closed the record.",
"format": "int32",
"readOnly": true
},
"closedOn": {
"type": "string",
"description": "The date and time the record is to be considered as inactive and closed.",
"format": "date-time",
"readOnly": true
},
"active": {
"type": "boolean",
"description": "A flag that shows if the record is currently active. This values is calculated based on the current date and the record closed date.",
"readOnly": true
},
"rowVersion": {
"type": [
"string",
"null"
],
"description": "A unique version stamp of the record.",
"format": "byte",
"readOnly": true
},
"sessionId": {
"type": [
"string",
"null"
],
"description": "The identity of the session that last modified the record.",
"readOnly": true
},
"accountId": {
"type": "integer",
"description": "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.",
"format": "int32"
},
"closingMinus31": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"accountTypeId": {
"maxLength": 128,
"minLength": 1,
"type": "string",
"description": "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."
},
"changeMinus31": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"reference": {
"minLength": 1,
"type": "string",
"description": "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."
},
"closingMinus30": {
"type": [
"number",
"null"
],
"description": "The ClosingMinus30 field in the AccountBalanceMonthTimeSeries table is a decimal field that stores the account balance 30 days prior to the account closing date.",
"format": "double"
},
"accountIdentifier": {
"minLength": 1,
"type": "string",
"description": "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."
},
"changeMinus30": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"ownerId": {
"type": "integer",
"description": "OwnerId is an integer field that identifies the account holder associated with the account balance data stored in the AccountBalanceMonthTimeSeries table.",
"format": "int32"
},
"closingMinus29": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"currencyId": {
"maxLength": 128,
"minLength": 1,
"type": "string",
"description": "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."
},
"changeMinus29": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"accountStateId": {
"type": [
"string",
"null"
],
"description": "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'."
},
"closingMinus28": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"institiuteId": {
"type": "integer",
"description": "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.",
"format": "int32"
},
"changeMinus28": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus27": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"ownerName": {
"minLength": 1,
"type": "string",
"description": "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."
},
"changeMinus27": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"ownerLogoImage": {
"type": [
"string",
"null"
],
"description": "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."
},
"closingMinus26": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"institiuteName": {
"minLength": 1,
"type": "string",
"description": "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."
},
"changeMinus26": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"logoImage": {
"type": [
"string",
"null"
],
"description": "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."
},
"closingMinus25": {
"type": [
"number",
"null"
],
"description": "ClosingMinus25 is a decimal field in the AccountBalanceMonthTimeSeries table that represents the account balance 25 months prior to the month of the closing balance.",
"format": "double"
},
"countryId": {
"maxLength": 128,
"type": [
"string",
"null"
],
"description": "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."
},
"changeMinus25": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"countryFlagImage": {
"type": [
"string",
"null"
],
"description": "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."
},
"closingMinus24": {
"type": [
"number",
"null"
],
"description": "The ClosingMinus24 field in the AccountBalanceMonthTimeSeries table stores the account balance for 24 months previously. The data type for this field is decimal.",
"format": "double"
},
"changeMinus24": {
"type": [
"number",
"null"
],
"description": "ChangeMinus24 field in AccountBalanceMonthTimeSeries table stores the amount of change compared to the balance of the previous day, expressed in dollars.",
"format": "double"
},
"closingMinus23": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus23": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus22": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus22": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus21": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus21": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus20": {
"type": [
"number",
"null"
],
"description": "ClosingMinus20: This field in the AccountBalanceMonthTimeSeries table records the closing balance of the account minus 20 points. It is represented as a decimal value.",
"format": "double"
},
"changeMinus20": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus19": {
"type": [
"number",
"null"
],
"description": "ClosingMinus19 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 19 months before the current month.",
"format": "double"
},
"changeMinus19": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus18": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus18": {
"type": [
"number",
"null"
],
"description": "ChangeMinus18 in the AccountBalanceMonthTimeSeries table is a decimal field that stores the change in the account balance from 18 months ago.",
"format": "double"
},
"closingMinus17": {
"type": [
"number",
"null"
],
"description": "The ClosingMinus17 field in the AccountBalanceMonthTimeSeries table stores the monthly closing balance of any account subtracting 17 days of transactions in a decimal format.",
"format": "double"
},
"changeMinus17": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus16": {
"type": [
"number",
"null"
],
"description": "ClosingMinus16 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the closing balance of the account 16 months prior to the current month.",
"format": "double"
},
"changeMinus16": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus15": {
"type": [
"number",
"null"
],
"description": "ClosingMinus15 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the balance at the close of the month 15 months in the past.",
"format": "double"
},
"changeMinus15": {
"type": [
"number",
"null"
],
"description": "The field ChangeMinus15 represents the decrease in the AccountBalanceMonthTimeSeries table from the previous 15 months, represented as a decimal.",
"format": "double"
},
"closingMinus14": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus14": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus13": {
"type": [
"number",
"null"
],
"description": "ClosingMinus13 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the month-on-month closing balance of the account thirteen months prior.",
"format": "double"
},
"changeMinus13": {
"type": [
"number",
"null"
],
"description": "The 'ChangeMinus13' field in the 'AccountBalanceMonthTimeSeries' table is a decimal that stores the change in account balance compared to 13 months prior.",
"format": "double"
},
"closingMinus12": {
"type": [
"number",
"null"
],
"description": "ClosingMinus12 is a decimal field in AccountBalanceMonthTimeSeries that stores the account balance from 12 months ago.",
"format": "double"
},
"changeMinus12": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus11": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus11": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus10": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus10": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus09": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus09": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus08": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus08": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus07": {
"type": [
"number",
"null"
],
"description": "ClosingMinus07 is a decimal field in the AccountBalanceMonthTimeSeries table representing the account balance at the close of the time period 7 months prior.",
"format": "double"
},
"changeMinus07": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus06": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus06": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus05": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus05": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus04": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus04": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus03": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus03": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus02": {
"type": [
"number",
"null"
],
"description": "ClosingMinus02 is a decimal field in the AccountBalanceMonthTimeSeries table that stores the account balance two months prior to the closing balance.",
"format": "double"
},
"changeMinus02": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus01": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus01": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"closingMinus00": {
"type": [
"number",
"null"
],
"description": "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.",
"format": "double"
},
"changeMinus00": {
"type": [
"number",
"null"
],
"description": "ChangeMinus00 is a decimal field in the AccountBalanceMonthTimeSeries table used to store the difference between the current and previous month's account balance.",
"format": "double"
}
},
"additionalProperties": false
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/financekey-finance-key-entity-account-pkg-v-account-balance-month-time-series"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.