CREATE TABLE `manual_transactions_archive` (
  `id` mediumint(40) UNSIGNED NOT NULL,
  `manual_transaction_id` mediumint(40) UNSIGNED NOT NULL,
  `transaction_type` tinyint(7) UNSIGNED NOT NULL COMMENT '1-Payment By Debtor,2-Transfer of payment by Originator,3-Remittance Notice from Debtor,4-Credit Note issued to Debtor,5-Other Discount offered to Debtor,6-Upload of Debtor Reconciliation,7-Originator Payment on Account,8-Bank Transmission Receipt,9-Paid ',
  `debtor_id` mediumint(40) UNSIGNED NOT NULL,
  `originator_id` smallint(40) UNSIGNED NOT NULL,
  `currency_id` tinyint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `reference_to` text NOT NULL,
  `specific_allocation` tinyint(4) NOT NULL COMMENT '0-not with,1-with',
  `notes` text NOT NULL,
  `credit_note_no` varchar(100) DEFAULT NULL,
  `transaction_file` varchar(255) NOT NULL,
  `specific_deductible` tinyint(4) NOT NULL COMMENT '0-Not specfic deductible,1- Specific deductible',
  `deductible_amount` decimal(10,2) NOT NULL,
  `trailing_balance` tinyint(4) NOT NULL COMMENT '0-not with,1-with',
  `trailing_balance_amt` decimal(10,2) NOT NULL,
  `transref_list` text NOT NULL COMMENT 'ref=>manual_transaction_id ',
  `reconcile_payment` mediumint(10) UNSIGNED NOT NULL,
  `reconcile_ref` mediumint(10) UNSIGNED NOT NULL,
  `payment_return` mediumint(10) UNSIGNED NOT NULL,
  `false_payment` mediumint(10) UNSIGNED NOT NULL,
  `amendment_id` mediumint(10) UNSIGNED NOT NULL,
  `status` tinyint(10) NOT NULL COMMENT '0-Created,1-Authorised,2-Notified',
  `reconcile_status` tinyint(5) NOT NULL DEFAULT '0' COMMENT '0-non reconcile,1-reconcile',
  `reconcile_credit` tinyint(4) NOT NULL COMMENT '0-Non reconcile,1-Reconcile',
  `multiple_payments` text NOT NULL,
  `multiple_status` tinyint(4) NOT NULL COMMENT '0-Off,1-On',
  `interface` tinyint(4) NOT NULL COMMENT '0-User,1-Admin',
  `paid_status` tinyint(4) NOT NULL COMMENT '0-Unpaid,1-Paid',
  `transaction_date` date NOT NULL,
  `notification_title` tinyint(4) NOT NULL COMMENT '1-Fee Notice,2-RSA Offer,3-Other',
  `transaction_name` varchar(250) NOT NULL,
  `issue_date` date NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` tinyint(4) NOT NULL,
  `modified_at` datetime NOT NULL,
  `modified_by` tinyint(4) NOT NULL,
  `authorised_at` datetime NOT NULL,
  `authorised_by` tinyint(4) NOT NULL,
  `reserve_on` mediumint(4) UNSIGNED NOT NULL DEFAULT '0',
  `rerouted` int(11) DEFAULT '0',
  `spooled` int(11) DEFAULT '0',
  `orpa_id` int(11) DEFAULT NULL,
  `fees_commissions` int(11) NOT NULL DEFAULT '0',
  `is_synced` enum('0','1') NOT NULL DEFAULT '0',
  `synced_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `manual_transactions_archive`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `manual_transactions_archive`
  MODIFY `id` mediumint(40) UNSIGNED NOT NULL AUTO_INCREMENT;