# `viw_eleteamperiod` (view)


- **Updatable:** NO

## Columns

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

## Definition

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

## Narrative

_No human-written narrative yet._