-- Create Table Statement for 'Billpay Mastercard Rpps Batch'
DROP TABLE IF EXISTS `BILLPAY_MASTERCARD_RPPS_BATCH`;
CREATE TABLE `BILLPAY_MASTERCARD_RPPS_BATCH` (
	IMMEDIATE_ORIGIN varchar,
	TRANSMISSION_DATE varchar,
	TRANSMISSION_TIME varchar,
	FILE_ID_MODIFIER varchar,
	ORIGIN_NAME varchar,
	BILLER_NAME varchar,
	BILLER_ID varchar,
	ENTRY_DESCRIPTION varchar,
	BATCH_NUMBER varchar,
	MASTERCARD_RPPS_ID_NUMBER varchar,
	ENTRY_ADDENDA_COUNT varchar,
	ENTRY_HASH varchar,
	TOTAL_DEBIT_AMOUNT varchar,
	TOTAL_CREDIT_AMOUNT varchar,
	CONCENTRATOR_ID varchar,
	CONCENTRATOR_NAME varchar,
	BILLPAY_MASTERCARD_RPPS_TRANSACTIONS bigint(20),
	ERROR_CODE varchar,
	ERROR_MESSAGE varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;