# `viw_hmwxjy3` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sid` | `varchar(100)` | NO |
| 2 | `iorder` | `int` | NO |
| 3 | `sSrcNo` | `varchar(255)` | NO |
| 4 | `sCustomerName` | `varchar(255)` | NO |
| 5 | `sBillNo` | `varchar(255)` | NO |
| 6 | `sProductName` | `varchar(100)` | NO |
| 7 | `dAuxiliaryQty` | `decimal(18,6)` | NO |
| 8 | `已确认数` | `decimal(40,6)` | YES |
| 9 | `sProcessName` | `varchar(100)` | NO |
| 10 | `规格` | `varchar(255)` | NO |
| 11 | `sAuxiliaryUnit` | `varchar(255)` | NO |
| 12 | `dMaterialsPrice` | `decimal(18,6)` | NO |
| 13 | `dMaterialsMoney` | `decimal(40,6)` | YES |
| 14 | `sName` | `varchar(255)` | NO |
| 15 | `dMaterialsNoTaxPrice` | `decimal(18,6)` | YES |
| 16 | `dMaterialsNoTaxMoney` | `decimal(18,6)` | YES |
| 17 | `dMaterialsTaxMoney` | `decimal(18,6)` | YES |
| 18 | `bCopyLimit` | `bit(1)` | NO |
| 19 | `bCheck` | `bit(1)` | NO |
| 20 | `bInStoreComplete` | `bit(1)` | NO |
| 21 | `tCreateDate` | `datetime` | NO |
| 22 | `sSupplyId` | `varchar(100)` | NO |
| 23 | `sCustomerId` | `varchar(100)` | NO |
| 24 | `sProductId` | `varchar(100)` | NO |
| 25 | `sProcessId` | `varchar(100)` | NO |
| 26 | `sPurchaseManId` | `varchar(100)` | YES |
| 27 | `sGetPayId` | `varchar(100)` | YES |
| 28 | `sSrcSlaveId` | `varchar(100)` | NO |
| 29 | `sFormId` | `varchar(100)` | NO |
| 30 | `sParentId` | `varchar(100)` | NO |
| 31 | `sSrcId` | `varchar(100)` | NO |
| 32 | `sSlaveId` | `varchar(100)` | NO |
| 33 | `sTaxId` | `varchar(100)` | YES |
| 34 | `iTestType` | `int` | NO |

## Definition

