viw_elemachineperiod（视图）

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

字段

#	名称	类型	可空
1	sPeriodId	varchar(100)	YES
2	iPeriodId	bigint	YES
3	sMachineId	varchar(50)	NO
4	sMachineNo	varchar(50)	NO
5	sMachineName	varchar(100)	NO
6	iPlcNo	int	NO
7	sBrandsId	varchar(100)	NO
8	sSubsidiaryId	varchar(100)	NO
9	iOrder	int	NO

定义

select distinct `a`.`sPeriodId` AS `sPeriodId`,cast(`a`.`sPeriodId` as signed) AS `iPeriodId`,`b`.`sId` AS `sMachineId`,`b`.`sMachineNo` AS `sMachineNo`,`b`.`sMachineName` AS `sMachineName`,`b`.`iPlcNo` AS `iPlcNo`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,0 AS `iOrder` from (`xlyweberp_saas_ai`.`sysaccountperiod` `a` join `xlyweberp_saas_ai`.`elemachine` `b`)

说明

暂无人工说明。