-- Create Table Statement for 'FirstData OmniPay Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_OMNI_PAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_OMNI_PAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	BIT3 varchar,
	BIT4 varchar,
	BIT4_TRANSACTION_AMOUNT varchar,
	BIT7 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT14 varchar,
	BIT15 varchar,
	BIT15_SETTLEMENT_DATE varchar,
	BIT18 varchar,
	BIT19 varchar,
	BIT19_COUNTRY_CODE varchar,
	BIT22 varchar,
	BIT23 varchar,
	BIT25 varchar,
	BIT26 varchar,
	BIT32 varchar,
	BIT32_ACQUIRING_INSTITUTION_CODE varchar,
	BIT37 varchar,
	BIT38_AUTHORISATION_CODE varchar,
	BIT39_RESPONSE_CODE varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT43 varchar,
	BIT44 varchar,
	BIT44_ADDITIONAL_RESPONSE_DATA varchar,
	BIT44_MC_CVC2_RESULT_CODE varchar,
	BIT44_VISA_CVV_RESULT_CODE varchar,
	BIT44_VISA_CVV2_RESULT_CODE varchar,
	BIT44_VISA_ADDRESS_VERIFICATION_RESULT_CODE varchar,
	BIT44_DINERS_CVV_RESULT_CODE varchar,
	BIT49 varchar,
	BIT54_ADDITIONAL_AMOUNTS varchar,
	BIT60 varchar,
	BIT60_ADDITIONAL_DATA varchar,
	BIT61_CUSTOM_DATA varchar,
	BIT62 varchar,
	BIT62_CUSTOM_PAYMENT_SERVICE_DATA varchar,
	BIT63 varchar,
	BIT70 varchar,
	BIT90 varchar,
	BIT95 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BIT38 varchar,
	BIT39 varchar,
	BIT54 varchar,
	BIT60_ADDRESS_VERIFICATION_DATA varchar,
	BIT54_BALANCE varchar,
	BIT44_DINERS_NETWORK_REFERENCE_ID varchar,
	BIT44_MC_BANKNET_REFERENCE_NUMBER varchar,
	BIT62_MARKET_SPECIFIC_DATA_IDENTIFIER varchar,
	BIT62_TRANSACTION_IDENTIFIER varchar,
	BIT62_VALIDATION_CODE varchar,
	BIT62_PRODUCT_ID varchar,
	CLIENT_REF varchar,
	MERCHANT_ID varchar,
	TERMINAL_ID varchar,
	BIT60_UCAF varchar,
	CLIENT_REF varchar,
	CLIENT_REF varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;