-- Create Table Statement for 'Fi Serv Batch Transaction'
DROP TABLE IF EXISTS `FI_SERV_BATCH_TRANSACTION`;
CREATE TABLE `FI_SERV_BATCH_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	ROUTING_TRANSIT_CHECK_DIGIT varchar,
	TRANSACTION_AMOUNT varchar,
	CUSTOMER_ID_NUMBER varchar,
	CUSTOMER_NAME varchar,
	CUSTOMER_ADDRESS varchar,
	CUSTOMER_CITY varchar,
	CUSTOMER_STATE varchar,
	CUSTOMER_ZIP varchar,
	MC_VISA_RATE_NAME varchar,
	EXCEPTION_REASON_CODE varchar,
	RETURN_REASON_CODE varchar,
	EFFECTIVE_DATE varchar,
	FI_SERV_BATCH_FK bigint(20),
	RETURN_TRANSACTION_CODE varchar,
	RESPONSE_TYPE varchar,
	NOC_REASON_CODE varchar,
	SEQUENCE_NUMBER varchar,
	FI_SERV_BATCH_PROVIDER_CHARGE_TRANSACTIONS_IDX int(11),
	CHARGE_TRANSACTION_FK bigint(20),
	CLIENT_TRANSACTION_CODE varchar,
	CLIENT_TRANSACTION_CODE varchar,
	RAW_RESPONSE_CODE varchar,
	RAW_RESPONSE_CODE varchar,
	CLIENT_TRANSACTION_CODE varchar,
	RAW_RESPONSE_CODE varchar,
	FI_SERV_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	FI_SERV_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;