-- Create Table Statement for 'Moneris ISO Auth Retail Transaction'
DROP TABLE IF EXISTS `MONERIS_ISO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MONERIS_ISO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DPC_NUMBER varchar,
	MESSAGE_TYPE varchar,
	BIT03 varchar,
	BIT04 varchar,
	BIT07 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT17_RESPONSE varchar,
	BIT22 varchar,
	BIT37 varchar,
	BIT38 varchar,
	BIT39_RESPONSE varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT44 varchar,
	BIT46 varchar,
	BIT48 varchar,
	BIT54 varchar,
	BIT54_RESPONSE varchar,
	BIT55 varchar,
	BIT55_RESPONSE varchar,
	BIT56 varchar,
	BIT57 varchar,
	BIT58 varchar,
	BIT58_RESPONSE varchar,
	BIT60 varchar,
	BIT61_RESPONSE varchar,
	BIT63 varchar,
	BIT64 varchar,
	BIT91 varchar,
	BIT95 varchar,
	BIT104_RESPONSE varchar,
	BIT114 varchar,
	BIT116 varchar,
	BIT117 varchar,
	BIT118 varchar,
	BIT119 varchar,
	BIT122_RESPONSE varchar,
	BIT123 varchar,
	BIT124 varchar,
	BIT126 varchar,
	BIT127 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BIT38_RESPONSE varchar,
	BIT37_RESPONSE varchar,
	BIT48_RESPONSE_CODE varchar,
	BIT116_RESPONSE varchar,
	BIT04_RESPONSE varchar,
	BIT57_RESPONSE varchar,
	BIT122_TRANSACTION_ID varchar,
	BIT56_RESPONSE varchar,
	BIT122_BANK_DATE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;