-- Create Table Statement for 'Vantiv Chargeback Transaction'
DROP TABLE IF EXISTS `VANTIV_CHARGEBACK_TRANSACTION`;
CREATE TABLE `VANTIV_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REPORT_DATE1 varchar,
	TRANSACTION_TYPE1 varchar,
	DISPUTE_AMOUNT1 varchar,
	RECORD_NUMBER1 varchar,
	ACQUIRER_TERMINAL_ID varchar,
	REGISTER_NUMBER varchar,
	NETWORK_ID varchar,
	MERCHANT_DRAFT_RETRIEVAL_NUMBER varchar,
	CHARGEBACK_USAGE_CODE varchar,
	ADJUSTMENT_TYPE1 varchar,
	ORIGINAL_TRANS_DATE varchar,
	DRAFT_ACTION_CODE varchar,
	DRAFT_ACTION_CODE_DATE varchar,
	DOCUMENT_INDICATOR varchar,
	ORIGINAL_TRANS_TIME varchar,
	PRIMARY_ACCOUNT_NUMBER varchar,
	CHARGEBACK_ACTION_CODE varchar,
	CHARGEBACK_ACTION_CODE_DATE varchar,
	DEPARTMENT_NUMBER varchar,
	ISSUER_CURRENCY_CODE varchar,
	MERCHANT_CATEGORY_CODE varchar,
	ADJUSTMENT_REASON_CODE varchar,
	CHARGEBACK_REFERENCE_NUMBER varchar,
	TRANSACTION_DISPOSITION_QUALIFIER varchar,
	ACQUIRER_REFERENCE_NUMBER varchar,
	MERCHANT_CHAIN_NUMBER varchar,
	MERCHANT_DIVISION_NUMBER varchar,
	MERCHANT_STORE_NUMBER varchar,
	FEE_AMOUNT varchar,
	SALES_PERSON_NUMBER varchar,
	ENTRY_MODE varchar,
	AUTHORIZATION_SOURCE varchar,
	PREVIOUS_DRAFT_ACTION varchar,
	ELECTRONIC_COMMERCE varchar,
	COMMENTS_FROM_ISSUER1 varchar,
	COMMENTS_TO_ISSUER1 varchar,
	REPORT_DATE2 varchar,
	TRANSACTION_TYPE2 varchar,
	DISPUTE_AMOUNT2 varchar,
	RECORD_NUMBER2 varchar,
	ADJUSTMENT_TYPE2 varchar,
	USER_DATA_FIELD1 varchar,
	USER_DATA_FIELD2 varchar,
	USER_DATA_FIELD3 varchar,
	USER_DATA_FIELD4 varchar,
	COMMENT_TO_MERCHANT2 varchar,
	COMMENT_FROM_MERCHANT2 varchar,
	REPORT_DATE3 varchar,
	TRANSACTION_TYPE3 varchar,
	DISPUTE_AMOUNT3 varchar,
	RECORD_NUMBER3 varchar,
	ADJUSTMENT_TYPE3 varchar,
	MERCHANT_RESEARCH_COMMENTS_LINE3 varchar,
	REPORT_DATE4 varchar,
	TRANSACTION_TYPE4 varchar,
	DISPUTE_AMOUNT4 varchar,
	RECORD_NUMBER4 varchar,
	ADJUSTMENT_TYPE4 varchar,
	MERCHANT_RESEARCH_COMMENTS_LINE4 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	VANTIV_CHARGEBACK_BATCH_FK bigint(20),
	VANTIV_CHARGEBACK_BATCH_VANTIV_CHARGEBACK_TRANSACTIONS_IDX int(11),
	MERCHANT_NUMBER varchar,
	REPORT_DATE5 varchar,
	TRANSACTION_TYPE5 varchar,
	DISPUTE_AMOUNT5 varchar,
	RECORD_NUMBER5 varchar,
	TOTAL_SEGMENTS varchar,
	NETWORK_ID5 varchar,
	ADJUSTMENT_TYPE5 varchar,
	DISCRETIONARY_FIELD1 varchar,
	DISCRETIONARY_FIELD2 varchar,
	DISCRETIONARY_FIELD3 varchar,
	MERCHANT_NAME varchar,
	PRIMARY_ACCOUNT_NUMBER1 varchar,
	PRIMARY_ACCOUNT_NUMBER2 varchar,
	NETWORK_ID1 varchar,
	NETWORK_ID2 varchar,
	NETWORK_ID3 varchar,
	NETWORK_ID4 varchar,
	MERCHANT_CHAIN_NUMBER1 varchar,
	MERCHANT_CHAIN_NUMBER2 varchar,
	MERCHANT_DIVISION_NUMBER1 varchar,
	MERCHANT_DIVISION_NUMBER2 varchar,
	MERCHANT_STORE_NUMBER1 varchar,
	MERCHANT_STORE_NUMBER2 varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;