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. |