-- Create Table Statement for 'Paymentech UTF Capture Retail Transaction'
DROP TABLE IF EXISTS `PAYMENTECH_UTF_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `PAYMENTECH_UTF_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CLIENT_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_STATUS varchar,
	ENTRY_DATA_SOURCE varchar,
	TRANSACTION_AMOUNT varchar,
	CREDIT_CASH_BACK_CASH_OVER varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	AUTHORIZATION_CODE varchar,
	CARD_TYPE varchar,
	AUTH_NETWORK_ID varchar,
	AUTH_SOURCE varchar,
	MARKET_DATA_SPECIFIC_INDICATOR varchar,
	INDUSTRY_CODE varchar,
	ORDER_NUM varchar,
	TYPE_INDICATOR varchar,
	ECOMMERCE_GOODS_INDICATOR varchar,
	REFERENCE_CODE varchar,
	CHARGE_DESCRIPTION varchar,
	TIP_AMOUNT varchar,
	SERVER_NUM varchar,
	ITEM_CODE varchar,
	CUSTOMER_REFERENCE_NUMBER varchar,
	LOCAL_TAX_FLAG varchar,
	DESTINATION_ZIP varchar,
	SALES_TAX_AMOUNT varchar,
	TOKEN_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	PAYMENT_TECH_UTF_RETAIL_FILE_BATCH_FK bigint(20),
	AI_APPLICATION_IDENTIFIER varchar,
	CR_CARD_AUTHENTICATION_RESULTS_CODE_REQUEST varchar,
	PS_PAN_SEQUENCE_NUMBER varchar,
	TS_TRANSACTION_SEQUENCE_COUNTER varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PAYMENTECH_UTF_RETAIL_FILE_BATCH_FK bigint(20),
	PAYMENTECH_UTF_RETAIL_FILE_BATCH_FK bigint(20),
	PAYMENTECH_UTF_RETAIL_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;