UserBillingHistory
Query the Billing History in Wordpress.
Table Specific Information
SELECT
The connector processes all the filters client-side within the connector.
SELECT * FROM UserBillingHistory
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the billing record. | |
| Address | String | The billing address associated with the user's account. | |
| Amount | String | The total billed amount, including the currency symbol. | |
| AmountInteger | Int | The billed amount expressed in the smallest currency unit (for example, cents). | |
| BillingHistoryTotal | Int | The total number of billing records available for the user. | |
| Date | Datetime | The date and time when the transaction occurred. | |
| CCDisplayBrand | String | The display name or brand of the credit card used for the transaction. | |
| CCEmail | String | The email address linked to the credit card account. | |
| CCName | String | The name of the credit card holder. | |
| CCNum | String | The masked credit card number displayed for reference. | |
| CCType | String | The type or category of credit card used (for example, Visa or MasterCard). | |
| Credit | String | The amount of credit or discount applied to this transaction. | |
| Currency | String | The three-letter currency code used for the transaction (for example, USD or EUR). | |
| Desc | String | A description of the billing item or service charged. | |
| Icon | String | The resource path or URL for the icon image representing the billing item. | |
| Items | String | A list of items or services included in the billing transaction. | |
| Org | String | The organization responsible for issuing the billing or payment request. | |
| PayPart | String | The payment partner or processor used to complete the transaction. | |
| PayRef | String | The reference or charge ID from the payment processor for this transaction. | |
| Service | String | The platform, product, or service associated with the billed item. | |
| ServiceSlug | String | A URL- and code-friendly version of the service name. | |
| Subtotal | String | The subtotal amount displayed in readable currency format before taxes or additional fees. | |
| SubtotalInteger | Int | The subtotal amount represented in the smallest currency unit (for example, cents). | |
| Support | String | The URL to the customer support page related to this billing item or service. | |
| Tax | String | The total amount of tax charged for this transaction. | |
| TaxCountryCode | String | The ISO country code for the country where the tax was applied. | |
| TaxExternalId | String | The external tax ID or reference code associated with the applied tax. | |
| TaxInteger | Int | The taxed amount represented in the smallest currency unit (for example, cents). | |
| TaxVendorInfo | String | Metadata or response details returned by the third-party tax service provider. | |
| UpcomingCharges | String | The total amount scheduled for the next billing or renewal period. | |
| ItemURL | String | The full URL linking to this billing record in the user's billing history. | |
| Volume | String | The quantity of items or units included in this billing record. |