API Reference

v_ Account Member Balance Descendent

patch
https://app.financekey.com/OData/v_AccountMemberBalanceDescendents()

This table shows the balance records that compose the balance records of another. In some cases, when an account is composed of other accounts, a cash pool say, then there are multiple balance records that create the top balance. This view shows that relationship.

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

The AccountBalanceId field is an integer type primary key field used to uniquely identify each record in the AccountMemberBalanceDescendent table. This field is used to store an ID that references the unique balance amount of a particular account member.

int32

DescendantAccountBalanceId is an integer (int) data type field in the AccountMemberBalanceDescendent table which holds the unique identifier of the balance of the descendant account. It is used as a primary key for the table to identify individuals accounts and their corresponding balances.

date-time
required

StatementDate is a field in the AccountMemberBalanceDescendent table which stores the date a statement was created for a particular account. It is of data type date.

int32 | null

The AccountId field in the AccountMemberBalanceDescendent table stores a unique identification number of type integer. This number serves as an identifier for each account within the member balance descending record. It is used to differentiate and retrieve specific account information from other records in the database. The AccountId field plays a crucial role in maintaining data accuracy and organization within the AccountMemberBalanceDescendent table.

double
required

The field 'OpeningBalance' in the table 'AccountMemberBalanceDescendent' is a decimal data type that stores the initial balance of an account. This field is used to track the starting amount of funds in the account before any transactions are made. It serves as a baseline for the current balance and allows for easy comparison of account activity over time. This field is essential for accurate bookkeeping and financial analysis.

double
required

The ClosingBalance field in the AccountMemberBalanceDescendent table is a decimal data type that stores the balance at the end of a specific time period for a member's account. This field is important for tracking the overall financial standing of the member and is used to calculate any changes in their account balance. The decimal data type allows for precision in displaying the exact value of the closing balance, ensuring accurate financial record-keeping. This field is essential for staying organized and informed about account activities and is an important component in managing and maintaining financial data within the AccountMemberBalanceDescendent table.

double | null

The BalanceDifference field in the AccountMemberBalanceDescendent table is a decimal data type that represents the difference between the current balance and the previous balance for a specific member account. This field is useful for tracking changes in account balances over time and can help identify discrepancies or patterns in a member's transaction history. The decimal data type allows for precision and accuracy in recording even small differences in balance amounts. This field is an important aspect of managing and monitoring account activity in the AccountMemberBalanceDescendent table.

double
required

The TransactionAmountSum field in the AccountMemberBalanceDescendent table is a decimal data type that stores the total sum of all transaction amounts for a specific account member. It is a useful metric for tracking the overall financial activity of an account and can provide insights into spending patterns and account balance changes over time. This field is crucial in ensuring accurate and up-to-date financial records for the account member and can help with budgeting and financial planning.

double | null

The TransactionToBalanceDifference field in the AccountMemberBalanceDescendent table is of the decimal data type and represents the difference between the current account balance and the transaction amount of a particular member. This field captures the change in balance over time and allows for easy tracking of transaction history. It is a crucial piece of information for monitoring account activity and ensuring accurate financial records.

string | null

The Content field is a string data type (nvarchar) within the AccountMemberBalanceDescendent table. This field stores text-based information related to the account member's balance. It may include details such as transaction notes, account activity descriptions, or account holder information. The Content field allows for the storage of variable-length, Unicode character data, making it versatile and able to accommodate a wide range of data. It is a crucial component in providing a complete and comprehensive view of the account member's balance and financial history.

date-time
required

The field 'AsOf' in the 'AccountMemberBalanceDescendent' table is a datetime2 data type that represents the date and time at which the account balance for a specific member was recorded. This field is used to track the chronological order of account balance updates for each member, allowing for accurate reporting and analysis of changes over time. It is a crucial component in maintaining the integrity and accuracy of financial data within this table.

int32

The SystemDefnId field in the AccountMemberBalanceDescendent table is an integer data type that stores a unique identifier for the system definition. This field is used to identify the specific account member balance within the table and is crucial for data organization and retrieval. It serves as a reference point when linking data from other tables and allows for more efficient data manipulation within the system. The SystemDefnId field plays a key role in maintaining data accuracy and integrity in the AccountMemberBalanceDescendent table.

