-- 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;