1
2
3
4
5
6
7
8
9
10
11
12
| -- 回滚脚本：销售台账 RB120260814001（污泥处置服务）删除前的原样数据
| -- 生成时间：2026-09-22 09:33:22 来源库：36.213.90.123:11101 / product-inventory-management-rbhb
| -- 恢复顺序：先 sales_ledger，再 sales_ledger_product，最后 production_plan
|
| -- 1. sales_ledger (id=95)
| INSERT INTO `sales_ledger` VALUES (95,'RB120260814001',NULL,'污泥处置服务','2026-08-14','李成芳',445,'克拉玛依市金宜永泰环保科技有限公司','卖油',NULL,NULL,NULL,NULL,NULL,NULL,'320',NULL,NULL,100,75471.00,'2025-05-16 00:00:00','银行转账','2026-08-14 16:00:00',320,100,75471.00);
|
| -- 2. sales_ledger_product (id=199)
| INSERT INTO `sales_ledger_product` VALUES (199,95,'污泥','据实','吨',1.00,NULL,6,75471.00,75471.00,71199.06,'增专票',1,NULL,429,'唐努尔','2026-09-18 15:47:56',NULL,0,1,320,100,1,NULL);
|
| -- 3. production_plan (id=144)
| INSERT INTO `production_plan` VALUES (144,95,199,'JH202608140001','2026-08-15 00:00:00.000000',NULL,'2026-09-17 17:54:25.654946','2026-09-17 17:54:25.655131',320,320,100,429,1.000000,0,'销售','2026-08-15 00:00:00.000000',NULL);
|
|
