viw_eleteamperiod（视图）

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

字段

#	名称	类型	可空
1	sPeriodId	varchar(100)	YES
2	iPeriodId	bigint	YES
3	sTeamId	varchar(100)	NO
4	sTeamNo	varchar(255)	YES
5	sTeamName	varchar(255)	YES
6	sBrandsId	varchar(100)	NO
7	sSubsidiaryId	varchar(100)	NO
8	iOrder	int	NO

定义

select distinct `a`.`sPeriodId` AS `sPeriodId`,cast(`a`.`sPeriodId` as signed) AS `iPeriodId`,`b`.`sId` AS `sTeamId`,`b`.`sTeamNo` AS `sTeamNo`,`b`.`sTeamName` AS `sTeamName`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,0 AS `iOrder` from (`xlyweberp_saas_ai`.`sysaccountperiod` `a` join `xlyweberp_saas_ai`.`eleteam` `b`)

说明

暂无人工说明。