TaxIds

Returns the tax Ids in Stripe and supports creating and deleting them.

Table-Specific Information

SELECT

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.


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 of the tax Id.
Country	String	True		The two-letter ISO code representing the country of the tax Id.
Customer	String	True		The Id of the customer.
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 or zw_tin. 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, 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.
Value	String	False		The value of the tax Id.
Created	Datetime	True		The date and time at which the object was created, measured in seconds since the Unix epoch.
Livemode	Boolean	True		Indicates whether the object exists in live mode. The value is true in live mode and false 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 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		The tax Id verification status, one of pending, verified, unverified, or unavailable.
VerificationVerifiedAddress	String	True		The tax Id verified address.
VerificationVerifiedName	String	True		The tax Id verified name.
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'.