crpm-proj-code-set/gcjhypcxt/sql/data/crpm_289b0b_e819b9.sql
2025-06-30 15:17:54 +08:00

3 lines
1.4 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT INTO `crpm_289b0b_e819b9` (`gcmc`,`gcdz`,`scnl`,`sczt`,`ddfp`,`zylyl`,`kcsp`,`ysnl`,`fzr`,`ksyysj`) VALUES ('上海精密制造总厂','上海市浦东新区川沙路888号','精密加工(轴承/齿轮8,000件/日','满负荷运行产能利用率98%','主责订单ORD-20240701-001/002/005占比75%','设备98%/人力95%/仓储85%','成品库存1,200件安全库存1,000件','华东区域配送(当日达)','厂长陈建国工号CJG202001','2020-03-01');
INSERT INTO `crpm_289b0b_e819b9` (`gcmc`,`gcdz`,`scnl`,`sczt`,`ddfp`,`zylyl`,`kcsp`,`ysnl`,`fzr`,`ksyysj`) VALUES ('广州自动化装配分厂','广州市黄埔区开源大道188号','电机组装/线束加工300台/日','产能爬坡期利用率65%','协同订单ORD-20240705-002占比30%','设备65%/人力70%/仓储60%','半成品库存58台安全库存50台','华南区域配送+跨境出口T+3','厂长林婉如工号LWR202205','2022-06-15');
INSERT INTO `crpm_289b0b_e819b9` (`gcmc`,`gcdz`,`scnl`,`sczt`,`ddfp`,`zylyl`,`kcsp`,`ysnl`,`fzr`,`ksyysj`) VALUES ('成都备件仓储中心','成都市双流区物流大道666号','库存调拨(无生产能力)','库存周转中日均出库2,000件','承接全国备件订单占比15%','仓储90%/运输75%','通用件库存18,000件安全库存15,000件','西南区域次日达','主管王志强工号WZQ202108','2021-09-20');