API Reference

v_ Booking Transaction

post
https://app.financekey.com/OData/v_BookingTransactions

The BookingTransaction table is part of the Unknown package and provides a record of all bookings made with the package. It stores booking details such as the customer, date, time, item, location, price, and other relevant data in order to keep track of all transactions. It is an important part of the Unknown package in order to provide customers and manage businesses with accurate booking records.

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

The AccountTransactionId field is an integer data type in the BookingTransaction table, used to identify individual transactions that are associated with a given account. It is a unique identifier used to reference a specific account transaction in the database.

int32

AccountBalanceId is an integer data type primary key in the BookingTransaction table and is used to uniquely identify a particular account balance associated with a booking transaction within the system.

date-time
required

The ValueDate field in table BookingTransaction is a date field, which stores the contractual value date of each BookingTransaction. This is the date by which the value of the transaction is determined, and is the contractual date for the transfer of ownership between the two parties.

string
required
length between 1 and 6

The DebitCredit field of the BookingTransaction table is used to store information about the type of transaction associated with the booking. It contains a 6-character varchar field, with 'debit' indicating a decrease in funds and 'credit' indicating an increase in funds.

double
required

The Amount field in the BookingTransaction table stores monetary values in a decimal format. This field represents the total amount of the transaction in either the native currency or a different currency as defined by the user.

double
required

CashflowItemAmount is a decimal data type field in the BookingTransaction table that represents the amount of a financial transaction or item associated with a particular booking.

double | null

AmountDifference is the field in BookingTransaction table and it stores decimal value which represents the difference between amount spent and amount received.

string | null

Content is a nvarchar field in the BookingTransaction table that holds notes, comments, or descriptions associated with a particular transaction.

int32 | null

The EndpointMethodLogId field is an integer data type in the BookingTransaction table and is used to store a log identifier that tracks the path of each transaction through the system. It is an auto-incrementing primary key field which uniquely identifies each transaction within the database.

double
required

The field ReportingAmount in the BookingTransaction table stores the numerical amount used for reporting purposes. The value stored in this field is of data type decimal.

string | null

UniqueId is an nvarchar field in the BookingTransaction table used to store a unique identifier for each booking transaction. The field is limited in size to 256 characters.

string | null

The RemitterName field in the BookingTransaction table is an nvarchar field with a maximum length of 256 characters. It stores the name of the person who initiated the transaction.

string | null

The BeneficiaryName field in the BookingTransaction table is a nvarchar (National Language Variable Character) field with a maximum length of 256 characters. It is used to store the full name of the beneficiary of a booking transaction.

string | null

The DebitCreditBadge field in the BookingTransaction table is a nvarchar data type with a maximum length of 4000 characters. This field is used to store the badge number of the credit/debit card used to process a booking transaction.

string | null

The RemittanceInformation field in the BookingTransaction table is a nvarchar field that is used to store information on remittance payment or transaction related to a booking. This field can contains information on payment methods, the payee, amounts, modes of payment, and any other relevant information related to the transaction.

int32

BookingId is an integer data type field in the BookingTransaction table used to store the unique identifier of each booking in the bookings system. This field ensures that there can be no duplicate bookings in the system.

int32

CashflowId is an integer field in the BookingTransaction table, which represents the unique identifier of the cash flow associated with a particular booking transaction.

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