viw_elematerials_m（视图）

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

字段

#	名称	类型	可空
1	sProductName	varchar(100)	NO
2	sProductNo	varchar(50)	NO
3	sProductStyle	char(0)	NO
4	sProductUnit	varchar(50)	YES
5	sCustomerProductNo	char(0)	NO
6	sId	varchar(50)	NO
7	sAllPartsName	char(0)	NO
8	sProductId	varchar(50)	NO
9	sProductClassifyId	varchar(50)	YES
10	sType	char(0)	NO
11	tCreateDate	datetime	NO
12	sCustomerId	char(0)	NO
13	sParentId	varchar(50)	YES
14	sProductClassifyName	varchar(100)	YES
15	sParentProductId	varchar(1)	NO
16	sBrandsId	varchar(50)	NO
17	sSubsidiaryId	varchar(50)	NO

定义

select distinct `a`.`sMaterialsName` AS `sProductName`,`a`.`sMaterialsNo` AS `sProductNo`,'' AS `sProductStyle`,`a`.`sMaterialsUnit` AS `sProductUnit`,'' AS `sCustomerProductNo`,`a`.`sId` AS `sId`,'' AS `sAllPartsName`,`a`.`sId` AS `sProductId`,`b`.`sId` AS `sProductClassifyId`,'' AS `sType`,`a`.`tCreateDate` AS `tCreateDate`,'' AS `sCustomerId`,`a`.`sParentId` AS `sParentId`,`b`.`sName` AS `sProductClassifyName`,'0' AS `sParentProductId`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId` from (`xlyweberp_saas_ai`.`elematerials` `a` left join `xlyweberp_saas_ai`.`sismaterialsclassify` `b` on(((`a`.`sParentId` = `b`.`sId`) and (`a`.`sBrandsId` = `b`.`sBrandsId`) and (`a`.`sSubsidiaryId` = `b`.`sSubsidiaryId`))))

说明

暂无人工说明。