-- Create Table Statement for 'Elavon EISOP Capture Retail Transaction'
DROP TABLE IF EXISTS `ELAVON_EISOP_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `ELAVON_EISOP_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	APPROVAL_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_CURRENCY varchar,
	CARDHOLDER_AMOUNT varchar,
	CARDHOLDER_CURRENCY_CODE varchar,
	CONVERSION_RATE varchar,
	CONVERSION_EXPONENT varchar,
	CUSTOM_DATA varchar,
	POS_ENTRY_MODE varchar,
	AUTH_SOURCE_CODE varchar,
	CARDHOLDER_ID_METHOD varchar,
	CARD_PRESENT_INDICATOR varchar,
	ELECTRONIC_COMMERCE_INDICATOR varchar,
	POS_TYPE_INDICATOR varchar,
	POS_CAPABILITY varchar,
	RESPONSE_CODE varchar,
	MERCHANT_CATEGORY_CODE varchar,
	ORIGINAL_AUTHORIZATION_AMOUNT varchar,
	AVS_RESULT varchar,
	CARD_TYPE varchar,
	STAN varchar,
	RETRIEVAL_REFERENCE_NO varchar,
	CVV_RESULT varchar,
	UCAF_COLLECTION_INDICATOR varchar,
	RE_D_REPLY_CODE varchar,
	TRANSACTION_REFERENCE varchar,
	DCC_ELIGIBLE varchar,
	REFERENCE_ADDENDUM_INDICATOR varchar,
	PURCHASE_IDENTIFIER_FORMAT varchar,
	PURCHASE_IDENTIFIER varchar,
	ICC_CURRENCY_CODE varchar,
	ICC_PAN_SEQUENCE_NUMBER varchar,
	ICC_APPLICATION_INTERCHANGE_PROFILE varchar,
	ICC_TVR varchar,
	ICC_IDD varchar,
	ICC_APPLICATION_CRYPTOGRAM varchar,
	ICC_CRYPTOGRAM_INFORMATION_DATA varchar,
	ICC_TERMINAL_CAPABILITIES varchar,
	ICC_APPLICATION_TRANSACTION_COUNTER varchar,
	ICC_ISR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	ELAVON_EISOP_RETAIL_FILE_BATCH_FK bigint(20),
	TRANSACTION_TYPE varchar,
	TRANSACTION_SOURCE varchar,
	AUTHORISATION_CODE varchar,
	AUTHORISATION_SOURCE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_STATE varchar,
	ICC_ISSUER_APPLICATION_DATA varchar,
	ICC_UNPREDICTABLE_NUMBER varchar,
	ICC_TERMINAL_VERIFICATION_RESULTS varchar,
	ICC_TRANSACTION_DATE varchar,
	ICC_TRANSACTION_TYPE varchar,
	ICC_TRANSACTION_AMOUNT varchar,
	ICC_TRANSACTION_CURRENCY_CODE varchar,
	ICC_TERMINAL_COUNTRY_CODE varchar,
	ICC_AMOUNT_OTHER varchar,
	ICC_CVM_RESULTS varchar,
	ICC_TERMINAL_TYPE varchar,
	ICC_INTERFACE_DEVICE_SERIAL_NO varchar,
	ICC_TRANSACTION_CATEGORY_CODE varchar,
	ICC_DEDICATED_FILE_NAME varchar,
	ICC_TERMINAL_APPLICATION_VERSION_NO varchar,
	ICC_TRANSACTION_SEQUENCE_COUNTER varchar,
	ICC_CARD_SEQUENCE_NUMBER varchar,
	ICC_ISSUER_SCRIPT_RESULTS_PART_I varchar,
	ICC_ISSUER_SCRIPT_RESULTS_PART_I_I varchar,
	SYSTEM_TRACE_AUDIT_NUMBER varchar,
	RETRIEVAL_REFERENCE_NUMBER varchar,
	MOTO_ECOMMERCE_AUTHENTICATION_INDICATOR varchar,
	TRANSACTION_IDENTIFIER varchar,
	VALIDATION_CODE varchar,
	AUTH_CHARACTERISTICS_IND varchar,
	BANK_NET_REF_DATE varchar,
	FINANCIAL_NETWORK_CODE varchar,
	BANK_NET_REFERENCE varchar,
	CASH_BACK_AMOUNT varchar,
	DYNAMIC_MERCHANT_DBA_NAME varchar,
	DYNAMIC_MERCHANT_CITY varchar,
	DYNAMIC_MERCHANT_STREET_ADDRESS varchar,
	DYNAMIC_MERCHANT_ZIP_CODE varchar,
	DYNAMIC_MERCHANT_COUNTRY_CODE varchar,
	DYNAMIC_MERCHANT_SUB_MERCHANT_ID varchar,
	CARD_SCHEME_DATA_DATE_TIME varchar,
	CARD_SCHEME_DATA_SETTLEMENT_DATE varchar,
	DYNAMIC_MERCHANT_STATE_CODE varchar,
	TRACK_DATA_CONDITION_CODE varchar,
	DAILY_ROOM_RATE varchar,
	DATE_OF_CHECK_OUT varchar,
	FOLIO_REFERENCE_NUMBER varchar,
	CONFIRMED_RESERVATION_INDICATOR varchar,
	DATE_OF_CHECK_IN varchar,
	NAME_OF_GUEST varchar,
	NUMBER_IN_PARTY varchar,
	NETWORK_REFERENCE_IDENTIFICATION_NUMBER varchar,
	PRODUCT_ID varchar,
	FORM_FACTOR_INDICATOR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	MOBILE_POS_INDICATOR varchar,
	POS_TERMINAL_CAPABILITY varchar,
	ACCOUNTHOLDER_AUTHENTICATION_VALUE_COLLECTION_INDICATOR varchar,
	DYNAMIC_MERCHANT_MCC_CODE varchar,
	DYNAMIC_MERCHANT_PHONE_NUMBER varchar,
	UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	THREE_D_SECURE_VERSION_NUMBER varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	PIN_CAPABILITY varchar,
	MOBILE_POS_ACCEPTANCE_DEVICE_INDICATOR varchar,
	DYNAMIC_MERCHANT_EMAIL_ADDRESS varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	MOBILE_POS_INDICATOR varchar,
	POS_TERMINAL_CAPABILITY varchar,
	ACCOUNTHOLDER_AUTHENTICATION_VALUE_COLLECTION_INDICATOR varchar,
	DYNAMIC_MERCHANT_MCC_CODE varchar,
	DYNAMIC_MERCHANT_PHONE_NUMBER varchar,
	UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	THREE_D_SECURE_VERSION_NUMBER varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	PIN_CAPABILITY varchar,
	MOBILE_POS_ACCEPTANCE_DEVICE_INDICATOR varchar,
	DYNAMIC_MERCHANT_EMAIL_ADDRESS varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	MOBILE_POS_INDICATOR varchar,
	POS_TERMINAL_CAPABILITY varchar,
	ACCOUNTHOLDER_AUTHENTICATION_VALUE_COLLECTION_INDICATOR varchar,
	DYNAMIC_MERCHANT_MCC_CODE varchar,
	DYNAMIC_MERCHANT_PHONE_NUMBER varchar,
	UNIQUE_TRANSACTION_RESPONSE_REFERENCE_NUMBER varchar,
	TRANSACTION_INTEGRITY_CLASS varchar,
	THREE_D_SECURE_VERSION_NUMBER varchar,
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	PIN_CAPABILITY varchar,
	MOBILE_POS_ACCEPTANCE_DEVICE_INDICATOR varchar,
	DYNAMIC_MERCHANT_EMAIL_ADDRESS varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	ELAVON_EISOP_RETAIL_FILE_BATCH_FK bigint(20),
	ELAVON_EISOP_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;