viw_zlldgroupby_sgdandsmaterialsid.md 974 Bytes

viw_zlldgroupby_sgdandsmaterialsid (view)

  • Updatable: NO

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

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

Narrative

No human-written narrative yet.