-- Create Table Statement for 'Paymentech Processing Cost'
DROP TABLE IF EXISTS `PAYMENTECH_PROCESSING_COST`;
CREATE TABLE `PAYMENTECH_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PAYMENTECH_PROCESSING_COST_BATCH_FK bigint(20),
	ENTITY_TYPE varchar,
	ENTITY_ID varchar,
	CATEGORY varchar,
	SUB_CATEGORY varchar,
	FUNDS_TRANSFER_INSTRUCTION_NUMBER varchar,
	SETTLEMENT_CURRENCY varchar,
	FEE_SCHEDULE varchar,
	MOP varchar,
	INTERCHANGE_QUALIFICATION_CODE varchar,
	FEE_TYPE_DESCRIPTION varchar,
	ACTION_TYPE varchar,
	UNIT_QUANTITY varchar,
	UNIT_FEE varchar,
	AMOUNT varchar,
	PERCENT_RATE varchar,
	TOTAL_CHARGE varchar,
	PRESENTMENT_CURRENCY varchar,
	PAYMENTECH_PROCESSING_COST_BATCH_FK bigint(20),
	PAYMENTECH_PROCESSING_COST_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;