-- Create Table Statement for 'Submission'
DROP TABLE IF EXISTS `SUBMISSION`;
CREATE TABLE `SUBMISSION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	IS_PROCESSED tinyint(1),
	ACH_SALE_AMOUNT bigint(20),
	ACH_SALE_COUNT int(11),
	ACH_CREDIT_AMOUNT bigint(20),
	ACH_CREDIT_COUNT int(11),
	BANK_CARD_SALE_AMOUNT bigint(20),
	BANK_CARD_SALE_COUNT int(11),
	BANK_CARD_CREDIT_AMOUNT bigint(20),
	BANK_CARD_CREDIT_COUNT int(11),
	ERROR_COUNT int(11),
	PROCESSING_PROFILE_FK bigint(20),
	CONFIG_DATA_FK bigint(20),
	MERCHANT_ACCOUNT_CODE_LIST varchar,
	BILLING_PROFILE_TYPE varchar,
	SUBMISSION_SUMMARY_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	ACH_CREDIT_AMOUNT bigint(20),
	ACH_SALE_AMOUNT bigint(20),
	BANK_CARD_SALE_AMOUNT bigint(20),
	BANK_CARD_CREDIT_AMOUNT bigint(20),
	ACH_CREDIT_AMOUNT bigint(20),
	ACH_SALE_AMOUNT bigint(20),
	BANK_CARD_SALE_AMOUNT bigint(20),
	BANK_CARD_CREDIT_AMOUNT bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BILLING_PROFILE_TYPE varchar,
	BILLING_PROFILE_TYPE varchar,
	CREATE_DATE datetime,
	TEST_DATA tinyint(1) NOT NULL,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;