Complete list of Detail report columns

More than 30 System fields and all Custom fields from the Fields library can be added to any Detail report. 

This article gives you a list of all of the System fields that can be added to Detail reports. To customize the display columns in the Detail report, click the Display columns button. 

Booking data

  • Meeting date and time in Customer's time zone: The booking date and time of a scheduled meeting in the Customer’s time zone. The field returns the meeting date, start time and end time. For example, Monday Jan 6, 2019, 11:30 AM - 12:00 PM.
  • Meeting date and time in Owner's time zone: The booking date and time of a scheduled meeting in the Booking owner’s time zone. The field returns the meeting date, start time and end time. For example, Monday Jan 6, 2019, 11:30 AM - 12:00 PM.
  • Starting date and time in Customer's time zone: The start date and time of a scheduled meeting in the Customer’s time zone. The field returns the meeting date, start time. For example, Monday Jan 6, 2019 at 11:30 AM.
  • Starting date and time in Owner's time zone: The start date and time of a scheduled meeting in the Booking owner's time zone. The field returns the meeting date, start time. For example Monday Jan 6, 2019 at 11:30 AM.
  • Duration: The meeting duration (in hours or minutes). For example, 15 min or 3 hrs.
  • Subject/Event type: The subject of the meeting. This field can show the subject set by the Owner or by the Customer. For example, "Product demo". If Event types are used, the name of the Event type is the subject.
  • Status: The status of the activity. This field shows the following states: Requested, Scheduled, Rescheduled, Completed, No-show or Canceled.
  • Last updated: The date and time of the last change made to the activity. For example, it can display the date and time when the booking was approved. E.g. Wednesday Jan 1, 2019 at 10:33 PM.
  • Virtual or Physical location: The Meeting location information set for the meeting. It can display virtual conferencing information, face-to-face location information, or it can be left empty.
  • Zoom, Google Meet, Microsoft Teams, GoToMeeting, or Webex Meetings link: The Zoom, Google Meet, Microsoft Teams, GoToMeeting, or Webex Meetings link used for connecting to the virtual meeting.
  • Booking calendar: The main booking calendar that the booking was created in.
  • Additional booking calendar: The additional calendars that the booking is created in.
  • Number of sessions: The number of sessions in a Session package that were scheduled or canceled by Customer or User.
  • Creation date and time in UTC: The date and time when the activity was first created in UTC. For example, Sun Jan 5, 2019 at 05:06 AM
  • Tracking ID:  A unique ID automatically assigned to every OnceHub booking.
  • Package ID: A unique ID automatically assigned to every OnceHub Session package.
  • Booking mode: The booking mode selected for the meeting. This field shows Automatic booking or Booking with approval.

Customer data

  • Customer name: The name provided by the Customer in the Booking form when booking.
  • Customer email: The email address provided by the Customer in the Booking form when booking.
  • Customer company: The company name provided by the Customer in the Booking form when booking.
  • Customer phone: The phone number provided by the Customer in the Booking form when booking.
  • Customer mobile phone: The mobile phone number provided by the Customer in the Booking form when booking.
  • Customer note: The note provided by the Customer in the Booking form when booking.
  • Customer time zone: The time zone selected by the Customer at the time of the booking.

Booking page data

  • Booking page name: The Customer-facing name of the Booking page used to make the booking.
  • Booking page label: The internal name of the Booking page used to make the booking.
  • Booking page link: The URL of the Booking page used to make the booking.
  • Booking page time zone: The Booking page time zone as defined in the Overview section of your Booking page.
  • Booking page Owner: Displays the Booking page Owner name. To edit this name, click your profile image or initials, and select Profile -> Personal details.
  • Editors: This field lists the Editors assigned to the Booking page. Each Editor name can be edited in the Editor’s account by clicking on their profile image or initials, and selecting Profile -> Personal details.
  • Booking page category: The category that the Booking page has been assigned to.
  • Master page name: The Customer-facing name of the Master page used to make the booking.
  • Master page label: The internal name of the Master page used to make the booking.
  • Master page link: The URL of the Master page used to make the booking.

Event type data

Cancel/reschedule data

  • Name of User who canceled/rescheduled: The name of the User who performed the cancel or reschedule action.
  • Name of Customer who canceled/rescheduled: The name of the Customer who performed the cancel or reschedule action.
  • Cancel/reschedule reason: The reason given for canceling or rescheduling a meeting.

CRM data

  • Infusionsoft Contact: A link to the Infusionsoft Contact of the Customer who made the booking.
  • Salesforce Lead: A link to the Salesforce Lead record of the Customer who made the booking.
  • Salesforce Contact: A link to the Salesforce Contact record of the Customer who made the booking.
  • Salesforce Case: A link to the Salesforce Case record of the Customer who made the booking.
  • Salesforce Activity: A link to the Salesforce Activity of the Customer who made the booking.

Payment data  

The system fields listed below can only be added to Revenue reports. This is because Payment data fields are itemized per transaction, while all other types of System fields are itemized per activity.

  • Invoice number: A unique number identifying each Customer invoice generated via Payment integration
  • Payment transaction date: The date a payment was made.
  • PayPal transaction ID: The ID of the transaction in PayPal. 
  • PayPal parent transaction ID: The ID of the transaction in PayPal that a refund was made from.
  • Relative cost: The cost of each individual session in a Session package. This is the total package cost divided by the number of sessions in the package.
  • Amount refunded: The value of a refund transaction.
  • Amount received: The value of a payment transaction.
  • Transaction status: The current status of the transaction: Paid, Refunded, or Pending.
  • Refund transaction date: The date a refund was processed.
  • Transaction type: Any of the following monetary transactions: PAYMENT (SCHEDULE), PAYMENT (RESCHEDULE), AUTOMATIC REFUND (CANCELLATION), MANUAL REFUND VIA ONCEHUB, MANUAL REFUND VIA PAYPAL.
  • Payment account email address: The Customer's email address of the PayPal account, or the email address the Customer provided when paying with a credit/debit card for bookings made via OnceHub. For example, john@example.com.
  • Refund reason: The reason given by the User for issuing a refund. 
  • Name of User who processed a manual refund: The name of the User who processed a manual refund via the Activity stream.
Was this article helpful?
Thank you for your feedback!