# `viw_elemachineperiod` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 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 |

## Definition

```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 (`sysaccountperiod` `a` join `elemachine` `b`)
```

## Narrative

_No human-written narrative yet._