| 
      
            Lines 2627-2633
          CREATE TABLE `cash_registers` (
      
      
        Link Here
      
     | 
  
        
          | 2627 | 
           | 
          2627 | 
           | 
        
        
          | 2628 | 
          DROP TABLE IF EXISTS `account_debit_types`;  | 
          2628 | 
          DROP TABLE IF EXISTS `account_debit_types`;  | 
        
        
          | 2629 | 
          CREATE TABLE `account_debit_types` (  | 
          2629 | 
          CREATE TABLE `account_debit_types` (  | 
        
          
            
              | 2630 | 
                `code` varchar(64) NOT NULL,  | 
              2630 | 
                `code` varchar(80) NOT NULL,  | 
            
        
          | 2631 | 
            `description` varchar(200) DEFAULT NULL,  | 
          2631 | 
            `description` varchar(200) DEFAULT NULL,  | 
        
        
          | 2632 | 
            `can_be_added_manually` tinyint(4) NOT NULL DEFAULT 1,  | 
          2632 | 
            `can_be_added_manually` tinyint(4) NOT NULL DEFAULT 1,  | 
        
        
          | 2633 | 
            `default_amount` decimal(28,6) DEFAULT NULL,  | 
          2633 | 
            `default_amount` decimal(28,6) DEFAULT NULL,  | 
        
  
    | 
      
            Lines 2636-2647
          CREATE TABLE `account_debit_types` (
      
      
        Link Here
      
     | 
  
        
          | 2636 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
          2636 | 
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;  | 
        
        
          | 2637 | 
           | 
          2637 | 
           | 
        
        
          | 2638 | 
          --  | 
          2638 | 
          --  | 
        
          
            
              | 2639 | 
              -- Table structure for table `ac_debit_types_branches`  | 
              2639 | 
              -- Table structure for table `account_debit_types_branches`  | 
            
        
          | 2640 | 
          --  | 
          2640 | 
          --  | 
        
        
          | 2641 | 
           | 
          2641 | 
           | 
        
          
            
              | 2642 | 
              DROP TABLE IF EXISTS `ac_debit_types_branches`;  | 
              2642 | 
              DROP TABLE IF EXISTS `account_debit_types_branches`;  | 
            
            
              | 2643 | 
              CREATE TABLE `ac_debit_types_branches` (  | 
              2643 | 
              CREATE TABLE `account_debit_types_branches` (  | 
            
            
              | 2644 | 
                  `debit_type_code` VARCHAR(64),  | 
              2644 | 
                  `debit_type_code` VARCHAR(80),  | 
            
        
          | 2645 | 
              `branchcode` VARCHAR(10),  | 
          2645 | 
              `branchcode` VARCHAR(10),  | 
        
        
          | 2646 | 
              FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE CASCADE,  | 
          2646 | 
              FOREIGN KEY (`debit_type_code`) REFERENCES `account_debit_types` (`code`) ON DELETE CASCADE,  | 
        
        
          | 2647 | 
              FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE  | 
          2647 | 
              FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE  | 
        
  
    | 
      
            Lines 2661-2667
          CREATE TABLE `accountlines` (
      
      
        Link Here
      
     | 
  
        
          | 2661 | 
            `amount` decimal(28,6) default NULL,  | 
          2661 | 
            `amount` decimal(28,6) default NULL,  | 
        
        
          | 2662 | 
            `description` LONGTEXT,  | 
          2662 | 
            `description` LONGTEXT,  | 
        
        
          | 2663 | 
            `accounttype` varchar(80) default NULL,  | 
          2663 | 
            `accounttype` varchar(80) default NULL,  | 
        
          
            
              | 2664 | 
                `debit_type_code` varchar(64) default NULL,  | 
              2664 | 
                `debit_type_code` varchar(80) default NULL,  | 
            
        
          | 2665 | 
            `status` varchar(16) default NULL,  | 
          2665 | 
            `status` varchar(16) default NULL,  | 
        
        
          | 2666 | 
            `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE  | 
          2666 | 
            `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE  | 
        
        
          | 2667 | 
            `amountoutstanding` decimal(28,6) default NULL,  | 
          2667 | 
            `amountoutstanding` decimal(28,6) default NULL,  | 
        
            
              | 2668 | 
              -   | 
               | 
               |