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

## 定义

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

## 说明

_暂无人工说明。_