The Ticket Payments dataset contains all relevant details about the payments applied to tickets including details about the payment type and provider.
Primary Key: org_id, store_id, ticket_id, payment_id, sale_type
| Column | Description |
|---|---|
| store_id | The unique identifier for each store |
| org_id | The unique identifier for each retail organization |
| org_name | The name of the organization |
| store_name | The name of the store where the sale was made |
| selltreez_url | The URL of the SellTreez Point of Sale |
| store_state | The US state where the store is located |
| store_timezone | The timezone in which the store operates |
| datalake_store_id | The store identifier used in a legacy Treez data system |
| date_open | The timestamp indicating when a ticket was opened |
| date_close | The timestamp indicating when a transaction was closed |
| store_tz_offset | The timezone offset of the store |
| ticket_number | The unique number assigned to each ticket |
| ticket_id | The unique identifier of a Ticket or Sale |
| sale_type | Denotes whether the ticket was sale or a return |
| order_channel | The channel through which the order was made |
| revenue_source | The source of an eCommerce order |
| cash_drawer_id | The unique identifier for the cash drawer associated with the ticket payment |
| cash_drawer_name | The name associated with the cash drawer |
| ticket_cashier_user_id | The unique identifier of the cashier who processed the ticket |
| ticket_cashier_shift_id | The unique identifier of the cashier’s shift |
| ticket_cashier_name | The name of the cashier |
| payment_id | The unique identifier for the payment associated with the ticket |
| payment_type_id | The unique identifier for the type of payment used |
| payment_type_name | The name of the payment type used for the transaction |
| provider_id | The unique identifier for the payment provider |
| provider_name | The name of the payment service provider |
| refund_flag | A numeric flag indicating whether the payment was a refund (1 for refund, 0 for regular payment) |
| original_payment | The original amount of the payment before any change given |
| change_given | The amount of change given to the customer after the payment |
| gross_receipts_paid | The total amount paid via the associated payment type on the associated ticket |
| payment_fee_amount | The payment fee amount associated with the payment |
| processor_fee_amount | The processor fee amount associated with the payment |
| processor_tip_amount | The processor tip amount associated with the payment |
| last_sync | A timestamp field that records the last time the data was synchronized into the Treez Data Warehouse |
| record_loaded_at | The timestamp when the record in the database was last updated |