-- Create Table Statement for 'Elavon Chargeback Transaction'
DROP TABLE IF EXISTS `ELAVON_CHARGEBACK_TRANSACTION`;
CREATE TABLE `ELAVON_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CASE_ID varchar,
	ACCOUNT_NUMBER varchar,
	USAGE_CODE varchar,
	STATUS varchar,
	MERCHANT_NAME varchar,
	MERCHANT_ID varchar,
	FINANCIAL_ACTION_AMOUNT varchar,
	FINANCIAL_ACTION varchar,
	AMOUNT int(11),
	FINANCIAL_ACTION_DATE varchar,
	TRANSACTION_DATE varchar,
	RESPONSE_EXPIRATION varchar,
	DAYS_LEFT_TO_RESPOND varchar,
	REASON_CODE varchar,
	REASON_CODE_DESCRIPTION varchar,
	TICKET_NUMBER varchar,
	ELAVON_CHARGEBACK_BATCH_FK bigint(20),
	AUTHORIZATION_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	REASON_CODE varchar,
	REASON_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;