-- Create Table Statement for 'Chargeback Case'
DROP TABLE IF EXISTS `CHARGEBACK_CASE`;
CREATE TABLE `CHARGEBACK_CASE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	LAST_UPDATE_DATE datetime,
	CASE_CODE varchar,
	BANK_ISSUED_DATE datetime,
	PROCESSOR_RECEIVED_DATE datetime,
	PROCESSOR_MERCHANT_NUMBER varchar,
	ACTIVITY_CL varchar,
	CYCLE_CL varchar,
	PROCESSOR_TRANSACTION_CODE varchar,
	MERCHANT_TRANSACTION_CODE varchar,
	ORDER_CODE varchar,
	CARD_NUMBER_LAST4 varchar,
	BANK_CARD_CL varchar,
	CHARGEBACK_AMOUNT int(11),
	CHARGEBACK_CURRENCY varchar,
	ORIGINAL_TRANSACTION_DATE datetime,
	CHARGEBACK_TYPE varchar,
	REPRESENTED_AMOUNT int(11),
	PRE_ARBITRATION_AMOUNT int(11),
	SETTLEMENT_AMOUNT int(11),
	REPRESENTED_CURRENCY varchar,
	PRE_ARBITRATION_CURRENCY varchar,
	PROCESSOR_RESPONSE_CODE varchar,
	PROCESSOR_RESPONSE_MESSAGE varchar,
	SETTLEMENT_CURRENCY varchar,
	FRAUD_NOTIFICATION_STATUS varchar,
	FRAUD_NOTIFICATION_DATE datetime,
	RETRIEVAL_REQUEST_CL varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	REPLY_BY_DATE datetime,
	CURRENT_QUEUE_CL varchar,
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CREATE_DATE datetime,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	CASE_CL varchar,
	AQUIRER_TRANSACTION_CODE varchar,
	OWNER_CODE varchar,
	LAST_OWNER_CHANGE_DATE datetime,
	REFERENCE_DATA varchar,
	PROVIDER_CL varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	SETTLEMENT_DATE datetime,
	STATUS_CL varchar,
	CASE_GROUP bigint(20),
	AUTHORIZATION_AMOUNT int(11),
	AUTHORIZATION_CURRENCY varchar,
	CHARGEBACK_CASE_DOCUMENT_FK bigint(20),
	CHARGEBACK_CASE_ACTIVITY_FK bigint(20),
	AMEX_CHARGEBACK_DOCUMENT_BATCH_FK bigint(20),
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	PROCESSOR_RESPONSE_CODE varchar,
	PROCESSOR_RESPONSE_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CASE_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;