```sql
select `wx`.`sid` AS `sid`,`wx`.`iorder` AS `iorder`,`wx`.`sSrcNo` AS `sSrcNo`,`wx`.`sCustomerName` AS `sCustomerName`,`wx`.`sBillNo` AS `sBillNo`,`wx`.`sProductName` AS `sProductName`,`wx`.`dAuxiliaryQty` AS `dAuxiliaryQty`,sum(`wx`.`已确认数`) AS `已确认数`,`wx`.`sProcessName` AS `sProcessName`,`wx`.`规格` AS `规格`,`wx`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`wx`.`dMaterialsPrice` AS `dMaterialsPrice`,sum(`wx`.`dMaterialsMoney`) AS `dMaterialsMoney`,`wx`.`sName` AS `sName`,`wx`.`dMaterialsNoTaxPrice` AS `dMaterialsNoTaxPrice`,`wx`.`dMaterialsNoTaxMoney` AS `dMaterialsNoTaxMoney`,`wx`.`dMaterialsTaxMoney` AS `dMaterialsTaxMoney`,`wx`.`bCopyLimit` AS `bCopyLimit`,`wx`.`bCheck` AS `bCheck`,`wx`.`bInStoreComplete` AS `bInStoreComplete`,`wx`.`tCreateDate` AS `tCreateDate`,`wx`.`sSupplyId` AS `sSupplyId`,`wx`.`sCustomerId` AS `sCustomerId`,`wx`.`sProductId` AS `sProductId`,`wx`.`sProcessId` AS `sProcessId`,`wx`.`sPurchaseManId` AS `sPurchaseManId`,`wx`.`sGetPayId` AS `sGetPayId`,`wx`.`sSrcSlaveId` AS `sSrcSlaveId`,`wx`.`sFormId` AS `sFormId`,`wx`.`sParentId` AS `sParentId`,`wx`.`sSrcId` AS `sSrcId`,`wx`.`sSlaveId` AS `sSlaveId`,`wx`.`sTaxId` AS `sTaxId`,`wx`.`iTestType` AS `iTestType` from (select distinct `a`.`sId` AS `sid`,`a`.`iOrder` AS `iorder`,`a`.`工单号` AS `sSrcNo`,`a`.`客户名称` AS `sCustomerName`,`a`.`外协单号` AS `sBillNo`,`a`.`产品名称` AS `sProductName`,`a`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`a`.`已确认数` AS `已确认数`,`a`.`发外工序` AS `sProcessName`,`a`.`规格` AS `规格`,`a`.`采购单位` AS `sAuxiliaryUnit`,`a`.`单价` AS `dMaterialsPrice`,`a`.`金额` AS `dMaterialsMoney`,`a`.`税码` AS `sName`,`a`.`不含税单价` AS `dMaterialsNoTaxPrice`,`a`.`不含税金额` AS `dMaterialsNoTaxMoney`,`a`.`税额` AS `dMaterialsTaxMoney`,`a`.`bCopyLimit` AS `bCopyLimit`,`a`.`bCheck` AS `bCheck`,`a`.`bInStoreComplete` AS `bInStoreComplete`,`a`.`tCreateDate` AS `tCreateDate`,`a`.`sSupplyId` AS `sSupplyId`,`a`.`sCustomerId` AS `sCustomerId`,`a`.`sProductId` AS `sProductId`,`a`.`sProcessId` AS `sProcessId`,`a`.`sPurchaseManId` AS `sPurchaseManId`,`a`.`sGetPayId` AS `sGetPayId`,`a`.`sSrcSlaveId` AS `sSrcSlaveId`,`a`.`sFormId` AS `sFormId`,`a`.`sParentId` AS `sParentId`,`a`.`sSrcId` AS `sSrcId`,`a`.`sSlaveId` AS `sSlaveId`,`a`.`sTaxId` AS `sTaxId`,`a`.`iTestType` AS `iTestType` from `viw_hmwxjy` `a` union select distinct `b`.`sId` AS `sid`,`b`.`iOrder` AS `iorder`,`b`.`工单号` AS `sSrcNo`,`b`.`客户名称` AS `sCustomerName`,`b`.`外协单号` AS `sBillNo`,`b`.`产品名称` AS `sProductName`,`b`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`b`.`已确认数` AS `已确认数`,`b`.`发外工序` AS `sProcessName`,`b`.`规格` AS `规格`,`b`.`采购单位` AS `sAuxiliaryUnit`,`b`.`单价` AS `dMaterialsPrice`,`b`.`金额` AS `dMaterialsMoney`,`b`.`税码` AS `sName`,`b`.`不含税单价` AS `dMaterialsNoTaxPrice`,`b`.`不含税金额` AS `dMaterialsNoTaxMoney`,`b`.`税额` AS `dMaterialsTaxMoney`,`b`.`bCopyLimit` AS `bCopyLimit`,`b`.`bCheck` AS `bCheck`,`b`.`bInStoreComplete` AS `bInStoreComplete`,`b`.`tCreateDate` AS `tCreateDate`,`b`.`sSupplyId` AS `sSupplyId`,`b`.`sCustomerId` AS `sCustomerId`,`b`.`sProductId` AS `sProductId`,`b`.`sProcessId` AS `sProcessId`,`b`.`sPurchaseManId` AS `sPurchaseManId`,`b`.`sGetPayId` AS `sGetPayId`,`b`.`sSrcSlaveId` AS `sSrcSlaveId`,`b`.`sFormId` AS `sFormId`,`b`.`sParentId` AS `sParentId`,`b`.`sSrcId` AS `sSrcId`,`b`.`sSlaveId` AS `sSlaveId`,`b`.`sTaxId` AS `sTaxId`,`b`.`iTestType` AS `iTestType` from `viw_hmwxjy2` `b`) `wx` group by `wx`.`sSrcNo`,`wx`.`sBillNo`,`wx`.`sProcessId`,`wx`.`tCreateDate`,`wx`.`sSupplyId`
```

## Narrative

_No human-written narrative yet._