-- Create Table Statement for 'Amex Capture Retail Transaction'
DROP TABLE IF EXISTS `AMEX_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `AMEX_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	RESPONSE_DATA varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_IDENTIFIER varchar,
	FORMAT_CODE varchar,
	MEDIA_CODE varchar,
	APPROVAL_CODE varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	TRANSACTION_AMOUNT varchar,
	PROCESSING_CODE varchar,
	TRANSACTION_CURRENCY_CODE varchar,
	EXTENDED_PAYMENT_DATA varchar,
	MERCHANT_ID varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_CONTACT_INFORMATION varchar,
	TERMINAL_ID varchar,
	POINT_OF_SERVICE_DATA_CODE varchar,
	INVOICE_REFERENCE_NUMBER varchar,
	ELECTRONIC_COMMERCE_INDICATOR varchar,
	SHIP_TO_POSTAL_CODE varchar,
	TOTAL_TAX_AMOUNT varchar,
	TAX_TYPE_CODE varchar,
	LOCATION_NAME varchar,
	LOCATION_ADDRESS varchar,
	LOCATION_CITY varchar,
	LOCATION_REGION_CODE varchar,
	LOCATION_COUNTRY_CODE varchar,
	LOCATION_POSTAL_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	AMEX_RETAIL_FILE_BATCH_FK bigint(20),
	EMV_FORMAT_TYPE varchar,
	ICC_SYSTEM_RELATED_DATA varchar,
	EXTENDED_PAYMENT_DATA varchar,
	MERCHANT_CATEGORY_CODE varchar,
	EMV_FORMAT_TYPE varchar,
	ICC_SYSTEM_RELATED_DATA varchar,
	EXTENDED_PAYMENT_DATA varchar,
	MERCHANT_CATEGORY_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	EMV_FORMAT_TYPE varchar,
	ICC_SYSTEM_RELATED_DATA varchar,
	MERCHANT_CATEGORY_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;