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

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

update gGoodsOrder10T set pay_date = getDate()

, process_result = '입금확인'
, pay_deposit_check = 'true'
, order_pay_check = 'true'
, pay_deposit_date = getDate()
, cancel_check = 'false'
, je_rate = pay_total_amount * 0.033
, soon_pay_total_amount = pay_total_amount - ((pay_total_amount * 0.033) + delivery_charge)
, pay_total_amount = '" + amt + "'
, nobank_amount = '" & nobank_amount & "'
, nobank_deposit_name = '" & nobank_deposit_name & "'
, pay_transfer = '" & pay_transfer & "'

, transfer_amount = '" & transfer_amount & "'
, transfer_deposit_name = '" & LGD_ACCOUNTOWNER & "'
, pay_card = '" & pay_card & "'
, card_amount = '" & card_amount & "'
Where order_no = '" + ordno + "'