v_ Account Member Transaction Descendent

This view shows the composit transactions that make any balance record in the system... even if the account consists of sub level account.

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

AccountTransactionId is an int data type field in the AccountMemberTransactionDescendent table. It is an auto-generated, unique identifier for each transaction record associated with a particular account member.

int32

AccountBalanceId is a primary key int field in the AccountMemberTransactionDescendent table. It is a unique identifier for each row in the database and represents the account balance of each AccountMemberTransactionDescendent.

date-time
required

BookingDate is a date field in the AccountMemberTransactionDescendent table that stores the date the transaction was booked.

date-time
required

ValueDate is the date field in the AccountMemberTransactionDescendent table that stores the date of when a single transaction occurred.

string
required
length between 1 and 128

The CurrencyId field in the AccountMemberTransactionDescendent table is a nvarchar data type with a maximum length of 128. It consists of an identification number that corresponds to a specific currency type and is used to track the different types of currencies used in transactions.

string
required
length between 1 and 6

The field DebitCredit in the AccountMemberTransactionDescendent table stores a varchar data type representing whether the transaction is a debit or a credit (ie. DR or CR) with a maximum length of 6 characters.

string
required
length between 1 and 256

The DebitCreditBadge is an nvarchar field with a maximum length of 256 in the AccountMemberTransactionDescendent table. It is used to identify the type of transaction such as debit, credit, or bad debt for a particular account member's transaction.

double
required

Amount is the amount of money that is being transferred between an Account Member and its respective Descendent. This field is of data type decimal and is part of the AccountMemberTransactionDescendent table.

string | null

The Content field of data type nvarchar in the AccountMemberTransactionDescendent table will store unstructured information about a particular transaction made by a user in the form of a character string. This could include comments or notes about the transaction noted by the user or any other unstructured data.

int32 | null

The EndpointMethodLogId field in the AccountMemberTransactionDescendent table is an integer data type field which stores a unique identifier for a method log entry. This identifier is used to track the execution of specific endpoint methods in the system.

double
required

ReportingAmount is a decimal field in the AccountMemberTransactionDescendent table that stores the amount of money reported in each individual transaction made by a member of the account, such as the amount used for a purchase or deposit.

string | null

UniqueId is an nvarchar field with a maximum length of 256 in the AccountMemberTransactionDescendent table, which stores a unique alphanumeric identification code for each record in the table. This UniqueId allows each record to be quickly identified, and it acts as a key to join the table with other related tables.

string | null

The RemitterName field is an nvarchar data type of length 256 used in the AccountMemberTransactionDescendent table. It holds the name of the remitter, or the person or entity that initiated the transaction.

string | null

BeneficiaryName is an nvarchar field in the AccountMemberTransactionDescendent table that stores the name of the beneficiary of the specific transaction, with a maximum length of 256 characters.

date-time
required

The AccountBalanceStatementDate field in the AccountMemberTransactionDescendent table holds the date when a member's account balance statement was last created.

int32

AccountId is the unique identifier of each record in the AccountMemberTransactionDescendent table. It is an integer data type field that associates each account member transaction with a unique account member ID. This field serves to uniquely identify each record in the table and can be used to track and reference any account member transaction history.

string
required
length ≥ 1

The AccountIdentifier field in the AccountMemberTransactionDescendent table is an nvarchar data type and is used to store a unique reference, or identifier, for each account member. It is used to help organize and cross-reference information from all members in the table.

string
required
length ≥ 1

OwnerName is an nvarchar field in the AccountMemberTransactionDescendent table which stores the name of the account holder or owner associated with a given transaction.

string | null

OwnerLogoImage is a nvarchar type field in the AccountMemberTransactionDescendent table. It stores the path to a logo image associated with the account owner, enabling users to quickly recognize an account and its associated owner.

string
required
length ≥ 1

The InstitiuteName field in the AccountMemberTransactionDescendent table stores the name of the institution associated with an account-member transaction as a character string in a variable-length format.

string | null

The InstituteLogoImage field within the AccountMemberTransactionDescendent table is an nvarchar field which holds a text representation of an image file (usually a logo for an institute/organization) associated with a particular member of a transaction.

string | null

CountryId in the AccountMemberTransactionDescendent table stores the national identifier of the country the account member belongs to. It is a variable-length character data type of up to 128 characters to capture potential international identifiers, such as two-letter ISO code for countries.

string | null

The CountryFlagImage field is an nvarchar field of (maximum) 255 characters that stores a text path to an image of a flag representing the country of origin for each user listed in the AccountMemberTransactionDescendent table.

string | null

RemittanceInformation is a field in the AccountMemberTransactionDescendent table to store the recipient details for a particular transaction. It is a nvarchar field, allowing up to 200 characters of text. This field is intended to store the name and address of the remittance recipient for transactions.

string | null

Reference is an nvarchar field of up to 64 characters which stores any relevant external references related to an AccountMemberTransactionDescendent record, such as a reference number from an external system or a comment from the user.

string
required
length ≥ 1

AccountReference is a field in the table AccountMemberTransactionDescendent that stores a unique alphanumeric reference code to identify an individual member's account in order to track their transactions. The data type is nvarchar.

boolean | null

ActiveAccount is a field of type bit in the AccountMemberTransactionDescendent table which indicates whether the account is actively used. A value of 0 indicates that the account is not active and a value of 1 indicates that the account is actively used.

string
required
length between 1 and 128

AccountTypeId is an nvarchar data type with a maximum length of 128 in the AccountMemberTransactionDescendent table. It stores the unique type of account associated with each transaction. This data is used to categorize the different types of accounts and transactions in the system.

int32

InstituteId is a field of data type int in the AccountMemberTransactionDescendent table. It stores the numerical identification of the educational institute associated with each account member transaction.

string | null

BusinessUnitCode is an nvarchar field in the AccountMemberTransactionDescendent table with a maximum length of 16 characters. It is used to store the unique code of the business unit associated with a particular transaction.

int32

The DescendentAccountBalanceId field in the AccountMemberTransactionDescendent table stores the ID associated with the current account balance of a descendent account. This is used to track the financial activity of a descendent account from the perspective of its parent account. The data type of this field is an integer.

string | null

The TransactionStatus field in the AccountTransaction table is a data type of nvarchar with a maximum length of 4 characters. This field is used to indicate the status of a financial transaction within the account. This could include values such as 'PEND' for pending, 'COMP' for completed, or 'FAIL' for a failed transaction. This field is important for keeping track and maintaining an accurate record of all transactions that occur within the account.

string | null

The TransactionCode field in the AccountTransaction table is a nvarchar data type with a maximum length of 12 characters. It is used to identify the specific type of transaction that occurred within the account. This field allows for easy categorization and tracking of different types of transactions such as deposits, withdrawals, transfers, fees, and more. The maximum length of 12 characters ensures that all types of transactions can be accurately represented within the field. It serves as a crucial piece of data in understanding and managing account activity.

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!