[encoded data, 240423 characters], '20251030', NULL, '20251030', 21, '2025-11-05 11:24:00');
INSERT INTO `reports` (`ReportNo`, `Name`, `Query`, `Reports`, `Type`, `Menu`, `Color`, `Program`, `Secret`, `Choice`, `ReportType`, `XData`, `Width`, `Height`, `Objects`, `ReportFrx`, `LAST_UPDATE`, `LAST_UPLOAD`, `CREATE_DATE`, `VIEW_COUNT`, `LAST_VIEW`) VALUES
(114, 'รายงานห้องจ่ายยา', NULL, NULL, NULL, 'รายงานห้องจ่ายยา', NULL, 'invs', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '20251030', NULL, NULL),
(115, 'test', NULL, NULL, NULL, 'รายงานห้องจ่ายยา', NULL, 'invs', NULL, NULL, 113, NULL, NULL, NULL, NULL, 0x[encoded data, 38406 characters], '20251105', NULL, NULL, 33, '2025-11-05 11:24:27');
INSERT INTO `reports` (`ReportNo`, `Name`, `Query`, `Reports`, `Type`, `Menu`, `Color`, `Program`, `Secret`, `Choice`, `ReportType`, `XData`, `Width`, `Height`, `Objects`, `ReportFrx`, `LAST_UPDATE`, `LAST_UPLOAD`, `CREATE_DATE`, `VIEW_COUNT`, `LAST_VIEW`) VALUES
(116, 'สรุปการเบิกยาจำแนกตามหน่วยเบิก_2', NULL, NULL, NULL, 'เจ๋', NULL, 'invs', NULL, NULL, 113, NULL, NULL, NULL, NULL, 0x[encoded data, 52146 characters], '20251105', NULL, NULL, 13, '2025-11-05 10:26:54');

-- --------------------------------------------------------

--
-- Table structure for table `req_con`
--

