-- Create Table Statement for 'STS Auth Retail Transaction'
DROP TABLE IF EXISTS `STS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `STS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_NUMBER varchar,
	TERMINAL_ID varchar,
	BUSINESS_TYPE varchar,
	ACTION_CODE varchar,
	TRANS_TYPE varchar,
	POS_ENTRY_MODE varchar,
	TRANSACTION_AMOUNT varchar,
	POINTS_AMOUNT varchar,
	TIP_AMOUNT varchar,
	TICKET varchar,
	AUTH_REFERENCE varchar,
	TRANSACTION_ID varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	ADDR1 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	PHONE1 varchar,
	EMAIL_ADDR varchar,
	RESPONSE_CODE varchar,
	RESPONSE_TEXT varchar,
	MISC_MESSAGE varchar,
	AMOUNT_BALANCE varchar,
	APPROVED_AMOUNT varchar,
	POINTS_BALANCE varchar,
	LIFE_POINTS_BALANCE varchar,
	TRANS_DATE_TIME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	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;