Account Balance Histories

The AccountBalanceHistory table in the Account package is used to store a history of account balances for accounts within the system. The table stores a reference to the account, a snapshot of the account balance at the time of the record being added, and a timestamp of when the record was added. This data allows for an audit of account balance changes and allows for historical analysis of the account balance over time.

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

AccountBalanceHistoryId is a data field of type int in the AccountBalanceHistory table which serves as a unique identifier for each row, allowing audits and changes to be tracked in the AccountBalanceHistory table.

int32

AccountId of data type int is a primary key column in the AccountBalanceHistory table that contains a unique identifier for each account balance history record.

date-time
required

The AsOf field of data type datetime2 in the AccountBalanceHistory table stores the timestamp of when the balance information was retrieved.

date-time
required

The StatementDate field in the AccountBalanceHistory table is a datetime2 data type field that stores the date on which the account balance was most recent and accurate at the time.

double
required

ClosingBalance is a decimal field in the AccountBalanceHistory table that stores the closing accounting balance of an account at the end of each period.

double
required

ReportingClosingBalance is a field in the AccountBalanceHistory table of type decimal that stores the reported ending balance of funds or assets for a given date, as stated in associated financial reports and documents.

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!