-- Create Table Statement for 'Vantiv Lowell Chargeback Transaction'
DROP TABLE IF EXISTS `VANTIV_LOWELL_CHARGEBACK_TRANSACTION`;
CREATE TABLE `VANTIV_LOWELL_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CASE_ID varchar,
	MERCHANT_ID varchar,
	DAY_ISSUED_BY_BANK varchar,
	DAY_RECEIVED_BY_LITLE varchar,
	CYCLE varchar,
	LITLE_TXN_ID varchar,
	MERCHANT_TXN_ID varchar,
	ORDER_ID varchar,
	CARD_NUMBER_LAST4 varchar,
	CARD_TYPE varchar,
	CHARGEBACK_AMOUNT int(11),
	CHARGEBACK_CURRENCY_TYPE varchar,
	ORIGINAL_TRANSACTION_DAY varchar,
	CHARGEBACK_TYPE varchar,
	ACTIVITY_TYPE varchar,
	REPRESENTED_AMOUNT int(11),
	REPRESENTED_CURRENCY_TYPE varchar,
	PRE_ARB_AMOUNT int(11),
	PRE_ARB_CURRENCY_TYPE varchar,
	REASON_CODE varchar,
	REASON_CODE_DESCRIPTION varchar,
	FROM_QUEUE varchar,
	TO_QUEUE varchar,
	CURRENT_QUEUE varchar,
	SETTLEMENT_AMOUNT int(11),
	SETTLEMENT_CURRENCY_TYPE varchar,
	NOTES varchar,
	RETRIEVAL_REQUEST_TYPE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	LITLE_CHARGEBACK_BATCH_FK bigint(20),
	FRAUD_NOTIFICATION_STATUS varchar,
	FRAUD_NOTIFICATION_DATE varchar,
	BIN varchar,
	PAYMENT_TYPE varchar,
	REPLY_BY_DATE varchar,
	AUTH_DATE varchar,
	AUTH_CURRENCY varchar,
	AUTH_AMOUNT varchar,
	ACTIVITY_DATE varchar,
	SETTLEMENT_DATE varchar,
	MERCHANT_NAME varchar,
	TXN_TYPE varchar,
	BATCH_ID varchar,
	SESSION_ID varchar,
	CUSTOMER_ID varchar,
	ISSUING_BANK varchar,
	ACQUIRER_REFERENCE_NUMBER varchar,
	CHARGEBACK_REFERENCE_NUMBER varchar,
	PAYMENT_AMOUNT int(11),
	IS_FINANCIAL tinyint(1),
	ORIGINAL_ACCOUNT_NUMBER varchar,
	UPDATED_ACCOUNT_NUMBER varchar,
	ORIGINAL_ROUTING_NUMBER varchar,
	UPDATED_ROUTING_NUMBER varchar,
	ORIGINAL_TRAN_CODE varchar,
	ACTION_TYPE varchar,
	UPDATED_TRAN_CODE varchar,
	CUSTOMER_NAME varchar,
	NEW_NAME_COMPANY_NAME varchar,
	CREATE_DATE varchar,
	REASON_CODE varchar,
	REASON_CODE varchar,
	MERCHANT_TXN_ID varchar,
	MERCHANT_TXN_ID varchar,
	VANTIV_LOWELL_CHARGEBACK_BATCH_FK bigint(20),
	VANTIV_LOWELL_CHARGEBACK_BATCH_FK bigint(20),
	VANTIV_LOWELL_CHARGEBACK_BATCH_FK bigint(20),
	BIN varchar,
	BIN varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;