-- Create Table Statement for 'Chargeback Transaction'
DROP TABLE IF EXISTS `CHARGEBACK_TRANSACTION`;
CREATE TABLE `CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	RESPONSE_DATE datetime,
	TRANSACTION_CL varchar,
	CHARGEBACK_CL varchar,
	SEQUENCE_NUMBER int(11),
	CALLBACK_DATE datetime,
	PROVIDER_DATE datetime,
	BANK_DATE datetime,
	DEPOSIT_DATE datetime,
	CUSTOM_FIELD varchar,
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_PERCENTAGE_FEE int(11),
	INTERCHANGE_FLAT_FEE int(11),
	INTERCHANGE_FEE_AMOUNT int(11),
	ASSESSMENTS_FEE_AMOUNT int(11),
	PROCESSOR_FEE_AMOUNT int(11),
	PROCESSING_FEE_AMOUNT int(11),
	FLAT_FEE_AMOUNT int(11),
	AGGREGATE_TRANSACTION_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	AMOUNT int(11),
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	IS_AGGREGATE_TRANSACTION tinyint(1),
	SUBMISSION_FK bigint(20),
	ORIGINAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	NOC_TRANSACTION_FK bigint(20),
	SECOND_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGEBACK_CASE_FK bigint(20),
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	TRANSACTION_TYPE varchar,
	TRANSACTION_TYPE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	CASE_NUMBER varchar,
	CASE_NUMBER varchar,
	FILE_STORE_CODE bigint(20),
	FILE_STORE_CODE bigint(20),
	TRANSACTION_TYPE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	CASE_NUMBER varchar,
	FILE_STORE_CODE bigint(20),
	SUBMISSION_FK bigint(20),
	ORIGINAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	AGGREGATE_TRANSACTION_FK bigint(20),
	TEST int(11),
	SUBMISSION_FK bigint(20),
	ORIGINAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	AGGREGATE_TRANSACTION_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	INTERCHANGE_RATE_NAME varchar,
	FEE_AMOUNT int(11),
	FEE_AMOUNT int(11),
	FEE_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;