-- Create Table Statement for 'Amex Chargeback Transaction'
DROP TABLE IF EXISTS `AMEX_CHARGEBACK_TRANSACTION`;
CREATE TABLE `AMEX_CHARGEBACK_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SE_NUMB varchar,
	CURRENT_CASE_NUMBER varchar,
	CURRENT_ACTION_NUMBER varchar,
	PREVIOUS_CASE_NUMBER varchar,
	PREVIOUS_ACTION_NUMBER varchar,
	RESOLUTION varchar,
	FROM_SYSTEM varchar,
	REJECT_TO_SYSTEM varchar,
	DISPUTES_TO_SYSTEM varchar,
	DATE_OF_ADJUSTMENT varchar,
	DATE_OF_CHARGE varchar,
	AMEX_ID varchar,
	CASE_TYPE varchar,
	LOC_NUMB varchar,
	CB_REAS_CODE varchar,
	CB_AMOUNT varchar,
	CB_ADJUSTMENT_NUMBER varchar,
	CB_RESOLUTION_ADJ_NUMBER varchar,
	CB_REFERENCE_CODE varchar,
	BILLED_AMOUNT varchar,
	SOC_AMOUNT varchar,
	SOC_INVOICE_NUMBER varchar,
	ROC_INVOICE_NUMBER varchar,
	FOREIGN_AMT varchar,
	CURRENCY varchar,
	SUPP_TO_FOLLOW varchar,
	CM_NAME1 varchar,
	CM_NAME2 varchar,
	CM_ADDR1 varchar,
	CM_ADDR2 varchar,
	CM_CITY_STATE varchar,
	CM_ZIP varchar,
	CM_FIRST_NAME1 varchar,
	CM_MIDDLE_NAME1 varchar,
	CM_LAST_NAME1 varchar,
	CM_ORIG_NAME varchar,
	CM_ORIG_FIRST_NAME varchar,
	CM_ORIG_MIDDLE_NAME varchar,
	CM_ORIG_LAST_NAME varchar,
	NOTE1 varchar,
	NOTE2 varchar,
	NOTE3 varchar,
	NOTE4 varchar,
	NOTE5 varchar,
	NOTE6 varchar,
	NOTE7 varchar,
	TRIUMPH_SEQ_NO varchar,
	AIRLINE_TKT_NUM varchar,
	AL_SEQUENCE_NUMBER varchar,
	FOLIO_REF varchar,
	MERCH_ORDER_NUM varchar,
	MERCH_ORDER_DATE varchar,
	CANC_NUM varchar,
	CANC_DATE varchar,
	FINCAP_TRACKING_ID varchar,
	FINCAP_FILE_SEQ_NUM varchar,
	FINCAP_BATCH_NUMBER varchar,
	FINCAP_BATCH_INVOICE_DT varchar,
	LABEL1 varchar,
	DATA1 varchar,
	LABEL2 varchar,
	DATA2 varchar,
	LABEL3 varchar,
	DATA3 varchar,
	LABEL4 varchar,
	DATA4 varchar,
	LABEL5 varchar,
	DATA5 varchar,
	LABEL6 varchar,
	DATA6 varchar,
	LABEL7 varchar,
	DATA7 varchar,
	LABEL8 varchar,
	DATA8 varchar,
	LABEL9 varchar,
	DATA9 varchar,
	LABEL10 varchar,
	DATA10 varchar,
	LABEL11 varchar,
	DATA11 varchar,
	LABEL12 varchar,
	DATA12 varchar,
	IND_REF_NUMBER varchar,
	LOC_REF_NUMBER varchar,
	PASSENGER_NAME varchar,
	PASSENGER_FIRST_NAME varchar,
	PASSENGER_MIDDLE_NAME varchar,
	PASSENGER_LAST_NAME varchar,
	SE_PROCESS_DATE varchar,
	RETURN_DATE varchar,
	CREDIT_RECEIPT_NUMBER varchar,
	RETURN_TO_NAME varchar,
	RETURN_TO_STREET varchar,
	CARD_DEPOSIT varchar,
	ASSURED_RESERVATION varchar,
	RES_CANCELLED varchar,
	RES_CANCELLED_DATE varchar,
	CANCEL_ZONE varchar,
	RESERVATION_MADE_FOR varchar,
	RESERVATION_LOCATION varchar,
	RESERVATION_MADE_ON varchar,
	RENTAL_AGREEMENT_NUMBER varchar,
	MERCHANTDISE_TYPE varchar,
	MERCHANTDISE_RETURNED varchar,
	RETURNED_NAME varchar,
	RETURNED_DATE varchar,
	RETURNED_HOW varchar,
	RETURNED_REASON varchar,
	STORE_CREDIT_RECEIVED varchar,
	IND_FORM_CODE varchar,
	CM_ACCT_NUMB_ENCODED varchar,
	CM_ORIG_ACCT_NUM_ENCODED varchar,
	CM_ACCT_NUMB_LAST4 varchar,
	CM_ORIG_ACCT_NUM_LAST4 varchar,
	IS_MAPPED tinyint(1),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGEBACK_CASE_ACTIVITY_FK bigint(20),
	XREF_SE_NUMB varchar,
	DISPUTE_CODE varchar,
	DISPUTE_AMOUNT varchar,
	ADJ_NUMBER_AREA varchar,
	DISPUTE_TEXT_AREA varchar,
	CHARGEBACK_CASE_ACTIVITY_DISPUTE_FK bigint(20),
	SUPPORT_SENT varchar,
	AMEX_CHARGEBACK_DISPUTE_BATCH_FK bigint(20),
	AMEX_CHARGEBACK_BATCH_FK bigint(20),
	CHARGEBACK_CASE_ACTIVITY_DISPUTE_FK bigint(20),
	CHARGEBACK_CASE_ACTIVITY_DISPUTE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;