1 |
Column Type |
Literal |
The column type (CH ). |
2 |
TRANSACTION_TYPE |
Varchar |
One of the following types of transaction:
-
PAYMENT : This type applies to money movement between a
buyer and a seller for an order.
-
AUTH : This type applies to authorization and
authorization void transactions.
|
3 |
TRANSACTION_SUBTYPE |
Varchar |
The value of the subtype of transaction depends on the value of the
TRANSACTION_TYPE . It can be blank in some use cases.
|
4 |
SELLER_ACCOUNT_ID |
Varchar |
The seller's PayPal encrypted account number. |
5 |
PAYPAL_REFERENCE_ID |
String |
The original PayPal transaction ID this event is related to. |
6 |
PAYPAL_TRANSACTION_ID |
Varchar |
The PayPal transaction ID. |
7 |
INVOICE_ID |
String |
The invoice ID of the transaction. |
8 |
CUSTOM_FIELD |
Varchar |
This indicates the custom_id that is passed in the Create
Order request.
|
9 |
TRANSACTION_DATE |
Date-time |
The date and time the case was filed, 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 .
|
10 |
TRANSACTION_AMOUNT |
Money |
The amount paid by or refunded to the buyer. This field contains the gross
transaction value for all transactions.
|
11 |
TRANSACTION_CURRENCY |
Three-character currency code |
The currency of the transaction. |
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:
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
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
SOLO: SOLO card transaction
STAR: STAR card transaction
SWITCH: SWITCH card transaction
VISA: VISA card transaction
DINERS: DINERS card transaction
RUPAY: RUPAY 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 |
DECLINE_CODE |
Varchar |
Normalized code that indicates the following:
- Reason of decline, when available
- Processor decline codes for credit card transactions
- Bank decline codes for bank transactions
-
See the
processor decline codes.
|
15 |
AVS_RESPONSE_CODE |
Varchar |
Address verification service (AVS) response code. See the
AVS response codes.
|
16 |
BILLING_ADDRESS_1 |
String |
The number and street of the card's billing address on file. |
17 |
BILLING_ADDRESS_2 |
String |
The number and street of the card's billing address on file. |
18 |
BILLING_CITY |
String |
The city of the card's billing address on file. |
19 |
BILLING_STATE |
String |
The state of the card's billing address on file. |
20 |
BILLING_ZIPCODE |
String |
The zip code or pincode of the card's address on file. |
21 |
BILLING_COUNTY_CODE |
String |
The country code of the card's address on file. |
21 |
INTEGRATION_IDENTIFIER |
String |
The partner's button source code, either the BN code or organization name.
|