-- Create Table Statement for 'Heartland Portico Retail File Batch'
DROP TABLE IF EXISTS `HEARTLAND_PORTICO_RETAIL_FILE_BATCH`;
CREATE TABLE `HEARTLAND_PORTICO_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	LICENSE_ID varchar,
	SITE_ID varchar,
	DEVICE_ID varchar,
	USER_NAME varchar,
	SITE_TRACE varchar,
	DEVELOPER_ID varchar,
	VERSION_NBR varchar,
	BATCH_ID varchar,
	TXN_CNT varchar,
	TOTAL_AMT varchar,
	BATCH_SEQ_NBR varchar,
	GATEWAY_TXN_ID varchar,
	RSP_DT varchar,
	GATEWAY_RSP_CODE varchar,
	GATEWAY_RSP_MSG varchar,
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;