double
required

The ReportingClosingBalance field, found within the AccountMemberBalanceDescendent table, is a decimal data type used to store the final reported balance for a specific account member. This balance reflects all financial transactions and adjustments made to the account, providing an accurate and up-to-date representation of the member's current funds. The decimal data type allows for precise and accurate calculations, making it an essential component of the AccountMemberBalanceDescendent table for tracking and managing account balances.

double
required

The ReportingOpeningBalance field in the AccountMemberBalanceDescendent table is a decimal data type that stores the opening balance of a member's account. This value represents the initial amount of funds or assets that were present in the account at the beginning of a reporting period. The purpose of this field is to track changes in the account's balance over time and provide a reference point for reporting on the member's financial activity. This field is essential for accurate financial analysis and record-keeping within the context of the AccountMemberBalanceDescendent table.

double | null

The ReportingBalanceDifference field in the AccountMemberBalanceDescendent table is a numerical data type, specifically decimal, that represents the difference between the current balance and the previous balance for a specific account member. This information is used for reporting purposes and is constantly updated as new transactions are made. The decimal data type allows for more precise calculations and ensures accurate reporting of balance differences. This field is an important aspect of tracking and analyzing account member balances within the larger database.

string
required
length ≥ 1

The Reference field in the AccountMemberBalanceDescendent table is a data type of nvarchar, which allows for the storage of alphanumeric characters. This field serves as a reference for any associated account members and their corresponding balance descent details. It may contain various pieces of information such as account numbers, transaction IDs, or member names. The Reference field is crucial for linking and organizing data within the table, providing a clear and identifiable point of reference for each record. This efficient data structure enables easy retrieval and analysis of valuable member balance information for the AccountMemberBalanceDescendent table.

string
required
length between 1 and 128

The CurrencyId field in the AccountMemberBalanceDescendent table is a nvarchar data type with a maximum length of 128 characters. It is used to store the unique identifier for the currency associated with a member's account balance. This field is crucial in maintaining accurate financial records and allowing for efficient currency conversion calculations. It ensures the proper tracking and management of funds in various currencies for the account members.

string
required
length between 1 and 128

The AccountTypeId field in the AccountMemberBalanceDescendent table is a nvarchar data type with a maximum length of 128 characters. This field is used to identify the type of account associated with a particular member's balance. It can contain a variety of account types, such as checking, savings, or credit. This field plays a crucial role in organizing and managing account information for members in a concise and efficient manner. It also allows for easy referencing and filtering of data based on the type of account, making it a valuable asset in financial databases.

string
required
length between 1 and 128

The Code field in the AccountMemberBalanceDescendent table is of the data type nvarchar, which can store alphanumeric characters and has a maximum length of 128. This field is used to uniquely identify each account member's balance descendent within the table. It may contain a combination of letters, numbers, and special characters, providing a specific code for each balance descendent. This field is essential for organizing and identifying account information and ensures efficient data management within the table.

string
required
length ≥ 1

The Name field is a data type nvarchar (short for 'national character varying') in the table AccountMemberBalanceDescendent. This field is used to store the names of account members who have a balance linked to this particular account. The nvarchar data type allows for the storage of both alphanumeric and special characters, making it a flexible option for different types of names. The Name field serves as an identifier for each account member and is an essential part of organizing and managing the account balance data in the AccountMemberBalanceDescendent table.

boolean | null

The Latest field in the AccountMemberBalanceDescendent table is a bit data type that indicates whether the account member's balance is the most recent record in the table. This field allows for easier tracking of the most up-to-date information for each member's account balance. It is set to 1 if the balance is the newest record and 0 if there are newer records available. This field is a useful tool for maintaining accurate and current account information for all members.

boolean | null

The ActiveAccount field in the AccountMemberBalanceDescendent table is a boolean data type (bit), used to track the status of a member's account. When set to '1', it indicates that the account is active and can be used for transactions. Conversely, when set to '0', it indicates that the account is inactive and cannot be used. This field serves as a useful tool in managing and organizing member balances within the account database.

