-- Create Table Statement for 'Mercury Pay Retail File Batch'
DROP TABLE IF EXISTS `MERCURY_PAY_RETAIL_FILE_BATCH`;
CREATE TABLE `MERCURY_PAY_RETAIL_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ID varchar,
	OPERATOR_ID varchar,
	TRAN_CODE varchar,
	MEMO varchar,
	RESPONSE_ORIGIN varchar,
	DSIX_RETURN_CODE varchar,
	CMD_STATUS varchar,
	TEXT_RESPONSE varchar,
	USER_TRACE_DATA varchar,
	BATCH_NO varchar,
	BATCH_ITEM_COUNT int(11),
	NET_BATCH_TOTAL varchar,
	CREDIT_PURCHASE_COUNT int(11),
	CREDIT_PURCHASE_AMOUNT varchar,
	CREDIT_RETURN_COUNT int(11),
	CREDIT_RETURN_AMOUNT varchar,
	DEBIT_PURCHASE_COUNT int(11),
	DEBIT_PURCHASE_AMOUNT varchar,
	DEBIT_RETURN_COUNT int(11),
	DEBIT_RETURN_AMOUNT varchar,
	EXPECTED_CREDIT_PURCHASE_COUNT int(11),
	EXPECTED_CREDIT_PURCHASE_AMOUNT varchar,
	EXPECTED_CREDIT_RETURN_COUNT int(11),
	EXPECTED_CREDIT_RETURN_AMOUNT varchar,
	EXPECTED_DEBIT_PURCHASE_COUNT int(11),
	EXPECTED_DEBIT_PURCHASE_AMOUNT varchar,
	EXPECTED_DEBIT_RETURN_COUNT int(11),
	EXPECTED_DEBIT_RETURN_AMOUNT varchar,
	CONTROL_NO varchar,
	BATCH_VALIDATION_MESSAGE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;