捷信达根据昆仑会员系统结算单据号获取捷信达主单详细信息和手牌号

1
2
3
4
5
6
7
--SNB2305208010072
-- 通过会员系统查看结算单据号，根据单据号进行查询明细，获取手牌号。
execute dbo.up_snRptBillItem @as_sDate = '2023-05-20', @as_eDate = '2023-05-20' 
SELECT * FROM snBillMast sbm  where v_PaidNo='SNB2305208010072'
select * from snBillDetail  where v_PaidNo='SNB2305208010072'
SELECT * from v_snTabMast where v_billno ='3052000223'