v_ Booking Import Booking

post

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

BookingImportBooking is a table in the Unknown package that stores information about imported bookings from external systems. It contains fields such as booking ID, source system, booking details, booking created date, and other related information. It can be used to track and manage the imported bookings for the system.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

amount

double

required

The Amount field on the BookingImportBooking table is a decimal data type that stores currency amounts associated with booking import records. It includes amounts for ticketing fees, taxes, baggage fees, and other associated costs.

estimateCashflowId

int32 | null

The EstimateCashflowId field is an integer data type in the BookingImportBooking table that acts as an identifying value assigned to a cashflow estimate related to a booking.

cashflowTagId

string

required

length between 1 and 32

CashflowTagId is a field in the BookingImportBooking table used to store a unique identifier for a cash flow tag of type nvarchar with a maximum length of 32. This identifier allows the BookingImportBooking to track the cash flow association for a particular booking.

valueDate

date-time

required

ValueDate: This field contains the date at which a transactions value is set between two parties. It stores the datetime2 value of the transaction booked on the BookingImportBooking table.

reportingAmount

double

required

The ReportingAmount field in the BookingImportBooking table stores the total monetary amount reported by the booking import process as a decimal.

sourceItemId

int32

SourceItemId is an integer field in the BookingImportBooking table that stores the id of the item from the source system where the booking originated.

sourceEntityId

string | null

SourceEntityId is a unique identifier that corresponds to the entity that uploaded a booking to the BookingImportBooking table. It is used to track the source of each booking. SourceEntityId is an nvarchar data type with a maximum length of 450.

internalReference

string | null

The InternalReference field in the BookingImportBooking table is a nvarchar field that stores an externally assigned alphanumeric identifier for a booking import. It has a maximum character length of 256.

fxRate

double

required

The FXRate field in the BookingImportBooking table is the foreign exchange rate, expressed as a decimal, that is applicable to the booking.

externalStatus

string | null

ExternalStatus of type nvarchar with a max length of 128 in the BookingImportBooking table is used to keep track of the status of a booking in terms of acceptance or rejection from outside sources. ExternalStatus will be populated with values such as 'Accepted', 'Rejected', or 'Pending'.

externalSourceNumber

string | null

ExternalSourceNumber is an nvarchar field in the BookingImportBooking table that holds a unique identifier up to 256 characters in length from an external source for the associated booking.

externalSourceKey

string | null

The ExternalSourceKey field in the BookingImportBooking table is an nvarchar data type with a maximum length of 256 characters and stores a unique identifier for each booking as assigned by the external source.

externalReference

string | null

The ExternalReference field in the BookingImportBooking table contains an externally supplied reference for the booking that can be used to identify the booking, such as a customer or purchase order reference. The data type is nvarchar with a maximum length of 256.

dueDate

date-time

required

The DueDate field in the BookingImportBooking table is a datetime2 data type that stores the due date for bookings imported into the system. This field can be used to keep track when each imported booking is due for completion.

debtorInstructionId

int32

The DebtorInstructionId field is an integer data type that corresponds to a Debtor Instruction number that is associated with a given booking in the BookingImportBooking table. This number is unique to each booking and is used to track the debtor associated with it.

currencyId

string | null

CurrencyId is an nvarchar field type with a maximum length of 128 in the BookingImportBooking table. It stores the currency code for each booking in the table. Currency codes are represented as ISO 4217 currency code abbreviations, such as USD for U.S. Dollars, EUR for Euro, and GBP for British Pounds.

creditorInstructionId

int32

CreditorInstructionId is an int data type field in the BookingImportBooking table. It is the unique identifier used to reference a credit instruction associated with a particular booking record in the database.

comment

string | null

Miscellaneous notes and information for the entry or record.

cashflowId

int32 | null

The 'CashflowId' field in the 'BookingImportBooking' table is a unique integer identifier assigned to each cash transaction or flow in the booking process. It is used to track individual financial transactions while importing bookings into the system.

