TripBookingSegmentCharges
Query all the charges for a trip.
Table Specific Information
Select
The adapter uses the SAP Concur APIs to process filters that refer to TripId. The adapter processes other filters client-side within the adapter.
For example, the following query is processed server side:
SELECT * FROM TripBookingSegmentCharges WHERE TripId ='sampleTripId'
Columns
| Name | Type | References | Description |
| TripId [KEY] | String | The id of the trip. | |
| BookingRecordLocator [KEY] | String | The record locator of the booking. | |
| SegmentType [KEY] | String | The type of the segment. | |
| ChargeType | String | The type of the charge. | |
| Amount | String | The total amount for the rate for the booking. | |
| AllowanceAmount | String | The cost of overage fees when the allowance is exceeded. | |
| Currency | String | The 3-letter ISO 4217 currency code for the total amount. | |
| Description | String | The description for the rate. | |
| IsPaid | Boolean | Whether the rate has been paid. | |
| AllowanceIsUnlimited | Boolean | Whether the allowance is unlimited. | |
| IsPrimary | Boolean | Indicates whether the charge is the Primary or Main rate. | |
| NumUnits | Integer | The number of units expected for the charge. For instance, 3 days. | |
| AllowanceNumUnits | Integer | The number of units for the allowance associated with the charge. | |
| PerUnit | String | The unit of measure for the charge. Values represent rates like per DAY, WEEK, or MONTH. | |
| AllowanceUnit | String | The unit of measure for the allowance associated with the charge. | |
| SemanticsCode | String | Indicates the charge category for the line item. | |
| SemanticsVendorType | String | The vendor type: H=Hotel, C=Car, A=Air, G=Ground, R=Rail | |
| StartDateLocal | Datetime | The start date of the booking, in the user's local time. | |
| Vendor | String | The vendor for the booking charge. | |
| VendorChargeCode | String | The vendor's code for the charge |