| 
      
            Lines 951-957
          CREATE TABLE `branchtransfers` ( -- information for items that are in transit be
      
      
        Link Here
      
     | 
  
        
          | 951 | 
            `datearrived` datetime default NULL, -- the date the transfer arrived at its destination  | 
          951 | 
            `datearrived` datetime default NULL, -- the date the transfer arrived at its destination  | 
        
        
          | 952 | 
            `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to  | 
          952 | 
            `tobranch` varchar(10) NOT NULL default '', -- the branch the transfer was going to  | 
        
        
          | 953 | 
            `comments` LONGTEXT, -- any comments related to the transfer  | 
          953 | 
            `comments` LONGTEXT, -- any comments related to the transfer  | 
        
          
            
              | 954 | 
                `trigger` ENUM('Manual'), -- what triggered the transfer | 
              954 | 
                `trigger` ENUM('Manual', 'StockrotationAdvance', 'StockrotationRepatriation'), -- what triggered the transfer | 
            
        
          | 955 | 
            PRIMARY KEY (`branchtransfer_id`),  | 
          955 | 
            PRIMARY KEY (`branchtransfer_id`),  | 
        
        
          | 956 | 
            KEY `frombranch` (`frombranch`),  | 
          956 | 
            KEY `frombranch` (`frombranch`),  | 
        
        
          | 957 | 
            KEY `tobranch` (`tobranch`),  | 
          957 | 
            KEY `tobranch` (`tobranch`),  | 
        
            
              | 958 | 
              -   | 
               | 
               |