Skip to main content

Order Items

The Order Items section provides a global view of all order items across all orders. This is useful for detailed reporting, filtering, and exporting comprehensive booking data.

Order items

The table displays all order items with the following columns:

  • No: Sequential order item number.
  • Order ID: Unique identifier for the parent order.
  • Order Detail ID: Unique identifier for the individual order item.
  • First Name: First name of the passenger associated with the order item.
  • Last Name: Last name of the passenger associated with the order item.
  • Pax Type: Type of the passenger (Adult/Child).
  • Pax ID: Identifier of the passenger. Optional field; can be provided during order creation. Its availability is configured per agent contract.
  • Contracts: Contract ID associated with the order item.
  • Agency ID: Identifier of the travel agency. Optional field; indicated when the order is created via a widget.
  • Status: Current status of the order item (e.g., Active, Refunded).
  • Created Date: Date and time when the order item was created.
  • Category: Product category (Lounge / Delay Care / Fast Track / Meet & Assist).
  • Order Status Set Date: Date and time when the order item status was last updated.
  • Product Name: Name of the product associated with the order item.
  • Airport Code: IATA code of the airport where the product is located.
  • Terminal: Name of the terminal where the product is located.
  • Product Value: Numeric indicator of the stay duration or service quantity.
  • Product Type: Type of duration or service (e.g., hours).
  • Visit Date (Local Time): Planned visit date based on the airport's local time zone.
  • Refund Expire Date: Date and time until which the order item can be refunded.
  • Sales Currency: Currency code used for the sale.
  • Gross Price in Sales Currency: Order item amount in the sales currency.
  • Rate to USD: Exchange rate from the sales currency to USD.
  • Gross Price (USD): Gross price in USD.
  • Commission (Percent/Fixed): Agent's commission on the order item.
  • Net Price (USD): Net price in USD after commission.
  • Net Margin (USD): Agent's net margin from the order item in USD.
  • Author: User or system that created the order item. Shows the username if placed via the B2B Agent Portal, or "API" if placed via API.
  • Widget ID: Identifier of the widget used to create the order item (if applicable).
  • Flight Status: Status of the associated flight (Scheduled/Delayed/Cancelled). Shown only for Delay Care order items.
  • Flight Number: Number of the associated flight. Shown only for Delay Care order items.

Download Excel Button​

Click the Download Excel button to export the order items table to Excel format.

note

Column filtering is available in all tables, and this filtering will affect the data exported to Excel.