-- Create Table Statement for 'First Data Compass Capture Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_COMPASS_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_COMPASS_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DIVISION_NUMBER varchar,
	ORDER_NUMBER varchar,
	ACTION_CODE varchar,
	MOP varchar,
	EXPIRATION_DATE varchar,
	AMOUNT varchar,
	TRANSACTION_TYPE varchar,
	CUSTOMER_REFERENCE_NUMBER varchar,
	SALES_TAX_AMOUNT varchar,
	NAME_TEXT varchar,
	ADDRESS_LINE1 varchar,
	CITY varchar,
	STATE varchar,
	POSTAL_CODE varchar,
	COUNTRY_CODE varchar,
	RESPONSE_REASON_CODE varchar,
	CAPTURE_RESPONSE_REASON_CODE varchar,
	RESPONSE_DATE varchar,
	AUTHORIZATION_CODE varchar,
	AVS_RESPONSE_CODE varchar,
	TRACE_NUMBER varchar,
	DEPOSIT_FLAG varchar,
	FIRST_DATA_COMPASS_RETAIL_FILE_BATCH_FK bigint(20),
	DESCRIPTION varchar,
	MERCHANT_CONTACT_INFORMATION varchar,
	MERCHANT_CITY varchar,
	ENCRYPTION_FLAG varchar,
	FIRST_DATA_TOKEN_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CURRENCY_CODE varchar,
	CARD_SECURITY_VALUE_RESPONSE varchar,
	EXEMPT_INDICATOR varchar,
	NATIONAL_TAX varchar,
	DEVICE_TYPE varchar,
	PAYMENT_DEVICE varchar,
	ITEM_DESCRIPTION1 varchar,
	ITEM_DESCRIPTION2 varchar,
	ITEM_DESCRIPTION3 varchar,
	ITEM_DESCRIPTION4 varchar,
	ITEM_DESCRIPTION5 varchar,
	ITEM_DESCRIPTION6 varchar,
	ITEM_QUANTITY1 varchar,
	ITEM_QUANTITY2 varchar,
	ITEM_QUANTITY3 varchar,
	ITEM_QUANTITY4 varchar,
	ITEM_QUANTITY5 varchar,
	ITEM_QUANTITY6 varchar,
	ITEM_AMOUNT1 varchar,
	ITEM_AMOUNT2 varchar,
	ITEM_AMOUNT3 varchar,
	ITEM_AMOUNT4 varchar,
	ITEM_AMOUNT5 varchar,
	ITEM_AMOUNT6 varchar,
	FREIGHT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DESTINATION_ZIP_POSTAL_CODE varchar,
	SHIP_FROM_ZIP_POSTAL_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	INVOICE_DISCOUNT_TREATMENT varchar,
	TAX_TREATMENT varchar,
	SPECIAL_PAYMENT_TYPE_INDICATOR varchar,
	EMAIL_ADDRESS varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	MESSAGE_TYPE varchar,
	SPECIAL_PAYMENT_TYPE_INDICATOR varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	CASH_BACK_AMOUNT_REQUESTED varchar,
	CASH_BACK_AMOUNT_APPROVED varchar,
	REQUESTOR_NAME varchar,
	SHIP_TO_NAME_TEXT varchar,
	SHIP_TO_ADDRESS_LINE1 varchar,
	SHIP_TO_CITY varchar,
	SHIP_TO_STATE varchar,
	SHIP_TO_POSTAL_CODE varchar,
	SHIP_TO_COUNTRY_CODE varchar,
	ACCOUNT_TYPE varchar,
	TRANSACTION_IDENTITY varchar,
	TRANSACTION_IDENTITY varchar,
	CURRENCY_CODE varchar,
	CARD_SECURITY_VALUE_RESPONSE varchar,
	EXEMPT_INDICATOR varchar,
	NATIONAL_TAX varchar,
	DEVICE_TYPE varchar,
	PAYMENT_DEVICE varchar,
	ITEM_DESCRIPTION1 varchar,
	ITEM_DESCRIPTION2 varchar,
	ITEM_DESCRIPTION3 varchar,
	ITEM_DESCRIPTION4 varchar,
	ITEM_DESCRIPTION5 varchar,
	ITEM_DESCRIPTION6 varchar,
	ITEM_QUANTITY1 varchar,
	ITEM_QUANTITY2 varchar,
	ITEM_QUANTITY3 varchar,
	ITEM_QUANTITY4 varchar,
	ITEM_QUANTITY5 varchar,
	ITEM_QUANTITY6 varchar,
	ITEM_AMOUNT1 varchar,
	ITEM_AMOUNT2 varchar,
	ITEM_AMOUNT3 varchar,
	ITEM_AMOUNT4 varchar,
	ITEM_AMOUNT5 varchar,
	ITEM_AMOUNT6 varchar,
	FREIGHT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DESTINATION_ZIP_POSTAL_CODE varchar,
	SHIP_FROM_ZIP_POSTAL_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	INVOICE_DISCOUNT_TREATMENT varchar,
	TAX_TREATMENT varchar,
	EMAIL_ADDRESS varchar,
	MESSAGE_TYPE varchar,
	CASH_BACK_AMOUNT_REQUESTED varchar,
	CASH_BACK_AMOUNT_APPROVED varchar,
	REQUESTOR_NAME varchar,
	SHIP_TO_NAME_TEXT varchar,
	SHIP_TO_ADDRESS_LINE1 varchar,
	SHIP_TO_CITY varchar,
	SHIP_TO_STATE varchar,
	SHIP_TO_POSTAL_CODE varchar,
	SHIP_TO_COUNTRY_CODE varchar,
	ACCOUNT_TYPE varchar,
	SPECIAL_PAYMENT_TYPE_INDICATOR varchar,
	TRACKING_NUMBER varchar,
	INITIATION_INDICATOR varchar,
	ORIGINAL_VISA_TRANSACTION_ID varchar,
	SCHEDULE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	VISA_TRANSACTION_ID varchar,
	TRANSACTION_IDENTITY varchar,
	CURRENCY_CODE varchar,
	CARD_SECURITY_VALUE_RESPONSE varchar,
	EXEMPT_INDICATOR varchar,
	NATIONAL_TAX varchar,
	DEVICE_TYPE varchar,
	PAYMENT_DEVICE varchar,
	ITEM_DESCRIPTION1 varchar,
	ITEM_DESCRIPTION2 varchar,
	ITEM_DESCRIPTION3 varchar,
	ITEM_DESCRIPTION4 varchar,
	ITEM_DESCRIPTION5 varchar,
	ITEM_DESCRIPTION6 varchar,
	ITEM_QUANTITY1 varchar,
	ITEM_QUANTITY2 varchar,
	ITEM_QUANTITY3 varchar,
	ITEM_QUANTITY4 varchar,
	ITEM_QUANTITY5 varchar,
	ITEM_QUANTITY6 varchar,
	ITEM_AMOUNT1 varchar,
	ITEM_AMOUNT2 varchar,
	ITEM_AMOUNT3 varchar,
	ITEM_AMOUNT4 varchar,
	ITEM_AMOUNT5 varchar,
	ITEM_AMOUNT6 varchar,
	FREIGHT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DESTINATION_ZIP_POSTAL_CODE varchar,
	SHIP_FROM_ZIP_POSTAL_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	INVOICE_DISCOUNT_TREATMENT varchar,
	TAX_TREATMENT varchar,
	EMAIL_ADDRESS varchar,
	MESSAGE_TYPE varchar,
	CASH_BACK_AMOUNT_REQUESTED varchar,
	CASH_BACK_AMOUNT_APPROVED varchar,
	REQUESTOR_NAME varchar,
	SHIP_TO_NAME_TEXT varchar,
	SHIP_TO_ADDRESS_LINE1 varchar,
	SHIP_TO_CITY varchar,
	SHIP_TO_STATE varchar,
	SHIP_TO_POSTAL_CODE varchar,
	SHIP_TO_COUNTRY_CODE varchar,
	ACCOUNT_TYPE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	FIRST_DATA_COMPASS_RETAIL_FILE_BATCH_FK bigint(20),
	FIRST_DATA_COMPASS_RETAIL_FILE_BATCH_FK bigint(20),
	FIRST_DATA_COMPASS_RETAIL_FILE_BATCH_FK bigint(20),
	CAVV varchar,
	XID varchar,
	CAVV_RESPONSE_CODE varchar,
	CAVV varchar,
	XID varchar,
	CAVV_RESPONSE_CODE varchar,
	CAVV varchar,
	XID varchar,
	CAVV_RESPONSE_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;