-- Create Table Statement for 'Batch'
DROP TABLE IF EXISTS `BATCH`;
CREATE TABLE `BATCH` (
	ID bigint(20) NOT NULL,
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT bigint(20),
	EFFECTIVE_DATE datetime,
	DESCRIPTION varchar,
	PROCESSED_DATE datetime,
	IS_FILE_NOTIFICATION_ENABLED tinyint(1),
	SUB_BATCH_FK bigint(20),
	BILLING_SUB_BATCH_FK bigint(20),
	EMAIL_TRANSACTION_FK bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	ACCOUNT_UPDATE_TRANSACTION_FK bigint(20),
	CHARGEBACK_CASE_DOCUMENT_FK bigint(20),
	ACCOUNT_UPDATE_SUBSCRIPTION_TRANSACTION_FK bigint(20),
	CREDIT_AGENCY_TRANSACTION_FK bigint(20),
	SKIP_TRACING_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	SUBSCRIPTION_TRANSACTION_FK bigint(20),
	TOTAL_AMOUNT bigint(20),
	TOTAL_COUNT int(11),
	DESCRIPTION varchar,
	TOTAL_AMOUNT bigint(20),
	TOTAL_COUNT int(11),
	DESCRIPTION varchar,
	EFFECTIVE_DATE datetime,
	EFFECTIVE_DATE datetime,
	TEST_FIELD bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;