ORDERREQUESTS | Data from Order Requests. |
Tenant | |
TenantGroup | This field to be used if multiple tenants are part of a singular group. |
Organization | |
OrganizationName | The name of the organization this order request is for |
OrderRequest | |
Notes | Notes left for this order request |
OrderRequestCreationDate | The date that the order request was created |
OrderRequestNumber | A venue unique number used to identify this order request |
OrderRequestStatus | The status of the order request, one of Open, Cancelled or Completed |
OrderRequestTotal | The total amount that the order request costs |
OrderRequestUpdatedDate | The last update date of the order request |
PaymentStatus | The payment status. One of NoOrdersYet, NotPaid, PartiallyPaid, PaidInFull or Refunded |
OrderRequestContact | |
ContactFirstName | The first name of the person that placed the order request |
ContactLastName | The last name of the person that placed the order request |
InternalContactFirstName | The first name of the person that will be approving the order request. |
InternalContactLastName | The last name of the person that will be approving the order request. |
OrderRequestItem | |
EventName | The Event instance created to an Order Request |
EventStartTime | The start time of the referenced Event on an Order Request |
EventTemplateName | The Event Template Name used to create the Event Instance for an Order Request |
ExternalReferenceId | A user input reference number for the Order Request |
OrderNumber | The Order number created by an Order Request |
EventTemplateCustomFields | |
EventTemplateCustomField1 | Custom field assigned to the event template. |
EventTemplateCustomField2 | Custom field assigned to the event template. |
EventTemplateCustomField3 | Custom field assigned to the event template. |
EventTemplateCustomField4 | Custom field assigned to the event template. |
EventTemplateCustomField5 | Custom field assigned to the event template. |
EventCustomFields | |
EventCustomField1 | Custom field assigned to the event. |
EventCustomField2 | Custom field assigned to the event. |
EventCustomField3 | Custom field assigned to the event. |
EventCustomField4 | Custom field assigned to the event. |
EventCustomField5 | Custom field assigned to the event. |
OrderRequestItemSummary | |
OrderRequestItemSummaryBalance | The balance of an item on a Order Request Summary |
OrderRequestItemSummarySubtotal | The subtotal of an item on a Order Request Summary |
OrderRequestItemSummaryTotal | The Total of an item on a Order Request Summary |
OrderRequestItemDetail | |
OrderRequestItemDetailDiscountedSubtotal | The total discounted price for this item |
OrderRequestItemDetailDiscountedUnitPrice | The discounted unit price for this item |
OrderRequestItemDetailsAddon | True if this is an add-on otherwise false |
OrderRequestItemDetailQuantity | The number of these items in the order request |
OrderRequestItemDetailSubtotal | The subtotal of these items before they are discounted |
OrderRequestItemDetailType | The type of item this is. One of Event, Inventory or Donation. |
OrderRequestItemDetailUnitPrice | The unit price, prior to any discount, per ticket for this item. |
Reporting Data Sources - Order Requests Data Set Print
Modified on: Tue, 2 Jul, 2019 at 12:20 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.