-- Create Table Statement for 'First Data Rapid Connect Auth Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	PYMT_TYPE varchar,
	REVERSAL_IND varchar,
	TXN_TYPE varchar,
	LOCAL_DATE_TIME varchar,
	TRNMSN_DATE_TIME varchar,
	STAN varchar,
	REF_NUM varchar,
	ORDER_NUM varchar,
	TPPID varchar,
	TERM_ID varchar,
	MERCH_ID varchar,
	ALT_MERCH_ID varchar,
	MERCH_CAT_CODE varchar,
	POS_ENTRY_MODE varchar,
	POS_COND_CODE varchar,
	TERM_CAT_CODE varchar,
	TERM_ENTRY_CAPABLT varchar,
	TXN_AMT varchar,
	TXN_AMT_RESPONSE varchar,
	TXN_CRNCY varchar,
	TERM_LOC_IND varchar,
	CARD_CAPT_CAP varchar,
	PROGRAM_ID varchar,
	GROUP_ID varchar,
	POSID varchar,
	SETTLE_IND varchar,
	CARD_TYPE varchar,
	AVS_RESULT_CODE varchar,
	CCV_IND varchar,
	CCV_RESULT_CODE varchar,
	ADD_AMT1 varchar,
	ADD_AMT_TYPE1 varchar,
	PART_AUTHRZTN_APPRVL_CAPABLT1 varchar,
	ADD_AMT2 varchar,
	ADD_AMT_TYPE2 varchar,
	ADD_AMT3 varchar,
	ADD_AMT4 varchar,
	ADD_AMT5 varchar,
	ADD_AMT6 varchar,
	ADD_AMT_TYPE3 varchar,
	ADD_AMT_TYPE4 varchar,
	ADD_AMT_TYPE5 varchar,
	ADD_AMT_TYPE6 varchar,
	RESP_CODE varchar,
	AUTH_ID varchar,
	ADDTL_RESP_DATA varchar,
	STTLM_DATE varchar,
	ATH_NTWK_ID varchar,
	ERROR_DATA varchar,
	ORIG_AUTH_ID varchar,
	ORIG_LOCAL_DATE_TIME varchar,
	ORIG_TRAN_DATE_TIME varchar,
	ORIG_STAN varchar,
	ORIG_RESP_CODE varchar,
	BILL_PYMT_TXN_IND varchar,
	MERCH_ADVICE_CODE varchar,
	CARD_SEQ_NUM varchar,
	XCODE_RESP varchar,
	SERV_CODE varchar,
	CARC varchar,
	PROC_IND varchar,
	ACI varchar,
	MRKT_SPECIFIC_DATA_IND varchar,
	CARD_LEVEL_RESULT varchar,
	SOURCE_REASON_CODE varchar,
	TRANS_ID varchar,
	VISA_BID1 varchar,
	VISA_AUAR1 varchar,
	TAX_AMT_CAPABLT varchar,
	TAX_AMT_CAPABLT_RESPONSE varchar,
	BANKNET_DATA varchar,
	MC_MSDI varchar,
	CCV_ERROR_CODE varchar,
	POS_ENTRY_MODE_CHG varchar,
	TRAN_EDIT_ERR_CODE varchar,
	MC_POS_DATA varchar,
	DEV_TYPE_IND varchar,
	DISC_PROC_CODE varchar,
	DISC_POS_ENTRY varchar,
	DISC_RESP_CODE varchar,
	DISC_POS_DATA varchar,
	DISC_TRANS_QUALIFIER varchar,
	DISC_NRID varchar,
	AM_EX_POS_DATA varchar,
	AM_EX_TRAN_ID varchar,
	TAX_AMT varchar,
	TAX_IND varchar,
	PURCH_IDFR varchar,
	PC_ORDER_NUM varchar,
	DISCNT_AMT varchar,
	FRGHT_AMT varchar,
	DUTY_AMT varchar,
	DEST_POSTAL_CODE varchar,
	SHIP_FROM_POSTAL_CODE varchar,
	DEST_CTRY_CODE varchar,
	MERCH_TAX_ID varchar,
	PROD_DESC varchar,
	ECOMM_TXN_IND varchar,
	CUST_SVC_PHONE_NUMBER varchar,
	ECOMM_URL varchar,
	CAVV_RESULT_CODE varchar,
	SAFEKEY varchar,
	UCAF_COLLECT_IND varchar,
	AVS_BILLING_ADDR varchar,
	AVS_BILLING_POSTAL_CODE varchar,
	CARD_CLASS varchar,
	CARD_COST varchar,
	PAYEE_PHONE_NUM varchar,
	PAYEE_ID varchar,
	BILLING_IND varchar,
	FPI varchar,
	EBT_TYPE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ACI_RESPONSE varchar,
	ADD_AMT1_RESPONSE varchar,
	ADD_AMT_CRNCY1_RESPONSE varchar,
	ADD_AMT_TYPE1_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE1_RESPONSE varchar,
	ADD_AMT2_RESPONSE varchar,
	ADD_AMT_CRNCY2_RESPONSE varchar,
	ADD_AMT_TYPE2_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE2_RESPONSE varchar,
	ADD_AMT3_RESPONSE varchar,
	ADD_AMT_CRNCY3_RESPONSE varchar,
	ADD_AMT_TYPE3_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE3_RESPONSE varchar,
	ADD_AMT4_RESPONSE varchar,
	ADD_AMT_CRNCY4_RESPONSE varchar,
	ADD_AMT_TYPE4_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE4_RESPONSE varchar,
	ADD_AMT5_RESPONSE varchar,
	ADD_AMT_CRNCY5_RESPONSE varchar,
	ADD_AMT_TYPE5_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE5_RESPONSE varchar,
	ADD_AMT6_RESPONSE varchar,
	ADD_AMT_CRNCY6_RESPONSE varchar,
	ADD_AMT_TYPE6_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE6_RESPONSE varchar,
	ADD_AMT7_RESPONSE varchar,
	ADD_AMT_CRNCY7_RESPONSE varchar,
	ADD_AMT_TYPE7_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE7_RESPONSE varchar,
	ADD_AMT8_RESPONSE varchar,
	ADD_AMT_CRNCY8_RESPONSE varchar,
	ADD_AMT_TYPE8_RESPONSE varchar,
	ADD_AMT9_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE8_RESPONSE varchar,
	ADD_AMT_CRNCY9_RESPONSE varchar,
	ADD_AMT_TYPE9_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE9_RESPONSE varchar,
	ADD_AMT10_RESPONSE varchar,
	ADD_AMT_CRNCY10_RESPONSE varchar,
	ADD_AMT_ACCT_TYPE10_RESPONSE varchar,
	ADD_AMT_TYPE10_RESPONSE varchar,
	STATUS varchar,
	RETURN_CODE varchar,
	CLIENT_REF varchar,
	TRNMSN_DATE_TIME_RESPONSE varchar,
	CH_FULL_NM_RES varchar,
	ADD_AMT7 varchar,
	ADD_AMT_TYPE7 varchar,
	ADD_AMT8 varchar,
	ADD_AMT_TYPE8 varchar,
	ADD_AMT9 varchar,
	ADD_AMT_TYPE9 varchar,
	ADD_AMT10 varchar,
	ADD_AMT_TYPE10 varchar,
	ADD_AMT11 varchar,
	ADD_AMT_TYPE11 varchar,
	ADD_AMT12 varchar,
	ADD_AMT_TYPE12 varchar,
	ADD_AMT13 varchar,
	ADD_AMT_TYPE13 varchar,
	ADD_AMT14 varchar,
	ADD_AMT_TYPE14 varchar,
	VISA_BID2 varchar,
	VISA_BID3 varchar,
	VISA_AUAR2 varchar,
	VISA_AUAR3 varchar,
	MCSC varchar,
	CH_FIRST_NM varchar,
	CH_LAST_NM varchar,
	SPEND_Q_IND varchar,
	PROC_INFO varchar,
	EMV_DATA_REQUEST varchar,
	EMV_DATA_RESPONSE varchar,
	GIFT_ACCOUNT_NUMBER varchar,
	GIFT_CARD_EXPIRATION_DATE varchar,
	ATH_NTWK_NM varchar,
	RT_IND varchar,
	SIG_IND varchar,
	MC_ACI varchar,
	MC_ADD_DATA varchar,
	VAT_TAX_AMT varchar,
	VAT_TAX_RT varchar,
	DURATION varchar,
	RENTAL_CITY varchar,
	RENTAL_STATE varchar,
	RENTAL_CTRY varchar,
	RENTAL_DATE varchar,
	RENTAL_TIME varchar,
	RETURN_CITY varchar,
	RETURN_STATE varchar,
	RETURN_CTRY varchar,
	RETURN_DATE varchar,
	RETURN_TIME varchar,
	AMT_EXTRA_CHRGS varchar,
	RENTER_NAME varchar,
	AUTO_AGREE_NUM varchar,
	RENTAL_DURATION varchar,
	RENTAL_EXTRA_CHRGS varchar,
	AUTO_NO_SHOW varchar,
	MC_ADD_DATA_RESPONSE varchar,
	MCSN varchar,
	CARD_TYPE_RESPONSE varchar,
	ODO varchar,
	VEH_NUM varchar,
	JOB_NUM varchar,
	DRV_NUM varchar,
	FLT_EMP_NUM varchar,
	LIC_NUM varchar,
	JOB_ID varchar,
	DEPT_NUM varchar,
	CUST_DATA varchar,
	USER_ID varchar,
	VEH_ID_NUM varchar,
	SERV_RES_CD varchar,
	ORIG_ATH_NTWK_ID varchar,
	ORDER_DATE varchar,
	MERCH_FNS_NUM varchar,
	EBT_CARD_SEQ_NUM varchar,
	VOUCHER_NUM varchar,
	MERCH_NAME varchar,
	MERCH_ADDR varchar,
	MERCH_CITY varchar,
	MERCH_STATE varchar,
	MERCH_CNTY varchar,
	MERCH_POSTAL_CODE varchar,
	MERCH_CTRY varchar,
	PC3_ADD varchar,
	FIRST_DATA_RAPID_CONNECT_AUTH_RETAIL_ITEM_FK bigint(20),
	PL_POS_DEBIT_FLG varchar,
	PL_POS_DEBIT_FLG_RESPONSE varchar,
	POS_ID varchar,
	VERSION varchar,
	TPP_ID varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	TPPID varchar,
	POSID varchar,
	TPPID varchar,
	POSID varchar,
	TPPID varchar,
	POSID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;