-- apps_transaction.inNicepayTransactionReport (PROCEDURE)
BEGIN
	INSERT INTO `apps_transaction`.`nicepay_transaction_report`
	(
		resultCd,
		resultMsg,
		tXid,
		referenceNo,
		payMethod,
		amt,
		transDt,
		transTm,
		description,
		authNo,
		issuBankCd,
		acquBankCd,
		cardNo,
		receiptCode,
		mitraCd,
		recurringToken,
		preauthToken,
		currency,
		goodsNm,
		billingNm,
		ccTransType,
		mRefNo,
		instmntType,
		instmntMon,
		cardExpYymm,
		issuBankNm,
		acquBankNm,
		`timeStamp`,
		merchantToken,
		insertTime
	)
	VALUES 
	(
		resultCd1,
		resultMsg1,
		tXid1,
		referenceNo1,
		payMethod1,
		amt1,
		transDt1,
		transTm1,
		description1,
		authNo1,
		issuBankCd1,
		acquBankCd1,
		cardNo1,
		receiptCode1,
		mitraCd1,
		recurringToken1,
		preauthToken1,
		currency1,
		goodsNm1,
		billingNm1,
		ccTransType1,
		mRefNo1,
		instmntType1,
		instmntMon1,
		cardExpYymm1,
		issuBankNm1,
		acquBankNm1,
		`timeStamp1`,
		merchantToken1,
		now()
	);
END