TaxIds

Creates, deletes and queries the Tax Ids in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

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. 使用できる値は次のとおりです。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'. 使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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

SSIS Components for Stripe