-- Create Table Statement for 'Elavon EISOP Auth Retail Transaction'
DROP TABLE IF EXISTS `ELAVON_EISOP_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `ELAVON_EISOP_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	BIT3 varchar,
	BIT4 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT22 varchar,
	BIT24 varchar,
	BIT25 varchar,
	BIT28 varchar,
	BIT29 varchar,
	BIT32 varchar,
	BIT37 varchar,
	BIT38 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT43 varchar,
	BIT48 varchar,
	BIT49 varchar,
	BIT54 varchar,
	BIT55 varchar,
	BIT60 varchar,
	BIT4_RESPONSE varchar,
	BIT38_RESPONSE varchar,
	BIT39_RESPONSE varchar,
	BIT48_RESPONSE varchar,
	BIT55_RESPONSE varchar,
	BIT63_RESPONSE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BIT63_CVV_RESULT_CODE varchar,
	BIT63_AVS_RESULT_CODE varchar,
	BIT63_ACI varchar,
	BIT63_TRAN_ID varchar,
	BIT63_VALIDATION_CODE varchar,
	BIT63_TRACK_DATA_CONDITION_CODE varchar,
	BIT63_BANK_NET_DATE varchar,
	BIT63_PRODUCT_ID varchar,
	BIT63_UP_DATE_TIME varchar,
	BIT63_UP_SETTLEMENT_DATE varchar,
	BIT63_STAN varchar,
	BIT48_ELAVON_STAN varchar,
	BIT48_ELAVON_DATE_TIME varchar,
	BIT48_ELAVON_RETRIEVAL_REF_NUMBER varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	BIT63_AAV_COLLECTION_INDICATOR varchar,
	BIT63_UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	BIT60 varchar,
	BIT63_AAV_COLLECTION_INDICATOR varchar,
	BIT63_UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	BIT60 varchar,
	BIT63_AAV_COLLECTION_INDICATOR varchar,
	BIT63_UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	BIT53 varchar,
	BIT53 varchar,
	BIT53 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;