wms / wms_xiaogangabu · Files

update-data-2026.06.sql 12.8 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 

INSERT INTO `wms_xiaogangabu`.`receipt_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`) VALUES (20, 'CS0001', 'BHF', 'TLD', '退料单', '', '2', '1', '2026-06-03 10:09:17', 'xcq', '2026-06-03 10:09:17', 'xcq', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`receipt_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`) VALUES (21, 'CS0001', 'BHF', 'JY', '检验入库单', '', '2', '1', '2026-06-05 13:38:32', 'MES', '2026-06-05 13:38:32', 'MES', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO `wms_xiaogangabu`.`receipt_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`) VALUES (22, 'CS0001', 'BHF', '1', '成品入库单', '', '2', '1', '2026-06-05 13:38:32', 'MES', '2026-06-05 14:19:48', 'MES', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO `wms_xiaogangabu`.`receipt_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`) VALUES (23, 'CS0001', 'BHF', '4', '销退入库单', '', '2', '1', '2026-06-05 13:38:32', 'MES', '2026-06-05 13:41:37', 'MES', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');
INSERT INTO `wms_xiaogangabu`.`receipt_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`) VALUES (24, 'CS0001', 'BHF', '5', '杂收单', '', '2', '1', '2026-06-05 13:38:32', 'MES', '2026-06-05 13:41:37', 'MES', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0');

INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (13, 'CS0001', 'BHF', '6', '杂发单', '', 'Standard ', '1', '2026-06-01 15:43:32', 'xcq', '2026-06-01 15:43:32', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (14, 'CS0001', 'BHF', '8', '采购仓退单', '', 'Standard ', '1', '2026-06-01 16:24:27', 'xcq', '2026-06-01 16:24:27', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (15, 'CS0001', 'BHF', '4', '调拨出库单', '', 'Standard ', '1', '2026-06-01 16:24:50', 'xcq', '2026-06-01 16:24:50', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (16, 'CS0001', 'BHF', '1', '产生出货单', '', 'Standard ', '1', '2026-06-01 16:44:35', 'xcq', '2026-06-01 16:44:35', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (17, 'CS0001', 'BHF', '3', '质检出库', '', 'Standard ', '1', '2026-06-02 11:33:01', 'xcq', '2026-06-02 11:33:01', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (18, 'CS0001', 'BHF', 'JL', '叫料单', '', 'Standard ', '1', '2026-06-02 15:29:32', 'xcq', '2026-06-02 15:29:32', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wms_xiaogangabu`.`shipment_type` (`id`, `warehouseCode`, `companyCode`, `code`, `name`, `referType`, `shipmentFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `processStamp`) VALUES (19, 'CS0001', 'BHF', 'KLD', '扣料单', '', 'Standard ', '1', '2026-06-03 10:09:04', 'xcq', '2026-06-03 10:09:04', 'xcq', 0, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `wms_xiaogangabu`.`location_type` (`id`, `code`, `warehouseCode`, `zoneCode`, `name`, `length`, `width`, `height`, `maxWeight`, `minQtyUm`, `checkDigit`, `maxMaterials`, `maxLots`, `maxContainers`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `processStamp`) VALUES (2, 'P', 'CS0001', 'EJK', '二级平库', 1.00, 1.00, 1.00, 1, '1', '', 1, 0, 0, b'1', '2026-06-03 10:14:00', 'xcq', '2026-06-05 14:36:56', 'xcq', NULL);
INSERT INTO `wms_xiaogangabu`.`location_type` (`id`, `code`, `warehouseCode`, `zoneCode`, `name`, `length`, `width`, `height`, `maxWeight`, `minQtyUm`, `checkDigit`, `maxMaterials`, `maxLots`, `maxContainers`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `processStamp`) VALUES (3, 'XBK', 'CS0001', 'XBK', '线边库', 1.00, 1.00, 1.00, 1, '1', '', 1, 0, 0, b'1', '2026-06-03 10:20:38', 'xcq', '2026-06-03 10:20:38', 'xcq', NULL);
INSERT INTO `wms_xiaogangabu`.`location_type` (`id`, `code`, `warehouseCode`, `zoneCode`, `name`, `length`, `width`, `height`, `maxWeight`, `minQtyUm`, `checkDigit`, `maxMaterials`, `maxLots`, `maxContainers`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `processStamp`) VALUES (4, 'D', 'CS0001', 'D', '材料平库', 1.00, 1.00, 1.00, 1, '1', '1', 1, 0, 0, b'1', '2026-06-05 14:29:37', 'zf', '2026-06-05 14:29:37', 'zf', NULL);
INSERT INTO `wms_xiaogangabu`.`location_type` (`id`, `code`, `warehouseCode`, `zoneCode`, `name`, `length`, `width`, `height`, `maxWeight`, `minQtyUm`, `checkDigit`, `maxMaterials`, `maxLots`, `maxContainers`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `processStamp`) VALUES (5, 'E', 'CS0001', 'E', '成品平库', 1.00, 1.00, 1.00, 1, '1', '1', 1, 0, 0, b'1', '2026-06-05 14:32:47', 'zf', '2026-06-05 14:32:47', 'zf', NULL);
INSERT INTO `wms_xiaogangabu`.`location_type` (`id`, `code`, `warehouseCode`, `zoneCode`, `name`, `length`, `width`, `height`, `maxWeight`, `minQtyUm`, `checkDigit`, `maxMaterials`, `maxLots`, `maxContainers`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `processStamp`) VALUES (6, 'F', 'CS0001', 'F', '不良品平库', 1.00, 1.00, 1.00, 1, '1', '1', 1, 1, 1, b'1', '2026-06-05 14:33:12', 'zf', '2026-06-05 14:33:12', 'zf', NULL);

INSERT INTO `wms_xiaogangabu`.`location` (`id`, `code`, `warehouseCode`, `zoneCode`, `locationType`, `containerCode`, `status`, `iRow`, `iColumn`, `iLayer`, `iGrid`, `high`, `rowFlag`, `nearLocationCode`, `roadway`, `area`, `materialAreaCode`, `name`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `systemCreated`, `deleted`) VALUES (3568, 'F01_01_01', 'CS0001', 'F', 'F', '', 'empty', 1, 1, 1, 1, 0, 0, NULL, '1', '1', NULL, NULL, NULL, '2026-06-05 14:34:36', 'zf', '2026-06-05 14:34:36', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, b'0');
INSERT INTO `wms_xiaogangabu`.`location` (`id`, `code`, `warehouseCode`, `zoneCode`, `locationType`, `containerCode`, `status`, `iRow`, `iColumn`, `iLayer`, `iGrid`, `high`, `rowFlag`, `nearLocationCode`, `roadway`, `area`, `materialAreaCode`, `name`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `systemCreated`, `deleted`) VALUES (3567, 'E01_01_01', 'CS0001', 'E', 'E', '', 'empty', 1, 1, 1, 1, 0, 0, NULL, '1', '5', NULL, NULL, NULL, '2026-06-05 14:33:38', 'zf', '2026-06-05 14:33:38', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, b'0');
INSERT INTO `wms_xiaogangabu`.`location` (`id`, `code`, `warehouseCode`, `zoneCode`, `locationType`, `containerCode`, `status`, `iRow`, `iColumn`, `iLayer`, `iGrid`, `high`, `rowFlag`, `nearLocationCode`, `roadway`, `area`, `materialAreaCode`, `name`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `systemCreated`, `deleted`) VALUES (3566, 'D01_01_01', 'CS0001', 'D', 'D', '', 'empty', 1, 1, 1, 1, 0, 0, NULL, '1', '4', NULL, NULL, NULL, '2026-06-05 14:30:18', 'zf', '2026-06-05 14:30:18', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, b'0');
INSERT INTO `wms_xiaogangabu`.`location` (`id`, `code`, `warehouseCode`, `zoneCode`, `locationType`, `containerCode`, `status`, `iRow`, `iColumn`, `iLayer`, `iGrid`, `high`, `rowFlag`, `nearLocationCode`, `roadway`, `area`, `materialAreaCode`, `name`, `lastCycleCountDate`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `systemCreated`, `deleted`) VALUES (3565, 'XBK01_01_01', 'CS0001', 'XBK', 'XBK', 'X00001', 'empty', 1, 1, 1, 1, 0, 0, NULL, '0', '3', NULL, NULL, NULL, '2026-06-03 10:21:11', 'xcq', '2026-06-03 10:34:04', 'xcq', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, b'0');

INSERT INTO `wms_xiaogangabu`.`zone` (`id`, `code`, `warehouseCode`, `companyCode`, `area`, `name`, `locationType`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`, `enable`) VALUES (3, 'EJK', 'CS0001', NULL, '2', '二级库', 'P', '2026-06-02 15:16:25', 'xcq', '2026-06-03 10:18:11', 'xcq', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true');
INSERT INTO `wms_xiaogangabu`.`zone` (`id`, `code`, `warehouseCode`, `companyCode`, `area`, `name`, `locationType`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`, `enable`) VALUES (4, 'XBK', 'CS0001', NULL, '3', '线边库', 'P', '2026-06-02 15:16:50', 'xcq', '2026-06-03 10:18:13', 'xcq', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true');
INSERT INTO `wms_xiaogangabu`.`zone` (`id`, `code`, `warehouseCode`, `companyCode`, `area`, `name`, `locationType`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`, `enable`) VALUES (5, 'D', 'CS0001', NULL, '4', '材料平库', '', '2026-06-05 14:24:31', 'zf', '2026-06-05 14:24:42', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true');
INSERT INTO `wms_xiaogangabu`.`zone` (`id`, `code`, `warehouseCode`, `companyCode`, `area`, `name`, `locationType`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`, `enable`) VALUES (6, 'E', 'CS0001', NULL, '5', '成品平库', '', '2026-06-05 14:25:00', 'zf', '2026-06-05 14:25:00', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true');
INSERT INTO `wms_xiaogangabu`.`zone` (`id`, `code`, `warehouseCode`, `companyCode`, `area`, `name`, `locationType`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `userDef1`, `userDef2`, `userDef3`, `userDef4`, `userDef5`, `userDef6`, `userDef7`, `userDef8`, `processStamp`, `enable`) VALUES (7, 'F', 'CS0001', NULL, '6', '不良品平库', '', '2026-06-05 14:25:23', 'zf', '2026-06-05 14:25:23', 'zf', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'true');