-- Create Table Statement for 'Retail Transaction'
DROP TABLE IF EXISTS `RETAIL_TRANSACTION`;
CREATE TABLE `RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	CAPTURE_AMOUNT int(11),
	CONFIRM varchar,
	VOID_TRANSACTION_CODE varchar,
	VOID_DATE datetime,
	VOID_TRANSACTION_MEMO varchar,
	TRANSACTION_INDUSTRY_CL varchar,
	CVV2_RESPONSE_CODE varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20) NOT NULL,
	REFUND_TRANSACTION_FK bigint(20),
	SUB_BATCH_FK bigint(20) NOT NULL,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;