-- Create Table Statement for 'Fi Serv Batch'
DROP TABLE IF EXISTS `FI_SERV_BATCH`;
CREATE TABLE `FI_SERV_BATCH` (
	ID bigint(20) NOT NULL,
	COMPANY_NAME_FILE_HEADER varchar,
	COMPANY_NAME_BATCH_HEADER varchar,
	CLIENT_ID varchar,
	DESCRIPTION varchar,
	COLLECTION_DATE varchar,
	RECORD_COUNT int(11),
	TOTAL_DEBIT_AMOUNT int(11),
	TOTAL_CREDIT_AMOUNT int(11),
	RETURN_DATE varchar,
	FILE_CREATION_DATE_TIME varchar,
	BLOCK_COUNT varchar,
	PROVIDER_CHARGE_TRANSACTIONS bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;