1 |
Column Type |
Literal |
The column type (CH ). |
2 |
TRANSACTION_TYPE |
Varchar |
The type of transaction. One of:
PAYMENT . Forward money movement between buyer and seller for a given order.
CORRECTION . Correction type transactions.
CURRENCY_CONVERSION . Currency conversion type transactions.
DEPOSIT . Deposit type transactions.
DISBURSEMENT . Disbursement type transactions.
FEES . Fees type transactions for partner fee, payment fee, or fee reversal.
HOLD . Hold type transactions.
HOLD_RELEASE . Hold release type transactions.
OTHER . Other type transactions.
PAYMENT . Payment type transactions.
RECOUP . Recoup type transactions done either from bank or loss Accounts
REFUND . Refund type transactions.
REVERSAL . Reversal type transactions.
WITHDRAWAL . Withdrawal type transactions.
PAYABLE . Funds payable are funds provided by PayPal that need to be paid back.
RECEIVABLE . Funds receivable are funds provided by PayPal that are being paid back.
TRANSFER . Transfers are funds transferred either from or to a PayPal account and another payable account.
SETTLEMENT_CONSOLIDATION
ACH_REVERSAL
BONUS . Bonus type transactions.
PAYOUT_REFUND Refund against a past payout transaction.
PAYOUT_REVERSAL Reversal of a Payout transaction
|
3 |
TRANSACTION_SUBTYPE |
Varchar |
The Subtype of Transaction. One of:
FEE . Fee subtype transactions, applicable for transaction type Chargeback.
REVERSAL . Reversal subtype transactions, applicable for transaction types chargeback, fees, and withdrawals.
PARTNER_FEE . Partner fee subtype transactions, applicable for transaction type Fees.
PAYMENT_FEE . Payment fee subtype transactions, applicable for transaction type Fees.
MASS_PAY . Masspay subtype transactions, applicable for transaction type Payment.
BANK . Bank subtype transactions, applicable for transaction type Withdrawal.
LOSS_ACCOUNT . Loss account subtype transactions, applicable for transaction type Recoup.
DEPOSIT When the transaction type is CORRECTION , the value DEPOSIT or WITHDRAWAL will be populated for the transaction subtype depending on whether the amount is deposited or withdrawn from the partner's financial account.
WITHDRAWAL When the transaction type is CORRECTION , the value DEPOSIT or WITHDRAWAL will be populated for the transaction subtype depending on whether the amount is deposited or withdrawn from the partner's financial account.
FROM . Currency Conversion from currency.
TO . Currency Conversion to currency
FOREIGN_WITHDRAWAL . Indicates foreign withdrawal fees, applicable for transaction type FEES .
BONUS . This subtype applies to bonus transactions.
|
4 |
COUNTERPARTY_ACCOUNT_ID |
Varchar |
Encrypted PayPal account number of the counter party involved in a transaction. |
5 |
COUNTERPARTY_TRANSACTION_TYPE |
Varchar |
The transaction that contributed to the actual transaction. The transaction type can be one of the types defined in TRANSACTION_TYPE field. For example, if the TRANSACTION_TYPE is FEES and the TRANSACTION_SUBTYPE is PARTNER_FEE then the COUNTERPARTY_TRANSACTION_TYPE can be PAYMENT or REFUND .
|
6 |
COUNTERPARTY_TRANSACTION_SUBTYPE |
Varchar |
The subtype of transaction that contributed to the actual transaction. This field can be one of the subtypes defined in the TRANSACTION_SUBTYPE field.
|
7 |
PAYPAL_REFERENCE_ID |
String |
Original PayPal transaction ID to which this event is related. |
8 |
PAYPAL_TRANSACTION_ID |
Varchar |
PayPal transaction ID of the transaction. |
9 |
INVOICE_ID |
Varchar |
Invoice ID of the transaction. |
10 |
CUSTOM_FIELD |
Varchar |
A field for custom data. |
11 |
TRANSACTION_DATE |
Date-time |
The date and time the transaction was initiated, in the following format: YYYY/MM/DD HH:MM:SS offset . YYYY is the four-digit year. MM is the two-digit month of the year. DD is the two-digit day of the month. HH is the hour in 24-hour notation. MM is minutes. SS is seconds. offset is the five-character signed offset from GMT, such as +0800. |
12 |
INTEGRATION_IDENTIFIER |
Varchar |
For multi-tenancy partners, this identifier is the organization name. For partners who onboard before payment, this identifier is the button source code. |
12 |
PP_FEES |
Money |
PayPal fees associated with the transaction. Funds moving out of the PayPal fee account have a dash (- ) prefix. |
13 |
PP_FEES_PERCENTAGE |
Varchar |
Percentage of transaction amount charged as fee. Total PP fees include this component and PP_FEES_FIXED_AMOUNT . |
14 |
PP_FEES_FIXED_AMOUNT |
Money |
Fixed PayPal fee amount component of PayPal fees. |
15 |
PP_FEES_CURRENCY |
Three character currency code |
The currency of the PayPal fee. |
16 |
BASE_FX_RATE |
Varchar |
Base Rate is setup by Company to be within the buy and sale wholesale currency market rates published by reputable, independent publisher on the conversion day. |
17 |
MARKUP_FX_RATE |
Varchar |
Markup fee percentage for the currency exchange. |
18 |
NET_FX_RATE |
Varchar |
Base exchange rate for the relevant currency exchange("Company Base Rate") +/- a percentage fee (Markup FX Rate) currency conversion spread. |
19 |
TRANSACTION_CURRENCY |
Three-character currency code |
The currency of the transaction. |
20 |
TRANSACTION_AMOUNT |
Money |
The transaction amount. |
21 |
DECLINE_CODE |
Varchar |
This code indicates the reason of decline, when available. For credit card transactions, the code is a processor decline code. For bank transactions, the code is a bank decline code. For more information, see processor decline codes. |
22 |
SETTLEMENT_REFERENCE_ID |
Varchar |
The bank reference ID for the bank transfer transaction. |