-- Create Table Statement for 'Mercury Pay Auth Retail Transaction'
DROP TABLE IF EXISTS `MERCURY_PAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MERCURY_PAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_ID varchar,
	OPERATOR_ID varchar,
	TRAN_TYPE varchar,
	TRAN_CODE varchar,
	INVOICE_NO varchar,
	REF_NO varchar,
	MEMO varchar,
	NAME varchar,
	AMOUNT_PURCHASE varchar,
	AMOUNT_AUTHORIZE varchar,
	CMD_STATUS varchar,
	USER_TRACE_DATA varchar,
	CARD_TYPE varchar,
	ACQ_REF_DATA varchar,
	PARTIAL_AUTH varchar,
	PROCESS_DATA varchar,
	CAPTURE_STATUS varchar,
	STATUS varchar,
	ADDRESS varchar,
	ZIP varchar,
	TAX varchar,
	CUSTOMER_CODE varchar,
	AVS_DATA varchar,
	AUTH_CODE varchar,
	AVS_RESPONSE varchar,
	TEXT_RESPONSE varchar,
	CVV_RESULT varchar,
	RESPONSE_ORIGIN varchar,
	DSIX_RETURN_CODE varchar,
	RETURN_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	AMOUNT_GRATUITY varchar,
	AMOUNT_CASHBACK varchar,
	RECORD_NO varchar,
	AMOUNT_BALANCE varchar,
	TERMINAL_ID varchar,
	AMOUNT_PRESCRIPTION varchar,
	VOUCHER_NUMBER 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;