-- Create Table Statement for 'Trans First Auth Retail Transaction'
DROP TABLE IF EXISTS `TRANS_FIRST_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `TRANS_FIRST_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERC_ID varchar,
	TRAN_CODE varchar,
	CONTACT_FULL_NAME varchar,
	CONTACT_PHONE_NR varchar,
	CONTACT_ADDR_LN1 varchar,
	CONTACT_CITY varchar,
	CONTACT_STATE varchar,
	CONTACT_ZIP_CODE varchar,
	CONTACT_EMAIL varchar,
	SHIP_FULL_NAME varchar,
	SHIP_ADDR_LN1 varchar,
	SHIP_ADDR_LN2 varchar,
	SHIP_CITY varchar,
	SHIP_STATE varchar,
	SHIP_ZIP_CODE varchar,
	REQ_AMT varchar,
	IND_CODE varchar,
	AUTH_REQ_PURC_CARD_MERC_ORD_NR varchar,
	AUTH_REQ_PURC_CARD_BILL_SHIP_TYPE varchar,
	AUTH_REQ_PURC_CARD_BILL_SHIP_CONTACT_ZIP_CODE varchar,
	AUTH_REQ_ORD_NR varchar,
	TAX_IDCR varchar,
	TAX_AMT varchar,
	ORIG_TRAN_DATA_DT_TM varchar,
	ORIG_TRAN_DATA_AUTH varchar,
	ORIG_TRAN_DATA_TRAN_NR varchar,
	RSP_CODE varchar,
	AUTH_RSP_AVS_RSLT varchar,
	AUTH_RSP_ACI varchar,
	AUTH_RSP_TRAN_ID varchar,
	AUTH_RSP_VAL_CODE varchar,
	TRAN_DATA_SWCH_KEY varchar,
	TRAN_DATA_TRAN_NR varchar,
	TRAN_DATA_DT_TM varchar,
	TRAN_DATA_AMT varchar,
	TRAN_DATA_STAN varchar,
	TRAN_DATA_AUTH varchar,
	CARD_TYPE varchar,
	MAP_CAID varchar,
	ADDITIONAL_AMOUNT_ACCOUNT_TYPE varchar,
	ADDITIONAL_AMOUNT_AMOUNT_TYPE varchar,
	ADDITIONAL_AMOUNT_CURRENCY_CODE varchar,
	ADDITIONAL_AMOUNT_AMOUNT_SIGN varchar,
	ADDITIONAL_AMOUNT_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	EXT_RSP_CODE varchar,
	FAULT_ERROR_CODE varchar,
	FAULT_ERROR_MESSAGE varchar,
	AUTH_RSP_SEC_RSLT 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;