# `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 |

## 定义

```sql
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`)
```

## 说明

_暂无人工说明。_