| created_at | TIMESTAMP_NTZ | Date when Payment has been created. |
| updated_at | TIMESTAMP_NTZ | Date when latest payment event has happened. |
| timezone | VARCHAR | Timezone in which the session happened. |
| merchant_id | VARCHAR | Unique identifier of the merchant. |
| workspace_id | VARCHAR | Workspace identifier mapped from the merchant, used for Payrails reporting. |
| payrails_payment_id | VARCHAR | Unique identifier of the Payment in Payrails. |
| payrails_execution_id | VARCHAR | Unique identifier of the execution. |
| holder_id | VARCHAR | ID of the payer (holder). |
| merchant_reference | VARCHAR | Payment reference provided by the merchant. |
| provider_name | VARCHAR | Provider who processed the payment. |
| provider_account_name | VARCHAR | Provider account display name. |
| provider_reference | VARCHAR | Unique identifier of the Payment in an external system, e.g. PSP. |
| is_zero_auth | BOOLEAN | If payment is zero authorization. |
| status | VARCHAR | Final status of the payment. |
| is_authorized | BOOLEAN | If payment was authorized. |
| authorization_failure_result | VARCHAR | Transformed authorization failure response code, provides more details on failed transactions than status. |
| processing_type | VARCHAR | Payment processing type, values: Regular, Subscription, CardOnFile, UnscheduledCardOnFile |
| currency | VARCHAR | Three-letter ISO currency code, in uppercase. |
| amount | NUMBER | Payment amount in local currency. |
| captured_amount | NUMBER | Amount that was captured from the Payment in local currency. If no capture is initiated for the payment, the value will be 0 until a successful capture occurs. |
| refunded_amount | NUMBER | Amount that was refunded from the Payment in local currency. If multiple partial refunds have been made, this will be the sum of them. If no refund is initiated for the payment, the value will remain 0 until a successful refund occurs. |
| has_threeds | BOOLEAN | Whether payment went through 3ds. |
| threeds_id | VARCHAR | Unique identifier of the associated 3ds object. |
| eci | VARCHAR | Electronic commerce indicator |
| payment_method_type | VARCHAR | Payment method type, values: card, easypaisa, jazzCash, fawryPay, etc. |
| bin | NUMBER | First 6-8 digits of the Card number. Also known as IIN (Issuer Identification Number). Card only. |
| issuer | VARCHAR | Card issuing bank. |
| issuer_country_code | VARCHAR | ISO alpha-2 issuer country. |
| issuer_country_name | VARCHAR | English name of the country of the bank or institution that issued the card. Card only. |
| card_network | VARCHAR | Card network that supports the card, e.g. Visa, Mastercard, American Express. Card only. |
| card_local_network | VARCHAR | Card local network that supports the card, e.g. CartesBancaires, Dankort, Mada, Bancontact. |
| card_segment | VARCHAR | Segment of the card, e.g. gold, black, business. Card only. |
| card_type | VARCHAR | Card type, values: credit, debit, notset, prepaid. |
| card_type_details | VARCHAR | More information about the card type, e.g. personal, commercial. Card only. |
| token_id | VARCHAR | Instrument Token ID related to the payment. |
| token_type | VARCHAR | Type of the token, values: network, vault, psp, networkOffers. |
| error_reason_source | VARCHAR | Source of the error reason (null if payment was successful). |
| error_reason_detail | VARCHAR | Details of the error reason (null if payment was successful). |
| error_reason_result | VARCHAR | End result of the error reason (null if payment was successful). |
| error_reason_category | VARCHAR | Category of error reason (null if payment was successful). |
| error_detail | VARCHAR | Details of the error (null if payment was successful). |
| is_success | BOOLEAN | Whether execution action was succeeded. |
| milliseconds_to_completion | NUMBER | Time from request to completion in milliseconds. |
| raw_psp_response | VARIANT | PSP result details for Authorize operation. |
| meta | VARIANT | Complete merchant’s metadata details (ex: customer, order, risk, tags, etc.). |
