# MySQL-Front 5.0  (Build 1.0)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: pos2122
# ------------------------------------------------------
# Server version 5.1.30-community

USE `pos2122`;

#
# Table structure for table stocktransfer
#

DROP TABLE IF EXISTS `stocktransfer`;
CREATE TABLE `stocktransfer` (
  `STID` int(11) NOT NULL AUTO_INCREMENT,
  `CHALLANNO` varchar(30) DEFAULT '-',
  `CHALLANDATE` date DEFAULT '2000-01-01',
  `ITEMCODE` int(11) DEFAULT '0',
  `MRP` decimal(10,2) DEFAULT '0.00',
  `TRANSFERQTY` int(3) DEFAULT '0',
  `RECEIPTQTY` int(3) DEFAULT '0',
  `LOC1` int(3) DEFAULT '0',
  `LOC2` int(3) DEFAULT '0',
  `STKID` int(11) DEFAULT '0',
  `LOTNO` varchar(50) DEFAULT '-',
  `BLTYPE` int(3) DEFAULT '0',
  PRIMARY KEY (`STID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
INSERT INTO `stocktransfer` VALUES (1,'ST1','2022-04-07',1,345,1,0,2,2,76,'-',1);
INSERT INTO `stocktransfer` VALUES (2,'ST1','2022-04-07',1,345,2,0,2,2,77,'-',1);
INSERT INTO `stocktransfer` VALUES (3,'ST1','2022-04-07',1,345,1,0,2,1,76,'-',1);
INSERT INTO `stocktransfer` VALUES (4,'ST1','2022-04-07',1,345,5,0,2,1,77,'-',1);
/*!40000 ALTER TABLE `stocktransfer` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
