Referral
Query Transactions involving Referrals.
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the transaction record of the merchant. | |
| PayerDisplayName | String | The display name of the buyer. | |
| NetAmount | Decimal | The net amount of the transaction. | |
| FeeAmount | Decimal | The fee that PayPal charged for the transaction. | |
| GrossAmount | Decimal | The total gross amount charged, including any profile shipping cost and taxes. | |
| Status | String | The status of the transaction. This field is one of the following values: Pending, Processing, Success, Denied, or Reversed.
使用できる値は次のとおりです。Pending, Processing, Success, Denied, Reversed | |
| Date | Datetime | The date and time that the transaction occurred. | |
| Timezone | String | The time zone of the transaction. The value is always GMT. | |
| Type | String | The type of the transaction. It is one of the following values: Currency Conversion (credit), Currency Conversion (debit), Payment, Recurring Payment, Temporary Hold, Transfer, Donation. | |
| Payer | String | The email address of the buyer. Character length and limitations: 127 single-byte alphanumeric characters. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Amount | String | Search by the transaction amount. You must set the CurrencyCode input to one of the 3-character currency codes for any of the supported PayPal currencies. This value cannot exceed 10,000.00 USD or the per transaction limit for the currency. It includes no currency symbol. | |
| AuctionItemNumber | String | Search by the auction item number of the purchased goods. This field is not applicable to point-of-sale. | |
| CardNumber | String | Search by the credit card number, as set by you for the original transaction. This field searches the records for items the merchant sells. The field is not applicable to point-of-sale. | |
| CurrencyCode | String | Search by the 3-character, ISO 4217 currency code. | |
| InvoiceId | String | Search by invoice identification key, as set by you for the original transaction. This field searches the records for items the merchant sells. Character length and limitations: 127 single-byte characters maximum with no wildcards allowed. | |
| ProfileId | String | Search by the alphanumeric string (generated by PayPal) that uniquely identifies a recurring profile. You can specify the Profile Id to obtain all payments associated with the identified profile. | |
| ReceiptId | String | Search by the PayPal Account Optional receipt Id. This field is not applicable to point-of-sale transactions. | |
| Receiver | String | Search by the email address of the receiver. If the merchant account has only one email address, this is the primary email. It can also be a non-primary email address. | |
| PayerName | String | Search by the name of the buyer. |