This reference guide provides a comprehensive list of all available Payments data fields in Report Builder, including column names and detailed descriptions of what each field contains. Use this article to understand which Payments fields are available when building custom reports, what information each field represents, and how to select the right fields for your reporting needs. This resource helps you make informed decisions when configuring reports and ensures you're pulling the correct data.
Payments
| Column Name | What It Means |
| ControlID | The Visitor Centre that received this payment |
| ItineraryID | The overall trip/itinerary this payment applies to |
| BookingID | The specific booking this payment portion applies to |
| PaymentDate | The date the payment was made |
| PaymentTime | The time of day the payment was made |
| ReconciledDate | When the payment was reconciled/verified in accounting |
| PaymentBy | Who processed/accepted the payment |
| PaymentLocation | Where the payment was physically taken |
| PaymentType | How the customer paid |
| PaymentID | Unique identifier combining the payment and split |
| PaymentSplitDate | When this specific split was created/allocated |
| PaymentSplitTime | Time this specific split was created |
| Payment | The dollar amount allocated to this booking |
| ReceiptNumber | The receipt ID given to the customer |
| Description | Notes about the payment |
| PaymentGST | The GST/tax portion included in the payment |
| RawPayment | The total payment amount before splitting |
| ThePaymentId | The main payment record ID (database internal) |
| ThePaymentSplitId | The split allocation ID (database internal) |
| GatewayId | ID of the payment gateway used (if online payment) |
| GatewayGuid | Unique global identifier for the gateway |
| GatewayName | Name of the payment processor |
| SalePaymentId | Link to retail/point-of-sale payment (if applicable) |
| SaleItemVoucherId | Link to voucher sale (if payment was for purchasing a voucher) |
| GatewayTransactionNumber | Transaction ID from the payment gateway |
| GatewayPaymentType | Specific payment method used at the gateway |