| 
      
            Lines 1528-1535
          CREATE TABLE `branchtransfers` (
      
      
        Link Here
      
     | 
  
        
          | 1528 | 
            `datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',  | 
          1528 | 
            `datecancelled` datetime default NULL COMMENT 'the date the transfer was cancelled',  | 
        
        
          | 1529 | 
            `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',  | 
          1529 | 
            `tobranch` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to',  | 
        
        
          | 1530 | 
            `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',  | 
          1530 | 
            `comments` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'any comments related to the transfer',  | 
        
          
            
              | 1531 | 
                `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve', 'TransferCancellation') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer', | 
              1531 | 
                `reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve', 'TransferCancellation', 'WrongTransfer') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'what triggered the transfer', | 
            
            
              | 1532 | 
                `cancellation_reason` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost', 'WrongTransfer') default NULL COMMENT 'what triggered the transfer cancellation', | 
              1532 | 
                `cancellation_reason` enum('Manual', 'StockrotationAdvance', 'StockrotationRepatriation', 'ReturnToHome', 'ReturnToHolding', 'RotatingCollection', 'Reserve', 'LostReserve', 'CancelReserve', 'ItemLost', 'WrongTransfer') default NULL COMMENT 'what triggered the transfer cancellation', | 
            
        
          | 1533 | 
            PRIMARY KEY (`branchtransfer_id`),  | 
          1533 | 
            PRIMARY KEY (`branchtransfer_id`),  | 
        
        
          | 1534 | 
            KEY `frombranch` (`frombranch`),  | 
          1534 | 
            KEY `frombranch` (`frombranch`),  | 
        
        
          | 1535 | 
            KEY `tobranch` (`tobranch`),  | 
          1535 | 
            KEY `tobranch` (`tobranch`),  | 
        
            
              | 1536 | 
              -   | 
               | 
               |