Booking Cycle Account Transactions

post

https://app.financekey.com/OData/v_BookingCycleAccountTransactions

The BookingCycleAccountTransaction table is part of the Unknown package and stores data related to the booking cycle accounting transaction. This table contains information such as transaction ID, transaction date, company name, type of transaction, amount, and more. The table also tracks the details of the booking cycle, such as the start and end dates of the cycle. This table is used for comprehensive tracking and analysis of all the data related to the accounting transaction, providing useful information to management.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

accountTransactionId

int32

AccountTransactionId is an integer field located in the BookingCycleAccountTransaction table. This field stores a unique sequential identifier for each bookkeeping transaction related to a BookingCycle. It is used to track changes to the BookingCycleAccountTransaction table over time.

accountBalanceId

int32

The AccountBalanceId is an INT data type primary key that is used to uniquely identify a BookingCycleAccountTransaction record in the database. This key is assigned by the system when the record is initially created and remains immutable for the life of the transaction.

valueDate

date-time

required

The ValueDate field in the BookingCycleAccountTransaction table is of data type Date and is used as a reference point for releasing money from an account and booking the transactions. It indicates the date on which funds can be drawn from the account or when money can be debited from the customer's account and credited to the company's account.

debitCredit

string

required

length between 1 and 6

The DebitCredit field in the BookingCycleAccountTransaction table identifies whether the transaction is a debit or credit. The field is a varchar data type with a maximum length of 6 characters. Possible values include DEBIT, CREDIT, DEB, CRE, DEBPOS, and CREDPOS.

amount

double

required

The Amount field in the BookingCycleAccountTransaction table stores the monetary value of a transaction, expressed as a decimal number. It is used to track the details of each transaction associated with a specific cycle or booking account.

content

string | null

The Content field of the BookingCycleAccountTransaction table is an nvarchar data type field that stores general notes or comments related to the transaction that took place. This field can contain up to 250 characters.

endpointMethodLogId

int32 | null

The EndpointMethodLogId is an integer field in the BookingCycleAccountTransaction table that stores a unique identifier for each of the endpoint methods used in the booking cycle, such as a web service, a system event, or a database stored procedure. This field provides an audit trail of the actions taken in the booking cycle, enabling improved tracking and investigation of any discrepancies.

amountDifference

double | null

The AmountDifference field in the BookingCycleAccountTransaction table is used to store the difference in amounts between two transactions within a single booking cycle. The field is a decimal data type and can contain negative values if a second transaction amount is smaller than the original.

reportingAmount

double

required

ReportingAmount is a decimal field in the BookingCycleAccountTransaction table that stores the value of a transaction that is to be reported to a financial reporting entity.

uniqueId

string | null

The UniqueId field is a nvarchar data type with a maximum length of 256 characters and is used to identify a record in the BookingCycleAccountTransaction table. The UniqueId is used to ensure that each record in the table has a unique identifier.

remitterName

string | null

The RemitterName field of data type nvarchar will store the name of a person or organization who is sending a BookingCycleAccountTransaction. It must have a maximum length of 256 characters.

beneficiaryName

string | null

BeneficiaryName is the nvarchar field in the BookingCycleAccountTransaction table that stores the name of the recipient of the transaction up to 256 characters in length.

debitCreditBadge

string | null

The DebitCreditBadge field in the BookingCycleAccountTransaction table is an nvarchar field with a maximum length of 4000 characters which identifies whether an account transaction was a debit or credit.

remittanceInformation

string | null

RemittanceInformation is an nvarchar data type field in the BookingCycleAccountTransaction table which contains information about payments made to the booking cycle account. This data field may include data such as the payment date and amount, payment method, and the remittance details.

cashflowId

int32

The CashflowId field is an integer data type in the BookingCycleAccountTransaction table used to store the primary key for each individual cash flow transaction in the booking cycle associated with the account.

bookingCycleId

int32

BookingCycleId is an integer data type that holds the unique identifier for each Booking Cycle Account Transaction on the table. It helps to maintain a link between the transactions for easy grouping and analysis.

Headers

content-type

string

enum

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

Generated from available request content types

Response

200

Language

URL

Loading…

Response

Click Try It! to start a request and see the response here!