-- Create Table Statement for 'FirstData Nashville Capture Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_NASHVILLE_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_NASHVILLE_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_DATE 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,
	AUTHORIZATION_SOURCE varchar,
	POS_TERMINAL_CAPABILITY varchar,
	ENTRY_MODE varchar,
	CARDHOLDER_ID varchar,
	MERCHANT_NAME varchar,
	MERCHANT_ZIP varchar,
	PURCHASE_ID_FORMAT varchar,
	MARKET_SPECIFIC_DATE varchar,
	TOTAL_AUTH_AMOUNT varchar,
	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,
	NETWORK_REFERENCE_ID varchar,
	SPECIAL_CONDITION_INDICATOR varchar,
	CLEARING_SEQUENCE varchar,
	CLEARING_COUNT 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,
	RESTAURANT_ID varchar,
	RESTAURANT_FOOD_AMOUNT varchar,
	RESTAURANT_TIP_ID varchar,
	RESTAURANT_TIP_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK bigint(20),
	INITIAL_AUTH_AMOUNT 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,
	ACKNOWLEDGMENT_CODE varchar,
	ARRIVAL_DATE varchar,
	DEPARTURE_DATE varchar,
	FOLIO_NUMBER varchar,
	PROPERTY_TELEPHONE_NUMBER varchar,
	CUSTOMER_SERVICE800_NUMBER varchar,
	ROOM_RATE varchar,
	TOTAL_ROOM_TAX varchar,
	PROGRAM_CODE varchar,
	PHONE_CHARGES varchar,
	RESTAURANT_CHARGES varchar,
	MINI_BAR_CHARGES varchar,
	GIFT_SHOP_CHARGES varchar,
	LAUNDRY_AMOUNT varchar,
	OTHER_SERVICES_CODE varchar,
	OTHER_SERVICES_CHARGES varchar,
	BILLING_ADJUSTMENT_INDICATOR varchar,
	BILLING_ADJUSTMENT_AMOUNT varchar,
	LODGING_CHARGE_TYPE varchar,
	LODGING_ARRIVAL_DATE varchar,
	LODGING_DEPARTURE_DATE varchar,
	LODGING_DURATION_STAY varchar,
	LODGING_SPECIAL_PROGRAM varchar,
	LODGING_ROOM_RATE varchar,
	MERCHANT_TAX_ID varchar,
	CARD_SEQUENCE_NUMBER varchar,
	CRYPTOGRAM_AMOUNT varchar,
	TRANSACTION_TYPE varchar,
	TERMINAL_TRANSACTION_DATE varchar,
	TRANSACTION_CURRENCY_CODE varchar,
	TERMINAL_COUNTRY_CODE varchar,
	APPLICATION_CRYPTOGRAM varchar,
	APPLICATION_TRANSACTION_COUNTER varchar,
	UNPREDICTABLE_NUMBER varchar,
	TERMINAL_VERIFICATION_RESULTS varchar,
	TERMINAL_SERIAL_NUMBER varchar,
	APPLICATION_EXPIRATION_DATE varchar,
	ISSUER_APPLICATION_DATA1 varchar,
	ISSUER_APPLICATION_DATA2 varchar,
	TRANSACTION_CATEGORY_CODE varchar,
	TRANSACTION_SEQUENCE_COUNTER varchar,
	OTHER_AMOUNT varchar,
	DEDICATED_FILE_NAME varchar,
	CRYPTOGRAM_INFORMATION_DATA varchar,
	CARDHOLDER_VERIFICATION_METHOD_RESULTS varchar,
	TERMINAL_APPLICATION_VERSION_NUMBER varchar,
	TERMINAL_TYPE varchar,
	TERMINAL_CAPABILITY_PROFILE varchar,
	ISSUER_AUTHENTICATION_DATA varchar,
	AUTHORIZATION_RESPONSE_CODE varchar,
	ISSUER_SCRIPT1_RESULTS varchar,
	CHIP_CONDITION_CODE varchar,
	EMV_RECORD_TYPE varchar,
	CAR_RENTAL_AGREEMENT_NUMBER varchar,
	RENTER_NAME varchar,
	TAX_EXEMPT_INDICATOR varchar,
	RENTAL_RETURN_CITY varchar,
	RENTAL_RETURN_STATE_COUNTRY varchar,
	RENTAL_RETURN_DATE varchar,
	RETURN_LOCATION_ID varchar,
	RENTAL_DATE varchar,
	DAILY_RENTAL_RATE varchar,
	RATE_PER_MILE varchar,
	TOTAL_MILES varchar,
	MAXIMUM_FREE_MILES varchar,
	INSURANCE_INDICATOR varchar,
	INSURANCE_CHARGES varchar,
	ADJUSTED_AMOUNT_INDICATOR varchar,
	ADJUSTED_AMOUNT varchar,
	RENTAL_CITY varchar,
	RENTAL_STATE varchar,
	RENTAL_TIME varchar,
	RETURN_TIME varchar,
	RETURN_COUNTRY_CODE varchar,
	VISA_SERVICE_DEVELOPMENT varchar,
	APPLICATION_INTERCHANGE_PROFILE varchar,
	FIRST_DATA_NASHVILLE_RETAIL_ITEM_FK bigint(20),
	SPEND_QUALIFIED_INDICATOR varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK bigint(20),
	FIRST_DATA_NASHVILLE_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;