Lines 1692-1698
CREATE TABLE `branchtransfers` (
Link Here
|
1692 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1692 |
`datecancelled` datetime DEFAULT NULL COMMENT 'the date the transfer was cancelled', |
1693 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1693 |
`tobranch` varchar(10) NOT NULL DEFAULT '' COMMENT 'the branch the transfer was going to', |
1694 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1694 |
`comments` longtext DEFAULT NULL COMMENT 'any comments related to the transfer', |
1695 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer', |
1695 |
`reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','TransferCancellation','Recall','RecallCancellation','WrongTransfer') DEFAULT NULL COMMENT 'what triggered the transfer', |
1696 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1696 |
`cancellation_reason` enum('Manual','StockrotationAdvance','StockrotationRepatriation','ReturnToHome','ReturnToHolding','RotatingCollection','Reserve','LostReserve','CancelReserve','ItemLost','WrongTransfer','RecallCancellation') DEFAULT NULL COMMENT 'what triggered the transfer cancellation', |
1697 |
PRIMARY KEY (`branchtransfer_id`), |
1697 |
PRIMARY KEY (`branchtransfer_id`), |
1698 |
KEY `frombranch` (`frombranch`), |
1698 |
KEY `frombranch` (`frombranch`), |
1699 |
- |
|
|