-- Create Table Statement for 'UniPay Auth Retail Transaction'
DROP TABLE IF EXISTS `UNI_PAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `UNI_PAY_AUTH_RETAIL_TRANSACTION` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
REQUEST_TYPE varchar,
PROVIDER_MERCHANT_ACCOUNT_CODE int(11),
ACCOUNT_TYPE varchar,
HOLDER_NAME varchar,
HOLDER_TYPE varchar,
AMOUNT int(11),
TRANSACTION_INDUSTRY_TYPE varchar,
TRANSACTION_MODE_TYPE varchar,
DESCRIPTOR varchar,
SHIPPING_NAME varchar,
TIP_AMOUNT int(11),
RESPONSE_TYPE varchar,
RESPONSE_TRANSACTION_DATE varchar,
RESPONSE_AMOUNT varchar,
RESPONSE_ORIGINAL_AMOUNT varchar,
RESPONSE_CASHBACK_AMOUNT varchar,
RESPONSE_BALANCE varchar,
RESPONSE_EBT_FOOD_STAMP_BALANCE varchar,
RESPONSE_EBT_CASH_BENEFIT_BALANCE varchar,
RESPONSE_REFERENCE_NUMBER varchar,
RESPONSE_PROVIDER_REFERENCE_NUMBER varchar,
RESPONSE_APPROVAL_CODE varchar,
RESPONSE_TOKEN varchar,
RESPONSE_EXTENDED_ACCOUNT_TYPE varchar,
RESPONSE_CYCLE_CODE varchar,
WARNING_CODE varchar,
RESPONSE_CODE varchar,
RESPONSE_MESSAGE varchar,
PROVIDER_RESPONSE_CODE varchar,
PROVIDER_RESPONSE_MESSAGE varchar,
AVS_RESPONSE_CODE varchar,
PROVIDER_AVS_RESPONSE_CODE varchar,
CSC_RESPONSE_CODE varchar,
PROVIDER_CSC_RESPONSE_CODE varchar,
ERROR_CODE varchar,
ERROR_MESSAGE varchar,
FAILURE_CODE varchar,
FAILURE_MESSAGE varchar,
FAILED_REQUEST_TYPE varchar,
EXCEPTION_PROCESSOR varchar,
EXCEPTION_CAUSE varchar,
EXCEPTION_LEVEL varchar,
EXCEPTION_HINT varchar,
EXCEPTION_FORMAT varchar,
EXCEPTION_FIELD varchar,
EXCEPTION_VALUE varchar,
CHARGE_TRANSACTION_FK bigint(20),
RETAIL_TRANSACTION_CYCLE_FK bigint(20),
REFERENCE_NUMBER varchar,
TRANSACTION_CODE varchar,
IS_PARTIAL_AUTHORIZATION varchar,
TOKEN varchar,
TRANSACTION_DATE varchar,
RESPONSE_REMAINING_AMOUNT varchar,
RESPONSE_FEE_AMOUNT varchar,
RESPONSE_ACCOUNT_ACCESSORY varchar,
SPLIT_SCHEMA_FK bigint(20),
SPLIT_SCHEMA_FK bigint(20),
RESPONSE_CODE varchar,
RESPONSE_CODE varchar,
SPLIT_SCHEMA_FK bigint(20),
DESCRIPTOR varchar,
DESCRIPTOR varchar,
RESPONSE_NETWORK_TRANSACTION_ID varchar,
RESPONSE_NETWORK_TRANSACTION_ID varchar,
RESPONSE_NETWORK_TRANSACTION_ID varchar,
RETAIL_TRANSACTION_CYCLE_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
RETAIL_TRANSACTION_CYCLE_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;