Refund_Transactions

The table below describes the Refund_Transactions table.

This is a virtual table, and is linked to the Refunds table (see Refunds).

None of the columns in this table are nullable.

This table contains the following foldable column:

  • Refund_Id

This table does not contain Return Primary Key columns.

Column Name SQL Type Updatable

Refund_Id

Primary Key
Foreign Key linked to column Refund_Id in Refunds table
SQL_BIGINT(unsigned) True

Refund_Transactions_Index

Primary Key
SQL_INTEGER(unsigned) False

Refund_Transactions_Order_Id

Foreign Key linked to column Order_Id in Orders table
SQL_BIGINT(unsigned) False

Refund_Transactions_Amount

SQL_NUMERIC(38,2) False

Refund_Transactions_Authorization

SQL_VARCHAR(1024) False

Refund_Transactions_Created_At

SQL_TIMESTAMP False

Refund_Transactions_Currency

SQL_VARCHAR(1024) False

Refund_Transactions_Device_Id

SQL_BIGINT(unsigned) False

Refund_Transactions_Error_Code

SQL_VARCHAR(1024) False

Refund_Transactions_Gateway

SQL_VARCHAR(1024) False

Refund_Transactions_Id

SQL_BIGINT(unsigned) False

Refund_Transactions_Kind

SQL_VARCHAR(1024) False

Refund_Transactions_Parent_Id

SQL_BIGINT(unsigned) False

Refund_Transactions_Payment_Details_Avs_Result_Code

SQL_VARCHAR(1024) False

Refund_Transactions_Payment_Details_Credit_Card_Bin

SQL_VARCHAR(1024) False

Refund_Transactions_Payment_Details_Credit_Card_Company

SQL_VARCHAR(1024) False

Refund_Transactions_Payment_Details_Credit_Card_Number

SQL_VARCHAR(1024) False

Refund_Transactions_Payment_Details_Cvv_Result_Code

SQL_VARCHAR(1024) False

Refund_Transactions_Receipt_Authorization

SQL_BIGINT(unsigned) False

Refund_Transactions_Receipt_Testcase

SQL_BIT False

Refund_Transactions_Source_Name

SQL_VARCHAR(1024) False

Refund_Transactions_Status

SQL_VARCHAR(1024) False

Refund_Transactions_Test

SQL_BIT False

Refund_Transactions_User_Id

SQL_BIGINT(unsigned) False