-- Create Table Statement for 'HPG Auth Retail Transaction'
DROP TABLE IF EXISTS `HPG_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `HPG_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ORIGIN varchar,
	BASE_AMOUNT varchar,
	CONV_FEE_AMOUNT varchar,
	TOTAL_AMOUNT varchar,
	NAME_ON_CARD varchar,
	ADDRESS_LINE1 varchar,
	ZIP_CODE varchar,
	REFERENCE varchar,
	UNIQUE_ID varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	AUTH_CODE varchar,
	AUTH_REFERENCE varchar,
	BASE_AMOUNT_AUTHORIZED varchar,
	CONV_FEE_AMOUNT_AUTHORIZED varchar,
	TOTAL_AMOUNT_AUTHORIZED varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CITY varchar,
	STATE varchar,
	PHONE varchar,
	TRANSACTION_TYPE varchar,
	FEE_AMOUNT varchar,
	ACCOUNT_NUMBER varchar,
	CUSTOM_STRING001 varchar,
	CHARGE_TRANSACTION_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;