BalanceAffecting
Query Transactions that affect the account balance.
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 | Date and time that the transaction occurred. Character length and limitations: The date and time of the transaction. | |
| 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. The field is not applicable to point-of-sale. | |
| CurrencyCode | String | Search by the 3-character, ISO 4217 currency code. | |
| InvoiceId | String | Search by the invoice identification key, as set by you for the original transaction. 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 nonprimary email address. | |
| PayerName | String | Search by the name of the buyer. |