-- Create Table Statement for 'PayFacto Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYFACTO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYFACTO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MESSAGE_CLASS varchar,
	TERMINAL_ID varchar,
	SEQUENCE_NUMBER varchar,
	TRAN_TYPE varchar,
	DATE_TIME_REQUEST varchar,
	POS_CARD_ENTRY_MODE varchar,
	FID_B varchar,
	FID_C varchar,
	FID_D varchar,
	FID_E1 varchar,
	FID_E2 varchar,
	FID_E3_RESPONSE varchar,
	FID_E4_RESPONSE varchar,
	FID_F varchar,
	FID_F_RESPONSE varchar,
	FID_E5 varchar,
	FID_K1 varchar,
	FID_K4 varchar,
	FID_K5_RESPONSE varchar,
	FID_P varchar,
	FID_S varchar,
	FID_X_RESPONSE varchar,
	FID_Y_RESPONSE varchar,
	FID_CS_RESPONSE varchar,
	FID_DS_RESPONSE varchar,
	FID_PS_F varchar,
	FID_SS_IS_MASTER_CARD tinyint(1),
	FID_SS1_RESPONSE varchar,
	FID_SS_IS_VISA tinyint(1),
	FID_SS2_RESPONSE varchar,
	FID_SS3_RESPONSE varchar,
	FID_SS_IS_AM_EX tinyint(1),
	FID_SS4_RESPONSE varchar,
	FID_SS5_RESPONSE varchar,
	FID_SS6_RESPONSE varchar,
	FID_SS_IS_DISCOVER tinyint(1),
	FID_E3 varchar,
	SEQUENCE_NUMBER_RESPONSE varchar,
	DATE_TIME_RESPONSE varchar,
	POS_STATUS_INDICATOR_RESPONSE varchar,
	POS_RESULT_CODE_RESPONSE varchar,
	FID_SS6 varchar,
	FID_I_RESPONSE varchar,
	FID_SS8_RESPONSE varchar,
	TRANSACTION_IDENTITY varchar,
	PARSE_ERRORS_WARNINGS varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;