viw_1cahreceiptslavesum.md
802 Bytes
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 |
定义
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`
说明
暂无人工说明。