bookingTypeId

string | null

BookingTypeId is a non-nullable NVARCHAR field with a maximum length of 128 characters in the BookingImportBooking table. It serves as a unique identifier for the different types of bookings that are imported/managed in the system.

bookingText

string | null

BookingText is an nvarchar field in the BookingImportBooking table that stores the booking information related to a specified item in the table. It has a maximum capacity of 512 characters.

bookingStatusId

string | null

BookingStatusId is a nvarchar field with a maximum length of 128 in the BookingImportBooking table. It stores the status of an imported booking, such as 'Confirmed', 'Cancelled', 'Pending', etc.

bookingStatusBadge

string | null

BookingStatusBadge is an Nvarchar data field with a maximum length of 4000 characters in the BookingImportBooking table. It stores a badge representing the current status of a booking as it progresses through one of the various stages. It can range from a status such as “pending”, “confirmed”, “cancelled”, etc. Various colors and symbols will be attached to each status to make it easier to identify.

bookingId

int32

The BookingId field in the BookingImportBooking table is an integer data type and serves as the primary key for the table. It is composed of a set of numerical characters that uniquely identify each row of the table and can serve as a reference for transactions or bookings associated with that entry.

bookingDate

date-time

required

BookingDate is the datetime2 field in the BookingImportBooking table that stores the date and time on which a booking was imported.

bookingCycleId

int32 | null

BookingCycleId is an int data type field in the BookingImportBooking table, that is used to identify the cycle of bookings imported from external source systems. It links a set of bookings belonging to a particular batch, cycle, or period, for easier overview and tracking of each import.

creditorInstructionBeneficiaryName

string | null

CreditorInstructionBeneficiaryName is a field in the BookingImportBooking table that stores the name of the beneficiary of creditor instructions in the form of an nvarchar data type with a maximum length of 128 characters.

debtorInstructionBeneficiaryName

string | null

DebtorInstructionBeneficiaryName is a field in the BookingImportBooking table which allows a user to enter up to 128 characters of text to define the name of the beneficiary to whom the debit instructions apply.

debtorAccountReference

string | null

DebtorAccountReference is an nvarchar field in the Booking table which contains the unique identifier of a debtor account related to a booking. It is used to store and retrieve information related to bookings and debtor accounts.

sourceEntityEntityId

string | null

The SourceEntityEntityId field in the BookingImportBooking table is a nvarchar data type of maximum length 450, and is used to identify which source entity a particular booking relates to. It could for example identify the airline, hotel or other third party vendor whom the booking was made through.

debtorBankName

string | null

DebtorBankName is an nvarchar field with a maximum length of 128 in the table BookingImportBooking. It stores the name of the bank of the corporate/debtor associated with the booking.

cashflowCashflowTypeId

string | null

The CashFlowTypeId field is an nvarchar field in the BookingImportBooking table, with a maximum length of 32 characters. This field is used to identify the type of cashflow associated with the particular import booking.

creditorBankName

string | null

CreditorBankName is an NVARCHAR field of size 128 in the BookingImportBooking table. Its purpose is to store the name of the bank of the creditor associated with a booking.

estimateCashflowCashflowTypeId

string | null

EstimateCashflowCashflowTypeId is an nvarchar data field with a maximum length of 32 in the BookingImportBooking table. It is used to identify the CashflowType associated with an estimate cashflow.

debtorAccountNumber

string | null

The DebtorAccountNumber field in the BookingImportBooking table is a character string with a maximum length of 64 characters. The field stores up to 64 characters for a debtor's account number, such as an account number for a bank, credit card company, or other financial institution.

creditorAccountNumber

string | null

The CreditorAccountNumber field in the BookingImportBooking table is a nvarchar data type with a maximum length of 64 characters and stores the account number for a creditor associated with the booking.

Headers

content-type

string

enum

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

Generated from available request content types

Response

200