# `view_mftproductionmeans`（视图）


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

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `iIncrement` | `int` | NO |
| 2 | `sId` | `varchar(100)` | NO |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |
| 5 | `tCreateDate` | `datetime` | NO |
| 6 | `sMakePerson` | `varchar(255)` | NO |
| 7 | `iOrder` | `int` | NO |
| 8 | `sWorkOrderNo` | `varchar(255)` | NO |
| 9 | `sWorkOrderId` | `varchar(255)` | NO |
| 10 | `sWorkOrderSlaveId` | `varchar(255)` | NO |
| 11 | `sWorkOrderControlId` | `varchar(255)` | NO |
| 12 | `sProductId` | `varchar(255)` | NO |
| 13 | `sProductName` | `varchar(500)` | NO |
| 14 | `iControlStick` | `int` | NO |
| 15 | `sPartsName` | `varchar(255)` | YES |
| 16 | `iStick` | `int` | NO |
| 17 | `sStickName` | `varchar(255)` | NO |
| 18 | `sDataInformationId` | `varchar(50)` | YES |
| 19 | `sDataInformation` | `varchar(50)` | YES |
| 20 | `bCheck` | `bit(1)` | YES |
| 21 | `sCheckPerson` | `varchar(255)` | YES |
| 22 | `tCheckDate` | `datetime` | YES |
| 23 | `bInvalid` | `bit(1)` | YES |
| 24 | `sStatus` | `varchar(255)` | YES |
| 25 | `sMaterialsName` | `varchar(255)` | YES |
| 26 | `sParentId` | `varchar(50)` | YES |
| 27 | `sFaceName` | `varchar(255)` | YES |
| 28 | `sMemo` | `text` | YES |
| 29 | `sZBNum` | `varchar(255)` | YES |

## 定义

```sql
select distinct `a`.`iIncrement` AS `iIncrement`,`a`.`sId` AS `sId`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,`a`.`tCreateDate` AS `tCreateDate`,`a`.`sMakePerson` AS `sMakePerson`,`a`.`iOrder` AS `iOrder`,`a`.`sWorkOrderNo` AS `sWorkOrderNo`,`a`.`sWorkOrderId` AS `sWorkOrderId`,`a`.`sWorkOrderSlaveId` AS `sWorkOrderSlaveId`,`a`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`a`.`sProductId` AS `sProductId`,`a`.`sProductName` AS `sProductName`,`a`.`iControlStick` AS `iControlStick`,`a`.`sPartsName` AS `sPartsName`,`a`.`iStick` AS `iStick`,`a`.`sStickName` AS `sStickName`,`a`.`sDataInformationId` AS `sDataInformationId`,`a`.`sDataInformation` AS `sDataInformation`,`a`.`bCheck` AS `bCheck`,`a`.`sCheckPerson` AS `sCheckPerson`,`a`.`tCheckDate` AS `tCheckDate`,`a`.`bInvalid` AS `bInvalid`,`a`.`sStatus` AS `sStatus`,`a`.`sMaterialsName` AS `sMaterialsName`,`a`.`sParentId` AS `sParentId`,`a`.`sFaceName` AS `sFaceName`,`a`.`sMemo` AS `sMemo`,`a`.`sZBNum` AS `sZBNum` from (`xlyweberp_saas_ai`.`mftproductionmeans` `a` join `xlyweberp_saas_ai`.`mftproductionmeans` `b` on(((`a`.`sWorkOrderId` = `b`.`sWorkOrderId`) and (`a`.`sProductId` = `b`.`sProductId`) and (`a`.`sWorkOrderControlId` = `b`.`sWorkOrderControlId`) and (`a`.`sStickName` = `b`.`sStickName`)))) where ((`a`.`sDataInformation` = '资料下达') and (`a`.`bCheck` = 0) and (`b`.`sDataInformation` = '蓝纸确认') and (`b`.`bCheck` = 1))
```

## 说明

_暂无人工说明。_
