-- Create Table Statement for 'Paymentech Provisioning File Batch'
DROP TABLE IF EXISTS `PAYMENTECH_PROVISIONING_FILE_BATCH`;
CREATE TABLE `PAYMENTECH_PROVISIONING_FILE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FILE_NAME varchar,
	COMPANY_NAME varchar,
	RECORD_COUNT varchar,
	ACKNOWLEDGEMENT_DATE_AND_TIME varchar,
	ACKNOWLEDGEMENT_FILE_PROCESS_DATE varchar,
	ACKNOWLEDGEMENT_STATUS varchar,
	ACKNOWLEDGEMENT_REJECT_REASON varchar,
	EXCEPTION_FILE_PROCESS_DATE varchar,
	EXCEPTION_DATE_AND_TIME varchar,
	PID varchar,
	SID varchar,
	CREATION_DATE varchar,
	MERCHANT_SPACE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;