Page 25 - 17.Payment Process-결제(40P)

주문 결과 상세 저장 쿼리 1(기존)

Update gGoodsOrder20T

set process_result = '입금확인'
, pay_deposit_check = 'true'
, order_pay_amount = order_amount + delivery_charge
, pay_deposit_date = getDate()
, order_pay_check = 'true'
, pay_type = '" & pay_type & "'
Where 1 = 1
and order_no = '" + ordno + "'