-- Create Table Statement for 'Vantiv Tandem Auth Retail Transaction'
DROP TABLE IF EXISTS `VANTIV_TANDEM_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `VANTIV_TANDEM_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	NETWORK_ROUTING varchar,
	MESSAGE_TYPE_IDENTIFIER varchar,
	BIT_MAP_TYPE varchar,
	BIT03 varchar,
	BIT04 varchar,
	BIT07 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT22 varchar,
	BIT25 varchar,
	BIT32 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT43 varchar,
	BIT60 varchar,
	BIT63 varchar,
	BIT65 varchar,
	BIT67 varchar,
	BIT70 varchar,
	BIT105 varchar,
	BIT106 varchar,
	BIT107 varchar,
	BIT109 varchar,
	BIT110 varchar,
	BIT111 varchar,
	BIT112 varchar,
	BIT115 varchar,
	BIT133 varchar,
	BIT134 varchar,
	BIT135 varchar,
	BIT136 varchar,
	BIT137 varchar,
	BIT37_RETRIEVAL_REFERENCE_NUMBER varchar,
	BIT65_AUTHORIZATION_IDENTIFICATION_RESPONSE varchar,
	BIT105_AVS_RESULT_CODE varchar,
	BIT105_PAYMENT_SERVICE_INDICATOR varchar,
	BIT105_TRANSACTION_IDENTIFIER varchar,
	BIT105_VISA_VALIDATION_CODE varchar,
	BIT120_BATCH_NUMBER varchar,
	BIT120_DEMO_MERCHANT_FLAG varchar,
	BIT120_CARD_TYPE varchar,
	BIT123_RESPONSE_CODE varchar,
	BIT123_ERROR_TEXT varchar,
	BIT124_WORKING_KEY varchar,
	BIT128_ADDITIONAL_AMOUNTS varchar,
	G009 varchar,
	G014 varchar,
	G015 varchar,
	G023 varchar,
	R001 varchar,
	R006 varchar,
	R007 varchar,
	R008 varchar,
	R999 varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	APPROVED_AMOUNT int(11),
	IS_DEBIT_TRANSACTION tinyint(1),
	BIT90 varchar,
	G001 varchar,
	R009 varchar,
	BIT04_AMOUNT varchar,
	G021 varchar,
	IS_REVERSAL_APPLIED tinyint(1),
	CHARGE_TRANSACTION_FK bigint(20),
	G034 varchar,
	R023 varchar,
	R025 varchar,
	R026 varchar,
	R027 varchar,
	G017 varchar,
	G008 varchar,
	G048 varchar,
	G012 varchar,
	G009 varchar,
	G012 varchar,
	G009 varchar,
	TRANSACTION_IDENTITY varchar,
	G012 varchar,
	TRANSACTION_IDENTITY varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;