viw_1cahpaymentslavesum.md
805 Bytes
viw_1cahpaymentslavesum (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`.`cahpaymentslave`.`sParentId` AS `sparentid`,sum(`xlyweberp_saas_ai`.`cahpaymentslave`.`dRoundingMoney`) AS `dSumRoundingMoney`,sum(`xlyweberp_saas_ai`.`cahpaymentslave`.`dTotalMoney`) AS `dSumTotalMoney`,`xlyweberp_saas_ai`.`cahpaymentslave`.`iIncrement` AS `iIncrement` from `xlyweberp_saas_ai`.`cahpaymentslave` group by `xlyweberp_saas_ai`.`cahpaymentslave`.`sParentId`
Narrative
No human-written narrative yet.