Power BI Connector for Square

Build 21.0.8137

Payments

Query the available card Payments in Square. Cash and other tenders payments will not be returned.

Table Specific Information

Select

The following queries show the filters that are processed server side, while other filters are processed client side within the 本製品. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will have an unfiltered response.

Retrieve all Payments:

SELECT * FROM Payments
Retrieve a single payment by providing a valid Id:
    Select * FROM Payments where id = '5xNDT7Sd6qFHsLyKlugpZIqeV'
   

Filter by the creation date of a Payment:

  SELECT * FROM Payments WHERE CreatedAt>'2015-08-15'
  SELECT * FROM Payments WHERE CreatedAt<'2015-08-15'
  

Columns

Name Type Description
Id [KEY] String The Id of the payment.
MoneyAmount Int64 The amount of money, in the smallest denomination of the currency indicated by currency. For example, when currency is USD, amount is in cents.
MoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
AppFeeMoneyAmount Int64 The amount the developer is taking as a fee for facilitating the payment on behalf of the seller.
AppFeeMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
ApprovedMoneyAmount Int64 The initial amount of money approved for this payment. The amount the developer is taking as a fee for facilitating the payment on behalf of the seller.
ApprovedMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
BankAccountOwnershipType String The ownership type of the bank account performing the transfer.

使用できる値は次のとおりです。INDIVIDUAL, COMPANY, UNKNOWN

ACHDetailsAccountNumberSuffix String The last few digits of the bank account number.
ACHDetailsAccountType String The type of the bank account performing the transfer.

使用できる値は次のとおりです。CHECKING, SAVINGS, UNKNOWN

ACHDetailsRoutingNumber String The routing number for the bank account.
BankName String The name of the bank associated with the bank account.
BankAccountCountry String The two-letter ISO code representing the country the bank account is located in.
BankAccountFingerprint String Uniquely identifies the bank account for this seller and can be used to determine if payments are from the same bank account.
BankAccountStatementDescription String The statement description as sent to the bank.
BankAccountTransferType String The type of the bank transfer.

使用できる値は次のとおりです。ACH, UNKNOWN

BillingAddressLine1 String The first line of the address.
BillingAddressLine2 String The second line of the address, if any.
BillingAddressLine3 String The third line of the address, if any.
BillingAddressAdministrativeDistrictLevel1 String A civil entity within the address's country. In the US, this is the state.
BillingAddressAdministrativeDistrictLevel2 String A civil entity within the address's administrative_district_level_1. In the US, this is the county.
BillingAddressAdministrativeDistrictLevel3 String A civil entity within the address's administrative_district_level_2, if any.
BillingAddressCountry String The address's country, in ISO 3166-1-alpha-2 format.
BillingAddressFirstName String Optional first name when it's representing recipient.
BillingAddressLastName String Optional last name when it's representing recipient.
BillingAddressLocality String The city or town of the address.
BillingAddressOrganization String Optional organization name when it's representing recipient.
BillingAddressPostalCode String The address's postal code.
BillingAddressSubLocality String A civil region within the address's locality, if any.
BillingAddressSubLocality2 String A civil region within the address's sublocality, if any.
BillingAddressSubLocality3 String A civil region within the address's sublocality_2, if any.
BuyerEmailAddress String The buyer's email address.
Capabilities String Actions that can be performed on this payment:EDIT_AMOUNT_UP,EDIT_AMOUNT_DOWN,EDIT_TIP_AMOUNT_UP,EDIT_TIP_AMOUNT_DOWN
CardDetailsApplicationCryptogram String For EMV payments, the cryptogram generated for the payment.
CardDetailsApplicationIdentifier String For EMV payments, the application ID identifies the EMV application used for the payment.
CardDetailsApplicationName String For EMV payments, the human-readable name of the EMV application used for the payment.
CardDetailsAuthResultCode String The status code returned by the card issuer that describes the payment's authorization status.
CardDetailsAverageStatus String The status code returned from the Address Verification System (AVS) check.

使用できる値は次のとおりです。AVS_ACCEPTED, AVS_REJECTED, AVS_NOT_CHECKED

