-- Create Table Statement for 'Trust Commerce Chargeback Transaction'
DROP TABLE IF EXISTS `TRUST_COMMERCE_CHARGEBACK_TRANSACTION`;
CREATE TABLE `TRUST_COMMERCE_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	CC varchar,
	MEDIA_NAME varchar,
	EXP varchar,
	TRANS_DATE varchar,
	TRANSID varchar,
	REF_TRANSID varchar,
	AMOUNT varchar,
	AUTH_AMOUNT varchar,
	BANK_AMOUNT varchar,
	CREDIT_AMOUNT varchar,
	CHARGEBACK_AMOUNT varchar,
	ACTION_NAME varchar,
	STATUS_NAME varchar,
	NAME varchar,
	ADDRESS1 varchar,
	ADDRESS2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP varchar,
	PHONE varchar,
	EMAIL varchar,
	SHIPTOSAME varchar,
	SHIPTO_NAME varchar,
	SHIPTO_ADDRESS1 varchar,
	SHIPTO_ADDRESS2 varchar,
	SHIPTO_CITY varchar,
	SHIPTO_STATE varchar,
	SHIPTO_ZIP varchar,
	EXPIRED varchar,
	REAUTH varchar,
	CHAIN varchar,
	CHAIN_HEAD varchar,
	TICKET varchar,
	BATCHNUM varchar,
	AUTHCODE varchar,
	BILLINGID varchar,
	CUST_ID varchar,
	FAIL_NAME varchar,
	AVS varchar,
	OPERATOR varchar,
	SERVER varchar,
	TRANSID2 varchar,
	BILLINGID2 varchar,
	CUSTOMFIELD9 varchar,
	COUNTRY_CODE varchar,
	TAX varchar,
	PURCHASEORDERNUM varchar,
	BATCHID varchar,
	CLOSED varchar,
	ENTRY_MODE varchar,
	HEALTHCARE varchar,
	PRESCRIPTION varchar,
	RESPONSECODE varchar,
	DESCRIPTION varchar,
	EMAILRECEIPTSTATUS varchar,
	TRUST_COMMERCE_CHARGEBACK_BATCH_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;