-- Create Table Statement for 'Heartland Portico Auth Retail Transaction'
DROP TABLE IF EXISTS `HEARTLAND_PORTICO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `HEARTLAND_PORTICO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REQUEST_TYPE varchar,
	LICENSE_ID varchar,
	SITE_ID varchar,
	DEVICE_ID varchar,
	USER_NAME varchar,
	SITE_TRACE varchar,
	DEVELOPER_ID varchar,
	VERSION_NBR varchar,
	AMT varchar,
	CVV2_STATUS varchar,
	CARD_PRESENT varchar,
	READER_PRESENT varchar,
	CARD_HOLDER_FIRST_NAME varchar,
	CARD_HOLDER_LAST_NAME varchar,
	CARD_HOLDER_ADDR varchar,
	CARD_HOLDER_CITY varchar,
	CARD_HOLDER_STATE varchar,
	CARD_HOLDER_ZIP varchar,
	CARD_HOLDER_PHONE varchar,
	CARD_HOLDER_EMAIL varchar,
	DIRECT_MKT_INVOICE_NBR varchar,
	DIRECT_MKT_SHIP_MONTH varchar,
	DIRECT_MKT_SHIP_DAY varchar,
	FIRST_ADDITIONAL_AMT_TYPE varchar,
	FIRST_ADDITIONAL_AMT varchar,
	SECOND_ADDITIONAL_AMT_TYPE varchar,
	SECOND_ADDITIONAL_AMT varchar,
	THIRD_ADDITIONAL_AMT_TYPE varchar,
	THIRD_ADDITIONAL_AMT varchar,
	FOURTH_ADDITIONAL_AMT_TYPE varchar,
	FOURTH_ADDITIONAL_AMT varchar,
	CARD_HOLDER_PO_NBR varchar,
	TAX_TYPE varchar,
	TAX_AMT varchar,
	GRATUITY_AMT_INFO varchar,
	CPC_REQ varchar,
	ALLOW_PARTIAL_AUTH varchar,
	ECOMMERCE varchar,
	OFFLINE_AUTH_CODE varchar,
	ONE_TIME_PAYMENT varchar,
	INVOICE_NBR varchar,
	CASH_BACK_AMT_INFO varchar,
	ELECTRONIC_VOUCHER_SERIAL_NBR varchar,
	VOUCHER_APPROVAL_CD varchar,
	BALANCE_INQUIRY_TYPE varchar,
	BALANCE_AMOUNT varchar,
	REFUND_AMOUNT varchar,
	SPLIT_TENDER_CARD_AMT varchar,
	SPLIT_TENDER_BALANCE_DUE_AMT varchar,
	GATEWAY_TXN_ID varchar,
	GATEWAY_RSP_CODE varchar,
	GATEWAY_RSP_MSG varchar,
	RSP_DT varchar,
	RSP_CODE varchar,
	RSP_TEXT varchar,
	AUTH_CODE varchar,
	AUTH_AMT varchar,
	AVS_RSLT_CODE varchar,
	CVV_RSLT_CODE varchar,
	CPC_IND varchar,
	REF_NBR varchar,
	AVAILABLE_BALANCE varchar,
	CARD_TYPE varchar,
	AVS_RSLT_TEXT varchar,
	CVV_RSLT_TEXT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	REAL_TIME_SUBSTANTIATION varchar,
	CURRENCY varchar,
	POINTS_BALANCE_AMT varchar,
	REWARDS varchar,
	NOTES varchar,
	ACTION varchar,
	ALIAS varchar,
	LODGING_FOLIO_NUMBER varchar,
	LODGING_DURATION int(11),
	LODGING_CHECK_IN_DATE varchar,
	LODGING_CHECK_OUT_DATE varchar,
	LODGING_ROOM_RATE_AMOUNT varchar,
	LODGING_ADVANCED_DEPOSIT_TYPE varchar,
	LODGING_NO_SHOW varchar,
	LODGING_EXTRA_CHARGES_RESTAURANT varchar,
	LODGING_EXTRA_CHARGES_GIFT_SHOP varchar,
	LODGING_EXTRA_CHARGES_MINI_BAR varchar,
	LODGING_EXTRA_CHARGES_TELEPHONE varchar,
	LODGING_EXTRA_CHARGES_OTHER varchar,
	LODGING_EXTRA_CHARGES_LAUNDRY varchar,
	TRACK_DATA_METHOD varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CARD_HOLDER_ADDR varchar,
	CARD_HOLDER_PHONE varchar,
	CARD_HOLDER_EMAIL varchar,
	CARD_HOLDER_ADDR varchar,
	CARD_HOLDER_PHONE varchar,
	CARD_HOLDER_EMAIL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;