-- Create Table Statement for 'PayFacto Processing Cost'
DROP TABLE IF EXISTS `PAYFACTO_PROCESSING_COST`;
CREATE TABLE `PAYFACTO_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	PAYFACTO_PROCESSING_COST_BATCH_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11),
	SETTLEMENT_FILE_ID varchar,
	SETTLEMENT_FILE_NAME varchar,
	MERCHANT_NAME varchar,
	MERCHANT_ID varchar,
	MERCHANT_DESCRIPTOR varchar,
	TRANSACTION_DATE varchar,
	POSTING_DATE varchar,
	TRANSACTION_TYPE varchar,
	ORIGINAL_TRANSACTION_CURRENCY varchar,
	ORIGINAL_TRANSACTION_AMOUNT varchar,
	TRANSACTION_REGION varchar,
	CARD_SCHEME varchar,
	CARD_TYPE varchar,
	CARD_BRAND varchar,
	CARD_PRODUCT varchar,
	CARD_NUMBER_MASKED varchar,
	CARD_HOLDER_COUNTRY varchar,
	UNIQUE_TRANSACTION_ID varchar,
	AUTHORISATION_CODE varchar,
	RRN varchar,
	ARN varchar,
	REFERENCE_NUMBER varchar,
	SETTLEMENT_CURRENCY varchar,
	DDF_MAS_CODE varchar,
	INTERCHANGE_RATE varchar,
	GROSS_TRANSACTION_AMOUNT varchar,
	TOTAL_TRANSACTION_FEE_AMOUNT varchar,
	ACQUIRING_FIXED_TRANSACTION_FEE varchar,
	ACQUIRING_FEE varchar,
	INTERCHANGE_FEE varchar,
	CARD_SCHEME_FEES varchar,
	NET_SETTLEMENT_AMOUNT varchar,
	FEE_PROGRAM_ENGLISH varchar,
	AMOUNT int(11),
	BANK_NET_REF_NUMBER varchar,
	PURCHASE_ID varchar,
	TRANSACTION_IDENTITY varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;