TaxIds
Creates, deletes and queries the Tax Ids in Stripe.
Table Specific Information
Select
Server-Side Query Support
The connector uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.
- Id, OwnerType, OwnerAccount, OwnerCustomer and AccountId support the following operator: =.
You can select:
A tax id by specifying its Id:
SELECT * FROM TaxIds WHERE Id = 'txi_1Q3XrEATXQzBWNrlcebspJzb'
Tax ids associated with an account:
SELECT * FROM TaxIds WHERE OwnerType = 'account' AND OwnerAccount = 'acct_1B42lgHolImcIH68'
Tax ids associated with a customer:
SELECT * FROM TaxIds WHERE OwnerType = 'customer' AND OwnerCustomer = 'cus_82RUaYXb4z4XFV'
Tax ids associated with an application (Either provide the account id in the query or in the AccountId connection property):
SELECT * FROM TaxIds WHERE OwnerType = 'application' AND AccountId = 'acct_1B42lgHolImcIH68'
Tax ids associated with the current authenticated account:
SELECT * FROM TaxIds
Insert
The Type and Value columns are required to create a new tax id:
INSERT INTO TaxIds (Type, Value) VALUES ('eu_vat', 'DE131156989')
To create a tax id on a particular account use OwnerType = 'account':
INSERT INTO TaxIds (Type, Value, OwnerType, OwnerAccount) VALUES ('eu_vat', 'DE993156911', 'account', 'acct_1B42lgHolImcIH68')
To create a tax id on a particular customer use OwnerType = 'customer':
INSERT INTO TaxIds (Type, Value, OwnerType, OwnerCustomer) VALUES ('eu_vat', 'DE991911189', 'customer', 'cus_82RUaYXb4z4XFV')
To create a tax id on the connected application use OwnerType = 'application' along with AccountId:
INSERT INTO TaxIds (Type, Value, OwnerType, AccountId) VALUES ('eu_vat', 'DE999411789', 'application', 'acct_1B42lgHolImcIH68')
Delete
To delete a tax id, specify the Id:
DELETE FROM TaxIds WHERE Id = 'txi_1Q3XrEATXQzBWNrlcebspJzb'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Id of the tax codes. | |
| Country | String | True |
Two-letter ISO code representing the country of the tax ID. | |
| Customer | String | True |
ID of the customer. | |
| Type | String | False |
Type of the tax ID, one of ad_nrt, ae_trn, ar_cuit, au_abn, au_arn, bg_uic, bh_vat, bo_tin, br_cnpj, br_cpf, ca_bn, ca_gst_hst, ca_pst_bc, ca_pst_mb, ca_pst_sk, ca_qst, ch_uid, ch_vat, cl_tin, cn_tin, co_nit, cr_tin, de_stn, do_rcn, ec_ruc, eg_tin, es_cif, eu_oss_vat, eu_vat, gb_vat, ge_vat, hk_br, hr_oib, hu_tin, id_npwp, il_vat, in_gst, is_vat, jp_cn, jp_rn, jp_trn, ke_pin, kr_brn, kz_bin, li_uid, mx_rfc, my_frp, my_itn, my_sst, ng_tin, no_vat, no_voec, nz_gst, om_vat, pe_ruc, ph_tin, ro_tin, rs_pib, ru_inn, ru_kpp, sa_vat, sg_gst, sg_uen, si_tin, sv_nit, th_vat, tr_tin, tw_vat, ua_vat, us_ein, uy_ruc, ve_rif, vn_tin, or za_vat. Note that some legacy tax IDs have type unknown. The allowed values are ad_nrt, ae_trn, ar_cuit, au_abn, au_arn, bg_uic, bh_vat, bo_tin, br_cnpj, br_cpf, ca_bn, ca_gst_hst, ca_pst_bc, ca_pst_mb, ca_pst_sk, ca_qst, ch_uid, ch_vat, cl_tin, cn_tin, co_nit, cr_tin, de_stn, do_rcn, ec_ruc, eg_tin, es_cif, eu_oss_vat, eu_vat, gb_vat, ge_vat, hk_br, hr_oib, hu_tin, id_npwp, il_vat, in_gst, is_vat, jp_cn, jp_rn, jp_trn, ke_pin, kr_brn, kz_bin, li_uid, mx_rfc, my_frp, my_itn, my_sst, ng_tin, no_vat, no_voec, nz_gst, om_vat, pe_ruc, ph_tin, ro_tin, rs_pib, ru_inn, ru_kpp, sa_vat, sg_gst, sg_uen, si_tin, sv_nit, th_vat, tr_tin, tw_vat, ua_vat, unknown, us_ein, uy_ruc, ve_rif, vn_tin, za_vat. | |
| Value | String | False |
Value of the tax ID. | |
| Created | Datetime | True |
Time at which the object was created. Measured in seconds since the Unix epoch. | |
| Livemode | Boolean | True |
Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
| OwnerType | String | False |
Type of owner referenced. The default value is 'self'. The allowed values are account, application, customer, self. | |
| OwnerAccount | String | False |
The account being referenced when type is account. | |
| OwnerCustomer | String | False |
The customer being referenced when type is customer. | |
| OwnerApplication | String | True |
The Connect Application being referenced when type is application. | |
| VerificationStatus | String | True |
Tax ID verification status, one of pending, verified, unverified, or unavailable. | |
| VerificationVerifiedAddress | String | True |
Tax ID Verified address. | |
| VerificationVerifiedName | String | True |
Tax ID Verified name. | |
| Object | String | True |
String representing the object’s type. Objects of the same type share the same value. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AccountId | String |
The Id of the connected account. Required when OwnerType = 'Application'. |