CREATE TABLE `req_con` (
  `STOCK_ID` char(6) DEFAULT NULL,
  `START_DATE` char(8) DEFAULT NULL,
  `END_DATE` char(8) DEFAULT NULL,
  `STOCK_FOR_WEEK` int(11) DEFAULT NULL,
  `DAYS_DISP` int(11) DEFAULT NULL,
  `A` smallint(6) DEFAULT NULL,
  `B` smallint(6) DEFAULT NULL,
  `C` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `req_con`
--

INSERT INTO `req_con` (`STOCK_ID`, `START_DATE`, `END_DATE`, `STOCK_FOR_WEEK`, `DAYS_DISP`, `A`, `B`, `C`) VALUES
('BAB01', '20180613', NULL, NULL, 30, 70, 20, 10),
('ROM01', '20180313', NULL, NULL, 30, 70, 20, 10),
('MKP01', '20180313', NULL, NULL, 30, 0, 0, 0),
('SAW01', '20180314', NULL, NULL, 30, 70, 20, 10),
('KRO01', '20180402', NULL, NULL, 30, 70, 20, 10),
('KAN01', '20180313', NULL, NULL, 30, 0, 0, 0),
('NOT01', '20180313', NULL, NULL, 7, 70, 20, 10),
('PAL01', '20180313', NULL, NULL, 7, 0, 0, 0),
('SWJ01', '20180313', NULL, NULL, 30, 70, 20, 10),
('DON01', '20180329', NULL, NULL, 7, 70, 20, 10),
('KOT01', '20180612', NULL, NULL, 30, 0, 0, 0),
('KKL01', '20180612', NULL, NULL, 7, 70, 20, 10),
('BAY01', '20180313', NULL, NULL, 10, 0, 0, 0),
('KOK01', '20180613', NULL, NULL, 7, 70, 20, 10),
(NULL, NULL, NULL, NULL, 30, NULL, NULL, NULL),
(NULL, NULL, NULL, NULL, 30, NULL, NULL, NULL),
('HUA01', '20180313', NULL, NULL, 30, 0, 0, 0),
('NNA01', '20180523', NULL, NULL, 7, 70, 20, 10),
('STO01', '20180625', NULL, NULL, 7, 50, 30, 20),
('SAK01', '20180612', NULL, NULL, 7, 70, 20, 10),
('BUL01', '20180613', NULL, NULL, 7, 0, 0, 0),
('KAS01', '20180612', NULL, NULL, 30, 70, 20, 10),
('STOCK1', '20251020', NULL, NULL, 1, 70, 20, 10),
('ERR01', '20251010', NULL, NULL, 1, NULL, NULL, NULL),
('DIS01', '20251028', NULL, NULL, 1, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `rs_con`
--

CREATE TABLE `rs_con` (
  `RS_DATE` char(8) DEFAULT NULL,
  `RS_CON` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rs_con`
--

INSERT INTO `rs_con` (`RS_DATE`, `RS_CON`) VALUES
('20251103', 9);

-- --------------------------------------------------------

--
-- Table structure for table `rtn_action`
--

CREATE TABLE `rtn_action` (
  `ID` int(11) NOT NULL,
  `ACTION_DES` varchar(60) DEFAULT NULL,
  `HIDE` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rtn_action`
--

INSERT INTO `rtn_action` (`ID`, `ACTION_DES`, `HIDE`) VALUES
(1, 'ทดสอบ', 'N');

-- --------------------------------------------------------

--
-- Table structure for table `rtn_reason`
--

CREATE TABLE `rtn_reason` (
  `ID` int(11) NOT NULL,
  `RETURN_REASON` varchar(60) DEFAULT NULL,
  `HIDE` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rtn_reason`
--

INSERT INTO `rtn_reason` (`ID`, `RETURN_REASON`, `HIDE`) VALUES
(1, 'อัตราการใช้ลดลง', 'N'),
(2, 'หน่วยเบิกเบิกผิดรายการ', 'N'),
(3, 'หน่วยเบิกเบิกผิดจำนวน', 'N'),
(4, 'คลังฯจ่ายผิดรายการ', 'N'),
(5, 'คลังฯจ่ายผิดจำนวน', 'N'),
(6, 'แพทย์เปลี่ยนการรักษา', 'N'),
(7, 'เลื่อนการทำหัตการ', 'N'),
(8, 'D/C or refer or ปฏิเสธการรักษา', 'N'),
(9, 'ผู้ป่วยเสียชีวิต', 'N'),
(10, 'ยาเสื่อมสภาพ or exp.', 'N'),
(11, 'Dispensing error', 'N'),
(12, 'Pre admin error', 'N'),
(13, 'Administration error', 'N'),
(14, 'ยาเหลือสะสม', 'N'),
(15, 'ADR', 'N'),
(16, 'Non-compliance', 'N'),
(17, 'ไม่มีอาการแล้ว', 'N'),
(18, 'บรรจุภัณฑ์ชำรุด', 'N'),
(19, 'ขอเปลี่ยนยาช่วยชีวิตตามข้อตกลง', 'N');

-- --------------------------------------------------------

--
-- Table structure for table `sale_unit`
--

CREATE TABLE `sale_unit` (
  `SALE_UNIT` varchar(60) DEFAULT NULL,
  `SU_ID` int(11) NOT NULL,
  `HIDE` char(1) DEFAULT NULL,
  `SU_ID_EX` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sale_unit`
--

INSERT INTO `sale_unit` (`SALE_UNIT`, `SU_ID`, `HIDE`, `SU_ID_EX`) VALUES
('AMP  ', 1, 'N', ''),
('BAG  ', 2, 'N', ''),
('BLI  ', 3, 'N', ''),
('BOT  ', 4, 'N', ''),
('BOX', 5, 'N', ''),
('CAP  ', 6, 'N', ''),
('DOS  ', 7, 'N', ''),
('GAL  ', 8, 'N', ''),
('JAR  ', 9, 'N', ''),
('NEB  ', 10, 'N', ''),
('PCS  ', 11, 'N', ''),
('SAC  ', 12, 'N', ''),
('SET  ', 13, 'N', ''),
('SHE  ', 14, 'N', ''),
('SYR  ', 15, 'N', ''),
('TAB  ', 16, 'N', ''),
('TUB  ', 17, 'N', ''),
('VA   ', 18, 'N', ''),
('VIA  ', 19, 'N', ''),
('VIAL ', 20, 'N', ''),
('PCS', 21, 'N', ''),
('KG', 22, 'N', ''),
('ม้วน', 23, 'N', ''),
('แพค', 24, 'N', ''),
('ปี๊บ', 25, 'N', ''),
('PENTIPS', 26, 'N', '');

-- --------------------------------------------------------

--
-- Table structure for table `scan`
--

CREATE TABLE `scan` (
  `REF_NO` varchar(20) DEFAULT NULL,
  `DOC_CODE` varchar(6) DEFAULT NULL,
  `IMG_DATA` longblob DEFAULT NULL,
  `USER_ID` varchar(16) DEFAULT NULL,
  `ID` varchar(17) DEFAULT NULL,
  `SYS_DATE` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `server_config`
--

CREATE TABLE `server_config` (
  `section` varchar(50) DEFAULT NULL,
  `ident` varchar(50) DEFAULT NULL,
  `value` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=tis620 COLLATE=tis620_thai_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `sm_po`
--

CREATE TABLE `sm_po` (
  `RECORD_NUMBER` int(11) NOT NULL,
  `SUB_PO_NO` char(12) DEFAULT NULL,
  `DEPT_ID` char(6) DEFAULT NULL,
  `ACC_NO` char(5) DEFAULT NULL,
  `TOTAL_ITEM` double DEFAULT NULL,
  `TOTAL_COST` double DEFAULT NULL,
  `TOTAL_VALUE` double DEFAULT NULL,
  `SYSDATE` datetime DEFAULT NULL,
  `OK` char(1) DEFAULT NULL,
  `PROCESS` char(1) DEFAULT NULL,
  `ERROR_ENTER` char(1) DEFAULT NULL,
  `ERROR_PROCESS` char(1) DEFAULT NULL,
  `STOCK_ID` char(6) DEFAULT NULL,
  `USER_ID` varchar(30) DEFAULT NULL,
  `SUB_PO_DATE` char(8) DEFAULT NULL,
  `CONFIRM_FLAG` char(1) DEFAULT NULL,
  `PRIOR_FLAG` smallint(6) DEFAULT NULL,
  `R_S_STATUS` char(1) DEFAULT NULL,
  `SEND_FLAG` char(1) DEFAULT NULL,
  `PRINT_FLAG` char(1) DEFAULT NULL,
  `MOD_SYS` varchar(10) DEFAULT NULL,
  `REF_NO` varchar(15) DEFAULT NULL,
  `CONFIRM_DATE` char(8) DEFAULT NULL,
  `CONFIRM_TIME` char(4) DEFAULT NULL,
  `DIST_TYPE` int(11) DEFAULT NULL,
  `RES_DATE` char(8) DEFAULT NULL,
  `SUB_PO_UNO` varchar(15) DEFAULT NULL,
  `REQ_INTER` char(1) DEFAULT 'N',
  `CFM_INTER` char(1) DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sm_po`
--

INSERT INTO `sm_po` (`RECORD_NUMBER`, `SUB_PO_NO`, `DEPT_ID`, `ACC_NO`, `TOTAL_ITEM`, `TOTAL_COST`, `TOTAL_VALUE`, `SYSDATE`, `OK`, `PROCESS`, `ERROR_ENTER`, `ERROR_PROCESS`, `STOCK_ID`, `USER_ID`, `SUB_PO_DATE`, `CONFIRM_FLAG`, `PRIOR_FLAG`, `R_S_STATUS`, `SEND_FLAG`, `PRINT_FLAG`, `MOD_SYS`, `REF_NO`, `CONFIRM_DATE`, `CONFIRM_TIME`, `DIST_TYPE`, `RES_DATE`, `SUB_PO_UNO`, `REQ_INTER`, `CFM_INTER`) VALUES
(3145, '6809080001', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 11:58:50', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3146, '6809080002', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 11:59:00', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3147, '6809080004', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 12:10:13', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3148, '6809080005', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 12:23:32', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3149, '6809080006', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 14:02:11', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3150, '6809080007', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 14:02:38', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3151, '6809080008', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 14:17:55', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', '', NULL, NULL, 0, NULL, '', 'N', 'N'),
(3152, '6809080009', 'PT01', NULL, 0, NULL, NULL, '2025-09-08 14:19:36', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20250908', 'N', NULL, 'S', NULL, NULL, 'MED', '', NULL, NULL, 0, NULL, '', 'N', 'N'),
(3153, '6810070002', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-07 14:33:08', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251007', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3154, '6810070003', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-07 14:37:56', NULL, NULL, NULL, NULL, 'DS001', '4009', '20251007', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3155, '6810070008', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-07 15:53:32', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251007', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3156, '6810090001', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-09 10:36:02', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251009', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3157, '6810090002', 'PT01', NULL, 0, NULL, NULL, '2025-10-09 12:24:27', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3158, '6810090003', 'PT01', NULL, 0, NULL, NULL, '2025-10-09 12:24:51', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3159, '6810090004', 'PT01', NULL, 0, NULL, NULL, '2025-10-09 12:26:18', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'S', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3160, '6810090007', 'ANC01', NULL, 0, NULL, NULL, '2025-10-09 15:55:59', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3161, '6810090008', 'DIS01', NULL, 0, NULL, NULL, '2025-10-09 15:59:01', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3162, '6810090009', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-09 15:59:29', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251009', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3163, '6810090010', 'WAR01', NULL, 0, NULL, NULL, '2025-10-09 16:00:09', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251009', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3164, '6810100001', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-10 09:05:00', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251010', 'N', NULL, 'R', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3165, '6810100002', 'DEN01', NULL, 0, NULL, NULL, '2025-10-10 12:30:03', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251010', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3166, '6810100003', 'ANC01', NULL, 0, NULL, NULL, '2025-10-10 12:31:47', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251010', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3167, '6810100004', 'ANC01', NULL, 0, NULL, NULL, '2025-10-10 12:31:53', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251010', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3168, '6810100005', 'DIS01', NULL, 0, NULL, NULL, '2025-10-10 13:26:18', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251010', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3169, '6810200004', 'ANC01', NULL, 0, NULL, NULL, '2025-10-20 13:28:52', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251020', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3170, '6810280001', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 09:51:19', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3171, '6810280002', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:07:38', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3172, '6810280003', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:09:31', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3173, '6810280004', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:12:23', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3174, '6810280005', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:14:40', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3175, '6810280006', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:15:23', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3176, '6810280007', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-28 10:16:08', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251028', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3177, '6810280008', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:17:16', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3178, '6810280009', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:21:59', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3179, '6810280010', 'STOCK1', NULL, 0, NULL, NULL, '2025-10-28 10:22:25', NULL, NULL, NULL, NULL, 'DIS01', '4009', '20251028', 'N', NULL, 'R', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3180, '6810280011', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 10:29:41', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, 3, NULL, '', 'N', 'N'),
(3181, '6810280012', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:32:39', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, 2, NULL, '', 'N', 'N'),
(3182, '6810280013', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:33:15', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3183, '6810280014', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:33:59', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', '', NULL, NULL, 0, NULL, '', 'N', 'N'),
(3184, '6810280015', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 10:36:51', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3185, '6810280016', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 11:18:58', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3186, '6810280017', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 11:37:16', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3187, '6810280018', 'DIS01', NULL, 0, NULL, NULL, '2025-10-28 11:50:23', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3188, '6810280019', 'VPB01', NULL, 0, NULL, NULL, '2025-10-28 16:10:22', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'N', NULL, 'T', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3189, '6810290001', 'VPB01', NULL, 1, 375, 375, '2025-10-29 09:00:20', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251028', 'Y', NULL, 'T', NULL, NULL, 'MED', '', '20251029', '0902', NULL, NULL, '', 'N', 'N'),
(3190, '6810300001', 'PT01', NULL, 0, NULL, NULL, '2025-10-30 10:22:02', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251030', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3191, '6810300002', 'PT01', NULL, 0, NULL, NULL, '2025-10-30 10:23:01', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251030', 'N', NULL, 'S', NULL, NULL, 'MED', NULL, NULL, NULL, NULL, NULL, '', 'N', 'N'),
(3192, '6811030001', 'EMR01', NULL, 3, 859.5, 859.5, '2025-11-03 09:45:41', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0946', NULL, NULL, '', 'N', 'N'),
(3193, '6811030002', 'WAR01', NULL, 2, 856, 856, '2025-11-03 09:49:18', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0949', NULL, NULL, '', 'N', 'N'),
(3194, '6811030003', 'WAR02', NULL, 2, 784, 784, '2025-11-03 09:50:28', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0950', NULL, NULL, '', 'N', 'N'),
(3195, '6811030004', 'WAR03', NULL, 2, 133.5, 133.5, '2025-11-03 09:51:30', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0951', NULL, NULL, '', 'N', 'N'),
(3196, '6811030005', 'WAR04', NULL, 1, 8, 8, '2025-11-03 09:52:37', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0952', NULL, NULL, '', 'N', 'N'),
(3197, '6811030006', 'LBR01', NULL, 1, 16, 16, '2025-11-03 09:53:14', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0953', NULL, NULL, '', 'N', 'N'),
(3198, '6811030007', 'OR001', NULL, 4, 1699.5, 1699.5, '2025-11-03 09:54:40', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '0954', NULL, NULL, '', 'N', 'N'),
(3199, '6811030008', 'DIS01', NULL, 5, 12406.47, 12406.47, '2025-11-03 10:07:10', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '1007', NULL, NULL, '', 'N', 'N'),
(3200, '6811030009', 'DIS01', NULL, 51, 170858.54, 170858.54, '2025-11-03 11:08:55', NULL, NULL, NULL, NULL, 'STOCK1', '4009', '20251103', 'Y', NULL, 'T', NULL, NULL, 'MED', NULL, '20251103', '1108', NULL, NULL, '', 'N', 'N');

-- --------------------------------------------------------

--
-- Table structure for table `sm_po_c`
--

CREATE TABLE `sm_po_c` (
  `RECORD_NUMBER` int(11) NOT NULL,
  `SUB_PO_NO` char(12) DEFAULT NULL,
  `WORKING_CODE` char(7) DEFAULT NULL,
  `QTY_ORDER` double DEFAULT NULL,
  `QTY_RCV` double DEFAULT NULL,
  `PACK_RATIO` double DEFAULT NULL,
  `COST` double DEFAULT NULL,
  `VALUE` double DEFAULT NULL,
  `VENDOR_CODE` char(6) DEFAULT NULL,
  `MANUFAC_CODE` char(6) DEFAULT NULL,
  `QTY_RCV1` double DEFAULT NULL,
  `PACK_RATIO1` double DEFAULT NULL,
  `EXPIRED_DATE1` datetime DEFAULT NULL,
  `LOCATION1` char(5) DEFAULT NULL,
  `COST1` double DEFAULT NULL,
  `VALUE1` double DEFAULT NULL,
  `VENDOR_CODE2` char(6) DEFAULT NULL,
  `MANUFAC_CODE2` char(6) DEFAULT NULL,
  `QTY_RCV2` double DEFAULT NULL,
  `PACK_RATIO2` double DEFAULT NULL,
  `EXPIRED_DATE2` datetime DEFAULT NULL,
  `LOCATION2` char(5) DEFAULT NULL,
  `COST2` double DEFAULT NULL,
  `VALUE2` double DEFAULT NULL,
  `VENDOR_CODE3` char(6) DEFAULT NULL,
  `MANUFAC_CODE3` char(6) DEFAULT NULL,
  `QTY_RCV3` double DEFAULT NULL,
  `PACK_RATIO3` double DEFAULT NULL,
  `EXPIRED_DATE3` datetime DEFAULT NULL,
  `LOCATION3` char(5) DEFAULT NULL,
  `COST3` double DEFAULT NULL,
  `VALUE3` double DEFAULT NULL,
  `PROCESS` char(1) DEFAULT NULL,
  `SUB_PROCESS` char(1) DEFAULT NULL,
  `BAR_CODE` char(13) DEFAULT NULL,
  `TRADE_CODE` varchar(18) DEFAULT NULL,
  `EXPIRED_DATE` char(8) DEFAULT NULL,
  `LOCATION` char(5) DEFAULT NULL,
  `USER_ID` varchar(30) DEFAULT NULL,
  `CONFIRM_FLAG` varchar(1) DEFAULT NULL,
  `BUY_UNIT_COST` double DEFAULT NULL,
  `LOT_NO` varchar(40) DEFAULT NULL,
  `USER_CFM` varchar(30) DEFAULT NULL,
  `CANCEL_DISP` varchar(30) DEFAULT NULL,
  `SUB_FLAG` int(11) DEFAULT NULL,
  `PACK_COST` double DEFAULT NULL,
  `REQ_DATE` varchar(8) DEFAULT NULL,
  `CONFIRM_DATE` varchar(8) DEFAULT NULL,
  `PACK_CODE` int(11) DEFAULT NULL,
  `NLEM` smallint(6) DEFAULT NULL,
  `MOD_SYS` varchar(10) DEFAULT NULL,
  `REMARK` varchar(100) DEFAULT NULL,
  `APP_VERSION` varchar(8) DEFAULT NULL,
  `CLIENT_IP` varchar(15) DEFAULT NULL,
  `SEND_CANCEL` varchar(1) DEFAULT NULL,
  `QTY_CFM` varchar(1) DEFAULT NULL,
  `LAST_UPD` datetime DEFAULT NULL,
  `REV_DATE` datetime DEFAULT NULL,
  `WA_COST` decimal(10,0) DEFAULT NULL,
  `DISP_RECNO` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sm_po_c`
--

INSERT INTO `sm_po_c` (`RECORD_NUMBER`, `SUB_PO_NO`, `WORKING_CODE`, `QTY_ORDER`, `QTY_RCV`, `PACK_RATIO`, `COST`, `VALUE`, `VENDOR_CODE`, `MANUFAC_CODE`, `QTY_RCV1`, `PACK_RATIO1`, `EXPIRED_DATE1`, `LOCATION1`, `COST1`, `VALUE1`, `VENDOR_CODE2`, `MANUFAC_CODE2`, `QTY_RCV2`, `PACK_RATIO2`, `EXPIRED_DATE2`, `LOCATION2`, `COST2`, `VALUE2`, `VENDOR_CODE3`, `MANUFAC_CODE3`, `QTY_RCV3`, `PACK_RATIO3`, `EXPIRED_DATE3`, `LOCATION3`, `COST3`, `VALUE3`, `PROCESS`, `SUB_PROCESS`, `BAR_CODE`, `TRADE_CODE`, `EXPIRED_DATE`, `LOCATION`, `USER_ID`, `CONFIRM_FLAG`, `BUY_UNIT_COST`, `LOT_NO`, `USER_CFM`, `CANCEL_DISP`, `SUB_FLAG`, `PACK_COST`, `REQ_DATE`, `CONFIRM_DATE`, `PACK_CODE`, `NLEM`, `MOD_SYS`, `REMARK`, `APP_VERSION`, `CLIENT_IP`, `SEND_CANCEL`, `QTY_CFM`, `LAST_UPD`, `REV_DATE`, `WA_COST`, `DISP_RECNO`) VALUES
(1, '6810290001', '8512', 50, 50, 1, 375, 375, '1293', '1293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8520', '20280620', '', '4009', 'Y', 7.5, '466867', '4009', NULL, NULL, 7.5, '20251029', '20251029', 12236, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-10-29 09:02:37', NULL, 375, NULL),
(2, '6811030001', '7603', 73, 73, 1, 547.5, 547.5, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7619', '20271201', '', '4009', 'Y', 7.5, '83BCB', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:46:27', NULL, 548, NULL),
(3, '6811030001', '8698', 31, 31, 1, 248, 248, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:46:27', NULL, 248, NULL),
(4, '6811030001', '5838', 4, 4, 1, 64, 64, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5840', '20271121', '', '4009', 'Y', 16, 'AYJ001', '4009', NULL, NULL, 16, '20251103', '20251103', 12800, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:46:27', NULL, 64, NULL),
(5, '6811030002', '7603', 112, 112, 1, 840, 840, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7619', '20271201', '', '4009', 'Y', 7.5, '83BCB', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:49:48', NULL, 840, NULL),
(6, '6811030002', '8698', 2, 2, 1, 16, 16, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:49:48', NULL, 16, NULL),
(7, '6811030003', '7603', 96, 96, 1, 720, 720, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7619', '20271201', '', '4009', 'Y', 7.5, '83BCB', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:50:37', NULL, 720, NULL),
(8, '6811030003', '8698', 8, 8, 1, 64, 64, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:50:37', NULL, 64, NULL),
(9, '6811030004', '7603', 5, 5, 1, 37.5, 37.5, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7619', '20271201', '', '4009', 'Y', 7.5, '83BCB', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:51:38', NULL, 38, NULL),
(10, '6811030004', '8698', 12, 12, 1, 96, 96, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:51:38', NULL, 96, NULL),
(11, '6811030005', '8698', 1, 1, 1, 8, 8, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:52:52', NULL, 8, NULL),
(12, '6811030006', '8698', 2, 2, 1, 16, 16, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8701', '20270714', '', '4009', 'Y', 8, '83BBE', '4009', NULL, NULL, 8, '20251103', '20251103', 12863, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:53:20', NULL, 16, NULL),
(13, '6811030007', '7603', 1, 1, 1, 7.5, 7.5, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7619', '20271201', '', '4009', 'Y', 7.5, '83BCB', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:54:53', NULL, 7, NULL),
(14, '6811030007', '5838', 62, 62, 1, 992, 992, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5840', '20271121', '', '4009', 'Y', 16, 'AYJ001', '4009', NULL, NULL, 16, '20251103', '20251103', 12800, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:54:53', NULL, 992, NULL),
(15, '6811030007', '7309', 35, 35, 1, 525, 525, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7321', '20261219', '', '4009', 'Y', 15, 'BAI018', '4009', NULL, NULL, 15, '20251103', '20251103', 12816, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:54:53', NULL, 525, NULL),
(16, '6811030007', '5599', 14, 14, 1, 175, 175, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5608', '20280604', '', '4009', 'Y', 12.5, 'J680186', '4009', NULL, NULL, 12.5, '20251103', '20251103', 12790, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 09:54:53', NULL, 175, NULL),
(17, '6811030008', '5838', 56, 56, 1, 896, 896, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5840', '20271121', '', '4009', 'Y', 16, 'AYJ001', '4009', NULL, NULL, 16, '20251103', '20251103', 12800, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 10:07:33', NULL, 896, NULL),
(18, '6811030008', '7309', 80, 80, 1, 1200, 1200, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7321', '20261219', '', '4009', 'Y', 15, 'BAI018', '4009', NULL, NULL, 15, '20251103', '20251103', 12816, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 10:07:33', NULL, 1200, NULL),
(19, '6811030008', '7473', 130, 130, 1, 247, 247, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7487', '20270327', '', '4009', 'Y', 1.9, 'A670140', '4009', NULL, NULL, 1.9, '20251103', '20251103', 12844, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 10:07:33', NULL, 247, NULL),
(20, '6811030008', '7494', 166, 166, 1, 1937.22, 1937.22, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7500', '20261206', '', '4009', 'Y', 11.67, '266827', '4009', NULL, NULL, 11.67, '20251103', '20251103', 12828, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 10:07:33', NULL, 1937, NULL),
(21, '6811030008', '7516', 375, 375, 1, 8126.25, 8126.25, '1017', '1017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7585', '20271021', '', '4009', 'Y', 21.67, '269622', '4009', NULL, NULL, 21.67, '20251103', '20251103', 12837, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 10:07:33', NULL, 8126, NULL),
(22, '6811030009', '8717', 3000, 3000, 1000, 834.6, 834.6, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8729', '20271023', '', '4009', 'Y', 0.2782, 'F670668', '4009', NULL, NULL, 278.2, '20251103', '20251103', 12068, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 835, NULL),
(23, '6811030009', '2804', 30000, 30000, 1000, 4140, 4140, '1305', '1305', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2815', '20270501', '', '4009', 'Y', 0.138, '684264', '4009', NULL, NULL, 138, '20251103', '20251103', 2836, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 4140, NULL),
(24, '6811030009', '2014', 150, 150, 1, 900, 900, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022', '20270315', '', '4009', 'Y', 6, 'J680062', '4009', NULL, NULL, 6, '20251103', '20251103', 2046, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 900, NULL),
(25, '6811030009', '6697', 4000, 4000, 100, 2800, 2800, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6700', '20280210', '', '4009', 'Y', 0.7, 'F680351', '4009', NULL, NULL, 70, '20251103', '20251103', 6728, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 2800, NULL),
(26, '6811030009', '4372', 4000, 4000, 1000, 984.4, 984.4, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4408', '20271108', '', '4009', 'Y', 0.2461, 'T670270', '4009', NULL, NULL, 246.1, '20251103', '20251103', 12006, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 984, NULL),
(27, '6811030009', '8890', 1000, 1000, 500, 933.04, 933.04, '443', '443', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8900', '20280128', '', '4009', 'Y', 0.93304, '2556005', '4009', NULL, NULL, 466.52, '20251103', '20251103', 12145, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:54', NULL, 933, NULL),
(28, '6811030009', '8985', 5000, 5000, 500, 1600, 1600, '1362', '1362', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8992', '20280521', '', '4009', 'Y', 0.32, '1FE0631', '4009', NULL, NULL, 160, '20251103', '20251103', 12204, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1600, NULL),
(29, '6811030009', '9404', 20000, 20000, 1000, 1300, 1300, '1091', '1091', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9415', '20290105', '', '4009', 'Y', 0.065, 'TS02D01', '4009', NULL, NULL, 65, '20251103', '20251103', 13142, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1300, NULL),
(30, '6811030009', '3442', 120, 120, 1, 1560, 1560, '1362', '1362', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3457', '20280106', '', '4009', 'Y', 13, '4FA0084', '4009', NULL, NULL, 13, '20251103', '20251103', 3474, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1560, NULL),
(31, '6811030009', '6123', 4260, 4260, 30, 8094, 8094, '617', '617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6134', '20270327', '', '4009', 'Y', 1.9, 'FN502', '4009', NULL, NULL, 57, '20251103', '20251103', 12109, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 8094, NULL),
(32, '6811030009', '6388', 4000, 4000, 1000, 1120, 1120, '819', '819', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6390', '20280606', '', '4009', 'Y', 0.28, '132632', '4009', NULL, NULL, 280, '20251103', '20251103', 6414, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1120, NULL),
(33, '6811030009', '9347', 60, 60, 1, 750, 750, '1293', '1293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9352', '20290421', '', '4009', 'Y', 12.5, '266806', '4009', NULL, NULL, 12.5, '20251103', '20251103', 13093, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 750, NULL),
(34, '6811030009', '9306', 50, 50, 1, 550, 550, '29', '29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9310', '20261123', '', '4009', 'Y', 11, 'S25191', '4009', NULL, NULL, 11, '20251103', '20251103', 12340, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 550, NULL),
(35, '6811030009', '4735', 5, 5, 1, 175.5, 175.5, '1072', '1072', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4742', '20260930', '', '4009', 'Y', 35.1, 'F0025', '4009', NULL, NULL, 35.1, '20251103', '20251103', 12408, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 176, NULL),
(36, '6811030009', '2955', 100, 100, 1, 5885, 5885, '82', '82', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2964', '20280604', '', '4009', 'Y', 58.85, '83CAA', '4009', NULL, NULL, 58.85, '20251103', '20251103', 12338, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 5885, NULL),
(37, '6811030009', '8239', 40, 40, 1, 400, 400, '617', '617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8256', '20280205', '', '4009', 'Y', 10, 'OD2502', '4009', NULL, NULL, 10, '20251103', '20251103', 12113, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 400, NULL),
(38, '6811030009', '3909', 300, 300, 100, 1251, 1251, '617', '617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3921', '20270418', '', '4009', 'Y', 4.17, 'DL507', '4009', NULL, NULL, 417, '20251103', '20251103', 3945, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1251, NULL),
(39, '6811030009', '7275', 20000, 20000, 1000, 10914, 10914, '443', '443', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7281', '20270322', '', '4009', 'Y', 0.5457, 'OH053A', '4009', NULL, NULL, 545.7, '20251103', '20251103', 7309, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 10914, NULL),
(43, '6811030009', '8370', 300, 0, 1, 0, 0, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8389', '20251103', '', '4009', 'Y', 0, '-', '4009', NULL, NULL, 0, '20251103', '20251103', 0, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 0, NULL),
(44, '6811030009', '9848', 5000, 5000, 500, 1391, 1391, '1206', '1206', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9853', '20270711', '', '4009', 'Y', 0.2782, '149660', '4009', NULL, NULL, 139.1, '20251103', '20251103', 9876, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1391, NULL),
(45, '6811030009', '5180', 10000, 10000, 1000, 1500, 1500, '250', '250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5198', '20290624', '', '4009', 'Y', 0.15, 'F39347', '4009', NULL, NULL, 150, '20251103', '20251103', 5216, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1500, NULL),
(46, '6811030009', '7949', 4000, 4000, 100, 2720, 2720, '768', '768', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7954', '20290515', '', '4009', 'Y', 0.68, '99BK', '4009', NULL, NULL, 68, '20251103', '20251103', 12669, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 2720, NULL),
(47, '6811030009', '7384', 100, 100, 1, 7200, 7200, '836', '836', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7397', '20280131', '', '4009', 'Y', 72, 'T0B140225', '4009', NULL, NULL, 72, '20251103', '20251103', 12925, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 7200, NULL),
(48, '6811030009', '9998', 100, 100, 1, 1200, 1200, '1293', '1293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '10003', '20290327', '', '4009', 'Y', 12, '46821', '4009', NULL, NULL, 12, '20251103', '20251103', 12258, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1200, NULL),
(49, '6811030009', '4973', 400, 400, 1, 7600, 7600, '1321', '1321', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4987', '20280719', '', '4009', 'Y', 19, '568189', '4009', NULL, NULL, 19, '20251103', '20251103', 5007, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 7600, NULL),
(50, '6811030009', '4816', 500, 500, 100, 415, 415, '768', '768', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4828', '20270722', '', '4009', 'Y', 0.83, '365BD', '4009', NULL, NULL, 83, '20251103', '20251103', 4859, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 415, NULL),
(51, '6811030009', '8512', 200, 200, 1, 1500, 1500, '1293', '1293', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8520', '20280620', '', '4009', 'Y', 7.5, '466867', '4009', NULL, NULL, 7.5, '20251103', '20251103', 12236, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1500, NULL),
(52, '6811030009', '9811', 10000, 10000, 1000, 3100, 3100, '250', '250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '11769', '20290519', '', '4009', 'Y', 0.31, 'E39247', '4009', NULL, NULL, 310, '20251103', '20251103', 11949, 2, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 3100, NULL),
(53, '6811030009', '7822', 100, 100, 1, 1150, 1150, '1158', '1158', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7846', '20270804', '', '4009', 'Y', 11.5, '508016', '4009', NULL, NULL, 11.5, '20251103', '20251103', 12611, 2, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1150, NULL),
(54, '6811030009', '2183', 100, 100, 1, 1300, 1300, '81', '81', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2196', '20280109', '', '4009', 'Y', 13, 'B251008', '4009', NULL, NULL, 13, '20251103', '20251103', 2219, 2, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1300, NULL),
(55, '6811030009', '7425', 5000, 5000, 100, 13132, 13132, '1111', '1111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7439', '20270326', '', '4009', 'Y', 2.6264, '2KZ2505', '4009', NULL, NULL, 262.64, '20251103', '20251103', 12994, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 13132, NULL),
(56, '6811030009', '2634', 48, 48, 1, 16320, 16320, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2647', '20261119', '', '4009', 'Y', 340, 'C22M', '4009', NULL, NULL, 340, '20251103', '20251103', 2668, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 16320, NULL),
(57, '6811030009', '4340', 100, 100, 1, 521, 521, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4355', '20270523', '', '4009', 'Y', 5.21, 'J670201', '4009', NULL, NULL, 5.21, '20251103', '20251103', 11996, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 521, NULL),
(58, '6811030009', '9208', 5000, 5000, 500, 13300, 13300, '1349', '1349', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9212', '20300708', '', '4009', 'Y', 2.66, 'D25234', '4009', NULL, NULL, 1330, '20251103', '20251103', 13072, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 13300, NULL),
(59, '6811030009', '8391', 120, 120, 10, 1800, 1800, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8406', '20280909', '', '4009', 'Y', 15, 'K675318', '4009', NULL, NULL, 150, '20251103', '20251103', 12052, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1800, NULL),
(60, '6811030009', '4669', 10000, 10000, 1000, 6850, 6850, '250', '250', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4682', '20280510', '', '4009', 'Y', 0.685, 'E39133', '4009', NULL, NULL, 685, '20251103', '20251103', 4703, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 6850, NULL),
(61, '6811030009', '8755', 6000, 6000, 500, 2940, 2940, '197', '197', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8764', '20270806', '', '4009', 'Y', 0.49, '682013', '4009', NULL, NULL, 245, '20251103', '20251103', 13040, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 2940, NULL),
(62, '6811030009', '4034', 1000, 1000, 100, 1650, 1650, '88', '88', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4047', '20270422', '', '4009', 'Y', 1.65, '8042026', '4009', NULL, NULL, 165, '20251103', '20251103', 4068, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1650, NULL),
(63, '6811030009', '9560', 9000, 9000, 100, 5364, 5364, '768', '768', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9573', '20280221', '', '4009', 'Y', 0.596, 'T2502015', '4009', NULL, NULL, 59.6, '20251103', '20251103', 12676, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 5364, NULL),
(64, '6811030009', '5665', 100, 100, 1, 749, 749, '30', '30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5677', '20280408', '', '4009', 'Y', 7.49, 'C680098', '4009', NULL, NULL, 7.49, '20251103', '20251103', 11954, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 749, NULL),
(65, '6811030009', '9876', 150, 150, 1, 675, 675, '268', '268', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9882', '20280530', '', '4009', 'Y', 4.5, '425158', '4009', NULL, NULL, 4.5, '20251103', '20251103', 9905, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 675, NULL),
(66, '6811030009', '7350', 50, 50, 1, 450, 450, '24', '24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7366', '20290430', '', '4009', 'Y', 9, '253154', '4009', NULL, NULL, 9, '20251103', '20251103', 7384, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 450, NULL),
(67, '6811030009', '10192', 100, 100, 1, 3500, 3500, '1069', '1069', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '10205', '20280729', '', '4009', 'Y', 35, 'MLA062568', '4009', NULL, NULL, 35, '20251103', '20251103', 10222, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 3500, NULL),
(68, '6811030009', '4800', 100, 100, 1, 400, 400, '180', '180', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4837', '20280808', '', '4009', 'Y', 4, '0925ID2', '4009', NULL, NULL, 4, '20251103', '20251103', 12431, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 400, NULL),
(69, '6811030009', '5216', 200, 200, 10, 1200, 1200, '103', '103', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5228', '20280807', '', '4009', 'Y', 6, 'E5H118', '4009', NULL, NULL, 60, '20251103', '20251103', 12742, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 1200, NULL),
(70, '6811030009', '2836', 12000, 12000, 30, 14160, 14160, '617', '617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2843', '20280705', '', '4009', 'Y', 1.18, 'VS525', '4009', NULL, NULL, 35.4, '20251103', '20251103', 2862, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 14160, NULL),
(71, '6811030009', '8336', 2, 2, 1, 700, 700, '88', '88', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8343', '20280421', '', '4009', 'Y', 350, '8715024', '4009', NULL, NULL, 350, '20251103', '20251103', 8362, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 700, NULL),
(72, '6811030009', '5237', 9000, 9000, 100, 2700, 2700, '617', '617', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5244', '20290514', '', '4009', 'Y', 0.3, 'CA503', '4009', NULL, NULL, 30, '20251103', '20251103', 12099, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 2700, NULL),
(73, '6811030009', '3593', 100, 100, 1, 5885, 5885, '1043', '1043', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8549', '20270121', '', '4009', 'Y', 58.85, '70172', '4009', NULL, NULL, 58.85, '20251103', '20251103', 8565, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 5885, NULL),
(74, '6811030009', '9265', 150, 150, 1, 4800, 4800, '1227', '1227', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9277', '20270609', '', '4009', 'Y', 32, '70725', '4009', NULL, NULL, 32, '20251103', '20251103', 13086, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 4800, NULL),
(75, '6811030009', '8084', 300, 300, 100, 495, 495, '1176', '1176', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8097', '20271130', '', '4009', 'Y', 1.65, 'E10924011', '4009', NULL, NULL, 165, '20251103', '20251103', 12514, 1, 'MED', NULL, '1.747', '172.16.1.77', NULL, NULL, '2025-11-03 11:08:55', NULL, 495, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sm_po_e`
--

CREATE TABLE `sm_po_e` (
  `RECORD_NUMBER` int(11) NOT NULL,
  `SUB_PO_NO` char(12) DEFAULT NULL,
  `WORKING_CODE` char(7) DEFAULT NULL,
  `QTY_DIST` double DEFAULT NULL,
  `QTY_DIST_E` double DEFAULT NULL,
  `PACK_RATIO` double DEFAULT NULL,
  `COST` double DEFAULT NULL,
  `TRADE_CODE` varchar(18) DEFAULT NULL,
  `EXPIRED_DATE` char(8) DEFAULT NULL,
  `LOCATION` char(5) DEFAULT NULL,
  `USER_ID` varchar(30) DEFAULT NULL,
  `COMPLETE_FLAG` varchar(1) DEFAULT NULL,
  `LOT_NO` varchar(40) DEFAULT NULL,
  `CANCEL_DIST` char(1) DEFAULT NULL,
  `INV_NO` varchar(25) DEFAULT NULL,
  `INV_REMAIN_QTY` double DEFAULT NULL,
  `RECEIVE_NO` varchar(10) DEFAULT NULL,
  `DEPT_ID` varchar(6) DEFAULT NULL,
  `DIST_DATE` varchar(8) DEFAULT NULL,
  `DIST_TIME` varchar(2) DEFAULT NULL,
  `MSIVOC_RECORD` int(11) DEFAULT NULL,
  `STOCK_ID` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sm_po_e`
--

INSERT INTO `sm_po_e` (`RECORD_NUMBER`, `SUB_PO_NO`, `WORKING_CODE`, `QTY_DIST`, `QTY_DIST_E`, `PACK_RATIO`, `COST`, `TRADE_CODE`, `EXPIRED_DATE`, `LOCATION`, `USER_ID`, `COMPLETE_FLAG`, `LOT_NO`, `CANCEL_DIST`, `INV_NO`, `INV_REMAIN_QTY`, `RECEIVE_NO`, `DEPT_ID`, `DIST_DATE`, `DIST_TIME`, `MSIVOC_RECORD`, `STOCK_ID`) VALUES
(1, NULL, '727267', 0, 1, 1, 0.55, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'LOT01X', 'N', 'INV001', 999, '6106090002', 'STO01', '20180609', '13', 55, 'TEST01'),
(2, '6106140018', '727267', 200, 200, 100, 110, '1O005A', '20201231', '', 'invs', 'Y', 'Lot2', 'N', 'INV0001', 49800, '6106120001', 'BAY01', '20180612', '14', 60, 'BAB01'),
(3, '6106140019', '727267', 500, 500, 100, 275, '1O005A', '20201231', '', 'invs', 'Y', 'Lot2', 'N', 'INV0001', 49300, '6106120001', 'BUL01', '20180612', '14', 60, 'BAB01'),
(4, '6106140020', '727267', 10000, 10000, 100, 5500, '1O005A', '20201231', '', 'invs', 'Y', 'Lot2', 'N', 'INV0001', 39300, '6106120001', 'KAS01', '20180612', '14', 60, 'BAB01'),
(5, NULL, '226047', 0, 50000, 1000, 5700, '1D022B', '20200612', 'D1', 'invs', 'N', 'DILOO01', 'N', 'XX01', 50000, '6106120002', 'KAS01', '20180612', '14', 61, 'BAB01'),
(6, NULL, '727267', 0, 22, 1, 12.1, '1O005A', '20180625', '', 'ratchata', 'N', 'Lot001', 'N', 'sdf', 9978, '6106250002', 'PAL01', '20180625', '22', 66, 'BAB01'),
(7, NULL, '727267', 0, 33, 1, 18.15, '1O005A', '20180625', 'A', 'ratchata', 'N', 'Lot001', 'N', '6106080003', 67, '6106250001', 'NOT01', '20180625', '22', 64, 'BAB01'),
(8, NULL, '727267', 0, 44, 1, 24.2, '1O005A', '20180625', 'A', 'ratchata', 'N', 'Lot001', 'Y', '6106080003', 23, '6106250001', 'NOP01', '20180625', '22', 64, 'BAB01'),
(9, NULL, '727267', 0, 23, 1, 12.65, '1O005A', '20180625', 'A', 'ratchata', 'N', 'Lot001', 'N', '6106080003', 0, '6106250001', 'NOP01', '20180625', '22', 64, 'BAB01'),
(10, NULL, '727267', 0, 1, 1, 0.55, '1O005A', '20180625', '', 'ratchata', 'N', 'Lot001', 'N', 'sdf', 9977, '6106250002', 'NNA01', '20180625', '22', 66, 'STO01'),
(11, NULL, '727267', 0, 2, 1, 1.1, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'LOT01X', 'N', 'INV001', 997, '6106090002', 'NNA01', '20180625', '22', 55, 'STO01'),
(12, NULL, '727267', 0, 3, 1, 1.65, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'Lot001', 'N', 'INV003', 97, '6106090003', 'NNA01', '20180625', '22', 56, 'STO01'),
(13, NULL, '727267', 0, 4, 1, 2.2, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'Lot001', 'Y', 'INV003', 93, '6106090003', 'NNA01', '20180625', '22', 56, 'STO01'),
(14, NULL, '727267', 0, 5, 1, 2.75, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'Lot001', 'N', 'INV003', 88, '6106090003', 'NNA01', '20180625', '22', 56, 'STO01'),
(15, NULL, '727267', 0, 1, 1, 0.55, '1O005A', '20180625', '', 'ratchata', 'N', 'Lot001', 'N', 'sdf', 9976, '6106250002', 'KAN01', '20180626', '00', 66, 'BAB01'),
(16, NULL, '727267', 0, 1, 1, 0.55, '1O005A', '20180609', 'Z0', 'ratchata', 'N', 'LOT01X', 'N', 'INV001', 996, '6106090002', 'SAW01', '20180626', '00', 55, 'TEST01');

-- --------------------------------------------------------

--
-- Table structure for table `special`
--

CREATE TABLE `special` (
  `SPECIAL_CODE` char(2) DEFAULT NULL,
  `SPECIAL_NAME` char(30) DEFAULT NULL,
  `AVG_RATE` double DEFAULT NULL,
  `MIN_LEVEL` double DEFAULT NULL,
  `MAX_LEVEL` double DEFAULT NULL,
  `REORDER_QTY` double DEFAULT NULL,
  `DEPT_ID` char(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `special`
--

INSERT INTO `special` (`SPECIAL_CODE`, `SPECIAL_NAME`, `AVG_RATE`, `MIN_LEVEL`, `MAX_LEVEL`, `REORDER_QTY`, `DEPT_ID`) VALUES
('01', 'ยาทั่วไป', 30, 15, 20, 15, NULL),
('T1', 'สูตรบ้านบัว', 30, 7, 45, 30, 'BAB01'),
('S1', 'สูตรสวายสอ', 30, 7, 45, 30, 'SAW01'),
(NULL, 'สูตรแก่นเจริญ', 7, 3, 2, 7, NULL),
('01', 'สูตรหนองตาด', 30, 7, 45, 30, 'NOT01'),
(NULL, 'สูตรแก่นเจริญ', NULL, NULL, NULL, NULL, NULL),
(NULL, 'สูตรแก่นเจริญ', NULL, NULL, NULL, NULL, NULL),
(NULL, 'รพ.สต.พะไล', 7, NULL, NULL, NULL, NULL),
('', '', NULL, NULL, NULL, NULL, 'KAN01'),
('', 'สูตรคำนวนยาพารา', 10, 5, 15, 10, 'NOP01'),
('', NULL, NULL, NULL, NULL, NULL, NULL),
('01', 'ใส่ชื่อสูตร', 90, 15, 45, 30, 'STO01'),
('', NULL, NULL, NULL, NULL, NULL, NULL),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('T1', 'สูตรสวายจีก', 7, 3, 7, 7, NULL),
('k1', 'โกรกขี้หนู', 30, 7, 45, 30, 'KRO01'),
(NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('', 'รพ.สต.พะไล', 30, 7, 45, 15, 'PAL01'),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('T2', 'สูตรบ้านบัว2', 90, 7, 45, 30, 'BAB01'),
('', '', NULL, NULL, NULL, NULL, 'DON01'),
('01', 'ปีกฝาย', 30, 7, 45, 30, 'PIK01'),
('', 'ใส่ชื่อสูตร', 90, 10, 1, 1, 'PLA01'),
(NULL, 'k1', 7, 7, 14, 7, NULL),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('', 'ใส่ชื่อสูตร', 7, 3, 7, 7, 'TAL01'),
(NULL, 'สูตรลุมปุ๊ก', 15, 5, 15, 10, NULL),
(NULL, NULL, 7, 3, 7, 7, NULL),
('T1', 'โคกตาล', 30, 7, 45, 30, 'KOT01'),
('K1', 'k1', 90, 45, 55, 60, 'KAS01'),
(NULL, 'บุลาว', 30, 30, 90, 30, NULL),
('', 'หัววัว1', 7, 3, 7, 7, 'HUA01'),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('1', 'buloa', 90, 15, 60, 30, 'BUL01'),
('', '', 60, 3, 1, 1, 'ROM01'),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('', 'ใส่ชื่อสูตร', 1, 1, 1, 1, 'PRA01'),
(NULL, '1', 7, 3, 7, 7, NULL),
('n1', 'สูตรหนองนา', 30, 7, 45, 30, 'NNA01'),
('2', 'ใส่ชื่อสูตร', 1, 1, 1, 1, 'BUL01'),
('T2', 'สวายจีก2', 90, 7, 45, 30, 'SWJ01'),
(NULL, 'สส', NULL, NULL, NULL, NULL, NULL),
('S2', 'สูตรสวายสอ2', 90, 7, 45, 30, 'SAW01'),
(NULL, '', NULL, NULL, NULL, NULL, NULL),
('01', 'ทดสอบ', 30, 3, 10, 7, 'KOK01'),
('T3', 'สวายจีก3', 180, 7, 45, 30, 'SWJ01'),
('k2', 'โกรก2', 90, 7, 45, 30, 'KRO01'),
('02', 'แก่น2', 30, 10, 15, 20, 'KAN01'),
('', NULL, NULL, NULL, NULL, NULL, NULL),
('', '', NULL, NULL, NULL, NULL, 'KAN01'),
('01', 'ยาทั่วไป', 30, 4, 10, 7, 'KKL01'),
('02', 'สูตรหนองตาด2', 90, 7, 45, 30, 'NOT01'),
('02', 'ปีกฝาย2', 90, 7, 45, 30, 'PIK01'),
('T2', 'โคกตาล2', 90, 7, 45, 30, 'KOT01'),
('T3', 'สูตรบ้านบัว3', 180, 7, 45, 30, 'BAB01'),
('', 'T1', 7, 5, 1, 1, 'BAY01'),
('T1', 'สวายจีก1', 30, 7, 45, 30, 'SWJ01'),
('T3', 'โคกตาล3', 180, 7, 45, 30, 'KOT01'),
('03', 'สูตรหนองตาด3', 180, 7, 45, 30, 'NOT01'),
('03', 'ปีกฝาย3', 180, 7, 45, 30, 'PIK01'),
('n2', 'สูตรหนองนา2', 90, 7, 45, 30, 'NNA01'),
('S3', 'สูตรสวายสอ3', 180, 7, 45, 30, 'SAW01'),
('n3', 'สูตรหนองนา3', 180, 7, 45, 30, 'NNA01'),
('01', 'ใส่ชื่อสูตร', 90, 3, 10, 7, 'SAK01'),
('02', 'ยาที่มีการใช้น้อย', 90, 4, 10, 7, 'KKL01');

-- --------------------------------------------------------

--
-- Table structure for table `sub_com`
--

CREATE TABLE `sub_com` (
  `SUB_COMMIT_CODE` int(11) NOT NULL,
  `SUB_COMMIT_DES` varchar(60) DEFAULT NULL,
  `HIDE` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `sub_com`
--

INSERT INTO `sub_com` (`SUB_COMMIT_CODE`, `SUB_COMMIT_DES`, `HIDE`) VALUES
(1, '', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tmt`
--

CREATE TABLE `tmt` (
  `TPUCode` varchar(255) DEFAULT NULL,
  `ActiveIngredient` varchar(255) DEFAULT NULL,
  `Strength` varchar(255) DEFAULT NULL,
  `dosageform` varchar(255) DEFAULT NULL,
  `contvalue` varchar(255) DEFAULT NULL,
  `contunit` varchar(255) DEFAULT NULL,
  `DispUnit` varchar(255) DEFAULT NULL,
  `TradeName` varchar(255) DEFAULT NULL,
  `Manufacturer` varchar(255) DEFAULT NULL,
  `FSN` varchar(255) DEFAULT NULL,
  `Status` varchar(255) DEFAULT NULL,
  `RegNo` varchar(30) DEFAULT NULL,
  `DC24` varchar(24) DEFAULT NULL,
  `TMTID` bigint(20) DEFAULT NULL,
  `TYPE_TMT` varchar(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `uom`
--

CREATE TABLE `uom` (
  `UOM_ID` int(11) NOT NULL,
  `UOM_NAME` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `uom`
--

INSERT INTO `uom` (`UOM_ID`, `UOM_NAME`) VALUES
(1, '%'),
(2, '% w/v'),
(3, '% w/w'),
(4, 'actuation'),
(5, 'ampoule'),
(6, 'anti-Xa unit'),
(7, 'AU'),
(8, 'bag'),
(9, 'bar'),
(10, 'BAU'),
(11, 'bead'),
(12, 'billion organisms'),
(13, 'bottle'),
(14, 'box'),
(15, 'bucket'),
(16, 'can'),
(17, 'canister'),
(18, 'capsule'),
(19, 'cartridge'),
(20, 'catridge'),
(21, 'ccid50'),
(22, 'cfu'),
(23, 'D antigen unit'),
(24, 'depot'),
(25, 'dose'),
(26, 'dropper bottle'),
(27, 'DU'),
(28, 'each'),
(29, 'elisa u'),
(30, 'g'),
(31, 'gallon'),
(32, 'gel'),
(33, 'gum'),
(34, 'hand held syringe'),
(35, 'hr'),
(36, 'implant'),
(37, 'inhalation'),
(38, 'inhaler'),
(39, 'iu'),
(40, 'jar'),
(41, 'kg'),
(42, 'L'),
(43, 'Lf'),
(44, 'lozenge'),
(45, 'LSU'),
(46, 'mcg'),
(47, 'mcL'),
(48, 'measure'),
(49, 'meg'),
(50, 'meq'),
(51, 'mg'),
(52, 'mL'),
(53, 'mmol'),
(54, 'MU'),
(55, 'OU'),
(56, 'pack'),
(57, 'pad'),
(58, 'patch'),
(59, 'pen'),
(60, 'pfu'),
(61, 'piece'),
(62, 'power injector syringe'),
(63, 'prefilled syr'),
(64, 'sachet'),
(65, 'set'),
(66, 'sheet'),
(67, 'sq.cm.'),
(68, 'stick'),
(69, 'suppo'),
(70, 'suppository'),
(71, 'syringe'),
(72, 'tablet'),
(73, 'tablets'),
(74, 'tcid50'),
(75, 'tube'),
(76, 'tuberculin unit'),
(77, 'u'),
(78, 'unit'),
(79, 'unit dose'),
(80, 'v'),
(81, 'vaccinating dose'),
(82, 'vial'),
(83, 'w'),
(84, 'wafer'),
(85, 'ตลับ');

-- --------------------------------------------------------

--
-- Table structure for table `usercon`
--

CREATE TABLE `usercon` (
  `UserCode` char(16) DEFAULT NULL,
  `module` char(8) DEFAULT NULL,
  `menu` char(50) DEFAULT NULL,
  `Note` char(50) DEFAULT NULL,
  `Systype` char(2) DEFAULT NULL,
  `utype` char(1) DEFAULT NULL,
  `report_flag_only` char(1) DEFAULT NULL,
  `MenuDesc` char(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `usercon`
--

INSERT INTO `usercon` (`UserCode`, `module`, `menu`, `Note`, `Systype`, `utype`, `report_flag_only`, `MenuDesc`) VALUES
('invs', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('invs', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('ratchata', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
(NULL, 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('9007', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('11005', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuSumInv', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'menuCancelPO', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'canSetMinMAX', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'ChangeSTC', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'CheckMapHIS', NULL, NULL, NULL, NULL, NULL),
('9013', 'INVS', 'PrintOrder', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'CheckMapHIS', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'ChangeSTC', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'canSetMinMAX', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuCancelPO', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSumInv', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'PrintOrder', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('4002', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'CheckMapHIS', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'ChangeSTC', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'canSetMinMAX', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuCancelPO', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSumInv', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'PrintOrder', NULL, NULL, NULL, NULL, NULL),
('4009', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system0', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuRtnReas', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDisType', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuAddInPrograms', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSiteList', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'CanSetModSys', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetHospInfo', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetURL', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuChgPass', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuRtnAct', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDesignForm', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'CheckMapHIS', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'ChangeSTC', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'canSetMinMAX', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuCancelPO', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDesignFR', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSumInv', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'setUserSock', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuEditPO', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'AppBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'CanEditCard', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'CanAdjOnhand', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system1', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'PrintOrder', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuGFMIS', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'canSetEPO', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuOrder', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuBuyPlan', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuContract', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system2', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuPreRCV', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuInvReturn', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDispSub', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuConfirm', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuReqList', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuViewINV', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuReq', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuTransFer', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDistX', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuStockCard', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuReceive', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system4', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetUser', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuHolDate', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuBuyCom', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSupplier', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuBuyMethod', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetComp', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetDept', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetUnit', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuImportTMT', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDrugCat', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDosageForm', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuBeginDatabase', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuSetBudget', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system5', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuScan', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDocType', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuConDBScan', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuDocFlow', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system6', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuReport', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menu_system7', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuExportDMSIC', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuImForm', NULL, NULL, NULL, NULL, NULL),
('9019', 'INVS', 'menuExForm', NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `userimport`
--

CREATE TABLE `userimport` (
  `user` varchar(50) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accr_disp`
--
ALTER TABLE `accr_disp`
  ADD PRIMARY KEY (`REQ_NO`,`WORKING_CODE`);

--
-- Indexes for table `add_in_programs`
--
ALTER TABLE `add_in_programs`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `adj_reason`
--
ALTER TABLE `adj_reason`
  ADD KEY `adj_reason0` (`AR_ID`);

--
-- Indexes for table `aic`
--
ALTER TABLE `aic`
  ADD PRIMARY KEY (`RECORD_NUMBER`,`REF_NO`,`AIC_CODE`);

--
-- Indexes for table `aic_name`
--
ALTER TABLE `aic_name`
  ADD PRIMARY KEY (`AIC_CODE`),
  ADD KEY `aic_name` (`AIC_NAME`);

--
-- Indexes for table `area`
--
ALTER TABLE `area`
  ADD PRIMARY KEY (`areaCode`) USING BTREE;

--
-- Indexes for table `bdg_amt`
--
ALTER TABLE `bdg_amt`
  ADD KEY `bdg_amt0` (`BUDGET_TYPE`,`FISCAL_YEAR`,`MOD_SYS`);

--
-- Indexes for table `bdg_type`
--
ALTER TABLE `bdg_type`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`);

--
-- Indexes for table `bill_status`
--
ALTER TABLE `bill_status`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `buycommon`
--
ALTER TABLE `buycommon`
  ADD PRIMARY KEY (`COMMON_CODE`);

--
-- Indexes for table `buymethod`
--
ALTER TABLE `buymethod`
  ADD PRIMARY KEY (`BUYMET_CODE`);

--
-- Indexes for table `buyplan_c`
--
ALTER TABLE `buyplan_c`
  ADD KEY `buyplan_c1` (`YEAR`,`WORKING_CODE`,`MOD_SYS`);

--
-- Indexes for table `buyplan_log`
--
ALTER TABLE `buyplan_log`
  ADD KEY `buyplan_log0` (`YEAR`,`WORKING_CODE`,`MOD_SYS`);

--
-- Indexes for table `buy_re_m`
--
ALTER TABLE `buy_re_m`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`);

--
-- Indexes for table `buy_re_y`
--
ALTER TABLE `buy_re_y`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`);

--
-- Indexes for table `card`
--
ALTER TABLE `card`
  ADD UNIQUE KEY `CARD0` (`RECORD_NUMBER`),
  ADD KEY `card1` (`WORKING_CODE`,`OPERATE_DATE`),
  ADD KEY `card2` (`WORKING_CODE`,`OPERATE_DATE`,`R_S_STATUS`,`DEPT_ID`,`STOCK_ID`),
  ADD KEY `card3` (`R_S_NUMBER`,`R_S_STATUS`,`TRADE_CODE`,`LOT_NO`),
  ADD KEY `card4` (`R_S_STATUS`,`R_S_NUMBER`,`TRADE_CODE`),
  ADD KEY `card5` (`R_S_NUMBER`),
  ADD KEY `card6` (`R_S_STATUS`);

--
-- Indexes for table `cnt_c`
--
ALTER TABLE `cnt_c`
  ADD PRIMARY KEY (`RECORD_NUMBER`,`CNT_NO`);

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`COMPANY_CODE`);

--
-- Indexes for table `concept`
--
ALTER TABLE `concept`
  ADD UNIQUE KEY `concept0` (`TMTID`);

--
-- Indexes for table `dept_id`
--
ALTER TABLE `dept_id`
  ADD PRIMARY KEY (`RECORD_NUMBER`,`DEPT_ID`),
  ADD UNIQUE KEY `dept_id` (`DEPT_ID`);

--
-- Indexes for table `dept_map`
--
ALTER TABLE `dept_map`
  ADD KEY `dept_map0` (`INVS_DEPT`,`HIS_DEPT`);

--
-- Indexes for table `df_con`
--
ALTER TABLE `df_con`
  ADD PRIMARY KEY (`REF_NO_CON`);

--
-- Indexes for table `dispensed`
--
ALTER TABLE `dispensed`
  ADD PRIMARY KEY (`RECORD_NUMBER`),
  ADD KEY `dispensed0` (`DISP_DATE`,`MED_CODE`,`DISP_DEPT`),
  ADD KEY `dispensed1` (`DISP_DATE`,`MED_CODE`,`DISP_DEPT`,`PROCESS_FLAG`);

--
-- Indexes for table `dist_type`
--
ALTER TABLE `dist_type`
  ADD PRIMARY KEY (`DIST_TYPE_CODE`);

--
-- Indexes for table `doc_flow`
--
ALTER TABLE `doc_flow`
  ADD PRIMARY KEY (`REF_NO`);

--
-- Indexes for table `doc_flow_c`
--
ALTER TABLE `doc_flow_c`
  ADD PRIMARY KEY (`REF_NO`,`INVOICE_NO`);

--
-- Indexes for table `doc_type`
--
ALTER TABLE `doc_type`
  ADD KEY `doc_type0` (`DOC_CODE`);

--
-- Indexes for table `dosage_form`
--
ALTER TABLE `dosage_form`
  ADD PRIMARY KEY (`DFORM_ID`);

--
-- Indexes for table `drug_compos`
--
ALTER TABLE `drug_compos`
  ADD PRIMARY KEY (`COMPOS_CODE`),
  ADD KEY `drug_compos0` (`WORKING_CODE`),
  ADD KEY `drug_compos1` (`TMTID`);

--
-- Indexes for table `drug_gn`
--
ALTER TABLE `drug_gn`
  ADD UNIQUE KEY `drug_gn0` (`WORKING_CODE`) USING BTREE,
  ADD KEY `drug_gn1` (`DRUG_NAME`);

--
-- Indexes for table `drug_gn_681009`
--
ALTER TABLE `drug_gn_681009`
  ADD UNIQUE KEY `drug_gn0` (`WORKING_CODE`) USING BTREE,
  ADD KEY `drug_gn1` (`DRUG_NAME`);

--
-- Indexes for table `drug_spec`
--
ALTER TABLE `drug_spec`
  ADD KEY `drug_spec0` (`WORKING_CODE`);

--
-- Indexes for table `drug_vn`
--
ALTER TABLE `drug_vn`
  ADD PRIMARY KEY (`TRADE_CODE`),
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `drug_vn0` (`TRADE_CODE`),
  ADD KEY `drug_vn1` (`TRADE_NAME`),
  ADD KEY `drug_vn2` (`WORKING_CODE`);

--
-- Indexes for table `edi_drug_vn`
--
ALTER TABLE `edi_drug_vn`
  ADD PRIMARY KEY (`VENDOR_TRADE_CODE`,`INVS_TRADE_CODE`,`VENDOR_CODE`);

--
-- Indexes for table `ed_group`
--
ALTER TABLE `ed_group`
  ADD PRIMARY KEY (`CODE`),
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `ED_GROUP1` (`CODE`);

--
-- Indexes for table `exchange_info`
--
ALTER TABLE `exchange_info`
  ADD PRIMARY KEY (`exchange_code`);

--
-- Indexes for table `e_po`
--
ALTER TABLE `e_po`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `e_po0` (`DEPT_ID`);

--
-- Indexes for table `focus_list`
--
ALTER TABLE `focus_list`
  ADD KEY `focus_list0` (`LIST_CODE`,`USER_ID`);

--
-- Indexes for table `focus_list_c`
--
ALTER TABLE `focus_list_c`
  ADD KEY `focus_list_c0` (`LIST_CODE`,`WORKING_CODE`);

--
-- Indexes for table `form`
--
ALTER TABLE `form`
  ADD KEY `form1` (`FORM_CODE`,`FORM_SYS`);

--
-- Indexes for table `gf`
--
ALTER TABLE `gf`
  ADD PRIMARY KEY (`GF_NO`,`RUNNO`);

--
-- Indexes for table `holiday`
--
ALTER TABLE `holiday`
  ADD PRIMARY KEY (`HOL_DATE`);

--
-- Indexes for table `hosp`
--
ALTER TABLE `hosp`
  ADD PRIMARY KEY (`HOSP_CODE`);

--
-- Indexes for table `hosp_list`
--
ALTER TABLE `hosp_list`
  ADD PRIMARY KEY (`HOSP_LIST_CODE`),
  ADD UNIQUE KEY `hosp_list0` (`HOSP_LIST_DESC`);

--
-- Indexes for table `id_con`
--
ALTER TABLE `id_con`
  ADD KEY `index0` (`ID_CON`);

--
-- Indexes for table `inst_name`
--
ALTER TABLE `inst_name`
  ADD KEY `inst_name0` (`INST_NAME`,`REF_CODE`);

--
-- Indexes for table `inv_has_his`
--
ALTER TABLE `inv_has_his`
  ADD KEY `inv_has_his0` (`INV_CODE`,`HIS_CODE`);

--
-- Indexes for table `inv_md`
--
ALTER TABLE `inv_md`
  ADD PRIMARY KEY (`RECORD_NUMBER`),
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD UNIQUE KEY `inv_md_c1` (`WORKING_CODE`,`DEPT_ID`) USING BTREE;

--
-- Indexes for table `inv_md_c`
--
ALTER TABLE `inv_md_c`
  ADD PRIMARY KEY (`RECORD_NUMBER`),
  ADD KEY `inv_md_c0` (`EXPIRED_DATE`,`TRADE_CODE`,`DEPT_ID`,`LOT_NO`);

--
-- Indexes for table `inv_rtn`
--
ALTER TABLE `inv_rtn`
  ADD KEY `inv_return0` (`RETURN_NO`),
  ADD KEY `inv_return1` (`RETURN_NO`,`DEPT_ID`,`STOCK_ID`,`RETURN_DATE`);

--
-- Indexes for table `inv_rtn_c`
--
ALTER TABLE `inv_rtn_c`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `INV_RETURN_C0` (`RETURN_NO`,`WORKING_CODE`,`TRADE_CODE`);

--
-- Indexes for table `inv_site`
--
ALTER TABLE `inv_site`
  ADD PRIMARY KEY (`DEPT_ID`,`TRADE_CODE`),
  ADD KEY `inv_site0` (`TRADE_CODE`,`DEPT_ID`) USING BTREE;

--
-- Indexes for table `item_type`
--
ALTER TABLE `item_type`
  ADD PRIMARY KEY (`WORKING_CODE`,`HOSP_LIST`,`FIRST_DATE`,`LAST_DATE`);

--
-- Indexes for table `location`
--
ALTER TABLE `location`
  ADD KEY `location0` (`LOCATION_ID`,`TRADE_CODE`);

--
-- Indexes for table `mbs_re_m`
--
ALTER TABLE `mbs_re_m`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `mbs_re_m` (`TRADE_CODE`),
  ADD KEY `MBS_RE_M1` (`YEAR`,`MONTH`,`DEPT_ID`,`WORKING_CODE`,`TRADE_CODE`);

--
-- Indexes for table `mbs_re_y`
--
ALTER TABLE `mbs_re_y`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`);

--
-- Indexes for table `module_system`
--
ALTER TABLE `module_system`
  ADD PRIMARY KEY (`MODULE_ID`);

--
-- Indexes for table `ms_ivo`
--
ALTER TABLE `ms_ivo`
  ADD UNIQUE KEY `ms_ivo0` (`RECORD_NUMBER`),
  ADD KEY `ms_ivo1` (`RECEIVE_NO`);

--
-- Indexes for table `ms_ivo_c`
--
ALTER TABLE `ms_ivo_c`
  ADD KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `ms_ivo_c0` (`INVOICE_NO`,`DEPT_ID`,`RECEIVE_NO`),
  ADD KEY `ms_ivo_c1` (`RECEIVE_NO`,`TRADE_CODE`),
  ADD KEY `ms_ivo_c2` (`RECEIVE_NO`,`FREE_FLAG`,`TRADE_CODE`,`LOT_NO`);

--
-- Indexes for table `ms_po`
--
ALTER TABLE `ms_po`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `ms_po0` (`PO_NO`);

--
-- Indexes for table `ms_po_c`
--
ALTER TABLE `ms_po_c`
  ADD PRIMARY KEY (`RECORD_NUMBER`),
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD UNIQUE KEY `ms_po_c1` (`PO_NO`,`FREE_FLAG`,`WORKING_CODE`,`VENDOR_CODE`),
  ADD KEY `ms_po_c0` (`PO_NO`),
  ADD KEY `ms_po_c2` (`PO_NO`,`WORKING_CODE`);

--
-- Indexes for table `pack_ratio`
--
ALTER TABLE `pack_ratio`
  ADD PRIMARY KEY (`PACK_CODE`);

--
-- Indexes for table `po_reason`
--
ALTER TABLE `po_reason`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `prcv_con`
--
ALTER TABLE `prcv_con`
  ADD KEY `PRCV_CON0` (`PRCV_DATE`,`PRCV_CON`);

--
-- Indexes for table `pre_ms_ivo`
--
ALTER TABLE `pre_ms_ivo`
  ADD PRIMARY KEY (`PRE_RECEIVE_NO`),
  ADD KEY `PRE_MS_IVO0` (`PRE_RECEIVE_NO`);

--
-- Indexes for table `profile`
--
ALTER TABLE `profile`
  ADD PRIMARY KEY (`UserCode`);

--
-- Indexes for table `quali_goal`
--
ALTER TABLE `quali_goal`
  ADD PRIMARY KEY (`QUALI_ID`,`WORKING_CODE`);

--
-- Indexes for table `quali_item`
--
ALTER TABLE `quali_item`
  ADD PRIMARY KEY (`QUALI_ID`);

--
-- Indexes for table `quali_rcv`
--
ALTER TABLE `quali_rcv`
  ADD PRIMARY KEY (`RECEIVE_NO`,`WORKING_CODE`,`TRADE_CODE`,`LOT_NO`,`QUALI_ID`);

--
-- Indexes for table `relationship`
--
ALTER TABLE `relationship`
  ADD KEY `relationship0` (`CONCEPT1`),
  ADD KEY `relationship1` (`CONCEPT2`);

--
-- Indexes for table `reports`
--
ALTER TABLE `reports`
  ADD PRIMARY KEY (`ReportNo`);

--
-- Indexes for table `rtn_action`
--
ALTER TABLE `rtn_action`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `rtn_reason`
--
ALTER TABLE `rtn_reason`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `sale_unit`
--
ALTER TABLE `sale_unit`
  ADD PRIMARY KEY (`SU_ID`);

--
-- Indexes for table `scan`
--
ALTER TABLE `scan`
  ADD KEY `scan0` (`REF_NO`),
  ADD KEY `scan1` (`DOC_CODE`),
  ADD KEY `scan3` (`REF_NO`,`DOC_CODE`),
  ADD KEY `scan4` (`REF_NO`,`DOC_CODE`,`ID`);

--
-- Indexes for table `server_config`
--
ALTER TABLE `server_config`
  ADD UNIQUE KEY `server_config0` (`section`,`ident`) USING BTREE;

--
-- Indexes for table `sm_po`
--
ALTER TABLE `sm_po`
  ADD PRIMARY KEY (`RECORD_NUMBER`),
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `INDEX1` (`SUB_PO_NO`,`STOCK_ID`,`SUB_PO_DATE`),
  ADD KEY `sm_po2` (`SUB_PO_UNO`);

--
-- Indexes for table `sm_po_c`
--
ALTER TABLE `sm_po_c`
  ADD UNIQUE KEY `INDEX0` (`RECORD_NUMBER`),
  ADD KEY `SM_PO_C1` (`SUB_PO_NO`);

--
-- Indexes for table `sm_po_e`
--
ALTER TABLE `sm_po_e`
  ADD PRIMARY KEY (`RECORD_NUMBER`);

--
-- Indexes for table `sub_com`
--
ALTER TABLE `sub_com`
  ADD PRIMARY KEY (`SUB_COMMIT_CODE`),
  ADD KEY `SUB_COM0` (`SUB_COMMIT_CODE`);

--
-- Indexes for table `uom`
--
ALTER TABLE `uom`
  ADD KEY `uom0` (`UOM_ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `add_in_programs`
--
ALTER TABLE `add_in_programs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `aic`
--
ALTER TABLE `aic`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `aic_name`
--
ALTER TABLE `aic_name`
  MODIFY `AIC_CODE` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `card`
--
ALTER TABLE `card`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=429;

--
-- AUTO_INCREMENT for table `cnt_c`
--
ALTER TABLE `cnt_c`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `COMPANY_CODE` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1368;

--
-- AUTO_INCREMENT for table `dept_id`
--
ALTER TABLE `dept_id`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;

--
-- AUTO_INCREMENT for table `dispensed`
--
ALTER TABLE `dispensed`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=268554;

--
-- AUTO_INCREMENT for table `dosage_form`
--
ALTER TABLE `dosage_form`
  MODIFY `DFORM_ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `drug_vn`
--
ALTER TABLE `drug_vn`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1190;

--
-- AUTO_INCREMENT for table `e_po`
--
ALTER TABLE `e_po`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hosp_list`
--
ALTER TABLE `hosp_list`
  MODIFY `HOSP_LIST_CODE` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `inv_md`
--
ALTER TABLE `inv_md`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3078;

--
-- AUTO_INCREMENT for table `inv_md_c`
--
ALTER TABLE `inv_md_c`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=357;

--
-- AUTO_INCREMENT for table `ms_ivo`
--
ALTER TABLE `ms_ivo`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=106;

--
-- AUTO_INCREMENT for table `ms_ivo_c`
--
ALTER TABLE `ms_ivo_c`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=356;

--
-- AUTO_INCREMENT for table `ms_po`
--
ALTER TABLE `ms_po`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `ms_po_c`
--
ALTER TABLE `ms_po_c`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `sm_po`
--
ALTER TABLE `sm_po`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3201;

--
-- AUTO_INCREMENT for table `sm_po_c`
--
ALTER TABLE `sm_po_c`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `sm_po_e`
--
ALTER TABLE `sm_po_e`
  MODIFY `RECORD_NUMBER` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `sub_com`
--
ALTER TABLE `sub_com`
  MODIFY `SUB_COMMIT_CODE` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

