Transaction log of Ogone payments

All payment transactions are stored in the Web Deposit database as a transaction history.

The “Payments” table stores general transaction data. The columns are as follows:

• “CASAccountId” and “CASUserID”: Data about the Equitrac account and the user who initiated the payment (database ID and User ID).
• “PaymentService”: Used payment methods; “2” is always used for Ogone.
• “Created” and “LastModified”: Timestamp of the creation and modification of the record.
• “CurrencyIsoCode”: The currency type in ISO format, which is used for the requested amount.
• “ItemAmount” and “FeeAmount”: Amount of money to participate in the transaction, meaning transaction amount and transaction fee.
• “Status”: State of the transaction. The following values are possible:
  • “1” (New): The transaction was initiated by Web Deposit and the user is on the Ogone screen. Money was not transferred yet.
  • “2” (Pending): The payment is in progress, waiting for update from Ogone. Money was not transferred yet.
  • “3” (Complete): Money was transferred successfully.
  • 4” (Canceled): The payment was canceled by the user and money was not transferred.
  • “5” (Declined): The payment was declined by Ogone or a bank and money was not transferred.
  • “6” (Failed): There was an error during the transaction and money was not transferred.
  • “7” (Uncertain): Ogone did not decide the status of the payment. You should call the bank for information.
  • “8” (Invalid): Web Deposit detected that somebody tried to hack the communication with Ogone. The payment workflow was terminated immediately; status of the payment is a question. You should call the bank for information.
• “CASBalanceUpdated”: “True” if balance of the Equitrac account was increased by the transaction amount; otherwise “False”.
  If a transaction is in complete state but this column is “False”, the Equitrac balance is not updated because of network problems. In this case, the Equitrac balance should be increased manually by the Equitrac server administrator.

  The “OgonePayments” table stores the Ogone related information of the payment.

• “Id”: Identifies the related transaction in the “Payments” table.
• “OrderID”, “OgoneStatus”, “NcError”, “PayId”: Ogone technical information about the transaction. These may be required by the Ogone support in case of any issue.
• “Acceptance”: The acceptance code of the acquirer reported by Ogone.
• “CardholderName”, “CardholderEmail”: Information about the card holder.
• “TrxDate”: The date when the transaction was latest updated at Ogone.
• “StatusUpdated”: The date when the latest status notification was received from Ogone.

  Additionally, all communication between Web Deposit and Ogone is also logged into the “OgoneTransactions” table.

  This information is important for the Ogone support in case of troubleshooting.
• “PaymentID”: Identifies the related transaction in the “Payments” table.
• “TimeStamp”: Shows when this communication happened.
• “Method”: Shows which method of the Ogone API was used.
• “Request”: “True” if a message was sent to Ogone. “False” if a response or notification was received from Ogone.
• “Message”: Content of the communication with Ogone.