-- Create Table Statement for 'Submission Summary'
DROP TABLE IF EXISTS `SUBMISSION_SUMMARY`;
CREATE TABLE `SUBMISSION_SUMMARY` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	VISA_SALE_COUNT int(11),
	VISA_SALE_AMOUNT bigint(20),
	VISA_CREDIT_COUNT int(11),
	VISA_CREDIT_AMOUNT bigint(20),
	MASTER_CARD_SALE_COUNT int(11),
	MASTER_CARD_SALE_AMOUNT bigint(20),
	MASTER_CARD_CREDIT_COUNT int(11),
	MASTER_CARD_CREDIT_AMOUNT bigint(20),
	AMEX_SALE_COUNT int(11),
	AMEX_SALE_AMOUNT bigint(20),
	AMEX_CREDIT_COUNT int(11),
	AMEX_CREDIT_AMOUNT bigint(20),
	DISCOVER_SALE_COUNT int(11),
	DISCOVER_SALE_AMOUNT bigint(20),
	DISCOVER_CREDIT_COUNT int(11),
	DISCOVER_CREDIT_AMOUNT bigint(20),
	OTHER_SALE_COUNT int(11),
	OTHER_SALE_AMOUNT bigint(20),
	OTHER_CREDIT_COUNT int(11),
	OTHER_CREDIT_AMOUNT bigint(20),
	ERROR_SALE_COUNT int(11),
	ERROR_SALE_AMOUNT bigint(20),
	ERROR_CREDIT_COUNT int(11),
	ERROR_CREDIT_AMOUNT bigint(20),
	SUBMISSION_FK bigint(20),
	FILE_BATCH_FK bigint(20),
	FILE_STORE_FK bigint(20),
	ACH_SALE_COUNT int(11),
	ACH_SALE_AMOUNT bigint(20),
	ACH_CREDIT_COUNT int(11),
	ACH_CREDIT_AMOUNT bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;