-- Create Table Statement for 'CC Westpac Batch'
DROP TABLE IF EXISTS `CC_WESTPAC_BATCH`;
CREATE TABLE `CC_WESTPAC_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	COMMUNITY_CODE varchar,
	FILE_CREATION_DATE varchar,
	FILE_CREATION_TIME varchar,
	CLIENT_NAME varchar,
	UNIQUE_FILE_IDENTIFIER varchar,
	COMPANY_NAME varchar,
	COMPANY_CODE varchar,
	BATCH_TYPE varchar,
	BATCH_DESCRIPTION varchar,
	UNIQUE_BATCH_IDENTIFIER varchar,
	REFUND_FLAG varchar,
	CURRENCY varchar,
	BATCH_TRANSACTION_COUNT varchar,
	BATCH_TRANSACTION_AMOUNT varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;