100313 15:35:44 1088 Connect root@60.48.91.106 on mpcms4 1088 Query SHOW VARIABLES 1088 Query SHOW COLLATION 1088 Query SET character_set_results=NULL 1088 Init DB mpcms4 1088 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 1088 Query BEGIN 1089 Connect root@60.48.91.106 on mpcms 1089 Query SHOW VARIABLES 1089 Query SHOW COLLATION 100313 15:35:45 1089 Query SET character_set_results=NULL 1089 Init DB mpcms 1089 Query SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ 1089 Query BEGIN 1089 Query Select tblProduct.productID, tblTransferDetails.stockID , tblTransferDetails.transferDetailsID , tblProduct.productType , tblTransferDetails.costPrice , tblTransferDetails.transferPrice , tblTransferDetails.stockSIQ From tblTransferDetails Inner Join tblTransfer On tblTransfer.transferID = tblTransferDetails.transferID Inner Join tblProduct On tblProduct.productID = tblTransferDetails.productID Where tblTransfer.outletFromID = 1 And tblTransfer.transferID = 1336 And tblTransferDetails.transferID = 1336 And tblTransferDetails.outletID = 1 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17904, stockID = 12439,outletFromID = 1,outletID = 4,productID = 2828, productType='Imei', stockSIQ = '358226033076364', stockBalance = 1 ,costPrice = 1695, stockPrice = 1697, stockDate='2010:03:13', stockTime='15:35:29', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17904, stockID = 12439,outletFromID = 1,outletID = 4,productID = 2828, stockSIQ = '358226033076364', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358226033076364' And tblStockCentral.stockID=20046 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 1697, tblProduct.productTotalAmount = 1697 Where tblProduct.productID=2828 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 1697 Where tblProduct.productID=2828 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17904, stockID = 12439, productID= 2828, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1697, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1787, averageCostAfter = 1697, quantity = 1, costPrice = 1695, transactionPrice = 1697, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:29', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17904, stockID = 12439, productID= 2828, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1697, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1787, averageCostAfter = 1697, quantity = 1, costPrice = 1695, transactionPrice = 1697, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:29', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17905, stockID = 12440,outletFromID = 1,outletID = 4,productID = 3674, productType='Imei', stockSIQ = '358226034510528', stockBalance = 1 ,costPrice = 1695, stockPrice = 1697, stockDate='2010:03:13', stockTime='15:35:30', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17905, stockID = 12440,outletFromID = 1,outletID = 4,productID = 3674, stockSIQ = '358226034510528', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358226034510528' And tblStockCentral.stockID=20047 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 1697, tblProduct.productTotalAmount = 1697 Where tblProduct.productID=3674 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 1697 Where tblProduct.productID=3674 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17905, stockID = 12440, productID= 3674, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1697, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1752, averageCostAfter = 1697, quantity = 1, costPrice = 1695, transactionPrice = 1697, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17905, stockID = 12440, productID= 3674, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1697, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1752, averageCostAfter = 1697, quantity = 1, costPrice = 1695, transactionPrice = 1697, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17906, stockID = 12441,outletFromID = 1,outletID = 4,productID = 3601, productType='Imei', stockSIQ = '359367039549555', stockBalance = 1 ,costPrice = 500, stockPrice = 502, stockDate='2010:03:13', stockTime='15:35:30', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17906, stockID = 12441,outletFromID = 1,outletID = 4,productID = 3601, stockSIQ = '359367039549555', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359367039549555' And tblStockCentral.stockID=20062 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 502, tblProduct.productTotalAmount = 1506 Where tblProduct.productID=3601 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 1506 Where tblProduct.productID=3601 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17906, stockID = 12441, productID= 3601, outletFromID = 1, outletToID = 4, totalAmountBefore = 1004, totalAmountAfter = 1506, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 502, averageCostAfter = 502, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 100313 15:35:46 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17906, stockID = 12441, productID= 3601, outletFromID = 1, outletToID = 4, totalAmountBefore = 1004, totalAmountAfter = 1506, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 502, averageCostAfter = 502, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17907, stockID = 12442,outletFromID = 1,outletID = 4,productID = 3601, productType='Imei', stockSIQ = '359367039533211', stockBalance = 1 ,costPrice = 500, stockPrice = 502, stockDate='2010:03:13', stockTime='15:35:30', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17907, stockID = 12442,outletFromID = 1,outletID = 4,productID = 3601, stockSIQ = '359367039533211', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359367039533211' And tblStockCentral.stockID=20067 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 4, tblProduct.productPrice = 502, tblProduct.productTotalAmount = 2008 Where tblProduct.productID=3601 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 4, tblProduct.branch4TotalAmount = 2008 Where tblProduct.productID=3601 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17907, stockID = 12442, productID= 3601, outletFromID = 1, outletToID = 4, totalAmountBefore = 1506, totalAmountAfter = 2008, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 502, averageCostAfter = 502, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17907, stockID = 12442, productID= 3601, outletFromID = 1, outletToID = 4, totalAmountBefore = 1506, totalAmountAfter = 2008, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 502, averageCostAfter = 502, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17908, stockID = 12443,outletFromID = 1,outletID = 4,productID = 3602, productType='Imei', stockSIQ = '359367039550744', stockBalance = 1 ,costPrice = 500, stockPrice = 502, stockDate='2010:03:13', stockTime='15:35:30', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17908, stockID = 12443,outletFromID = 1,outletID = 4,productID = 3602, stockSIQ = '359367039550744', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359367039550744' And tblStockCentral.stockID=20058 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 501.725, tblProduct.productTotalAmount = 1003.45 Where tblProduct.productID=3602 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 1003.45 Where tblProduct.productID=3602 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17908, stockID = 12443, productID= 3602, outletFromID = 1, outletToID = 4, totalAmountBefore = 501.45, totalAmountAfter = 1003.45, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 501.44, averageCostAfter = 501.73, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17908, stockID = 12443, productID= 3602, outletFromID = 1, outletToID = 4, totalAmountBefore = 501.45, totalAmountAfter = 1003.45, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 501.44, averageCostAfter = 501.73, quantity = 1, costPrice = 500, transactionPrice = 502, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:30', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17909, stockID = 12444,outletFromID = 1,outletID = 4,productID = 504, productType='Imei', stockSIQ = '356929038979944', stockBalance = 1 ,costPrice = 175, stockPrice = 177, stockDate='2010:03:13', stockTime='15:35:31', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17909, stockID = 12444,outletFromID = 1,outletID = 4,productID = 504, stockSIQ = '356929038979944', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='356929038979944' And tblStockCentral.stockID=20069 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 177.01, tblProduct.productTotalAmount = 177.01 Where tblProduct.productID=504 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 177.01 Where tblProduct.productID=504 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17909, stockID = 12444, productID= 504, outletFromID = 1, outletToID = 4, totalAmountBefore = 0.01, totalAmountAfter = 177.01, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 185.61, averageCostAfter = 177.01, quantity = 1, costPrice = 175, transactionPrice = 177, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17909, stockID = 12444, productID= 504, outletFromID = 1, outletToID = 4, totalAmountBefore = 0.01, totalAmountAfter = 177.01, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 185.61, averageCostAfter = 177.01, quantity = 1, costPrice = 175, transactionPrice = 177, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17910, stockID = 12445,outletFromID = 1,outletID = 4,productID = 2574, productType='Imei', stockSIQ = '359365033634639', stockBalance = 1 ,costPrice = 80.04, stockPrice = 82.04, stockDate='2010:03:13', stockTime='15:35:31', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17910, stockID = 12445,outletFromID = 1,outletID = 4,productID = 2574, stockSIQ = '359365033634639', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359365033634639' And tblStockCentral.stockID=20090 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 82.04, tblProduct.productTotalAmount = 82.04 Where tblProduct.productID=2574 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 82.04 Where tblProduct.productID=2574 100313 15:35:47 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17910, stockID = 12445, productID= 2574, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 82.04, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 82.05, averageCostAfter = 82.04, quantity = 1, costPrice = 80.04, transactionPrice = 82.04, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17910, stockID = 12445, productID= 2574, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 82.04, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 82.05, averageCostAfter = 82.04, quantity = 1, costPrice = 80.04, transactionPrice = 82.04, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17911, stockID = 12446,outletFromID = 1,outletID = 4,productID = 504, productType='Imei', stockSIQ = '356929038979910', stockBalance = 1 ,costPrice = 175, stockPrice = 177, stockDate='2010:03:13', stockTime='15:35:31', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17911, stockID = 12446,outletFromID = 1,outletID = 4,productID = 504, stockSIQ = '356929038979910', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='356929038979910' And tblStockCentral.stockID=20068 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 177.005, tblProduct.productTotalAmount = 354.01 Where tblProduct.productID=504 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 354.01 Where tblProduct.productID=504 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17911, stockID = 12446, productID= 504, outletFromID = 1, outletToID = 4, totalAmountBefore = 177.01, totalAmountAfter = 354.01, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 177.01, averageCostAfter = 177, quantity = 1, costPrice = 175, transactionPrice = 177, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17911, stockID = 12446, productID= 504, outletFromID = 1, outletToID = 4, totalAmountBefore = 177.01, totalAmountAfter = 354.01, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 177.01, averageCostAfter = 177, quantity = 1, costPrice = 175, transactionPrice = 177, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17912, stockID = 12447,outletFromID = 1,outletID = 4,productID = 3568, productType='Imei', stockSIQ = '351513040313782', stockBalance = 1 ,costPrice = 1185, stockPrice = 1187, stockDate='2010:03:13', stockTime='15:35:31', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17912, stockID = 12447,outletFromID = 1,outletID = 4,productID = 3568, stockSIQ = '351513040313782', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='351513040313782' And tblStockCentral.stockID=20051 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 1210.75, tblProduct.productTotalAmount = 2421.5 Where tblProduct.productID=3568 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 2421.5 Where tblProduct.productID=3568 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17912, stockID = 12447, productID= 3568, outletFromID = 1, outletToID = 4, totalAmountBefore = 1234.5, totalAmountAfter = 2421.5, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 1234.5, averageCostAfter = 1210.75, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17912, stockID = 12447, productID= 3568, outletFromID = 1, outletToID = 4, totalAmountBefore = 1234.5, totalAmountAfter = 2421.5, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 1234.5, averageCostAfter = 1210.75, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:31', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17913, stockID = 12448,outletFromID = 1,outletID = 4,productID = 3970, productType='Imei', stockSIQ = '351513040305440', stockBalance = 1 ,costPrice = 1185, stockPrice = 1187, stockDate='2010:03:13', stockTime='15:35:32', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17913, stockID = 12448,outletFromID = 1,outletID = 4,productID = 3970, stockSIQ = '351513040305440', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='351513040305440' And tblStockCentral.stockID=20048 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 1187, tblProduct.productTotalAmount = 1187 Where tblProduct.productID=3970 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 1187 Where tblProduct.productID=3970 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17913, stockID = 12448, productID= 3970, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1187, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1207, averageCostAfter = 1187, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17913, stockID = 12448, productID= 3970, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 1187, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 1207, averageCostAfter = 1187, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17914, stockID = 12449,outletFromID = 1,outletID = 4,productID = 3970, productType='Imei', stockSIQ = '351513040306174', stockBalance = 1 ,costPrice = 1185, stockPrice = 1187, stockDate='2010:03:13', stockTime='15:35:32', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17914, stockID = 12449,outletFromID = 1,outletID = 4,productID = 3970, stockSIQ = '351513040306174', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='351513040306174' And tblStockCentral.stockID=20049 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 1187, tblProduct.productTotalAmount = 2374 Where tblProduct.productID=3970 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 2374 Where tblProduct.productID=3970 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17914, stockID = 12449, productID= 3970, outletFromID = 1, outletToID = 4, totalAmountBefore = 1187, totalAmountAfter = 2374, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 1187, averageCostAfter = 1187, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 100313 15:35:48 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17914, stockID = 12449, productID= 3970, outletFromID = 1, outletToID = 4, totalAmountBefore = 1187, totalAmountAfter = 2374, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 1187, averageCostAfter = 1187, quantity = 1, costPrice = 1185, transactionPrice = 1187, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17915, stockID = 12450,outletFromID = 1,outletID = 4,productID = 3157, productType='Imei', stockSIQ = '359368039150055', stockBalance = 1 ,costPrice = 750, stockPrice = 752, stockDate='2010:03:13', stockTime='15:35:32', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17915, stockID = 12450,outletFromID = 1,outletID = 4,productID = 3157, stockSIQ = '359368039150055', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359368039150055' And tblStockCentral.stockID=20056 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 752, tblProduct.productTotalAmount = 752 Where tblProduct.productID=3157 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 752 Where tblProduct.productID=3157 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17915, stockID = 12450, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 752, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17915, stockID = 12450, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 752, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17916, stockID = 12451,outletFromID = 1,outletID = 4,productID = 3157, productType='Imei', stockSIQ = '359368039149149', stockBalance = 1 ,costPrice = 750, stockPrice = 752, stockDate='2010:03:13', stockTime='15:35:32', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17916, stockID = 12451,outletFromID = 1,outletID = 4,productID = 3157, stockSIQ = '359368039149149', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359368039149149' And tblStockCentral.stockID=20054 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 752, tblProduct.productTotalAmount = 1504 Where tblProduct.productID=3157 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 1504 Where tblProduct.productID=3157 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17916, stockID = 12451, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 752, totalAmountAfter = 1504, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17916, stockID = 12451, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 752, totalAmountAfter = 1504, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:32', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17917, stockID = 12452,outletFromID = 1,outletID = 4,productID = 3157, productType='Imei', stockSIQ = '359368039149578', stockBalance = 1 ,costPrice = 750, stockPrice = 752, stockDate='2010:03:13', stockTime='15:35:33', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17917, stockID = 12452,outletFromID = 1,outletID = 4,productID = 3157, stockSIQ = '359368039149578', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359368039149578' And tblStockCentral.stockID=20057 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 752, tblProduct.productTotalAmount = 2256 Where tblProduct.productID=3157 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 2256 Where tblProduct.productID=3157 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17917, stockID = 12452, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 1504, totalAmountAfter = 2256, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17917, stockID = 12452, productID= 3157, outletFromID = 1, outletToID = 4, totalAmountBefore = 1504, totalAmountAfter = 2256, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 752, averageCostAfter = 752, quantity = 1, costPrice = 750, transactionPrice = 752, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17918, stockID = 12453,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030500329', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:33', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17918, stockID = 12453,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030500329', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030500329' And tblStockCentral.stockID=20086 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 99 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 99 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17918, stockID = 12453, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 99, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 107, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 100313 15:35:49 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17918, stockID = 12453, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 99, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 107, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17919, stockID = 12454,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030500436', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:33', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17919, stockID = 12454,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030500436', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030500436' And tblStockCentral.stockID=20084 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 198 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 198 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17919, stockID = 12454, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 99, totalAmountAfter = 198, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17919, stockID = 12454, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 99, totalAmountAfter = 198, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:33', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17920, stockID = 12455,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030500220', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:33', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17920, stockID = 12455,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030500220', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030500220' And tblStockCentral.stockID=20085 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 297 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 297 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17920, stockID = 12455, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 198, totalAmountAfter = 297, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17920, stockID = 12455, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 198, totalAmountAfter = 297, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17921, stockID = 12456,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030500709', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:34', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17921, stockID = 12456,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030500709', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030500709' And tblStockCentral.stockID=20082 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 4, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 396 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 4, tblProduct.branch4TotalAmount = 396 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17921, stockID = 12456, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 297, totalAmountAfter = 396, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17921, stockID = 12456, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 297, totalAmountAfter = 396, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17922, stockID = 12457,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030499811', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:34', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17922, stockID = 12457,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030499811', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030499811' And tblStockCentral.stockID=20087 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 5, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 495 Where tblProduct.productID=4229 100313 15:35:50 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 5, tblProduct.branch4TotalAmount = 495 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17922, stockID = 12457, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 396, totalAmountAfter = 495, totalQuantityBefore = 4, totalQuantityAfter = 5, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17922, stockID = 12457, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 396, totalAmountAfter = 495, totalQuantityBefore = 4, totalQuantityAfter = 5, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17923, stockID = 12458,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030500816', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:34', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17923, stockID = 12458,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030500816', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030500816' And tblStockCentral.stockID=20083 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 6, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 594 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 6, tblProduct.branch4TotalAmount = 594 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17923, stockID = 12458, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 495, totalAmountAfter = 594, totalQuantityBefore = 5, totalQuantityAfter = 6, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17923, stockID = 12458, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 495, totalAmountAfter = 594, totalQuantityBefore = 5, totalQuantityAfter = 6, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:34', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17924, stockID = 12459,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030493988', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:34', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17924, stockID = 12459,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030493988', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030493988' And tblStockCentral.stockID=20070 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 7, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 693 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 7, tblProduct.branch4TotalAmount = 693 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17924, stockID = 12459, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 594, totalAmountAfter = 693, totalQuantityBefore = 6, totalQuantityAfter = 7, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17924, stockID = 12459, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 594, totalAmountAfter = 693, totalQuantityBefore = 6, totalQuantityAfter = 7, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17925, stockID = 12460,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030494432', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:35', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17925, stockID = 12460,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030494432', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030494432' And tblStockCentral.stockID=20071 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 8, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 792 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 8, tblProduct.branch4TotalAmount = 792 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17925, stockID = 12460, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 693, totalAmountAfter = 792, totalQuantityBefore = 7, totalQuantityAfter = 8, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17925, stockID = 12460, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 693, totalAmountAfter = 792, totalQuantityBefore = 7, totalQuantityAfter = 8, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17926, stockID = 12461,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030492956', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:35', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17926, stockID = 12461,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030492956', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030492956' And tblStockCentral.stockID=20077 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 9, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 891 Where tblProduct.productID=4229 100313 15:35:51 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 9, tblProduct.branch4TotalAmount = 891 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17926, stockID = 12461, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 792, totalAmountAfter = 891, totalQuantityBefore = 8, totalQuantityAfter = 9, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17926, stockID = 12461, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 792, totalAmountAfter = 891, totalQuantityBefore = 8, totalQuantityAfter = 9, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17927, stockID = 12462,outletFromID = 1,outletID = 4,productID = 2758, productType='Imei', stockSIQ = '351520041308489', stockBalance = 1 ,costPrice = 115, stockPrice = 117, stockDate='2010:03:13', stockTime='15:35:35', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17927, stockID = 12462,outletFromID = 1,outletID = 4,productID = 2758, stockSIQ = '351520041308489', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='351520041308489' And tblStockCentral.stockID=20092 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 116, tblProduct.productTotalAmount = 348 Where tblProduct.productID=2758 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 348 Where tblProduct.productID=2758 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17927, stockID = 12462, productID= 2758, outletFromID = 1, outletToID = 4, totalAmountBefore = 231, totalAmountAfter = 348, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 115.5, averageCostAfter = 116, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17927, stockID = 12462, productID= 2758, outletFromID = 1, outletToID = 4, totalAmountBefore = 231, totalAmountAfter = 348, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 115.5, averageCostAfter = 116, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17928, stockID = 12463,outletFromID = 1,outletID = 4,productID = 2798, productType='Imei', stockSIQ = '359328033671548', stockBalance = 1 ,costPrice = 115, stockPrice = 117, stockDate='2010:03:13', stockTime='15:35:35', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17928, stockID = 12463,outletFromID = 1,outletID = 4,productID = 2798, stockSIQ = '359328033671548', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359328033671548' And tblStockCentral.stockID=20097 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 117, tblProduct.productTotalAmount = 117 Where tblProduct.productID=2798 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 117 Where tblProduct.productID=2798 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17928, stockID = 12463, productID= 2798, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 117, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 114.02, averageCostAfter = 117, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17928, stockID = 12463, productID= 2798, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 117, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 114.02, averageCostAfter = 117, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:35', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17929, stockID = 12464,outletFromID = 1,outletID = 4,productID = 2758, productType='Imei', stockSIQ = '351520041306046', stockBalance = 1 ,costPrice = 115, stockPrice = 117, stockDate='2010:03:13', stockTime='15:35:36', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17929, stockID = 12464,outletFromID = 1,outletID = 4,productID = 2758, stockSIQ = '351520041306046', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='351520041306046' And tblStockCentral.stockID=20093 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 4, tblProduct.productPrice = 116.25, tblProduct.productTotalAmount = 465 Where tblProduct.productID=2758 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 4, tblProduct.branch4TotalAmount = 465 Where tblProduct.productID=2758 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17929, stockID = 12464, productID= 2758, outletFromID = 1, outletToID = 4, totalAmountBefore = 348, totalAmountAfter = 465, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 116, averageCostAfter = 116.25, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17929, stockID = 12464, productID= 2758, outletFromID = 1, outletToID = 4, totalAmountBefore = 348, totalAmountAfter = 465, totalQuantityBefore = 3, totalQuantityAfter = 4, averageCostBefore = 116, averageCostAfter = 116.25, quantity = 1, costPrice = 115, transactionPrice = 117, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17930, stockID = 12465,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030492931', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:36', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17930, stockID = 12465,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030492931', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030492931' And tblStockCentral.stockID=20078 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 10, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 990 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 10, tblProduct.branch4TotalAmount = 990 Where tblProduct.productID=4229 100313 15:35:52 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17930, stockID = 12465, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 891, totalAmountAfter = 990, totalQuantityBefore = 9, totalQuantityAfter = 10, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17930, stockID = 12465, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 891, totalAmountAfter = 990, totalQuantityBefore = 9, totalQuantityAfter = 10, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17931, stockID = 12466,outletFromID = 1,outletID = 4,productID = 4229, productType='Imei', stockSIQ = '358234030493111', stockBalance = 1 ,costPrice = 97, stockPrice = 99, stockDate='2010:03:13', stockTime='15:35:36', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17931, stockID = 12466,outletFromID = 1,outletID = 4,productID = 4229, stockSIQ = '358234030493111', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358234030493111' And tblStockCentral.stockID=20079 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 11, tblProduct.productPrice = 99, tblProduct.productTotalAmount = 1089 Where tblProduct.productID=4229 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 11, tblProduct.branch4TotalAmount = 1089 Where tblProduct.productID=4229 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17931, stockID = 12466, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 990, totalAmountAfter = 1089, totalQuantityBefore = 10, totalQuantityAfter = 11, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17931, stockID = 12466, productID= 4229, outletFromID = 1, outletToID = 4, totalAmountBefore = 990, totalAmountAfter = 1089, totalQuantityBefore = 10, totalQuantityAfter = 11, averageCostBefore = 99, averageCostAfter = 99, quantity = 1, costPrice = 97, transactionPrice = 99, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17932, stockID = 12467,outletFromID = 1,outletID = 4,productID = 3853, productType='Imei', stockSIQ = '358767037984269', stockBalance = 1 ,costPrice = 413, stockPrice = 415, stockDate='2010:03:13', stockTime='15:35:36', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17932, stockID = 12467,outletFromID = 1,outletID = 4,productID = 3853, stockSIQ = '358767037984269', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358767037984269' And tblStockCentral.stockID=20041 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 413.5, tblProduct.productTotalAmount = 827 Where tblProduct.productID=3853 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 827 Where tblProduct.productID=3853 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17932, stockID = 12467, productID= 3853, outletFromID = 1, outletToID = 4, totalAmountBefore = 412, totalAmountAfter = 827, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 412, averageCostAfter = 413.5, quantity = 1, costPrice = 413, transactionPrice = 415, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17932, stockID = 12467, productID= 3853, outletFromID = 1, outletToID = 4, totalAmountBefore = 412, totalAmountAfter = 827, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 412, averageCostAfter = 413.5, quantity = 1, costPrice = 413, transactionPrice = 415, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:36', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17933, stockID = 12468,outletFromID = 1,outletID = 4,productID = 3853, productType='Imei', stockSIQ = '358767037976711', stockBalance = 1 ,costPrice = 413, stockPrice = 415, stockDate='2010:03:13', stockTime='15:35:37', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17933, stockID = 12468,outletFromID = 1,outletID = 4,productID = 3853, stockSIQ = '358767037976711', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='358767037976711' And tblStockCentral.stockID=20042 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 414, tblProduct.productTotalAmount = 1242 Where tblProduct.productID=3853 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 1242 Where tblProduct.productID=3853 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17933, stockID = 12468, productID= 3853, outletFromID = 1, outletToID = 4, totalAmountBefore = 827, totalAmountAfter = 1242, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 413.5, averageCostAfter = 414, quantity = 1, costPrice = 413, transactionPrice = 415, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17933, stockID = 12468, productID= 3853, outletFromID = 1, outletToID = 4, totalAmountBefore = 827, totalAmountAfter = 1242, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 413.5, averageCostAfter = 414, quantity = 1, costPrice = 413, transactionPrice = 415, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17934, stockID = 12469,outletFromID = 1,outletID = 4,productID = 2787, productType='Imei', stockSIQ = '356385030554476', stockBalance = 1 ,costPrice = 543, stockPrice = 545, stockDate='2010:03:13', stockTime='15:35:37', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17934, stockID = 12469,outletFromID = 1,outletID = 4,productID = 2787, stockSIQ = '356385030554476', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='356385030554476' And tblStockCentral.stockID=20045 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 3, tblProduct.productPrice = 546.523333333333, tblProduct.productTotalAmount = 1639.57 Where tblProduct.productID=2787 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 3, tblProduct.branch4TotalAmount = 1639.57 Where tblProduct.productID=2787 100313 15:35:53 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17934, stockID = 12469, productID= 2787, outletFromID = 1, outletToID = 4, totalAmountBefore = 1094.57, totalAmountAfter = 1639.57, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 547.29, averageCostAfter = 546.52, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17934, stockID = 12469, productID= 2787, outletFromID = 1, outletToID = 4, totalAmountBefore = 1094.57, totalAmountAfter = 1639.57, totalQuantityBefore = 2, totalQuantityAfter = 3, averageCostBefore = 547.29, averageCostAfter = 546.52, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17935, stockID = 12470,outletFromID = 1,outletID = 4,productID = 2298, productType='Imei', stockSIQ = '359194030825630', stockBalance = 1 ,costPrice = 543, stockPrice = 545, stockDate='2010:03:13', stockTime='15:35:37', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17935, stockID = 12470,outletFromID = 1,outletID = 4,productID = 2298, stockSIQ = '359194030825630', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='359194030825630' And tblStockCentral.stockID=20039 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 1, tblProduct.productPrice = 545, tblProduct.productTotalAmount = 545 Where tblProduct.productID=2298 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 1, tblProduct.branch4TotalAmount = 545 Where tblProduct.productID=2298 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17935, stockID = 12470, productID= 2298, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 545, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 612, averageCostAfter = 545, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17935, stockID = 12470, productID= 2298, outletFromID = 1, outletToID = 4, totalAmountBefore = 0, totalAmountAfter = 545, totalQuantityBefore = 0, totalQuantityAfter = 1, averageCostBefore = 612, averageCostAfter = 545, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:37', transactionType = 'ti' 1088 Query Update tblID Set tblID.lastValue = lastValue + 1 Where tblID.tableName='tblStock' 1088 Query Insert into tblStock Set receiveOrderID= 1336,receiveOrderDetailsID = 17936, stockID = 12471,outletFromID = 1,outletID = 4,productID = 4071, productType='Imei', stockSIQ = '355265036546398', stockBalance = 1 ,costPrice = 543, stockPrice = 545, stockDate='2010:03:13', stockTime='15:35:37', transactionType='t' 1089 Query Insert into tblStockCentral Set receiveOrderID=1336,receiveOrderDetailsID = 17936, stockID = 12471,outletFromID = 1,outletID = 4,productID = 4071, stockSIQ = '355265036546398', transactionType = 't' 1089 Query Update tblStockCentral Set tblStockCentral.stockStatus = 'b' Where tblStockCentral.stockSIQ='355265036546398' And tblStockCentral.stockID=20037 And tblStockCentral.outletID=1 1088 Query Update tblProduct Set tblProduct.productTotalStock = 2, tblProduct.productPrice = 578.5, tblProduct.productTotalAmount = 1157 Where tblProduct.productID=4071 1089 Query Update tblProduct Set tblProduct.branch4TotalStock = 2, tblProduct.branch4TotalAmount = 1157 Where tblProduct.productID=4071 1088 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17936, stockID = 12471, productID= 4071, outletFromID = 1, outletToID = 4, totalAmountBefore = 612, totalAmountAfter = 1157, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 612, averageCostAfter = 578.5, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:38', transactionType = 'ti' 1089 Query Insert into tblTransaction Set transactionID = 1336, transactionDetailsID=17936, stockID = 12471, productID= 4071, outletFromID = 1, outletToID = 4, totalAmountBefore = 612, totalAmountAfter = 1157, totalQuantityBefore = 1, totalQuantityAfter = 2, averageCostBefore = 612, averageCostAfter = 578.5, quantity = 1, costPrice = 543, transactionPrice = 545, transactionEmployeeID = 82, transactionDate='2010:03:13', transactionTime='15:35:38', transactionType = 'ti' 1089 Query Update tblTransfer Set employeeToID='82',transferStatus ='y',transferToDate='2010:03:13', transferToTime='15:35:38' Where transferID=1336 And outletFromID =1 1088 Query COMMIT 1089 Query COMMIT 1088 Quit 1089 Quit