-- Create Table Statement for 'Transaction Processing Cost'
DROP TABLE IF EXISTS `TRANSACTION_PROCESSING_COST`;
CREATE TABLE `TRANSACTION_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	TRANSACTION_DATE datetime,
	PROCESSING_COST_CODE varchar,
	FLAT_FEE4P int(11),
	PERCENTAGE_FEE4P int(11),
	FEE_AMOUNT4P bigint(20),
	REFERENCE_DATE datetime,
	SOURCE_RECORD_CODE bigint(20),
	TRANSACTION_FK bigint(20),
	CAPTION varchar,
	TRANSACTION_AMOUNT int(11),
	SUBMISSION_CL varchar,
	ACCOUNT_CL varchar,
	REMITTANCE_DATE datetime,
	ATTEMPT_COUNT int(11),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PROVIDER_PROCESSING_COST_CODE varchar,
	PROVIDER_PROCESSING_COST_NAME varchar,
	TRANSACTION_COUNT int(11),
	FLAT_FEE_AMOUNT4P int(11),
	PERCENTAGE_FEE_AMOUNT4P int(11),
	ACCOUNT_TYPE_CL varchar,
	PROVIDER_NAME varchar,
	FEE_CL varchar,
	FEE_CL varchar,
	PROVIDER_PROCESSING_COST_CODE varchar,
	PROVIDER_PROCESSING_COST_NAME varchar,
	TRANSACTION_COUNT int(11),
	FLAT_FEE_AMOUNT4P int(11),
	PERCENTAGE_FEE_AMOUNT4P int(11),
	ACCOUNT_TYPE_CL varchar,
	PROVIDER_NAME varchar,
	FEE_CL varchar,
	PROVIDER_PROCESSING_COST_CODE varchar,
	PROVIDER_PROCESSING_COST_NAME varchar,
	TRANSACTION_COUNT int(11),
	FLAT_FEE_AMOUNT4P int(11),
	PERCENTAGE_FEE_AMOUNT4P bigint(20),
	ACCOUNT_TYPE_CL varchar,
	PROVIDER_NAME varchar,
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	PROCESSING_COST_CODE varchar,
	FLAT_FEE4P int(11),
	PERCENTAGE_FEE4P int(11),
	FEE_AMOUNT4P int(11),
	REFERENCE_DATE datetime,
	SOURCE_RECORD_CODE bigint(20),
	TRANSACTION_AMOUNT int(11),
	PROVIDER_PROCESSING_COST_CODE varchar,
	PROVIDER_PROCESSING_COST_NAME varchar,
	TRANSACTION_COUNT int(11),
	FLAT_FEE_AMOUNT4P int(11),
	PERCENTAGE_FEE_AMOUNT4P int(11),
	ACCOUNT_TYPE_CL varchar,
	PROVIDER_NAME varchar,
	FEE_CL varchar,
	TRANSACTION_DATE datetime,
	SUBMISSION_CL varchar,
	ACCOUNT_CL varchar,
	REMITTANCE_DATE datetime,
	ATTEMPT_COUNT int(11),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PERCENTAGE_FEE_AMOUNT4P bigint(20),
	FEE_AMOUNT4P bigint(20),
	PERCENTAGE_FEE_AMOUNT4P bigint(20),
	FEE_AMOUNT4P bigint(20),
	TAX_RATE4P int(11),
	TAX_AMOUNT int(11),
	TAX_RATE4P int(11),
	TAX_AMOUNT int(11),
	TAX_RATE4P int(11),
	TAX_AMOUNT int(11),
	PRIMARY KEY (ID, ID)
) ENGINE=InnoDB;