-- Create Table Statement for 'FirstData Nashville Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_NASHVILLE_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_NASHVILLE_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	CLIENT_REF varchar,
	BIT3 varchar,
	BIT4 varchar,
	BIT7 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT13 varchar,
	BIT18 varchar,
	BIT22 varchar,
	BIT24 varchar,
	BIT25 varchar,
	BIT37 varchar,
	BIT41 varchar,
	BIT42 varchar,
	BIT48 varchar,
	BIT59 varchar,
	BIT60 varchar,
	AUTHORIZATION_CODE varchar,
	RESPONSE_CODE varchar,
	AVS_RESPONSE_CODE varchar,
	ACI varchar,
	TRAN_ID varchar,
	VALIDATION_CODE varchar,
	MSDI varchar,
	BANK_NET_DATE varchar,
	BANK_NET_REFERENCE varchar,
	CVC_ERROR_CODE varchar,
	POS_ENTRY_MODE_CHANGE varchar,
	TRANSACTION_EDIT_ERROR_CODE varchar,
	POS_DATA varchar,
	HOST_RESPONSE_TEXT varchar,
	CVV2_RESULT_CODE varchar,
	CARD_LEVEL_RESPONSE_CODE varchar,
	APPROVED_AMOUNT varchar,
	BIT54 varchar,
	BIT38 varchar,
	IS_PRIVATE_DATA_FIELD_RESPONSE_PRESENT tinyint(1),
	MERCHANT_ADVICE_CODE varchar,
	DEBIT_NETWORK_ID varchar,
	MC varchar,
	DS_STAN varchar,
	DS_TRACK_DATA_CONDITION_CODE varchar,
	DS_ADDRESS_VERIFICATION_RESULT varchar,
	DS_NRID varchar,
	VPAS_RESPONSE_VALUE varchar,
	TABLE68_ACCOUNT_TYPE1 varchar,
	TABLE68_AMOUNT_TYPE1 varchar,
	TABLE68_CURRENCY_CODE1 varchar,
	TABLE68_SIGN_AMOUNT1 varchar,
	TABLE68_AMOUNT1 varchar,
	TABLE68_ACCOUNT_TYPE2 varchar,
	TABLE68_AMOUNT_TYPE2 varchar,
	TABLE68_CURRENCY_CODE2 varchar,
	TABLE68_SIGN_AMOUNT2 varchar,
	TABLE68_AMOUNT2 varchar,
	TABLE68_ACCOUNT_TYPE3 varchar,
	TABLE68_AMOUNT_TYPE3 varchar,
	TABLE68_CURRENCY_CODE3 varchar,
	TABLE68_SIGN_AMOUNT3 varchar,
	TABLE68_AMOUNT3 varchar,
	TABLE68_ACCOUNT_TYPE4 varchar,
	TABLE68_AMOUNT_TYPE4 varchar,
	TABLE68_CURRENCY_CODE4 varchar,
	TABLE68_SIGN_AMOUNT4 varchar,
	TABLE68_AMOUNT4 varchar,
	TABLE68_ACCOUNT_TYPE5 varchar,
	TABLE68_AMOUNT_TYPE5 varchar,
	TABLE68_CURRENCY_CODE5 varchar,
	TABLE68_SIGN_AMOUNT5 varchar,
	TABLE68_AMOUNT5 varchar,
	TABLE68_ACCOUNT_TYPE6 varchar,
	TABLE68_AMOUNT_TYPE6 varchar,
	TABLE68_CURRENCY_CODE6 varchar,
	TABLE68_SIGN_AMOUNT6 varchar,
	TABLE68_AMOUNT6 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	SUB_REQUEST_CL varchar,
	BIT39 varchar,
	TABLE60_ADDITIONAL_POS_INFO varchar,
	DS_PROCESSING_CODE varchar,
	BIT23 varchar,
	TABLE_EV varchar,
	BIT31 varchar,
	TAX_AMOUNT varchar,
	TAX_INDICATOR varchar,
	PURCHASE_IDENTIFIER varchar,
	CUSTOMER_REFERENCE_IDENTIFIER varchar,
	DESTINATION_POSTAL_CODE varchar,
	MERCHANT_TAX_ID varchar,
	BIT49 varchar,
	BIT43 varchar,
	SP_TAG01 varchar,
	SP_TAG02 varchar,
	SP_TAG03 varchar,
	SP_TAG04 varchar,
	SP_TAG06 varchar,
	SP_TAG07 varchar,
	SP_TAG10 varchar,
	SP_TAG11 varchar,
	TABLE14_RESP varchar,
	TABLE_VI_RESP varchar,
	TABLE_MC_RESP varchar,
	TABLE_DS_RESP varchar,
	BIT44 varchar,
	TOKEN_CODE varchar,
	PROVIDER_ID varchar,
	TABLE_TK_PN varchar,
	TOKEN_REQUESTOR_ID varchar,
	TABLE_TK_TI varchar,
	TABLE_TK_TB varchar,
	TABLE_TK_TA varchar,
	CANADIAN_NETWORK_RESPONSE_CODE varchar,
	SP_TAG08 varchar,
	SP_TAG12 varchar,
	BIT70 varchar,
	MERCHANT_ADVICE_CODE varchar,
	MERCHANT_ADVICE_CODE varchar,
	NETWORK_LABEL varchar,
	NETWORK_LABEL varchar,
	NETWORK_LABEL varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	SPEND_QUALIFIED_INDICATOR varchar,
	TABLE36_ORDER_NUMBER varchar,
	TABLE36_ORDER_NUMBER varchar,
	UCAF_COLLECTOR_DATA varchar,
	UCAF_DOWNGRADE_REASON_CODE varchar,
	UCAF_COLLECTOR_DATA varchar,
	UCAF_DOWNGRADE_REASON_CODE varchar,
	TABLE36_ORDER_NUMBER varchar,
	UCAF_COLLECTOR_DATA varchar,
	UCAF_DOWNGRADE_REASON_CODE 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;