-- Create Table Statement for 'Amex Auth Retail Transaction'
DROP TABLE IF EXISTS `AMEX_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `AMEX_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE_IDENTIFIER varchar,
	BIT4 varchar,
	BIT3 varchar,
	BIT7 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT19 varchar,
	BIT22 varchar,
	BIT24 varchar,
	BIT25 varchar,
	BIT26 varchar,
	BIT27 varchar,
	BIT31 varchar,
	BIT32 varchar,
	BIT33 varchar,
	BIT37 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT43 varchar,
	BIT47 varchar,
	BIT48 varchar,
	BIT49 varchar,
	BIT56 varchar,
	BIT63 varchar,
	BIT4_AMOUNT varchar,
	BIT31_ACQUIRED_REFERENCE_DATA varchar,
	BIT38_APPROVAL_CODE varchar,
	BIT39_ACTION_CODE varchar,
	BIT44_ADDITIONAL_RESPONSE_DATA varchar,
	BIT54_ADDITIONAL_AMOUNTS varchar,
	BIT62_PRIVATE_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	TERMINAL_PIN_CAPABILITY varchar,
	TERMINAL_CATEGORY_CODE varchar,
	TERMINAL_CARD_CAPTURE_CAPABILITY varchar,
	ORIGIN varchar,
	MERCH_NBR varchar,
	RT_IND varchar,
	BIT55 varchar,
	BIT55_RESPONSE varchar,
	BIT61_AEVV varchar,
	ERROR_MESSAGE varchar,
	REGION varchar,
	BIT55 varchar,
	BIT55_RESPONSE varchar,
	BIT61_AEVV varchar,
	ERROR_MESSAGE varchar,
	REGION varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	BIT55 varchar,
	BIT55_RESPONSE varchar,
	BIT61_AEVV varchar,
	ERROR_MESSAGE varchar,
	REGION varchar,
	BIT60 varchar,
	BIT113 varchar,
	BIT60 varchar,
	BIT113 varchar,
	BIT60 varchar,
	BIT113 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;