-- Create Table Statement for 'Elavon4 Capture Retail Transaction'
DROP TABLE IF EXISTS `ELAVON4_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `ELAVON4_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	CARD_TYPE varchar,
	SETTLEMENT_AMOUNT varchar,
	AUTHORIZATION_DATE varchar,
	AUTHORIZATION_TIME varchar,
	APPROVAL_CODE varchar,
	POS_ENTRY_MODE varchar,
	AUTH_SOURCE_CODE varchar,
	CARDHOLDER_ID_METHOD varchar,
	CARD_PRESENT_INDICATOR varchar,
	REFERENCE_NUMBER varchar,
	VISA_ACI varchar,
	VISA_TRANSACTION_ID varchar,
	VISA_VALIDATION_CODE varchar,
	ECOMMERCE_INDICATOR varchar,
	CARDHOLDER_ACTIVATED_TERMINAL varchar,
	POS_CAPABILITY varchar,
	RESPONSE_CODE varchar,
	ORIGINAL_AUTHORIZATION_AMOUNT varchar,
	AVS_RESULT varchar,
	DEBIT_NETWORK_ID varchar,
	DEBIT_SETTLEMENT_DATE varchar,
	MSDI_INDICATOR varchar,
	DEBIT_SURCHARGE_AMOUNT varchar,
	CVV2_RESULT varchar,
	ACCOUNT_LEVEL_PROCESSING varchar,
	ORDER_NUMBER varchar,
	INSTALLMENT_SEQUENCE varchar,
	INSTALLMENT_COUNT varchar,
	SHIP_DATE varchar,
	CUSTOMER_CODE varchar,
	SALES_TAX_INCLUDED varchar,
	SALES_TAX_AMOUNT varchar,
	ELAVON4_RETAIL_FILE_BATCH_FK bigint(20),
	ELAVON_CAPTURE_RETAIL_TRANSACTIONS_IDX int(11),
	UCAF_INDICATOR varchar,
	TOTAL_AUTHORIZED_AMOUNT varchar,
	MERCHANT_DBA_NAME varchar,
	CARD_SEQUENCE_NUMBER varchar,
	CHIP_CONDITION_CODE varchar,
	TERMINAL_CAPABILITIES_PROFILE varchar,
	TERMINAL_VERIFICATION_RESULTS varchar,
	UNPREDICTABLE_NUMBER varchar,
	ISSUER_APPLICATION_DATA varchar,
	APPLICATION_CRYPTOGRAM varchar,
	APPLICATION_TRANSACTION_COUNTER varchar,
	APPLICATION_INTERCHANGE_PROFILE varchar,
	CRYPTOGRAM_TRANSACTION_TYPE varchar,
	TERMINAL_COUNTRY_CODE varchar,
	TERMINAL_TRANSMISSION_DATE varchar,
	AUTHORIZATION_CURRENCY_CODE varchar,
	CASHBACK_AMOUNT varchar,
	CRYPTOGRAM_INFORMATION_DATA varchar,
	CARDHOLDER_VERIFICATION_METHOD_RESULTS varchar,
	TERMINAL_TYPE varchar,
	APPLICATION_EXPIRATION_DATE varchar,
	AUTHORIZED_AMOUNT varchar,
	CASHBACK_AMOUNT_EMV varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	SPEND_QUALIFIER varchar,
	VOUCHER_CLEAR_NBR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	SHIP_FROM_ZIP_CODE varchar,
	DESTINATION_ZIP_CODE varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	SHIPPING_AMOUNT varchar,
	NATIONAL_TAX_INCLUDED varchar,
	NATIONAL_TAX varchar,
	ORDER_DATE varchar,
	OTHER_TAX varchar,
	SUMMARY_COMMODITY_CODE varchar,
	MERCHANT_VAT_REG varchar,
	CUSTOMER_VAT_REGISTRATION_NUMBER varchar,
	VAT_AMOUNT_FREIGHT varchar,
	VAT_RATE_FREIGHT varchar,
	VAT_INVOICE_REFERENCE_NUMBER varchar,
	INVOICE_NUMBER varchar,
	MERCHANT_DBA_CITY varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	SHIP_FROM_ZIP_CODE varchar,
	DESTINATION_ZIP_CODE varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	SHIPPING_AMOUNT varchar,
	NATIONAL_TAX_INCLUDED varchar,
	NATIONAL_TAX varchar,
	ORDER_DATE varchar,
	OTHER_TAX varchar,
	SUMMARY_COMMODITY_CODE varchar,
	MERCHANT_VAT_REG varchar,
	CUSTOMER_VAT_REGISTRATION_NUMBER varchar,
	VAT_AMOUNT_FREIGHT varchar,
	VAT_RATE_FREIGHT varchar,
	VAT_INVOICE_REFERENCE_NUMBER varchar,
	INVOICE_NUMBER varchar,
	MERCHANT_DBA_CITY varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	STORED_CREDENTIAL_INDICATOR varchar,
	POS_CONDITION_CODE varchar,
	TRANSACTION_CHANNEL varchar,
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	SHIP_FROM_ZIP_CODE varchar,
	DESTINATION_ZIP_CODE varchar,
	DESTINATION_COUNTRY_CODE varchar,
	DISCOUNT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	SHIPPING_AMOUNT varchar,
	NATIONAL_TAX_INCLUDED varchar,
	NATIONAL_TAX varchar,
	ORDER_DATE varchar,
	OTHER_TAX varchar,
	SUMMARY_COMMODITY_CODE varchar,
	MERCHANT_VAT_REG varchar,
	CUSTOMER_VAT_REGISTRATION_NUMBER varchar,
	VAT_AMOUNT_FREIGHT varchar,
	VAT_RATE_FREIGHT varchar,
	VAT_INVOICE_REFERENCE_NUMBER varchar,
	INVOICE_NUMBER varchar,
	MERCHANT_DBA_CITY varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	POS_CONDITION_CODE varchar,
	TRANSACTION_CHANNEL varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	POS_CONDITION_CODE varchar,
	TRANSACTION_CHANNEL varchar,
	ELAVON4_RETAIL_FILE_BATCH_FK bigint(20),
	ELAVON4_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;