EventOrderItems
Returns data from the EventOrderItems table.
Table Specific Information
SELECT
The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:
- Id supports =,!=
- EventId supports =,!=
- AttendeeId supports =,!=
- OrderId supports =,!=
- ProductId supports =,!=
- ProductType supports =,!=
- Created supports =,!=,>,<,>=,<=
- LastModified supports =,!=,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * FROM EventOrderItems WHERE EventId='3a366031-7541-4a44-9fde-bc0f81d3e940'
Columns
| Name | Type | References | Description |
| Id | String | The Id of the EventOrderItems table. | |
| EventId | String |
Events.Id | The EventId field of the EventOrderItems table. |
| Guest | Boolean | The Guest field of the EventOrderItems table. | |
| Active | Boolean | The Active field of the EventOrderItems table. | |
| Name | String | The Name field of the EventOrderItems table. | |
| Price | Double | The Price field of the EventOrderItems table. | |
| Quantity | Double | The Quantity field of the EventOrderItems table. | |
| AmountOrdered | Double | The AmountOrdered field of the EventOrderItems table. | |
| AmountPaid | Double | The AmountPaid field of the EventOrderItems table. | |
| AmountDue | Double | The AmountDue field of the EventOrderItems table. | |
| ProductPriceTierAmount | Double | The ProductPriceTierAmount field of the EventOrderItems table. | |
| Tiered | Boolean | The Tiered field of the EventOrderItems table. | |
| Deleted | Boolean | The Deleted field of the EventOrderItems table. | |
| Created | Datetime | The Created field of the EventOrderItems table. | |
| CreatedBy | String | The CreatedBy field of the EventOrderItems table. | |
| LastModified | Datetime | The LastModified field of the EventOrderItems table. | |
| LastModifiedBy | String | The LastModifiedBy field of the EventOrderItems table. | |
| ProductId | String | The ProductId field of the EventOrderItems table. | |
| ProductType | String | The ProductType field of the EventOrderItems table. | |
| OrderId | String | The OrderId field of the EventOrderItems table. | |
| OrderType | String | The OrderType field of the EventOrderItems table. | |
| AttendeeId | String | The AttendeeId field of the EventOrderItems table. | |
| GuestDetailId | String | The GuestDetailId field of the EventOrderItems table. | |
| FeeId | String | The FeeId field of the EventOrderItems table. | |
| FeeName | String | The FeeName field of the EventOrderItems table. | |
| GeneralLedgerItemsId | String | The GeneralLedgerItemsId field of the EventOrderItems table. | |
| GeneralLedgerItemsName | String | The GeneralLedgerItemsName field of the EventOrderItems table. | |
| GeneralLedgerItemsCode | String | The GeneralLedgerItemsCode field of the EventOrderItems table. | |
| GeneralLedgerItemsDescription | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| GeneralLedgerItemsAllocationPercentage | String | The GeneralLedgerItemsAllocationPercentage field of the EventOrderItems table. | |
| DiscountsId | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| DiscountsName | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| DiscountsCode | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| DiscountsType | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| DiscountsValue | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. | |
| DiscountsAmount | String | The GeneralLedgerItemsDescription field of the EventOrderItems table. |