-- Create Table Statement for 'Westpac Auth Retail Transaction'
DROP TABLE IF EXISTS `WESTPAC_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `WESTPAC_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ORDER_TYPE varchar,
	CARD_CARD_HOLDER_NAME varchar,
	ORDER_AMOUNT int(11),
	CUSTOMER_ORDER_NUMBER bigint(20),
	CARD_CURRENCY varchar,
	ORDER_ECI varchar,
	CUSTOMER_ORIGINAL_ORDER_NUMBER bigint(20),
	ORDER_AUTH_ID varchar,
	CUSTOMER_CUSTOMER_REFERENCE_NUMBER varchar,
	ORDER_IP_ADDRESS varchar,
	RESPONSE_SUMMARY_CODE varchar,
	RESPONSE_RESPONSE_CODE varchar,
	RESPONSE_TEXT varchar,
	RESPONSE_RRN varchar,
	RESPONSE_SETTLEMENT_DATE varchar,
	RESPONSE_PREVIOUS_TXN varchar,
	RESPONSE_REFERENCE_NO varchar,
	RESPONSE_CARD_SCHEME_NAME varchar,
	RESPONSE_CREDIT_GROUP varchar,
	RESPONSE_TRANSACTION_DATE varchar,
	RESPONSE_AUTH_ID 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;