viw_1cahpaymentslavesum.md 802 Bytes

viw_1cahpaymentslavesum(视图)

  • 是否可更新: 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`.`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`

说明

暂无人工说明。