guest_payments
Payment records with status, payment method, and booking linkage.
| Column | Description |
|---|---|
id |
Unique identifier for the payment |
status |
Canceled, failed, success, due |
paid_at |
DEPRECATED |
should_be_paid_at |
DEPRECATED |
amount |
The amount paid by the guest |
guest_id |
DEPRECATED |
currency |
The currency paid by the user |
external_payment_id |
The external ID for the payment, not always populated |
booking_id |
The ID of the booking |
created_at |
The UTC date, including time, when this was created |
updated_at |
The UTC date, including time, when this row was updated |
source |
Empty if no source. ‘unknown’ if unknown. ‘channel_booking’ if from a channel. ‘scheduled_collection’, ‘myvr_dashboard’ |
mode |
Null/empty when unknown. ‘processed’, ‘recorded’, or ‘third-party’ |
payment_method |
cash, card, bank_transfer, other… |
card_type |
The type of card, only populated if payment_method is card |
card_last_four |
Last 4 digits of the card if payment_method is card |
card_first_six |
DEPRECATED |
exp_month |
Expiry month for card when payment_method is card |
exp_year |
Expiry year for card when payment_method is card |
name_on_card |
The name on the card, not always populated |
payment_gateway_id |
The ID of the payment gateway (numeric or UUID) |
payment_gateway_token |
The token or the gateway |
current_balance |
DEPRECATED |
exp_day |
DEPRECATED |
effective_date |
The effective date for this payment, in YYYY-MM-DD. Can also be empty |
payment_reference |
The reference for the payment |
created_by_id |
The user ID that created this payment |
label |
invoice_payment, downpayment, reservation, cancellation, other_charge, or refund |
processed_at |
The UTC, including time, when this payment was processed |
process_error |
If there is an error this is populated |
refunded_payment_id |
DEPRECATED |
payout_method |
Empty, other, bank_transfer, vcc, card |
payout_source |
Empty, ‘expedia’, ‘booking.com’, or ‘guest’ |
hidden |
DEPRECATED |
tokenized_card_number |
The tokenized card number, used very infrequently |
payment_request_id |
The ID of the payment request |
invoice_uuid |
A unique UUID for the invoice related to this payment |
payer_token |
A unique token for the payer, or empty |
booking_context_id |
The ID of the booking context |
timestamp |
Date when the table was last synchronized |