TaxIds

Represents tax Ids, including the owner reference, tax Id type and value, and verification status details.

Table-Specific Information

SELECT

The driver 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 driver.


Column	Supported Operators
Id	=
OwnerType	=
OwnerAccount	=
OwnerCustomer	=
AccountId	=

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, specify OwnerType as account:

INSERT INTO TaxIds (Type, Value, OwnerType, OwnerAccount) VALUES ('eu_vat', 'DE993156911', 'account', 'acct_1B42lgHolImcIH68')

To create a tax Id on a particular customer, specify OwnerType as customer:

INSERT INTO TaxIds (Type, Value, OwnerType, OwnerCustomer) VALUES ('eu_vat', 'DE991911189', 'customer', 'cus_82RUaYXb4z4XFV')

To create a tax Id on the connected application, specify OwnerType as application along with the 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 unique identifier for the tax Id.
Country	String	True		The two-letter ISO code representing the country of the tax Id.
Customer	String	True	Customers.Id	The Id of the customer associated with the tax Id.
Type	String	False		The 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, za_vat, am_tin, ao_tin, ba_tin, bb_tin, bs_tin, cd_nif, gn_nif, kh_tin, li_vat, me_pib, mk_vat, mr_nif, np_pan, sn_ninea, sr_fin, tj_tin, ug_tin, zm_tin, zw_tin, al_tin, aw_tin, az_tin, bd_bin, bf_ifu, bj_ifu, by_tin, cm_niu, cv_nif, et_tin, fo_vat, gi_tin, it_cf, kg_tin, la_tin, lk_vat, ma_vat, md_vat, pl_nip, py_ruc, tz_vat, uz_tin or uz_vat. Note that some legacy tax Ids have the 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, am_tin, ao_tin, ba_tin, bb_tin, bs_tin, cd_nif, gn_nif, kh_tin, li_vat, me_pib, mk_vat, mr_nif, np_pan, sn_ninea, sr_fin, tj_tin, ug_tin, zm_tin, zw_tin, al_tin, aw_tin, az_tin, bd_bin, bf_ifu, bj_ifu, by_tin, cm_niu, cv_nif, et_tin, fo_vat, gi_tin, it_cf, kg_tin, la_tin, lk_vat, ma_vat, md_vat, pl_nip, py_ruc, tz_vat, uz_tin, uz_vat.
Value	String	False		The value of the tax Id.
Created	Datetime	True		The time at which the tax Id was created, measured in seconds since the Unix epoch.
Livemode	Boolean	True		Indicates whether the object exists in live mode. 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		The 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 the type is account.
OwnerCustomer	String	False		The customer being referenced when the type is customer.
OwnerApplication	String	True		The Connect application being referenced when the type is application.
VerificationStatus	String	True		The tax Id verification status, one of pending, verified, unverified, or unavailable.
VerificationVerifiedAddress	String	True		The verified address for the tax Id.
VerificationVerifiedName	String	True		The verified name for the tax Id.
Object	String	True		The string representing the object's type. Objects of the same type share the same value.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
AccountId	String	The Id of the connected account. Required when OwnerType = 'Application'.