-- Create Table Statement for 'Paymentech Chargeback Batch'
DROP TABLE IF EXISTS `PAYMENTECH_CHARGEBACK_BATCH`;
CREATE TABLE `PAYMENTECH_CHARGEBACK_BATCH` (
ID bigint(20) NOT NULL,
MERCHANT_NUMBER varchar,
PROCESS_DATE varchar,
TOTAL_DISPOSITIONED_INDICATOR varchar,
TOTAL_DISPOSITIONED_AMOUNT varchar,
TOTAL_DISPOSITIONED_ITEMS varchar,
TOTAL_REPRESENTMENT_INDICATOR varchar,
TOTAL_REPRESENTMENT_AMOUNT varchar,
TOTAL_REPRESENTMENT_ITEMS varchar,
TOTAL_REVERSAL_INDICATOR varchar,
TOTAL_REVERSAL_AMOUNT varchar,
TOTAL_REVERSAL_ITEMS varchar,
TOTAL_MISCELLANEOUS_INDICATOR varchar,
TOTAL_MISCELLANEOUS_AMOUNT varchar,
TOTAL_MISCELLANEOUS_ITEMS varchar,
TOTAL_DEBIT_ADJUSTMENTS_INDICATOR varchar,
TOTAL_DEBIT_ADJUSTMENTS_AMOUNT varchar,
TOTAL_DEBIT_ADJUSTMENTS_ITEMS varchar,
TOTAL_AMOUNT_INDICATOR varchar,
TOTAL_AMOUNT varchar,
TOTAL_ITEMS varchar,
PAYMENTECH_CHARGEBACK_TRANSACTION_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;