-- Create Table Statement for 'EFT Westpac Batch'
DROP TABLE IF EXISTS `EFT_WESTPAC_BATCH`;
CREATE TABLE `EFT_WESTPAC_BATCH` (
	ID bigint(20) NOT NULL,
	FILE_NAME varchar,
	FILE_NUMBER varchar,
	DESCRIPTION varchar,
	NET_TOTAL_AMOUNT varchar,
	CREDIT_TOTAL_AMOUNT varchar,
	DEBIT_TOTAL_AMOUNT varchar,
	DETAIL_RECORD_COUNT varchar,
	FILE_ID bigint(20),
	TRACE_RECORD varchar,
	PROCESS_DATE varchar,
	STATUS_INDICATOR_EXC varchar,
	STATUS_INDICATOR_DISB varchar,
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;