PayoutEntries
Retrieves a list of all payout entries for a specific payout.
Table Specific Information
Select
The add-in uses the Square API to process the PayoutId filter, while other filters are processed client side within the add-in.
Retrieves a list of all payout entries for a specific payout. PayoutId is required to fetch PayoutEntries:
SELECT * FROM PayoutEntries where PayoutId='po_4d28e6c4-7dd5-4de4-8ec9-a059277646a6'
Columns
| Name | Type | Description |
| PayoutId | String | The ID of the payout to retrieve the information for. |
| Id [KEY] | String | A unique ID for the payout entry. |
| Type | String | The type of activity associated with this payout entry. |
| FeeAmountMoneyAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency. |
| FeeAmountMoneyCurrencyCode | String | The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD. |
| GrossAmountMoneyAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency. |
| GrossAmountMoneyCurrencyCode | String | The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD. |
| NetAmountMoneyAmount | Integer | The amount of money, in the smallest denomination of the currency indicated by currency. |
| NetAmountMoneyCurrencyCode | String | The type of currency, in ISO 4217 format. For example, the currency code for US dollars is USD. |
| TypeChargeDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeRefundDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeRefundDetailsRefundId | String | The ID of the refund associated with this activity. |
| EffectiveAt | Datetime | The timestamp of when the payout entry affected the balance, in RFC 3339 format. |
| TypeAppFeeRevenueDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeAppFeeRevenueDetailsLocationId | String | The ID of the location of the merchant associated with the payment activity. |
| TypeAppFeeRefundDetailsPaymentId | String | Details of a refund for an app fee on a payment. |
| TypeAppFeeRefundDetailsLocationId | String | The ID of the location of the merchant associated with the payment refund activity. |
| TypeAppFeeRefundDetailsRefundId | String | The ID of the refund associated with this activity. |
| TypeAutomaticSavingsDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeAutomaticSavingsDetailsPayoutId | String | The ID of the payout associated with this activity. |
| TypeAutomaticSavingsReversedDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeAutomaticSavingsReversedDetailsPayoutId | String | The ID of the payout associated with this activity. |
| TypeDepositFeeDetailsPayoutId | String | The ID of the payout that triggered this deposit fee activity. |
| TypeDisputeDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeDisputeDetailsDisputeId | String | The ID of the dispute associated with this activity. |
| TypeFeeDetailsPaymentId | String | The ID of the payment associated with this activity This will only be populated when a principal LedgerEntryToken is also populated. |
| TypeFreeProcessingDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeHoldAdjustmentDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeOpenDisputeDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeOpenDisputeDetailsDisputeId | String | The ID of the dispute associated with this activity. |
| TypeOtherDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeOtherAdjustmentDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeReleaseAdjustmentDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeReleaseHoldDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeReleaseReleaseDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeSquareCapitalPaymentDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeSquareCapitalReversedPaymentDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeTaxOnFeeDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeTaxOnFeeDetailsTaxRateDescription | String | The description of the tax rate being applied. For example: |
| TypeThirdPartyFeeDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeThirdPartyFeeRefundDetailsPaymentId | String | The ID of the payment associated with this activity. |
| TypeThirdPartyFeeRefundDetailsRefundId | String | The public refund id associated with this activity. |