-- Create Table Statement for 'Paymentech Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYMENTECH_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	INDUSTRY_TYPE varchar,
	TRANS_TYPE varchar,
	BIN varchar,
	MERCHANT_ID varchar,
	TERMINAL_ID varchar,
	CC_CARD_VERIFY_PRESENCE_IND varchar,
	AVS_ZIP varchar,
	AVS_ADDRESS1 varchar,
	AVS_CITY varchar,
	AVS_STATE varchar,
	ORDER_ID int(11),
	AMOUNT int(11),
	RETRY_TRACE bigint(20),
	CARD_PRESENT_IND varchar,
	TX_REF_NUM varchar,
	TX_REF_IDX varchar,
	RESP_DATE_TIME varchar,
	PROC_STATUS varchar,
	PROC_STATUS_MESSAGE varchar,
	APPROVAL_STATUS varchar,
	RESP_CODE varchar,
	RESP_CODE_MESSAGE varchar,
	AVS_RESP_CODE varchar,
	CVV_RESP_CODE varchar,
	AUTHORIZATION_CODE varchar,
	HOST_RESP_CODE varchar,
	HOST_AVS_RESP_CODE varchar,
	HOST_CVV_RESP_CODE varchar,
	RETRY_ATTEMPT_COUNT varchar,
	LAST_RETRY_DATE varchar,
	FAULT_STRING varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CARD_BRAND varchar,
	AVS_NAME varchar,
	COMMENTS varchar,
	SHIPPING_REF varchar,
	TAX_IND varchar,
	TAX_AMOUNT int(11),
	PCARD_ORDER_ID varchar,
	PCARD_DEST_ZIP varchar,
	DEBIT_BILLER_REFERENCE_NUMBER varchar,
	PARTIAL_AUTH_IND varchar,
	CUSTOMER_NAME varchar,
	REVERSAL_RETRY_NUMBER bigint(20),
	REMAINING_BALANCE varchar,
	REDEEMED_AMOUNT varchar,
	PARTIAL_AUTH_OCCURED 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;