-- Create Table Statement for 'TSYS Merlin Chargeback Case Transaction'
DROP TABLE IF EXISTS `TSYS_MERLIN_CHARGEBACK_CASE_TRANSACTION`;
CREATE TABLE `TSYS_MERLIN_CHARGEBACK_CASE_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TSYS_MERLIN_CHARGEBACK_CASE_BATCH_FK bigint(20),
	TRAN_CODE varchar,
	CASE_AMOUNT varchar,
	ITEM_TYPE varchar,
	RESOLUTION_TO varchar,
	DEBIT_CREDIT varchar,
	BIN_ICA varchar,
	DATE_RESOLVED varchar,
	ORIGINAL_REFERENCE_NUMBER varchar,
	FOREIGN_DOMESTIC varchar,
	MCC varchar,
	AUTH_CODE varchar,
	DATE_TRANSACTION varchar,
	DATE_POSTED varchar,
	DATE_LOADED varchar,
	CARDHOLDER_ACCOUNT_NUMBER varchar,
	DATE_SECOND_REQUEST varchar,
	ACCOUNT_NUMBER_PREFIX varchar,
	ACCOUNT_NUMBER_SUFFIX varchar,
	DBA_NAME varchar,
	ADDRESS1 varchar,
	ADDRESS2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	GROUP varchar,
	ASSOCIATION varchar,
	DATE_WAREHOUSE varchar,
	TRANS_ID varchar,
	MERCH_AMOUNT varchar,
	CASE_NUMBER varchar,
	CASE_TYPE varchar,
	ACQUIRER_REFERENCE_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	RECORD_TYPE varchar,
	CARD_BRAND varchar,
	REASON_CODE varchar,
	FAMILY_ID varchar,
	GL_COMMENT1 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	REASON_DESC varchar,
	GROUP_NUMBER varchar,
	CHARGEBACK_REFERENCE_NUMBER varchar,
	MCOMM_CLAIM_ID varchar,
	VROL_CASE_NUMBER varchar,
	CHARGEBACK_REFERENCE_NUMBER varchar,
	MCOMM_CLAIM_ID varchar,
	VROL_CASE_NUMBER varchar,
	CHARGEBACK_REFERENCE_NUMBER varchar,
	MCOMM_CLAIM_ID varchar,
	VROL_CASE_NUMBER varchar,
	TSYS_MERLIN_CHARGEBACK_CASE_BATCH_FK bigint(20),
	TSYS_MERLIN_CHARGEBACK_CASE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;