double
required

The WithheldBalance field, belonging to the AccountMemberBalanceDescendent table, is a decimal data type that stores the amount of funds that are currently being withheld from the account of a member. This can include funds that have been placed on hold, pending investigation, or any other reason determined by the account holder or the financial institution. WithheldBalance serves as an important measure of the available funds in an account and can impact the overall account balance and financial transactions.

double
required

The ReportingWithheldBalance field in the AccountMemberBalanceDescendent table is a decimal data type, representing the portion of a member's balance that has been withheld for reporting purposes. This field is used to track any funds that have been held by the organization for future reporting or auditing purposes. It provides important information for financial reporting and ensures accuracy and transparency in the management of member balances. The decimal data type allows for precise calculations, making it a valuable tool for tracking and managing withheld balances.

double | null

The AvailableReportingClosingBalance field, belonging to the AccountMemberBalanceDescendent table, is a decimal data type that represents the remaining balance available for reporting at the end of a specific reporting period. This field is typically used in financial or accounting databases to track and analyze the financial standing of a particular account or member. It allows for precise reporting of the current balance, taking into account any transactions or changes that have occurred within the designated reporting period. The AvailableReportingClosingBalance field provides crucial information for decision-making and financial analysis, making it a vital component of the AccountMemberBalanceDescendent table.

double | null

The AvailableReportingOpeningBalance field is a decimal data type within the AccountMemberBalanceDescendent table. This field stores the amount of available funds at the beginning of a reporting period for a specific account member. This balance is typically calculated by deducting any outstanding expenses or payments from the previous reporting period from the account member's overall balance. This field is useful for tracking the current financial standing of an account member and can be utilized for budgeting and forecasting purposes.

double | null

The AvailableClosingBalance field in the AccountMemberBalanceDescendent table stores the numeric value of the remaining funds available for withdrawal or transfer at the end of the current accounting period for each account member. It is of the decimal data type, allowing for precise calculation of even the smallest balances. This field serves as a crucial reference for account holders and financial institutions in managing and monitoring account transactions and balances.

double | null

The AvailableOpeningBalance field in the AccountMemberBalanceDescendent table is a decimal data type that represents the amount of funds that are currently available for use in a member's account. This balance is calculated by taking into account any previous transactions, such as deposits or withdrawals, and any interest or fees that have been applied. This field serves as a starting point for tracking and managing a member's account balance, and is updated regularly as new transactions occur. It provides a snapshot of the current financial status of the account and assists in managing budgeting and financial planning.

double
required

The ReportingOverdraftAmount field in the AccountMemberBalanceDescendent table is a decimal data type that tracks the amount of funds that a member's account is overdrawn by. This field plays a crucial role in accurately reporting and managing the balance of accounts within the database. By keeping track of the overdraft amount, this field can assist in identifying potential issues and discrepancies in a member's balance. It is an essential component for maintaining accurate financial records and ensuring proper account management within the system.

double | null

The HeadroomReportingAmount field in the AccountMemberBalanceDescendent table stores numerical values in decimal format. This field is used to track and report on the remaining balance or space available for a particular account member. It provides valuable information for managing and monitoring account balances, making informed decisions, and ensuring accurate reporting for financial purposes.

string
required
length ≥ 1

The OwnerName field in the AccountMemberBalanceDescendent table is a nvarchar data type that is used to store the name of the account owner. This field is essential for keeping track of the various account holders within a broader account hierarchy. The nvarchar data type allows for names of varying lengths to be stored, ensuring that all account owners' names can be accurately recorded. This field is a crucial component of the AccountMemberBalanceDescendent table, providing important information about the individuals who have a financial stake in the account.

string | null

The OwnerLogo field in the AccountMemberBalanceDescendent table is a data type of nvarchar and stores the logo of the account owner associated with the balance. This field allows for easy identification and verification of the account owner through their personalized logo. It is particularly useful in cases where there are multiple account members with different logos. With this field, users can quickly and accurately locate the desired account owner for further actions or inquiries.

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

Generated from available request content types

Response
200

OK

Updated about 1 year ago

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

Updated about 1 year ago