ADO.NET Provider for Stripe

Build 24.0.9062

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'.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062