10 lines
2.8 KiB
SQL
10 lines
2.8 KiB
SQL
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('冷轧钢板','MAT-001','原材料','15吨','2024-06-05','2024-06-10','上海宝钢集团','4200元/吨','4800元/吨','10吨','用于结构件生产');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('P.O 42.5水泥','MAT-002','原材料','80吨','2024-06-10','2024-06-15','海螺水泥股份有限公司','380元/吨','450元/吨','50吨','建筑施工用');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('YJV22电缆','MAT-003','原材料','300米','2024-06-15','2024-06-20','远东电缆有限公司','280元/米','350元/米','200米','电力系统安装');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('塑壳断路器','MAT-004','零部件','8个','2024-06-20','2024-06-25','施耐德电气有限公司','3500元/个','4200元/个','5个','电气控制系统');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('C30混凝土','MAT-005','原材料','50立方米','2024-06-25','2024-06-30','中建商品混凝土有限公司','450元/立方米','520元/立方米','30立方米','需当天使用');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('集成材','MAT-006','原材料','10立方米','2024-07-02','2024-07-07','吉林森工集团','1800元/立方米','2200元/立方米','8立方米','家具制造用');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('镀锌钢管','MAT-007','原材料','80米','2024-07-07','2024-07-12','天津友发钢管集团','52元/米','65元/米','50米','管道安装');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('交流接触器','MAT-008','零部件','25个','2024-07-12','2024-07-17','正泰电气股份有限公司','260元/个','320元/个','15个','电气设备配件');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('800×800瓷砖','MAT-009','成品','200块','2024-07-17','2024-07-22','马可波罗瓷砖有限公司','85元/块','100元/块','100块','建筑装修用');
|
||
INSERT INTO `crpm_13465a_478b8a` (`spmc`,`spbm`,`splb`,`kcsl`,`rksj`,`cksj`,`gys`,`cgjg`,`xsjg`,`aqkcl`,`bzxx`) VALUES ('钢化玻璃','MAT-010','成品','60平方米','2024-07-22','2024-07-27','福耀玻璃工业集团','120元/平方米','150元/平方米','40平方米','门窗安装'); |