API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 19th, 2015
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.12 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE `COR_TMP` (
  2. `DIHISTORYID` int(25) DEFAULT NULL,
  3. `DIH_INVENTORYID` int(25) DEFAULT NULL,
  4. `DIH_SECTIONID` int(25) DEFAULT NULL,
  5. `DIH_PRODUCTID` int(25) DEFAULT NULL,
  6. `DIH_QTY_BALANCE` decimal(10,2) DEFAULT NULL,
  7. `DIH_REORDER_QTY` decimal(10,2) DEFAULT NULL,
  8. `DIH_TYPE` varchar(30) DEFAULT NULL,
  9. `DIH_ADJUST_TYPE` varchar(30) DEFAULT NULL,
  10. `DIH_TRANSC_ID` int(25) DEFAULT NULL,
  11. `DII_QTY_BALANCE` decimal(10,2) DEFAULT NULL,
  12. `DII_PRODUCT_CODE` varchar(50) DEFAULT NULL,
  13. `DIH_ENTERED_DATE` datetime DEFAULT NULL
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  15.  
  16. /*Data for the table `COR_TMP` */
  17.  
  18. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (16866,1331,32,6823,98.00,20.00,'CONSUME','DEDUCT',2024,78.00,'SMBAG00016','2015-06-11 12:35:35');
  19. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (16234,1331,32,6823,98.00,50.00,'DODPI','ADD',100324,78.00,'SMBAG00016','2015-05-28 10:51:47');
  20. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (13864,1331,32,6823,68.00,20.00,'CONSUME','DEDUCT',1736,78.00,'SMBAG00016','2015-04-14 10:59:24');
  21. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (13577,1331,32,6823,68.00,10.00,'CONSUME','DEDUCT',1721,78.00,'SMBAG00016','2015-04-08 09:22:30');
  22. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (13073,1331,32,6823,78.00,50.00,'DODPI','ADD',93229,78.00,'SMBAG00016','2015-03-26 13:53:24');
  23. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (6532,1331,32,6823,28.00,10.00,'CONSUME','DEDUCT',872,78.00,'SMBAG00016','2014-11-26 14:33:25');
  24. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (5837,1331,32,6823,38.00,2.00,'CONSUME','DEDUCT',779,78.00,'SMBAG00016','2014-11-18 11:08:23');
  25. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (4381,1331,32,6823,40.00,10.00,'CONSUME','DEDUCT',565,78.00,'SMBAG00016','2014-10-29 11:19:51');
  26. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (2580,1331,32,6823,50.00,50.00,'DODPI','ADD',71344,78.00,'SMBAG00016','2014-10-02 11:56:24');
  27. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (22182,810,32,5923,13.00,3.00,'DODPI','ADD',116702,13.00,'SCHEM00039','2015-10-01 09:38:11');
  28. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (20186,810,32,5923,10.00,3.00,'DODPI','ADD',111263,13.00,'SCHEM00039','2015-08-19 11:47:27');
  29. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (19695,810,32,5923,7.00,2.00,'DODPI','ADD',109791,13.00,'SCHEM00039','2015-08-08 10:29:35');
  30. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (18507,810,32,5923,5.00,2.00,'DODPI','ADD',106018,13.00,'SCHEM00039','2015-07-11 11:12:03');
  31. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (16244,810,32,5923,7.00,4.00,'CONSUME','DEDUCT',1965,13.00,'SCHEM00039','2015-05-28 13:54:51');
  32. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (15943,810,32,5923,7.00,3.00,'DODPI','ADD',99510,13.00,'SCHEM00039','2015-05-20 17:13:30');
  33. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (13863,810,32,5923,8.00,4.00,'CONSUME','DEDUCT',1735,13.00,'SCHEM00039','2015-04-14 10:58:59');
  34. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (13432,810,32,5923,8.00,3.00,'DODPI','ADD',94131,13.00,'SCHEM00039','2015-04-03 11:13:36');
  35. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (12700,810,32,5923,5.00,3.00,'CONSUME','DEDUCT',1642,13.00,'SCHEM00039','2015-03-20 15:42:23');
  36. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (12413,810,32,5923,8.00,3.00,'DODPI','ADD',91893,13.00,'SCHEM00039','2015-03-16 16:12:42');
  37. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (11947,810,32,5923,5.00,3.00,'DODPI','ADD',90661,13.00,'SCHEM00039','2015-03-07 10:27:09');
  38. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (11807,810,32,5923,2.00,3.00,'CONSUME','DEDUCT',1519,13.00,'SCHEM00039','2015-03-05 10:20:32');
  39. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (11117,810,32,5923,5.00,2.00,'DODPI','ADD',88755,13.00,'SCHEM00039','2015-02-19 11:35:54');
  40. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (11100,810,32,5923,3.00,3.00,'CONSUME','DEDUCT',1465,13.00,'SCHEM00039','2015-02-18 15:20:10');
  41. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (10664,810,32,5923,6.00,3.00,'DODPI','ADD',87233,13.00,'SCHEM00039','2015-02-09 16:14:22');
  42. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (10248,810,32,5923,3.00,1.00,'DODPI','ADD',85990,13.00,'SCHEM00039','2015-01-30 14:15:05');
  43. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (9848,810,32,5923,2.00,1.00,'CONSUME','DEDUCT',1267,13.00,'SCHEM00039','2015-01-26 09:24:06');
  44. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (8852,810,32,5923,3.00,2.00,'CONSUME','DEDUCT',1168,13.00,'SCHEM00039','2015-01-12 09:08:01');
  45. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (7664,810,32,5923,5.00,3.00,'DODPI','ADD',80629,13.00,'SCHEM00039','2014-12-18 08:40:39');
  46. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (6857,810,32,5923,2.00,2.00,'CONSUME','DEDUCT',909,13.00,'SCHEM00039','2014-12-03 11:25:06');
  47. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (5031,810,32,5923,4.00,2.00,'CONSUME','DEDUCT',631,13.00,'SCHEM00039','2014-11-04 09:09:29');
  48. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (4706,810,32,5923,6.00,3.00,'DODPI','ADD',74736,13.00,'SCHEM00039','2014-10-30 14:30:44');
  49. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (3055,810,32,5923,3.00,1.00,'CONSUME','DEDUCT',278,13.00,'SCHEM00039','2014-10-09 15:45:08');
  50. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (1558,810,32,5923,4.00,2.00,'CONSUME','DEDUCT',16,13.00,'SCHEM00039','2014-09-17 12:12:53');
  51. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (1475,810,32,5923,6.00,3.00,'DODPI','ADD',69109,13.00,'SCHEM00039','2014-09-17 09:49:31');
  52. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (1467,810,32,5923,3.00,1.00,'CONSUME','DEDUCT',7,13.00,'SCHEM00039','2014-09-17 09:27:38');
  53. insert into `COR_TMP`(`DIHISTORYID`,`DIH_INVENTORYID`,`DIH_SECTIONID`,`DIH_PRODUCTID`,`DIH_QTY_BALANCE`,`DIH_REORDER_QTY`,`DIH_TYPE`,`DIH_ADJUST_TYPE`,`DIH_TRANSC_ID`,`DII_QTY_BALANCE`,`DII_PRODUCT_CODE`,`DIH_ENTERED_DATE`) values (1067,810,32,5923,4.00,4.00,'DODPI','ADD',67731,13.00,'SCHEM00039','2014-09-05 17:45:38');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!