-- Create Table Statement for 'First Data Rapid Connect Capture Retail Transaction '
DROP TABLE IF EXISTS `FIRST_DATA_RAPID_CONNECT_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_RAPID_CONNECT_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	AUTHORIZATION_CODE varchar,
	AUTHORIZATION_DATE varchar,
	REFERENCE_NUMBER varchar,
	RECEIPT_NO varchar,
	TRANSACTION_IDENTIFIER varchar,
	VALIDATION_CODE varchar,
	MERCHANT_CATEGORY_CODE varchar,
	CARDHOLDER_ACTIVATED_TERMINAL varchar,
	MAGNETIC_STRIPE_STATUS varchar,
	POS_TERMINAL_CAPABILITY varchar,
	ENTRY_MODE varchar,
	CARDHOLDER_ID varchar,
	MERCHANT_ZIP varchar,
	PURCHASE_ID_FORMAT varchar,
	MARKET_SPECIFIC_DATE varchar,
	TOTAL_AUTH_AMOUNT varchar,
	AUTH_AMOUNT varchar,
	INITIAL_AUTH_AMOUNT varchar,
	MARKET_SPECIFIC_AUTH_INDICATOR varchar,
	VISA_CARD_LEVEL_INDICATOR varchar,
	AUTH_RESPONSE_CODE varchar,
	ACI varchar,
	CVV2_RESULT_CODE varchar,
	BANK_NET_REFERENCE_ID varchar,
	BANK_NET_DATE varchar,
	EC_SECURITY_LEVEL varchar,
	TRANSACTION_ERROR_EDIT_CODE varchar,
	CVC_ERROR varchar,
	POS_DATA varchar,
	AVS_RESPONSE varchar,
	SPECIAL_CONDITION_INDICATOR varchar,
	ORDER_NUMBER varchar,
	CUSTOMER_SERVICE_NUMBER varchar,
	MERCHANT_PURCHASE_REFERENCE_IDENTIFIER varchar,
	DESTINATION_COUNTRY varchar,
	LOCAL_TAX_AMOUNT varchar,
	DISCOUNT_AMOUNT varchar,
	FREIGHT_AMOUNT varchar,
	DUTY_AMOUNT varchar,
	LOCAL_TAX_INDICATOR varchar,
	DISCOUNT_AMOUNT_INDICATOR varchar,
	FREIGHT_AMOUNT_INDICATOR varchar,
	DUTY_AMOUNT_INDICATOR varchar,
	DESTINATION_ZIP varchar,
	MERCHANT_ZIP_PURCHASE_CARD varchar,
	SHIP_FROM_ZIP varchar,
	DE22_DATA varchar,
	LOCAL_TRANSACTION_TIME varchar,
	DS_PROCESSING_CODE varchar,
	DS_STAN varchar,
	DS_POS_ENTRY_MODE varchar,
	DS_TRACK_DATA_CONDITION_CODE varchar,
	DS_POS_DATA varchar,
	MASTER_CARD_TRANSACTION_CATEGORY_INDICATOR varchar,
	UCAF_STATUS varchar,
	CUSTOMER_CODE varchar,
	CASH_BACK_AMOUNT varchar,
	NETWORK_ID varchar,
	VISA_SERVICE_DEVELOPMENT varchar,
	PREPAID_CARD_INDICATOR varchar,
	AUTH_CURRENCY_CODE varchar,
	VISA_POS_CONDITION_CODE varchar,
	POS_ENTRY_MODE_CHANGE varchar,
	AUTH_TIME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_DATE varchar,
	FILE_BATCH_FK bigint(20),
	CUSTOMER_NAME varchar,
	ACKNOWLEDGMENT_CODE varchar,
	NETWORK_REFERENCE_ID varchar,
	AUTHORIZATION_SOURCE varchar,
	LODGING_SPECIAL_PROGRAM varchar,
	RETURN_LOCATION_ID varchar,
	RENTAL_DATE varchar,
	RESTAURANT_FOOD_AMOUNT varchar,
	TRANSACTION_CATEGORY_CODE varchar,
	ADJUSTED_AMOUNT varchar,
	TRANSACTION_CURRENCY_CODE varchar,
	TOTAL_MILES varchar,
	CARD_SEQUENCE_NUMBER varchar,
	RETURN_COUNTRY_CODE varchar,
	AMOUNT_OTHER varchar,
	TERMINAL_COUNTRY_CODE varchar,
	TERMINAL_VERIFICATION_RESULTS varchar,
	PROGRAM_CODE varchar,
	ISSUER_APPLICATION_DATA2 varchar,
	DEDICATED_FILE_NAME varchar,
	LODGING_CHARGE_TYPE varchar,
	UNPREDICTABLE_NUMBER varchar,
	ISSUER_APPLICATION_DATA varchar,
	RESTAURANT_TIP_ID varchar,
	ISSUER_SCRIPT1_RESULTS2 varchar,
	CARDHOLDER_VERIFICATION_METHOD_RESULTS varchar,
	RESTAURANT_TIP_AMOUNT varchar,
	ISSUER_AUTHENTICATION_DATA varchar,
	TERMINAL_TYPE varchar,
	RENTAL_CITY varchar,
	APPLICATION_CRYPTOGRAM varchar,
	TERMINAL_SERIAL_NUMBER varchar,
	TRANSACTION_SEQUENCE_COUNTER varchar,
	TERMINAL_CAPABILITY_PROFILE varchar,
	INSURANCE_CHARGES varchar,
	APPLICATION_TRANSACTION_COUNTER varchar,
	DAILY_RENTAL_RATE varchar,
	APPLICATION_INTERCHANGE_PROFILE varchar,
	RENTAL_RETURN_STATE_COUNTRY varchar,
	DURATION varchar,
	MAXIMUM_FREE_MILES varchar,
	APPLICATION_EXPIRATION_DATE varchar,
	CRYPTOGRAM_INFORMATION_DATA varchar,
	CARDHOLDER_NAME varchar,
	TRANSACTION_TYPE varchar,
	RETURN_TIME varchar,
	FORM_FACTOR_INDICATOR varchar,
	RENTAL_TIME varchar,
	RENTAL_RETURN_DATE varchar,
	ADJUSTED_AMOUNT_INDICATOR varchar,
	INSURANCE_INDICATOR varchar,
	TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	ISSUER_SCRIPT1_RESULTS varchar,
	TERMINAL_TRANSACTION_DATE varchar,
	RENTAL_STATE varchar,
	AUDIT_INDICATOR varchar,
	RATE_PER_MILE varchar,
	CRYPTOGRAM_AMOUNT varchar,
	CAR_RENTAL_AGREEMENT_NUMBER varchar,
	DEPARTURE_DATE varchar,
	SAFE_KEY_ELECTRONIC_COMMERCE_INDICATOR varchar,
	LAUNDRY_AMOUNT varchar,
	TOTAL_ROOM_TAX varchar,
	GIFT_SHOP_CHARGES varchar,
	FOLIO_NUMBER varchar,
	TAX_EXEMPT_INDICATOR varchar,
	RESTAURANT_CHARGES varchar,
	EXTRA_CHARGES_INDICATOR varchar,
	RENTER_NAME varchar,
	NO_SHOW_INDICATOR varchar,
	ARRIVAL_DATE varchar,
	TIP_AMOUNT varchar,
	PHONE_CHARGES varchar,
	ROOM_RATE varchar,
	MINI_BAR_CHARGES varchar,
	RENTAL_RETURN_CITY varchar,
	EXTRA_CHARGE varchar,
	MERCHANT_URL_OR_EMAIL_ADDRESS varchar,
	EXTRA_MILE_CHARGE varchar,
	FUEL_CHARGE varchar,
	OTHER_CHARGES varchar,
	MERCHANT_TAX_ID varchar,
	GUEST_NAME varchar,
	ONE_WAY_DROP_OFF_CHARGES varchar,
	RENTAL_COUNTRY varchar,
	ORDER_DATE varchar,
	ORIGINATING_COUNTRY varchar,
	DESTINATION_STATE varchar,
	ORIGINATING_STATE varchar,
	ORIGINATING_CITY varchar,
	DESTINATION_CITY varchar,
	SHIPPING_HANDLING_FEE varchar,
	ORIGINATING_PHONE_NUMBER varchar,
	DESTINATION_ADDRESS varchar,
	TRANSACTION_TYPE_CODE varchar,
	ORIGINATING_ADDRESS varchar,
	ORIGINATING_ZIP varchar,
	RECEIVER_NAME varchar,
	RENTAL_ADDRESS varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;