# `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` ``` ## 说明 _暂无人工说明。_