摘要： SELECT null,s._room_name 包厢,a._session 账单号,COALESCE(s._amount_receivable,0)-COALESCE(s._flower_charge,0) 应收金额, a.amount 实收金额,a.xianjin 现金,a.bank 银行卡,a.qiandan 签单,a.zhaodai 招待,a.zhuguazhang 主挂账,a.fuguazhang 副挂账,s._value_discount 折率,_charged_by_name 埋单员工,_copy_count 打印次数, CASE s._check_out_mode WHEN . 阅读全文