# `viw_mftproductionplan_workorder`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sWorkOrderId` | `varchar(100)` | NO |
| 2 | `sSrcNo` | `varchar(255)` | NO |
| 3 | `sState` | `varchar(255)` | NO |
| 4 | `imorder` | `int` | YES |
| 5 | `sid` | `varchar(100)` | NO |
| 6 | `bFrozen` | `bit(1)` | NO |

## 定义

```sql
select `xlyweberp_saas_ai`.`mftproductionplan`.`sWorkOrderId` AS `sWorkOrderId`,`xlyweberp_saas_ai`.`mftproductionplan`.`sSrcNo` AS `sSrcNo`,`xlyweberp_saas_ai`.`mftproductionplan`.`sState` AS `sState`,min(`xlyweberp_saas_ai`.`mftproductionplan`.`iOrder`) AS `imorder`,`xlyweberp_saas_ai`.`mftproductionplan`.`sId` AS `sid`,`xlyweberp_saas_ai`.`mftproductionplan`.`bFrozen` AS `bFrozen` from `xlyweberp_saas_ai`.`mftproductionplan` where (`xlyweberp_saas_ai`.`mftproductionplan`.`sState` in (1,2,3,7)) group by `xlyweberp_saas_ai`.`mftproductionplan`.`sWorkOrderId`,`xlyweberp_saas_ai`.`mftproductionplan`.`sSrcNo`,`xlyweberp_saas_ai`.`mftproductionplan`.`sState`,`xlyweberp_saas_ai`.`mftproductionplan`.`iOrder` order by `xlyweberp_saas_ai`.`mftproductionplan`.`iOrder`
```

## 说明

_暂无人工说明。_
