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.
-
AUTH: Auth type transactions for Auth or Auth void.
BONUS: Bonus type transactions.
-
CHARGEBACK: Chargeback type transactions for Chargeback
fee or Chargeback fee reversal.
CORRECTION: Correction type transactions.
-
CURRENCY_CONVERSION: Currency conversion type
transactions.
DEPOSIT: Deposit type transactions.
DISBURSEMENT: Disbursement type transactions.
DISPUTE: Dispute type transactions.
-
FEES: Fees type transactions for Partner Fee, Payment
Fee or Fee Reversal.
HOLD: Hold type transactions.
HOLD_RELEASE: Hold release type transactions.
INCENTIVES: Incentives type transactions.
OTHERS: Others 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
-
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:
-
VOID: Void subtype transactions, applicable for
transaction type Auth.
-
FEE: Fee subtype transactions, applicable for
transaction type Chargeback.
-
REVERSAL: Reversal subtype transactions, applicable for
transaction types Chargeback, Fees and Withdrawal.
REFUND: Fees refund.
-
PARTNER_FEE: Partner fee subtype transactions,
applicable for transaction type Fees.
-
PAYMENT_FEE: Payment fee subtype transactions,
applicable for transaction type Fees.
-
MASSPAY: 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.
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 |
PRICING_FEE_TYPE |
Varchar |
One of the following fee types, based on transaction and forward or
reverse money movement
|
5 |
SELLER_ACCOUNT_ID |
Varchar |
Merchant's PayPal encrypted account number. |
6 |
PAYPAL_REFERENCE_ID |
String |
Original PayPal transaction ID to which this event is related. |
7 |
PAYPAL_TRANSACTION_ID |
Varchar |
PayPal transaction ID of the transaction. |
8 |
INVOICE_ID |
Varchar |
Invoice ID of the transaction. |
9 |
CUSTOM_FIELD |
Varchar |
A field for custom data. |
10 |
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 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 .
|
11 |
INTEGRATION_IDENTIFIER |
Varchar |
Button Source code or Organisation name of partner. |
12 |
PAYMENT_INSTRUMENT_TYPE |
Varchar |
A high-level classification of the type of financial instrument that was
used to fund a payment, such as the following:
PAYPAL
CREDIT_CARD
DEBIT_CARD
Direct Debit
VENMO
Apple Pay
Google Pay
Network Token
-
Supported APMs
|
13 |
PAYMENT_INSTRUMENT_SUBTYPE |
Varchar |
One of the following detailed classifications of the financial
instrument used to fund a payment:
AMEX: AMEX card transaction
CARTE_BANCAIRE: CARTE_BANCAIRE card transaction
CETELEM: CETELEM card transaction
COFIDIS: COFIDIS card transaction
COFINOGA: COFINOGA card transaction
-
CHINA_UNION_PAY: CHINA_UNION_PAY card transaction
DELTA: DELTA card transaction
DINERS: DINERS card transaction
DISCOVER: DISCOVER card transaction
ELECTRON: ELECTRON card transaction
ELO: ELO card transaction
HIPER: HIPER card transaction
HIPERCARD: HIPERCARD card transaction
JCB: JCB card transaction
MAESTRO: MAESTRO card transaction
MASTER_CARD: MASTER_CARD card transaction
RUPAY: RUPAY card transaction
SOLO: SOLO card transaction
STAR: STAR card transaction
SWITCH: SWITCH card transaction
VISA: VISA card transaction
For Wallets and Network token, Payment Source Subtype would show details
of card type and card brand used to fund the transaction. For
example:
CREDIT_CARD-VISA
DEBIT_CARD-MASTER_CARD
|
14 |
TRANSACTION_AMOUNT |
Money |
The Transaction Amount. |
15 |
TRANSACTION_CURRENCY |
Three character currency code
|
The currency of the transaction. |
16 |
TRANSACTION_DEBIT_CREDIT_CODE |
Varchar |
Indicates if money has been credited or debited from the account.
CR: – Denotes Credit.
DR: – Denotes Debit.
|
17 |
PRICING_MODEL |
Varchar |
Denotes if there is a revenue share on the transaction or if the fees
are gross billed through invoices.
GROSS_BILLING: gross billing of fees
REVSHARE: revenue share on fees
|
18 |
INTERCHANGE_PROGRAM |
varchar |
This denotes the updated interchange program received for the
transaction. If the transaction has received any interchange prior to
this, then that value has to be discarded and new details are to be
applied. A blank value means that there is no interchange program
applicable as of now and partners should nullify the interchange details
received prior to this.
|
19 |
INTERCHANGE_COST_PERCENTAGE |
varchar |
Percentage of transaction amount charged as the revised interchange
cost. If the transaction has received any interchange prior to this,
then that value has to be discarded and new details are to be applied.
Blank values should also be updated.
|
20 |
INTERCHANGE_COST_FIXED_AMOUNT |
Money |
Fixed amount component of the revised interchange cost. If the
transaction has received any interchange prior to this, then that value
has to be discarded and new details are to be applied. Blank values
should also be updated.
|
21 |
INTERCHANGE_COST |
Money |
Total revised interchange cost. If the transaction has received any
interchange prior to this then that value has to be discarded and new
details are to be applied. Blank values should also be updated.
|
22 |
NETWORK_NAME |
varchar |
Pinless debit network name such as the following:
VISA
AMEX
DISCOVER
MASTER_CARD
CARTE_BANCAIRE
|