# `viw_1cahreceiptslavesum`（视图）


- **是否可更新：** NO
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sparentid` | `varchar(100)` | NO |
| 2 | `dSumRoundingMoney` | `decimal(40,6)` | YES |
| 3 | `dSumTotalMoney` | `decimal(40,6)` | YES |
| 4 | `iIncrement` | `int` | NO |

## 定义

```sql
select `xlyweberp_saas_ai`.`cahreceiptslave`.`sParentId` AS `sparentid`,sum(`xlyweberp_saas_ai`.`cahreceiptslave`.`dRoundingMoney`) AS `dSumRoundingMoney`,sum(`xlyweberp_saas_ai`.`cahreceiptslave`.`dTotalMoney`) AS `dSumTotalMoney`,`xlyweberp_saas_ai`.`cahreceiptslave`.`iIncrement` AS `iIncrement` from `xlyweberp_saas_ai`.`cahreceiptslave` group by `xlyweberp_saas_ai`.`cahreceiptslave`.`sParentId`
```

## 说明

_暂无人工说明。_
