# `viw_mftproductionplanslaveeleteam`（视图）


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

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sState` | `varchar(11)` | NO |
| 2 | `sWorkCenterId` | `varchar(100)` | NO |
| 3 | `sWorkCenteName` | `varchar(100)` | NO |
| 4 | `sProductId` | `varchar(100)` | NO |
| 5 | `sProductName` | `varchar(100)` | NO |
| 6 | `sProcessId` | `varchar(100)` | NO |
| 7 | `sProcessName` | `varchar(100)` | NO |
| 8 | `sMaterialsId` | `varchar(100)` | YES |
| 9 | `sMaterialsName` | `varchar(100)` | NO |
| 10 | `sCustomerId` | `varchar(100)` | NO |
| 11 | `sCustomerName` | `varchar(255)` | NO |
| 12 | `sOrderNo` | `varchar(255)` | NO |
| 13 | `sMachineId` | `varchar(100)` | NO |
| 14 | `sParentId` | `varchar(100)` | NO |
| 15 | `sTeamName` | `varchar(255)` | YES |
| 16 | `dHour` | `decimal(18,6)` | NO |
| 17 | `iIncrement` | `bigint` | NO |
| 18 | `iOrder` | `int` | NO |

## 定义

```sql
select `s`.`sState` AS `sState`,`s`.`sWorkCenterId` AS `sWorkCenterId`,`w`.`sName` AS `sWorkCenteName`,`s`.`sProductId` AS `sProductId`,`product`.`sProductName` AS `sProductName`,`s`.`sProcessId` AS `sProcessId`,`process`.`sProcessName` AS `sProcessName`,`s`.`sMaterialsId` AS `sMaterialsId`,`m`.`sMaterialsName` AS `sMaterialsName`,`s`.`sCustomerId` AS `sCustomerId`,`c`.`sCustomerName` AS `sCustomerName`,`s`.`sOrderNo` AS `sOrderNo`,`e`.`sMachineId` AS `sMachineId`,`e`.`sParentId` AS `sParentId`,`t`.`sTeamName` AS `sTeamName`,`s`.`dHour` AS `dHour`,`s`.`iIncrement` AS `iIncrement`,`t`.`iOrder` AS `iOrder` from (((((((`xlyweberp_saas_ai`.`mftproductionplanslave` `s` join `xlyweberp_saas_ai`.`eleteammachine` `e` on((`e`.`sMachineId` = `s`.`sMachineId`))) join `xlyweberp_saas_ai`.`eleteam` `t` on((`e`.`sParentId` = `t`.`sId`))) join `xlyweberp_saas_ai`.`eleprocess` `process` on((`s`.`sProcessId` = `process`.`sId`))) join `xlyweberp_saas_ai`.`eleproduct` `product` on((`s`.`sProductId` = `product`.`sId`))) join `xlyweberp_saas_ai`.`elematerials` `m` on((`s`.`sMaterialsId` = `m`.`sId`))) join `xlyweberp_saas_ai`.`elecustomer` `c` on((`s`.`sCustomerId` = `c`.`sId`))) join `xlyweberp_saas_ai`.`sisworkcenter` `w` on((`s`.`sWorkCenterId` = `w`.`sId`)))
```

## 说明

_暂无人工说明。_
