-- Create Table Statement for 'SNGB Auth Retail Transaction'
DROP TABLE IF EXISTS `SNGB_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `SNGB_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ACTION varchar,
	MEMBER varchar,
	ADDR varchar,
	ZIP varchar,
	AMT varchar,
	CURRENCY_CODE varchar,
	TRANS_ID varchar,
	TRACK_ID bigint(20),
	RESPONSE_RESULT varchar,
	RESPONSE_AUTH varchar,
	RESPONSE_REF varchar,
	RESPONSE_CARD_BALANCE varchar,
	RESPONSE_AVR varchar,
	RESPONSE_DATE varchar,
	RESPONSE_TRANS_ID varchar,
	RESPONSE_TRACK_ID varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PAYMENT_ID varchar,
	RESPONSE_CODE varchar,
	RESPONSE_ECI varchar,
	RESPONSE_ERROR_CODE_TAG varchar,
	RESPONSE_ERROR_TEXT varchar,
	RESPONSE_PAYMENT_ID varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RESPONSE_RESULT varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;