Transaction log of PayPal 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; “1” is always used for PayPal.
  • “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 but Web Deposit did not communicate with PayPal yet. Normally, this value is never shown because if there is an error in the communication with PayPal (e.g. the wrong URL is used), it is updated to "6" (Failed), or if PayPal answers - it is updated to "2" (Pending).
    • "2" (Pending): When the PayPal screens appear the transaction is in pending state.
    • "3" (Complete): The money was transferred between the two PayPal accounts.
    • "4" (Cancelled): The transaction was cancelled by the user.
    • "6" (Failed): There was an error during the transaction.
  • “CASBalanceUpdated”: “True” if balance of the Equitrac account was increased by the transaction amount; otherwise “False”.
If a transaction is in a complete state but this column is “False”, the Equitrac balance is not updated because of network issues. In this case, the Equitrac balance should be increased manually by the Equitrac server administrator.

The “PayPalPayments” table stores the PayPal related information of the payment:

  • “Id”: Identifies the related transaction in the “Payments” table.
  • “CorrelationID”, “Token”, “PayerID”: PayPal technical information about the transaction. These may be required by the PayPal support in case of any issue.
  • “FirstName”, “LastName”, “Email”: Information of the buyer’s PayPal account.
  • “TransactionId”: This ID appears in the transaction history of the buyer’s PayPal account.

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

This information is important for the PayPal 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 PayPal API was used.
  • “Request”: “True” if a message was sent to PayPal. “False” if a response or notification was received from PayPal.
  • “Message”: Content of the communication with PayPal.
You are responsible for archiving the transaction history and logs.