# `viw_zlldgroupby_sgdandsmaterialsid` (view)


- **Updatable:** NO
- **Definer:** `xlyprint@%`

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sWorkOrderMaterialsTbId` | `varchar(100)` | NO |
| 2 | `lldsMaterialsId` | `varchar(100)` | YES |
| 3 | `LldQty` | `decimal(40,6)` | YES |
| 4 | `LldsMaterialsStyle` | `varchar(255)` | NO |

## Definition

```sql
select `xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sWorkOrderMaterialsTbId` AS `sWorkOrderMaterialsTbId`,min(`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sMaterialsId`) AS `lldsMaterialsId`,sum(if((`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sFormId` = '192116810113315226622476570'),-(`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`dAuxiliaryQty`),`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`dAuxiliaryQty`)) AS `LldQty`,`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sMaterialsStyle` AS `LldsMaterialsStyle` from `xlyweberp_saas_ai`.`viw_mitproductionmaterials` where (`xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sWorkOrderNo` <> '') group by `xlyweberp_saas_ai`.`viw_mitproductionmaterials`.`sWorkOrderMaterialsTbId`
```

## Narrative

_No human-written narrative yet._