-- Create Table Statement for 'MasterCard Auth Retail Transaction'
DROP TABLE IF EXISTS `MASTER_CARD_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MASTER_CARD_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BIT3 varchar,
	BIT4 varchar,
	BIT5 varchar,
	BIT6 varchar,
	BIT7 varchar,
	BIT9 varchar,
	BIT10 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT15 varchar,
	BIT16 varchar,
	BIT18 varchar,
	BIT20 varchar,
	BIT22 varchar,
	BIT23 varchar,
	BIT28 varchar,
	BIT32 varchar,
	BIT33 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT43 varchar,
	BIT49 varchar,
	BIT50 varchar,
	BIT51 varchar,
	BIT53 varchar,
	BIT54 varchar,
	BIT55 varchar,
	BIT60 varchar,
	BIT61 varchar,
	BIT63 varchar,
	BIT90 varchar,
	BIT91 varchar,
	BIT92 varchar,
	BIT112 varchar,
	BIT120 varchar,
	BIT37_RETRIEVAL_REFERENCE_NUMBER varchar,
	BIT38_AUTHORIZATION_ID_RESPONSE varchar,
	BIT39_RESPONSE_CODE varchar,
	BIT44_ADDITIONAL_RESPONSE_DATA varchar,
	BIT48_AVS_RESPONSE_CODE varchar,
	BIT48_CVV_RESPONSE_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MESSAGE_TYPE varchar,
	BIT48_AVS_REQUEST 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;