viw_1cahreceiptslavesum.md
805 Bytes
viw_1cahreceiptslavesum (view)
VIEW
- Updatable: NO
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 1 | sparentid |
varchar(100) |
NO |
| 2 | dSumRoundingMoney |
decimal(40,6) |
YES |
| 3 | dSumTotalMoney |
decimal(40,6) |
YES |
| 4 | iIncrement |
int |
NO |
Definition
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`
Narrative
No human-written narrative yet.