Booking Summary

post

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

The BookingSummary table in the Payment package is designed to aggregate and summarize key details of customer bookings for streamlined financial processing and reporting. It includes essential fields such as booking ID, customer ID, booking date, total amount, payment status, and transaction reference, allowing for efficient tracking of financial transactions related to bookings. This table serves as a crucial resource for monitoring revenue, managing payment workflows, and generating insights into booking trends and customer behavior.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

bookingSummaryId

string | null

The BookingSummaryId is a unique identifier of type nvarchar, with a maximum length of 134 characters, used to represent each individual booking summary in the BookingSummary table. This field is essential for distinguishing between different booking records and ensuring data integrity within the database.

amount

double | null

The Amount field in the BookingSummary table represents the total monetary value associated with a booking. This decimal field captures precise financial amounts, allowing for accurate calculations and reporting on revenue, fees, or charges related to each booking entry.

currencyId

string | null

The CurrencyId field in the BookingSummary table is a variable-length string (nvarchar) with a maximum length of 3 characters. It is designed to store the currency code used for the booking transaction, following ISO 4217 standards. This field allows for efficient identification of the currency, facilitating financial reporting and transaction processing within the booking system.

itemCount

int32

The ItemCount field is a primary key in the BookingSummary table, designed to store a unique integer value that represents the total number of items associated with a specific booking. This field ensures that each entry in the BookingSummary table is uniquely identifiable and allows for efficient tracking and management of the item count related to individual bookings.

reportingAmount

double | null

The ReportingAmount field in the BookingSummary table represents the total monetary value associated with each booking entry, expressed as a decimal. This amount includes all relevant charges, adjustments, and discounts, providing a comprehensive financial summary for reporting and analysis purposes.

bookingStatusId

string | null

BookingStatusId: A string identifier representing the current status of a booking in the BookingSummary table. This field can store values up to 128 characters in length and is used to categorize the booking's state, such as 'Pending,' 'Confirmed,' 'Cancelled,' or 'Completed.' It facilitates efficient tracking and management of bookings within the system.

bookingStatusBadge

string | null

The BookingStatusBadge field in the BookingSummary table is of data type nvarchar, allowing for a maximum length of 4000 characters. This field is intended to store a visual representation or textual description of the current status of a booking. Possible values may include statuses such as 'Confirmed,' 'Pending,' 'Cancelled,' or 'Completed,' which can be formatted with badges or labels for easy identification. This field can be used for display purposes in user interfaces, enabling users to quickly assess the state of their bookings.

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!