viw_sismaterialsclassify（视图）

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

字段

#	名称	类型	可空
1	sMaterialsType	varchar(100)	YES
2	sName	varchar(100)	NO
3	sNo	varchar(50)	YES
4	sId	varchar(50)	YES
5	sParentNo	varchar(50)	YES
6	sBrandsId	varchar(50)	YES
7	sSubsidiaryId	varchar(50)	YES
8	bInvalid	bit(1)	NO
9	iOrder	int	NO

定义

select (select `b`.`sName` from `xlyweberp_saas_ai`.`sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sMaterialsType`,`a`.`sName` AS `sName`,`a`.`sNo` AS `sNo`,`a`.`sId` AS `sId`,(select `b`.`sNo` from `xlyweberp_saas_ai`.`sismaterialsclassify` `b` where (`b`.`sId` = `a`.`sParentId`)) AS `sParentNo`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,`a`.`bInvalid` AS `bInvalid`,`a`.`iOrder` AS `iOrder` from `xlyweberp_saas_ai`.`sismaterialsclassify` `a` where ((`a`.`bInvalid` = 0) and (ifnull(`a`.`sParentId`,'') <> ''))

说明

暂无人工说明。