CardId String Unique ID for this card. Generated by Square.
CardBillingAddressLine1 String The first line of the address.
CardBillingAddressLine2 String The second line of the address, if any.
CardBillingAddressLine3 String The third line of the address, if any.
CardBillingAddressAdministrativeDistrictLevel1 String A civil entity within the address's country. In the US, this is the state.
CardBillingAddressAdministrativeDistrictLevel2 String A civil entity within the address's administrative_district_level_1. In the US, this is the county.
CardBillingAddressAdministrativeDistrictLevel3 String A civil entity within the address's administrative_district_level_2, if any.
CardBillingAddressCountry String The address's country, in ISO 3166-1-alpha-2 format.
CardBillingAddressFirstName String Optional first name when it's representing recipient.
CardBillingAddressLastName String Optional last name when it's representing recipient.
CardBillingAddressLocality String The city or town of the address.
CardBillingAddressOrganization String Optional organization name when it's representing recipient.
CardBillingAddressPostalCode String The address's postal code.
CardBillingAddressSubLocality String A civil region within the address's locality, if any.
CardBillingAddressSubLocality2 String A civil region within the address's sublocality, if any.
CardBillingAddressSubLocality3 String A civil region within the address's sublocality_2, if any.
CardBin String The first six digits of the card number, known as the Bank Identification Number (BIN). Only the Payments API returns this field.
CardType String The type of the card. The Card object includes this field only in response to Payments API calls.

使用できる値は次のとおりです。UNKNOWN_CARD_TYPE, CREDIT, DEBIT

CardholderName String The name of the cardholder.
CardCustomerId String The ID of a customer created using the Customers API to be associated with the card.
CardEnabled Boolean Indicates whether or not a card can be used for payments.
CardExpiryMonth Int64 The expiration month of the associated card as an integer between 1 and 12.
CardExpiryYear Int64 The four-digit year of the card's expiration date.
CardFingerprint String Intended as a Square-assigned identifier, based on the card number, to identify the card across multiple locations within a single application.
CardFingerprint String Intended as a Square-assigned identifier, based on the card number, to identify the card across multiple locations within a single application.
CardLast4 String The last 4 digits of the card number.
CardPrepaidType String Indicates whether the Card is prepaid or not. The Card object includes this field only in response to Payments API calls
CardReferenceId String An optional user-defined reference ID that associates this card with another entity in an external system.
CardVersion Int64 Current version number of the card. Increments with each card update.
CardTimelineAuthorizedAt Datetime The timestamp when the payment was authorized, in RFC 3339 format.
CardTimelineCapturedAt Datetime The timestamp when the payment was captured, in RFC 3339 format.
CardTimelineVoidedAt Datetime The timestamp when the payment was voided, in RFC 3339 format.
CardCVVStatus String The status code returned from the Card Verification Value (CVV) check.

使用できる値は次のとおりです。CVV_ACCEPTED, CVV_REJECTED, CVV_NOT_CHECKED

CardDeviceId String The Square-issued ID of the device.
CardDeviceInstallationId String The Square-issued installation ID for the device.
CardDeviceName String The name of the device set by the seller.
CardEntryMethod String The method used to enter the card's details for the payment.

使用できる値は次のとおりです。KEYED, SWIPED, EMV, ON_FILE, CONTACTLESS

RefundRequiresCardPresence Boolean Whether the card must be physically present for the payment to be refunded. If set to true, the card must be present.
CardStatementDescription String The statement description sent to the card networks.
CardStatus String The card payment's current state.

使用できる値は次のとおりです。AUTHORIZED, CAPTURED, VOIDED, FAILED

CardVerificationMethod String For EMV payments, the method used to verify the cardholder's identity.

使用できる値は次のとおりです。PIN, SIGNATURE, PIN_AND_SIGNATURE, ON_DEVICE, NONE

CardVerificationResults String For EMV payments, the results of the cardholder verification.

使用できる値は次のとおりです。SUCCESS, FAILURE, UNKNOWN

