-- Create Table Statement for 'FirstData BuyPass Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_BUY_PASS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_BUY_PASS_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,
	BIT18 varchar,
	BIT22 varchar,
	BIT32 varchar,
	BIT37 varchar,
	BIT38 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT54 varchar,
	BIT58 varchar,
	BIT60 varchar,
	BIT63 varchar,
	BIT111 varchar,
	BIT123 varchar,
	BIT4_APPROVED_AMOUNT varchar,
	BIT15_SETTLEMENT_DATE varchar,
	BIT38_AUTHORIZATION_CODE varchar,
	BIT39_RESPONSE_CODE varchar,
	BIT54_ADDITIONAL_AMOUNT varchar,
	BIT111_ADDITIONAL_EBT_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MESSAGE_TYPE varchar,
	BIT48 varchar,
	BIT90 varchar,
	BIT44_ADDITIONAL_RESPONSE_DATA varchar,
	BIT123_ADDRESS_VERIFICATION varchar,
	BIT126_ISSUER_TRACE_DATA varchar,
	BIT126_CVV2_RESPONSE_CODE varchar,
	BIT40 varchar,
	CLIENT_REF 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;