view_mftproductionmeans.md
2.82 KB
view_mftproductionmeans (view)
VIEW
- Updatable: NO
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 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 |
Definition
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))
Narrative
No human-written narrative yet.