-- Create Table Statement for 'Amex Inquiry Transaction'
DROP TABLE IF EXISTS `AMEX_INQUIRY_TRANSACTION`;
CREATE TABLE `AMEX_INQUIRY_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	INQUIRY_CASE_NUMBER varchar,
	AIRLINE_TICKET_NUMBER varchar,
	AMEX_PROCESS_DATE varchar,
	AMEX_ID varchar,
	CASE_TYPE varchar,
	SE_REPLY_BY_DATE varchar,
	LOCATION_NUMBER varchar,
	DATE_OF_CHARGE varchar,
	CARDMEMBER_NAME1 varchar,
	CARDMEMBER_NAME2 varchar,
	SERVICE_AGENT_MERCHANT_ID varchar,
	CARDMEMBER_CITY_STATE varchar,
	CARDMEMBER_ZIP varchar,
	SE_NUMBER varchar,
	INQUIRY_REASON_CODE varchar,
	FOLLOWUP_REASON_CODE varchar,
	FOREIGN_AMOUNT varchar,
	SUPPORT_TO_FOLLOW varchar,
	INQUIRY_ACTION_NUMBER varchar,
	CARDMEMBER_FIRST_NAME1 varchar,
	CARDMEMBER_MIDDLE_NAME1 varchar,
	CARDMEMBER_LAST_NAME1 varchar,
	CARDMEMBER_ORIGINAL_NAME varchar,
	CARDMEMBER_ORIG_FIRST_NAME varchar,
	CARDMEMBER_ORIG_MIDDLE_NAME varchar,
	CARDMEMBER_ORIG_LAST_NAME varchar,
	INQUIRY_NOTE1 varchar,
	INQUIRY_NOTE2 varchar,
	INQUIRY_NOTE3 varchar,
	INQUIRY_NOTE4 varchar,
	INQUIRY_NOTE5 varchar,
	INQUIRY_NOTE6 varchar,
	INQUIRY_NOTE7 varchar,
	CHARGE_AMOUNT varchar,
	DISPUTED_AMOUNT varchar,
	REFERENCE_NUMBER varchar,
	SOC_INVOICE_NUMBER varchar,
	SEQUENCE_INDICATOR varchar,
	PASSENGER_NAME varchar,
	PASSENGER_FIRST_NAME varchar,
	PASSENGER_MIDDLE_NAME varchar,
	PASSENGER_LAST_NAME varchar,
	SE_PROCESS_DATE varchar,
	IND_FORM_CODE varchar,
	IND_REF_NUMBER varchar,
	LOC_REF_NUMBER varchar,
	TRIUMPH_SEQUENCE_NUMBER varchar,
	INQUIRY_MARK varchar,
	LTA_FIELD_DATE varchar,
	RETURN_DATE varchar,
	CREDIT_RECEIPT_NUMBER varchar,
	RETURN_TO_NAME varchar,
	RETURN_TO_STREET varchar,
	CARD_DEPOSIT varchar,
	CARD_CANC_NUMBER varchar,
	ASSURED_RESERVATION varchar,
	RES_CANCELLED varchar,
	RES_CANCELLED_DATE varchar,
	RES_CANCELLED_TIME varchar,
	CANCEL_ZONE varchar,
	RESERVATION_MADE_FOR varchar,
	RESERVATION_LOCATION varchar,
	RESERVATION_MADE_ON varchar,
	FOLIO_REF_NUMBER varchar,
	RENTAL_AGREEMENT_NEEDED varchar,
	RENTAL_AGREEMENT_NUMBER varchar,
	MERCHANDISE_TYPE varchar,
	ORDER_NUMBER varchar,
	MERCHANDISE_RETURNED varchar,
	CREDIT_REQUESTED varchar,
	REPLACEMENT_REQUESTED varchar,
	RETURNED_NAME varchar,
	RETURNED_DATE varchar,
	RETURNED_HOW varchar,
	RETURNED_REASON varchar,
	STORE_CREDIT_RECEIVED varchar,
	CARDMEMBER_ACCOUNT_NUMBER_LAST4 varchar,
	CARDMEMBER_ACCOUNT_NUMBER_ENCODED varchar,
	CARDMEMBER_ORIGINAL_NUMBER_LAST4 varchar,
	CARDMEMBER_ORIGINAL_NUMBER_ENCODED varchar,
	IS_MAPPED tinyint(1),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGEBACK_CASE_ACTIVITY_FK bigint(20),
	INQUIRY_ACTION_RESOLUTION_CODE varchar,
	DOLLAR_AMOUNT varchar,
	DATE_ACTION_TAKEN varchar,
	SUPPORT_SENT varchar,
	SE_TRACKING varchar,
	TRIUMPH_AREA varchar,
	RESPONSE_EXPLANATION1 varchar,
	RESPONSE_EXPLANATION2 varchar,
	RESPONSE_EXPLANATION3 varchar,
	CHARGEBACK_CASE_ACTIVITY_RESPONSE_FK bigint(20),
	AMEX_CHARGEBACK_BATCH_FK bigint(20),
	AMEX_CHARGEBACK_RESPONSE_BATCH_FK bigint(20),
	AMEX_INQUIRY_TRANSACTION_RESPONSE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;