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`

说明

暂无人工说明。