CashBuyerSupplierMoneyAmount Int64 The amount of money, in the smallest denomination of the currency indicated by currency.
CashBuyerSupplierMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
CashChangeBackMoneyAmount Int64 The amount of change due back to the buyer. This read-only field is calculated from the amount_money and buyer_supplied_money fields.
CashChangeBackMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
CreatedAt Datetime The timestamp of when the payment was created, in RFC 3339 format.
CustomerId String The Customer ID of the customer associated with the payment.
DelayAction String The action to be applied to the payment when the delay_duration has elapsed.
DelayDuration String The duration of time after the payment's creation when Square automatically applies the delay_action to the payment.
DelayedUntil Datetime The timestamp of when the delay_action is automatically applied, in RFC 3339 format.
EmployeeId String An optional ID of the employee associated with taking the payment.
ExternalDetailsSource String A description of the external payment source. For example, 'Food Delivery Service'.
ExternalDetailsType String The type of external payment the seller received.

使用できる値は次のとおりです。CHECK, BANK_TRANSFER, OTHER_GIFT_CARD, CRYPTO, SQUARE_CASH, SOCIAL, EXTERNAL, EMONEY, CARD, STORED_BALANCE, OTHER

ExternalDetailsSourceFeeMoneyAmount Int64 The fees paid to the source. The amount_money minus this field is the net amount seller receives.
ExternalDetailsSourceFeeMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
ExternalDetailsSourceId String An ID to associate the payment to its originating source.
LocationId String The ID of the location associated with the payment.
Note String An optional note to include when creating a payment.
OrderId String The ID of the order associated with the payment.
ProcessingFee String The processing fees and fee adjustments assessed by Square for this payment.
ReceiptNumber String The payment's receipt number. The field is missing if a payment is canceled.
ReceiptURL String The URL for the payment's receipt. The field is only populated for COMPLETED payments.
ReferenceId String An optional ID that associates the payment with an entity in another system.
RefundIds String A list of refund_ids identifying refunds for the payment.
RefundedMoneyAmount Int64 The total amount of the payment refunded to date.
RefundedMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
RiskEvaluationCreatedAt Datetime Provides information about the risk associated with the payment, as determined by Square.
RiskEvaluationLevel String The risk level associated with the payment.

使用できる値は次のとおりです。PENDING, NORMAL, MODERATE, HIGH

RiskEvaluationLevel String The risk level associated with the payment.

使用できる値は次のとおりです。PENDING, NORMAL, MODERATE, HIGH

ShippingAddressLine1 String The first line of the address.
ShippingAddressLine2 String The second line of the address, if any.
ShippingAddressLine3 String The third line of the address, if any.
ShippingAddressAdministrativeDistrictLevel1 String A civil entity within the address's country. In the US, this is the state.
ShippingAddressAdministrativeDistrictLevel2 String A civil entity within the address's administrative_district_level_1. In the US, this is the county.
ShippingAddressAdministrativeDistrictLevel3 String A civil entity within the address's administrative_district_level_2, if any.
ShippingAddressCountry String The address's country, in ISO 3166-1-alpha-2 format.
ShippingAddressFirstName String Optional first name when it's representing recipient.
ShippingAddressLastName String Optional last name when it's representing recipient.
ShippingAddressLocality String The city or town of the address.
ShippingAddressOrganization String Optional organization name when it's representing recipient.
ShippingAddressPostalCode String The address's postal code.
ShippingAddressSubLocality String A civil region within the address's locality, if any.
ShippingAddressSubLocality2 String A civil region within the address's sublocality, if any.
ShippingAddressSubLocality3 String A civil region within the address's sublocality_2, if any.
SourceType String The source type for this payment.

使用できる値は次のとおりです。CARD, BANK_ACCOUNT, CASH, EXTERNAL

StatementDescriptionIdentifier String Additional payment information that gets added to the customer's card statement as part of the statement description.
Status String Indicates whether the payment is APPROVED, PENDING, COMPLETED, CANCELED, or FAILED.
TipMoneyAmount Int64 The amount designated as a tip.
TipMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
TotalMoneyAmount Int64 The total amount for the payment, including amount_money and tip_money.
TotalMoneyCurrency String The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD.
UpdatedAt Datetime The timestamp of when the payment was last updated, in RFC 3339 format.
VersionToken String Used for optimistic concurrency. This opaque token identifies a specific version of the Payment object.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137