-- Create Table Statement for 'Noble Processing Cost'
DROP TABLE IF EXISTS `NOBLE_PROCESSING_COST`;
CREATE TABLE `NOBLE_PROCESSING_COST` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
ACCOUNT_TYPE varchar,
TRANSACTION_AMOUNT varchar,
TRANSACTION_IDENTIFIER bigint(20),
CATEGORY varchar,
BRAND varchar,
REGULATED_DEBIT_ADJUSTMENT_CAP varchar,
REGULATED_DEBIT_ADJUSTMENT_RATE varchar,
REGULATED_DEBIT_ADJUSTMENT_ADJUSTMENT varchar,
REGULATED_DEBIT_ADJUSTMENT_FIXED varchar,
MAXIMUM_ADJUSTMENT_CAP varchar,
MAXIMUM_ADJUSTMENT_RATE varchar,
MAXIMUM_ADJUSTMENT_ADJUSTMENT varchar,
MAXIMUM_ADJUSTMENT_FIXED varchar,
MINIMUM_ADJUSTMENT_CAP varchar,
MINIMUM_ADJUSTMENT_RATE varchar,
MINIMUM_ADJUSTMENT_ADJUSTMENT varchar,
MINIMUM_ADJUSTMENT_FIXED varchar,
CALCULATED_ADJUSTMENT_CAP varchar,
CALCULATED_ADJUSTMENT_RATE varchar,
CALCULATED_ADJUSTMENT_ADJUSTMENT varchar,
CALCULATED_ADJUSTMENT_FIXED varchar,
RETAIL_TRANSACTION_CYCLE_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;