--RequestType=14 드림캐쉬 결제
Select Accounter, CreditRegnum from CreditPayment where RequestType=14 and OrderNum = @OrderNum
(
Select OrderNum from CusOrder Where PaymethodCD=1500 --드림캐쉬로 결재한 놈들 주문번호
)
Select Seq, ReplyDate, ReplyType, URO.ReplyDesc AS URODesc, Happ.UserName From UserReplyOrder As URO Left Join (Select Distinct UserName, UserID From HappyUser With (NoLock)) AS Happ On Happ.UserID = URO.ReplyID Where URO.UserID = 'delicoke ' And OrderNum= 1800873 Order By ReplyDate Desc
Select * From DreamCashLog --드림캐쉬 취소로그
