-- Create Table Statement for 'Bancomer Auth Retail Transaction'
DROP TABLE IF EXISTS `BANCOMER_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `BANCOMER_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BIT3 varchar,
	BIT4 varchar,
	BIT7 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT15 varchar,
	BIT17 varchar,
	BIT22 varchar,
	BIT23 varchar,
	BIT25 varchar,
	BIT32 varchar,
	BIT37 varchar,
	BIT38 varchar,
	BIT39 varchar,
	BIT41 varchar,
	BIT48 varchar,
	BIT49 varchar,
	BIT54 varchar,
	BIT58 varchar,
	BIT60 varchar,
	BIT63 varchar,
	BIT70 varchar,
	BIT90 varchar,
	BIT37_RETRIEVAL_REFERENCE_NUMBER varchar,
	BIT38_AUTHORIZATION_IDENTIFICATION_RESPONSE varchar,
	BIT39_RESPONSE_CODE varchar,
	BIT55_DATA_OF_INTEGRATED_CIRCUIT_CARD varchar,
	BIT63_POS_ADDITIONAL_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MESSAGE_TYPE varchar,
	ISO_HEADER varchar,
	BIT15_SETTLEMENT_DATE varchar,
	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;