viw_1cahreceiptslavesum.md 649 Bytes

viw_1cahreceiptslavesum (view)

  • Updatable: NO

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 `cahreceiptslave`.`sParentId` AS `sparentid`,sum(`cahreceiptslave`.`dRoundingMoney`) AS `dSumRoundingMoney`,sum(`cahreceiptslave`.`dTotalMoney`) AS `dSumTotalMoney`,`cahreceiptslave`.`iIncrement` AS `iIncrement` from `cahreceiptslave` group by `cahreceiptslave`.`sParentId`

Narrative

No human-written narrative yet.