viw_zlldgroupby_sgdandsmaterialsid（视图）

• 是否可更新： NO
• 定义者： xlyprint@%

字段

#	名称	类型	可空
1	sWorkOrderMaterialsTbId	varchar(100)	NO
2	lldsMaterialsId	varchar(100)	YES
3	LldQty	decimal(40,6)	YES
4	LldsMaterialsStyle	varchar(255)	NO

定义

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`

说明

暂无人工说明。