-- Create Table Statement for 'Taba Pay Auth Retail Transaction'
DROP TABLE IF EXISTS `TABA_PAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `TABA_PAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REFERENCE_ID varchar,
	CORRESPONDING_ID varchar,
	TYPE varchar,
	OWNER_FIRST_NAME varchar,
	OWNER_LAST_NAME varchar,
	OWNER_ADDRESS_LINE1 varchar,
	OWNER_ADDRESS_LINE2 varchar,
	OWNER_ADDRESS_CITY varchar,
	OWNER_ADDRESS_STATE varchar,
	OWNER_ADDRESS_ZIP_CODE varchar,
	OWNER_ADDRESS_COUNTRY varchar,
	OWNER_PHONE varchar,
	CURRENCY varchar,
	AMOUNT varchar,
	MEMO varchar,
	PULL_OPTIONS_RECURRING tinyint(1),
	PULL_OPTIONS3DS_ECI varchar,
	PULL_OPTIONS3DS_UCAF varchar,
	PULL_OPTIONS3DS_XID varchar,
	SC varchar,
	EC varchar,
	EM varchar,
	AVS_NETWORK_RC varchar,
	AVS_AUTHORIZE_ID varchar,
	AVS_RESULT_TEXT varchar,
	AVS_CODE_AVS varchar,
	AVS_CODE_SECURITY_CODE varchar,
	AVS_EC varchar,
	FEES_PULL_INTERCHANGE varchar,
	FEES_PULL_NETWORK varchar,
	FEES_PULL_TABAPAY varchar,
	FEES_PUSH_INTERCHANGE varchar,
	FEES_PUSH_NETWORK varchar,
	FEES_PUSH_TABAPAY varchar,
	TRANSACTION_ID varchar,
	NETWORK varchar,
	NETWORK_RC varchar,
	STATUS varchar,
	APPROVAL_CODE varchar,
	FEES_INTERCHANGE varchar,
	FEES_NETWORK varchar,
	FEES_TABAPAY varchar,
	ERRORS varchar,
	REVERSAL_STATUS varchar,
	REVERSAL_NETWORK_RC varchar,
	REVERSAL_ERROR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	TRANSACTION_TYPE varchar,
	CARD_PULL_ENABLED tinyint(1),
	CARD_PULL_NETWORK varchar,
	CARD_PULL_TYPE varchar,
	CARD_PULL_REGULATED tinyint(1),
	CARD_PULL_CURRENCY varchar,
	CARD_PULL_COUNTRY varchar,
	CARD_PUSH_ENABLED tinyint(1),
	CARD_PUSH_NETWORK varchar,
	CARD_PUSH_TYPE varchar,
	CARD_PUSH_REGULATED tinyint(1),
	CARD_PUSH_CURRENCY varchar,
	CARD_PUSH_COUNTRY varchar,
	CARD_PUSH_AVAILABILITY varchar,
	SOFT_DESCRIPTOR_ADDRESS_LINE1 varchar,
	SOFT_DESCRIPTOR_ADDRESS_LINE2 varchar,
	SOFT_DESCRIPTOR_NAME varchar,
	SOFT_DESCRIPTOR_ADDRESS_CITY varchar,
	SOFT_DESCRIPTOR_ADDRESS_COUNTRY varchar,
	SOFT_DESCRIPTOR_ADDRESS_ZIP_CODE varchar,
	SOFT_DESCRIPTOR_ADDRESS_STATE varchar,
	SOFT_DESCRIPTOR_PHONE_CODE varchar,
	SOFT_DESCRIPTOR_PHONE_NUMBER varchar,
	QUASI_CASH tinyint(1),
	SOFT_DESCRIPTOR_ADDRESS_COUNTY varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;