-- Create Table Statement for 'Elavon4 Auth Retail Transaction'
DROP TABLE IF EXISTS `ELAVON4_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `ELAVON4_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REQUEST varchar,
	APPLICATION_ID varchar,
	TERMINAL_ID varchar,
	POS_ENTRY_CAPABILITY varchar,
	ACCOUNT_ENTRY_MODE varchar,
	PARTIAL_AUTH_INDICATOR varchar,
	TRANSACTION_AMOUNT int(11),
	MERCHANT_REFERENCE_NBR varchar,
	POSTAL_ZIP_CODE varchar,
	STREET_ADDRESS varchar,
	CVV2_INDICATOR varchar,
	SALES_TAX int(11),
	CUSTOMER_CODE varchar,
	INVOICE_NUMBER varchar,
	SHIPPING_DATE varchar,
	ECOMMERCE_INDICATOR varchar,
	TRANSACTION_CODE varchar,
	ACCOUNT_TYPE varchar,
	SURCHARGE_AMOUNT int(11),
	KEY_POINTER varchar,
	RESPONSE_CODE varchar,
	ISSUER_RESPONSE_CODE varchar,
	AUTHORIZATION_SOURCE varchar,
	CAPTURE_CODE varchar,
	APPROVAL_CODE varchar,
	AUTHORIZATION_DATE varchar,
	AUTHORIZATION_TIME varchar,
	AUTHORIZATION_RESPONSE varchar,
	TRACE_NUMBER varchar,
	TRANSACTION_REFERENCE_NBR varchar,
	AMEX_CAPTURE_CODE varchar,
	AVS_RESPONSE varchar,
	CVV2_RESPONSE varchar,
	PS2000_DATA varchar,
	MSDI varchar,
	REFERENCE_NUMBER varchar,
	DEBIT_EBT_NETWORK_ID varchar,
	DEBIT_EBT_SETTLEMENT_DATE varchar,
	AUTHORIZED_AMOUNT varchar,
	ACCOUNT_BALANCE1 varchar,
	ACCOUNT_BALANCE2 varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	UCAF_INDICATOR varchar,
	RECURRING_PAYMENT_TYPE varchar,
	INSTALLMENT_NUMBER varchar,
	INSTALLMENT_COUNT varchar,
	DYNAMIC_DBA_NAME varchar,
	CASHBACK_AMOUNT varchar,
	GIFT_LOYALTY_TRANSACTION_CODE varchar,
	TENDER_TYPE varchar,
	PRE_AUTH_REFERENCE_NUMBER varchar,
	POINTS_ADDED varchar,
	POINTS_CANCELED varchar,
	MEMBER_NAME varchar,
	RECEIPT_MESSAGE varchar,
	VOUCHER_CLEAR_NBR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	ICC_ARC varchar,
	ICC_AUTHORIZED_AMOUNT varchar,
	ICC_CVMR varchar,
	ICC_OTHER_AMOUNT varchar,
	ICC_TRANSACTION_CURRENCY varchar,
	ICC_TT varchar,
	ICC_TTD varchar,
	LINE_NUMBER varchar,
	ICC_CID varchar,
	ICC_AED varchar,
	ICC_AIP varchar,
	ICC_ATC varchar,
	ICC_CRYPTOGRAM varchar,
	ICC_CSN varchar,
	ICC_CUSTOMER_EXCLUSIVE_DATA varchar,
	ICC_FORM_FACTOR_INDICATOR varchar,
	ICC_IAD varchar,
	ICC_TCP varchar,
	ICC_TERMINAL_TYPE varchar,
	ICC_TVR varchar,
	ICC_UNPREDICTABLE_NUMBER varchar,
	ICC_ARPC varchar,
	ICC_ISSUER_SCRIPT varchar,
	ICC_ISR varchar,
	PIN_ENTRY_CAPABILITY varchar,
	HEALTHCARE_AMOUNT int(11),
	PRESCRIPTION_AMOUNT int(11),
	VISION_AMOUNT int(11),
	CLINIC_OTHER_AMOUNT int(11),
	DENTAL_AMOUNT int(11),
	ICC_TCC varchar,
	ICC_CSN_RESPONSE varchar,
	ICC_ATC_RESPONSE varchar,
	TERMINAL_TYPE varchar,
	CAT_INDICATOR varchar,
	DYNAMIC_STREET_ADDRESS varchar,
	DYNAMIC_CITY varchar,
	DYNAMIC_STATE varchar,
	DYNAMIC_POSTAL_CODE varchar,
	DYNAMIC_PHONE_NUMBER varchar,
	DYNAMIC_COUNTRY_CODE varchar,
	DYNAMIC_SUB_MERCHANT_ID varchar,
	PROCESSING_CODE varchar,
	SYSTEM_TRACE_AUDIT_NBR varchar,
	RETRIEVAL_REFERENCE_NUMBER varchar,
	ORIGINAL_TRACE_NUMBER varchar,
	ORIGINAL_APPROVAL_CODE varchar,
	ORIGINAL_PS2000_DATA varchar,
	ORIGINAL_RESPONSE_CODE varchar,
	ORIGINAL_TRANSACTION_REFERENCE_NBR varchar,
	ASSOCIATION_NAME varchar,
	ICC_THIRD_PARTY_DATA varchar,
	SPEND_QUALIFIER varchar,
	DOCUMENTATION_VERSION varchar,
	ICC_DEDICATED_FILE_NAME varchar,
	DEVICE_TYPE varchar,
	ACCOUNT_BALANCE3 varchar,
	EMV_KEY_DATE varchar,
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	DYNAMIC_EMAIL_ADDRESS varchar,
	DYNAMIC_MCC varchar,
	DYNAMIC_TAX_ID varchar,
	DYNAMIC_AUTH_TYPE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	DYNAMIC_EMAIL_ADDRESS varchar,
	DYNAMIC_MCC varchar,
	DYNAMIC_TAX_ID varchar,
	DYNAMIC_AUTH_TYPE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	ECI_SECURITY_LEVEL_INDICATOR varchar,
	DYNAMIC_EMAIL_ADDRESS varchar,
	DYNAMIC_MCC varchar,
	DYNAMIC_TAX_ID varchar,
	DYNAMIC_AUTH_TYPE_INDICATOR varchar,
	STORED_CREDENTIAL_INDICATOR varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;