Description:
Captures all attempts to process payments within the Wunder platform. Each row represents a distinct payment processing attempt—successful, failed, refunded, or disputed. Attempts may originate from different payment sources and configurations.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the payment attempt. |
payment_id |
NUMBER | Reference to the primary payment this attempt belongs to. |
pgs_config_id |
TEXT | Payment Gateway Service configuration used for this attempt. |
state |
NUMBER | Current state of the payment attempt (0 => CREATED, 1 => WAITING, 2 => IN_PAYMENT, 3 => PAID, 4 => DISPUTED, 5 => UNSUCCESSFUL, 6 => EXCEPTION_PAYMENT, 7 => EXCEPTION_NOTIFICATION, 8 => PUSH_WAITING_FOR_USER, 9 => PUSH_CANCELLED_BY_USER, 10 => PUSH_BANK_REFUSED, 11 => REFUNDED, 12 => NOTIFIED, 13 => DISPUTE_LOST). |
state_name |
TEXT | String label for state. |
type |
NUMBER | Type of the payment method used for the attempt (0 => SEPA, 1 => CC, 2 => UNKNOWN, 3 => IDEAL, 4 => SOFORT, 5 => BANCONTACT, 6 => APAYA, 7 => PAYPAL, 8 => APPLEPAY, 9 => GOOGLEPAY, 10 => NO_PAYMENT_SOURCE, 11 => GENERIC_PUSH). |
type_name |
TEXT | String label for type. |
source_id |
TEXT | ID of the payment source used (e.g., card, wallet). |
charge_id |
TEXT | External charge identifier from the Payment Gateway. |
refund_id |
TEXT | ID of the refund record, if this attempt resulted in a refund. |
is_refund |
BOOLEAN | Indicates whether this attempt is a refund. |
is_notified |
BOOLEAN | Indicates whether a notification about this attempt was sent (e.g., to user or admin). |
error |
TEXT | Short technical error code or reason for failure. |
error_message |
TEXT | Human-readable error message providing more detail on the failure. Sparsely populated — frequently null even for failed attempts. |
payment_data |
TEXT | Structured data returned by the payment gateway (e.g., transaction metadata, response codes), stored as serialized text. |
reference |
TEXT | External or internal reference associated with the payment attempt. |
brand |
TEXT | Brand of the payment method used. |
amount |
NUMBER | Amount involved in the payment attempt. |
wait_until |
TIMESTAMP_NTZ | Indicates when the next retry attempt (if any) should be made. |
disputed_at |
TIMESTAMP_NTZ | Timestamp when the payment attempt was marked as disputed, if applicable. |
created_at |
TIMESTAMP_TZ | Timestamp when the payment attempt was initiated. |
updated_at |
TIMESTAMP_TZ | Timestamp when the record was last updated. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |