-- Create Table Statement for 'Paymentech UTF Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_UTF_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYMENTECH_UTF_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SYSTEM_INDICATOR varchar,
	CLIENT_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	TRANSACTION_SEQUENCE_FLAG varchar,
	SEQUENCE_NUMBER varchar,
	TRANSACTION_CODE varchar,
	PIN_CAPABILITY_CODE varchar,
	ENTRY_DATA_SOURCE varchar,
	LAST_RETRIEVAL_REFERENCE_NUMBER varchar,
	TRANSACTION_AMOUNT varchar,
	MARKET_SPECIFIC_DATA_INDICATOR varchar,
	INDUSTRY_CODE varchar,
	INDUSTRY_REFERENCE_CODE varchar,
	INDUSTRY_CHARGE_DESCRIPTION varchar,
	INDUSTRY_TIP_AMOUNT varchar,
	INDUSTRY_SERVER_NUMBER varchar,
	INDUSTRY_INVOICE_NUMBER varchar,
	INDUSTRY_ITEM_CODE varchar,
	INDUSTRY_TYPE_INDICATOR varchar,
	INDUSTRY_ELECTRONIC_COMMERCE_INDICATOR varchar,
	INDUSTRY_ECOMMERCE_GOODS_INDICATOR varchar,
	INDUSTRY_EMPLOYEE_NUMBER varchar,
	INDUSTRY_CASH_OUT_INDICATOR varchar,
	INDUSTRY_CARD_SEQUENCE_NUMBER varchar,
	INDUSTRY_CARD_TOTAL_NUMBER varchar,
	MISC_AUTHORIZATION_CODE varchar,
	MISC_RETRIEVAL_REFERENCE_NUMBER varchar,
	MISC_CASH_BACK_AMOUNT varchar,
	MISC_EBT_TYPE_CODE varchar,
	AV_CARDHOLDER_STREET_ADDRESS varchar,
	AV_EXTENDED_CARDHOLDER_STREET_ADDRESS varchar,
	AV_CARDHOLDER_ZIP_CODE varchar,
	PURCHASE_CUSTOMER_REFERENCE_NUMBER varchar,
	PURCHASE_LOCAL_TAX_FLAG varchar,
	PURCHASE_DESTINATION_ZIP varchar,
	PURCHASE_SALES_TAX_AMOUNT varchar,
	RESPONSE_ACTION_CODE varchar,
	RESPONSE_AUTHORIZATION_ERROR_CODE varchar,
	RESPONSE_BATCH_NUMBER varchar,
	RESPONSE_RETRIEVAL_REFERENCE_NUMBER varchar,
	RESPONSE_MESSAGE varchar,
	RESPONSE_CARD_TYPE varchar,
	RESPONSE_TRACE_NUMBER varchar,
	RESPONSE_AUTHORIZING_NETWORK_ID varchar,
	RESPONSE_AUTHORIZATION_SOURCE varchar,
	RESPONSE_SURCHARGE_FEE_AMOUNT varchar,
	RESPONSE_ADDRESS_VERIFICATION_CODE varchar,
	RESPONSE_FS_LEDGER_BALANCE varchar,
	RESPONSE_FS_AVAILABLE_BALANCE varchar,
	RESPONSE_BEGINNING_BALANCE varchar,
	RESPONSE_CASH_LEDGER_BALANCE varchar,
	RESPONSE_CASH_AVAILABLE_BALANCE varchar,
	RESPONSE_CASH_BEGINNING_BALANCE varchar,
	IC_AUTHORIZATION_CHARACTERISTICS_INDICATOR varchar,
	IC_VISA_TRANSACTION_ID varchar,
	IC_VISA_VALIDATION_CODE varchar,
	IC_VISA_AUTHORIZATION_RESPONSE_CODE varchar,
	IC_VISA_MERCHANT_CATEGORY_CODE varchar,
	IC_VISA_POS_ENTRY_MODE varchar,
	IC_VISA_COMMERCIAL_CARD_TYPE varchar,
	IC_VISA_TOTAL_AUTHORIZATION_AMOUNT varchar,
	IC_VISA_AVS_RESPONSE_CODE varchar,
	IC_MC_BANK_NET_REFERENCE_NUMBER varchar,
	IC_MC_BANK_NET_DATE varchar,
	IC_MC_CVC_ERROR_INDICATOR varchar,
	IC_MC_CVC_STATUS_CHANGE varchar,
	IC_MC_MAGNETIC_STRIPE_QUALITY_INDICATOR varchar,
	IC_MC_MERCHANT_CATEGORY_CODE varchar,
	TK_B1_CURRENT_BALANCE_AMOUNT varchar,
	TK_B3_PREVIOUS_BALANCE_AMOUNT varchar,
	TK_B3_APPROVED_AMOUNT int(11),
	TK_B5_CASH_OUT_AMOUNT varchar,
	TK_B6_AVAILABLE_BALANCE1_CURRENCY_CODE varchar,
	TK_B6_AVAILABLE_BALANCE1_AMOUNT varchar,
	TK_B7_AVAILABLE_BALANCE2_CURRENCY_CODE varchar,
	TK_B7_AVAILABLE_BALANCE2_AMOUNT varchar,
	TK_CV_RESPONSE_VALUE varchar,
	TK_ER_FAILED_TOKEN_INDICATOR varchar,
	TK_AP_APPROVED_AMOUNT int(11),
	TK_RN_POS_RETRIEVAL_REFERENCE_NUMBER varchar,
	TK_Q8_AUTHORIZATION_TYPE_CODE varchar,
	TK_Q8_CARD_TYPE varchar,
	TK_Q8_AUTHORIZED_AMOUNT varchar,
	TK_AT_TRANSACTION_IDENTIFIER varchar,
	TK_AC_CID_RESPONSE_VALUE varchar,
	TK_PD_AUTHORIZER_POS_DATA_CODE varchar,
	TK_PC_INFORMATION_RESPONSE_INDICATOR varchar,
	TK_PC_RESPONSE_VALUE varchar,
	TK_CB_CREDIT_CASH_BACK_OVER_AMOUNT varchar,
	TK_DA_PROCESSING_CODE varchar,
	TK_DA_SYSTEM_TRACE_AUDIT_NUMBER varchar,
	TK_DA_POS_ENTRY_MODE varchar,
	TK_DA_PIN_CAPABILITY_CODE varchar,
	TK_DA_TRACK_DATA_CONDITION_CODE varchar,
	TK_DA_AVS_RESPONSE_CODE varchar,
	TK_DA_CID_RESPONSE_CODE varchar,
	TK_DA_AUTH_AMOUNT varchar,
	TK_DC_DCC_CHECK_VALUE varchar,
	TK_VB_CAVV_RESPONSE_DATA varchar,
	TK_VC_VISA_CARD_LEVEL_RESULTS_CODE varchar,
	TK_CM_VISA_CVV_RESULTS_CODE varchar,
	TK_TT_NUMBER_OF_TOTALS varchar,
	TK_FB_FAILED_ACCOUNT_NUMBER varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	TK_B4_APPROVED_AMOUNT varchar,
	AI_APPLICATION_IDENTIFIER varchar,
	CR_CARD_AUTHENTICATION_RESULTS_CODE_REQUEST varchar,
	CR_CARD_AUTHENTICATION_RESULTS_CODE_RESPONSE varchar,
	DL_DOWNLOAD_FLAG varchar,
	FI_APPLICATION_IDENTIFIER varchar,
	FI_FALL_BACK_ALLOWED varchar,
	FL_APPLICATION_IDENTIFIER varchar,
	FL_OFFLINE_FLOOR_LIMIT varchar,
	FL_THRESHOLD_FOR_BASED_RANDOM_SELECTION_VALUE varchar,
	PS_PAN_SEQUENCE varchar,
	DS_DOWNLOAD_STATUS varchar,
	TS_TRANSACTION_SEQUENCE_COUNTER varchar,
	TK_DT_HOST_TIME varchar,
	TK_EK_ENCRYPTED_KEY_INDEX varchar,
	TK_CK_FORCED_CURRENT_KEY_REQUEST varchar,
	TK_VS_SPEND_QUALIFIED_RESULTS_CODE varchar,
	TK_AT_TRANSACTION_IDENTIFIER varchar,
	TK_AC_CID_RESPONSE_VALUE varchar,
	TK_PD_AUTHORIZER_POS_DATA_CODE varchar,
	TK_CM_VISA_CVV_RESULTS_CODE varchar,
	TK_TT_NUMBER_OF_TOTALS varchar,
	TK_FB_FAILED_ACCOUNT_NUMBER varchar,
	TK_DC_DCC_CHECK_VALUE varchar,
	TK_B3_APPROVED_AMOUNT int(11),
	TK_AP_APPROVED_AMOUNT int(11),
	DS_DOWNLOAD_STATUS varchar,
	FI_APPLICATION_IDENTIFIER varchar,
	FI_FALL_BACK_ALLOWED varchar,
	FL_APPLICATION_IDENTIFIER varchar,
	FL_OFFLINE_FLOOR_LIMIT varchar,
	FL_THRESHOLD_FOR_BASED_RANDOM_SELECTION_VALUE varchar,
	TK_DT_HOST_TIME varchar,
	TK_EK_ENCRYPTED_KEY_INDEX varchar,
	TK_CK_FORCED_CURRENT_KEY_REQUEST varchar,
	TK_VS_SPEND_QUALIFIED_RESULTS_CODE varchar,
	TK_AT_TRANSACTION_IDENTIFIER varchar,
	TK_AC_CID_RESPONSE_VALUE varchar,
	TK_PD_AUTHORIZER_POS_DATA_CODE varchar,
	TK_CM_VISA_CVV_RESULTS_CODE varchar,
	TK_TT_NUMBER_OF_TOTALS varchar,
	TK_FB_FAILED_ACCOUNT_NUMBER varchar,
	TK_DC_DCC_CHECK_VALUE varchar,
	TK_B3_APPROVED_AMOUNT int(11),
	TK_AP_APPROVED_AMOUNT int(11),
	DS_DOWNLOAD_STATUS varchar,
	FI_APPLICATION_IDENTIFIER varchar,
	FI_FALL_BACK_ALLOWED varchar,
	FL_APPLICATION_IDENTIFIER varchar,
	FL_OFFLINE_FLOOR_LIMIT varchar,
	FL_THRESHOLD_FOR_BASED_RANDOM_SELECTION_VALUE varchar,
	TK_DT_HOST_TIME varchar,
	TK_EK_ENCRYPTED_KEY_INDEX varchar,
	TK_CK_FORCED_CURRENT_KEY_REQUEST varchar,
	TK_VS_SPEND_QUALIFIED_RESULTS_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	PURCHASE_SALES_TAX_AMOUNT varchar,
	MISC_CASH_BACK_AMOUNT varchar,
	INDUSTRY_TIP_AMOUNT varchar,
	TK_B7_AVAILABLE_BALANCE2_AMOUNT varchar,
	TK_B6_AVAILABLE_BALANCE1_AMOUNT varchar,
	TK_B5_CASH_OUT_AMOUNT varchar,
	TK_B3_PREVIOUS_BALANCE_AMOUNT varchar,
	TK_B1_CURRENT_BALANCE_AMOUNT varchar,
	TK_B4_APPROVED_AMOUNT varchar,
	TK_MU_SUBMITTED_TRANSACTION_IDENTIFIER varchar,
	TRANSACTION_AMOUNT varchar,
	PURCHASE_SALES_TAX_AMOUNT varchar,
	MISC_CASH_BACK_AMOUNT varchar,
	INDUSTRY_TIP_AMOUNT varchar,
	TK_B7_AVAILABLE_BALANCE2_AMOUNT varchar,
	TK_B6_AVAILABLE_BALANCE1_AMOUNT varchar,
	TK_B5_CASH_OUT_AMOUNT varchar,
	TK_B3_PREVIOUS_BALANCE_AMOUNT varchar,
	TK_B1_CURRENT_BALANCE_AMOUNT varchar,
	TK_B4_APPROVED_AMOUNT varchar,
	TK_MU_SUBMITTED_TRANSACTION_IDENTIFIER varchar,
	TK_MU_SUBMITTED_TRANSACTION_IDENTIFIER varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;