-- 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;