-- Create Table Statement for 'Chargeback Case Activity'
DROP TABLE IF EXISTS `CHARGEBACK_CASE_ACTIVITY`;
CREATE TABLE `CHARGEBACK_CASE_ACTIVITY` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
ACTIVITY_DATE datetime,
CYCLE_CL varchar,
ACTIVITY_CL varchar,
SETTLEMENT_AMOUNT int(11),
REPRESENTED_AMOUNT int(11),
PRE_ARBITRATION_AMOUNT int(11),
FROM_QUEUE_CL varchar,
TO_QUEUE_CL varchar,
CURRENT_QUEUE_CL varchar,
NOTE varchar,
CHARGEBACK_CASE_FK bigint(20),
CREATOR_CODE varchar,
STATUS_CL varchar,
SUPPORT_SENT varchar,
CASE_RESOLUTION_CODE varchar,
SUB_BATCH_FK bigint(20),
IS_FINANCIAL tinyint(1),
PRIMARY KEY (ID)
) ENGINE=InnoDB;