| Column Name | Column Data Type |
|---|
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
account_id
List of unique account identifiers. | VARCHAR |
account_meta_data
The meta data information associated with the account. | STRUCT(
"account_name" VARCHAR,
"address" STRUCT(
"address_line1" VARCHAR,
"address_line2" VARCHAR,
"address_line3" VARCHAR,
"city" VARCHAR,
"country_code" VARCHAR,
"district_or_county" VARCHAR,
"postal_code" VARCHAR,
"state_or_region" VARCHAR
),
"address_role_map" MAP(VARCHAR, STRUCT(
"country_code" VARCHAR,
"state_or_region" VARCHAR
)),
"address_type" VARCHAR,
"seller" VARCHAR
) |
Show child fields- account_meta_data.account_name
The Amazon Web Services accounts name. - account_meta_data.address
The details of the address associated with the TRN information. Show child fields- account_meta_data.address.address_line1
The first line of the address. - account_meta_data.address.address_line2
The second line of the address, if applicable. - account_meta_data.address.address_line3
The third line of the address, if applicable. Currently, the Tax Settings API accepts the addressLine3 parameter only for Saudi Arabia. When you specify a TRN in Saudi Arabia, you must enter the addressLine3 and specify the building number for the address. For example, you might enter 1234. - account_meta_data.address.city
The city that the address is in. - account_meta_data.address.country_code
The country code for the country that the address is in. - account_meta_data.address.district_or_county
The district or county the address is located. For addresses in Brazil, this parameter uses the name of the neighborhood. When you set a TRN in Brazil, use districtOrCounty for the neighborhood name. - account_meta_data.address.postal_code
The postal code associated with the address. - account_meta_data.address.state_or_region
The state, region, or province that the address is located. If this is required for tax settings, use the same name as shown on the Tax Settings page.
- account_meta_data.address_role_map
Address roles associated with the account containing country code information. - account_meta_data.address_type
The type of address associated with the legal profile. - account_meta_data.seller
Seller information associated with the account.
|
tax_inheritance_details
Tax inheritance information associated with the account. | STRUCT(
"inheritance_obtained_reason" VARCHAR,
"parent_entity_id" VARCHAR
) |
Show child fields- tax_inheritance_details.inheritance_obtained_reason
Tax inheritance reason information associated with the account. - tax_inheritance_details.parent_entity_id
Tax inheritance parent account information associated with the account.
|
tax_registration
Your TRN information. Instead of having full legal address, here TRN information will have jurisdiction details (for example, country code and state/region/province if applicable). | STRUCT(
"additional_tax_information" STRUCT(
"brazil_additional_info" STRUCT(
"ccm_code" VARCHAR,
"legal_nature_code" VARCHAR
),
"canada_additional_info" STRUCT(
"canada_quebec_sales_tax_number" VARCHAR,
"canada_retail_sales_tax_number" VARCHAR,
"is_reseller_account" BOOLEAN,
"provincial_sales_tax_id" VARCHAR
),
"estonia_additional_info" STRUCT(
"registry_commercial_code" VARCHAR
),
"georgia_additional_info" STRUCT(
"person_type" VARCHAR
),
"india_additional_info" STRUCT(
"pan" VARCHAR
),
"israel_additional_info" STRUCT(
"customer_type" VARCHAR,
"dealer_type" VARCHAR
),
"italy_additional_info" STRUCT(
"cig_number" VARCHAR,
"cup_number" VARCHAR,
"sdi_account_id" VARCHAR,
"tax_code" VARCHAR
),
"kenya_additional_info" STRUCT(
"person_type" VARCHAR
),
"malaysia_additional_info" STRUCT(
"service_tax_codes" VARCHAR[]
),
"poland_additional_info" STRUCT(
"individual_registration_number" VARCHAR,
"is_group_vat_enabled" BOOLEAN
),
"romania_additional_info" STRUCT(
"tax_registration_number_type" VARCHAR
),
"saudi_arabia_additional_info" STRUCT(
"tax_registration_number_type" VARCHAR
),
"south_korea_additional_info" STRUCT(
"business_representative_name" VARCHAR,
"item_of_business" VARCHAR,
"line_of_business" VARCHAR
),
"spain_additional_info" STRUCT(
"registration_type" VARCHAR
),
"turkey_additional_info" STRUCT(
"industries" VARCHAR,
"kep_email_id" VARCHAR,
"secondary_tax_id" VARCHAR,
"tax_office" VARCHAR
),
"ukraine_additional_info" STRUCT(
"ukraine_trn_type" VARCHAR
)
),
"certified_email_id" VARCHAR,
"jurisdiction" STRUCT(
"country_code" VARCHAR,
"state_or_region" VARCHAR
),
"legal_name" VARCHAR,
"registration_id" VARCHAR,
"registration_type" VARCHAR,
"sector" VARCHAR,
"status" VARCHAR,
"tax_document_metadatas" STRUCT(
"tax_document_access_token" VARCHAR,
"tax_document_name" VARCHAR
)[]
) |
Show child fields- tax_registration.additional_tax_information
Additional tax information associated with your TRN. Show child fields- tax_registration.additional_tax_information.brazil_additional_info
Additional tax information associated with your TRN in Brazil. The Tax Settings API returns this information in your response when any additional information is present with your TRN in Brazil. Show child fields- tax_registration.additional_tax_information.brazil_additional_info.ccm_code
The Cadastro de Contribuintes Mobiliários (CCM) code for your TRN in Brazil. This only applies for a CNPJ tax type for the São Paulo municipality. - tax_registration.additional_tax_information.brazil_additional_info.legal_nature_code
Legal nature of business, based on your TRN in Brazil. This only applies for a CNPJ tax type.
- tax_registration.additional_tax_information.canada_additional_info
Additional tax information associated with your TRN in Canada. Show child fields- tax_registration.additional_tax_information.canada_additional_info.canada_quebec_sales_tax_number
The Quebec Sales Tax ID number. Leave blank if you do not have a Quebec Sales Tax ID number. - tax_registration.additional_tax_information.canada_additional_info.canada_retail_sales_tax_number
Manitoba Retail Sales Tax ID number. Customers purchasing Amazon Web Services for resale in Manitoba must provide a valid Retail Sales Tax ID number for Manitoba. Leave this blank if you do not have a Retail Sales Tax ID number in Manitoba or are not purchasing Amazon Web Services for resale. - tax_registration.additional_tax_information.canada_additional_info.is_reseller_account
The value for this parameter must be true if the provincialSalesTaxId value is provided for a TRN in British Columbia, Saskatchewan, or Manitoba provinces. To claim a provincial sales tax (PST) and retail sales tax (RST) reseller exemption, you must confirm that purchases from this account were made for resale. Otherwise, remove the PST or RST number from the provincialSalesTaxId parameter from your request. - tax_registration.additional_tax_information.canada_additional_info.provincial_sales_tax_id
The provincial sales tax ID for your TRN in Canada. This parameter can represent the following: -
Provincial sales tax ID number for British Columbia and Saskatchewan provinces -
Manitoba retail sales tax ID number for Manitoba province -
Quebec sales tax ID number for Quebec province The Tax Setting API only accepts this parameter if the TRN is specified for the previous provinces. For other provinces, the Tax Settings API doesn't accept this parameter.
- tax_registration.additional_tax_information.estonia_additional_info
Additional tax information associated with your TRN in Estonia. Show child fields- tax_registration.additional_tax_information.estonia_additional_info.registry_commercial_code
Registry commercial code (RCC) for your TRN in Estonia. This value is an eight-numeric string, such as 12345678.
- tax_registration.additional_tax_information.georgia_additional_info
Additional tax information associated with your TRN in Georgia. Show child fields- tax_registration.additional_tax_information.georgia_additional_info.person_type
The legal person or physical person assigned to this TRN in Georgia.
- tax_registration.additional_tax_information.india_additional_info
Additional tax information in India. Show child fields- tax_registration.additional_tax_information.india_additional_info.pan
India pan information associated with the account.
- tax_registration.additional_tax_information.israel_additional_info
Additional tax information associated with your TRN in Israel. Show child fields- tax_registration.additional_tax_information.israel_additional_info.customer_type
Customer type for your TRN in Israel. The value can be Business or Individual. Use Businessfor entities such as not-for-profit and financial institutions. - tax_registration.additional_tax_information.israel_additional_info.dealer_type
Dealer type for your TRN in Israel. If you're not a local authorized dealer with an Israeli VAT ID, specify your tax identification number so that Amazon Web Services can send you a compliant tax invoice.
- tax_registration.additional_tax_information.italy_additional_info
Additional tax information associated with your TRN in Italy. Show child fields- tax_registration.additional_tax_information.italy_additional_info.cig_number
The tender procedure identification code. - tax_registration.additional_tax_information.italy_additional_info.cup_number
Additional tax information to specify for a TRN in Italy. This is managed by the Interministerial Committee for Economic Planning (CIPE) which characterizes every public investment project (Individual Project Code). - tax_registration.additional_tax_information.italy_additional_info.sdi_account_id
Additional tax information to specify for a TRN in Italy. Use CodiceDestinatario to receive your invoices via web service (API) or FTP. - tax_registration.additional_tax_information.italy_additional_info.tax_code
List of service tax codes for your TRN in Italy. You can use your customer tax code as part of a VAT Group.
- tax_registration.additional_tax_information.kenya_additional_info
Additional tax information associated with your TRN in Kenya. Show child fields- tax_registration.additional_tax_information.kenya_additional_info.person_type
The legal person or physical person assigned to this TRN in Kenya.
- tax_registration.additional_tax_information.malaysia_additional_info
Additional tax information associated with your TRN in Malaysia. Show child fields- tax_registration.additional_tax_information.malaysia_additional_info.service_tax_codes[]
- tax_registration.additional_tax_information.poland_additional_info
Additional tax information associated with your TRN in Poland. Show child fields- tax_registration.additional_tax_information.poland_additional_info.individual_registration_number
The individual tax registration number (NIP). Individual NIP is valid for other taxes excluding VAT purposes. - tax_registration.additional_tax_information.poland_additional_info.is_group_vat_enabled
True if your business is a member of a VAT group with a NIP active for VAT purposes. Otherwise, this is false.
- tax_registration.additional_tax_information.romania_additional_info
Additional tax information to specify for a TRN in Romania. Show child fields- tax_registration.additional_tax_information.romania_additional_info.tax_registration_number_type
The tax registration number type. The value can be TaxRegistrationNumber or LocalRegistrationNumber.
- tax_registration.additional_tax_information.saudi_arabia_additional_info
Additional tax information associated with your TRN in Saudi Arabia. Show child fields- tax_registration.additional_tax_information.saudi_arabia_additional_info.tax_registration_number_type
The tax registration number type.
- tax_registration.additional_tax_information.south_korea_additional_info
Additional tax information associated with your TRN in South Korea. Show child fields- tax_registration.additional_tax_information.south_korea_additional_info.business_representative_name
The business legal name based on the most recently uploaded tax registration certificate. - tax_registration.additional_tax_information.south_korea_additional_info.item_of_business
Item of business based on the most recently uploaded tax registration certificate. - tax_registration.additional_tax_information.south_korea_additional_info.line_of_business
Line of business based on the most recently uploaded tax registration certificate.
- tax_registration.additional_tax_information.spain_additional_info
Additional tax information associated with your TRN in Spain. Show child fields- tax_registration.additional_tax_information.spain_additional_info.registration_type
The registration type in Spain.
- tax_registration.additional_tax_information.turkey_additional_info
Additional tax information associated with your TRN in Turkey. Show child fields- tax_registration.additional_tax_information.turkey_additional_info.industries
The industry information that tells the Tax Settings API if you're subject to additional withholding taxes. This information required for business-to-business (B2B) customers. This information is conditionally mandatory for B2B customers who are subject to KDV tax. - tax_registration.additional_tax_information.turkey_additional_info.kep_email_id
The Registered Electronic Mail (REM) that is used to send notarized communication. This parameter is optional for business-to-business (B2B) and business-to-government (B2G) customers. It's not required for business-to-consumer (B2C) customers. - tax_registration.additional_tax_information.turkey_additional_info.secondary_tax_id
Secondary tax ID (“harcama birimi VKN”si”). If one isn't provided, we will use your VKN as the secondary ID. - tax_registration.additional_tax_information.turkey_additional_info.tax_office
The tax office where you're registered. You can enter this information as a string. The Tax Settings API will add this information to your invoice. This parameter is required for business-to-business (B2B) and business-to-government customers. It's not required for business-to-consumer (B2C) customers.
- tax_registration.additional_tax_information.ukraine_additional_info
Additional tax information associated with your TRN in Ukraine. Show child fields- tax_registration.additional_tax_information.ukraine_additional_info.ukraine_trn_type
The tax registration type.
- tax_registration.certified_email_id
The email address to receive VAT invoices. - tax_registration.jurisdiction
The jurisdiction associated with your TRN information. Show child fields- tax_registration.jurisdiction.country_code
The country code of the jurisdiction. - tax_registration.jurisdiction.state_or_region
The state, region, or province associated with the country of the jurisdiction, if applicable.
- tax_registration.legal_name
The legal name associated with your TRN information. - tax_registration.registration_id
Your tax registration unique identifier. - tax_registration.registration_type
The type of your tax registration. This can be either VAT or GST. - tax_registration.sector
The industry that describes your business. For business-to-business (B2B) customers, specify Business. For business-to-consumer (B2C) customers, specify Individual. For business-to-government (B2G), specify Government.Note that certain values may not applicable for the request country. Please refer to country specific information in API document. - tax_registration.status
The status of your TRN. This can be either Verified, Pending, Deleted, or Rejected. - tax_registration.tax_document_metadatas[]
Show child fields- tax_registration.tax_document_metadatas[].tax_document_access_token
The tax document access token, which contains information that the Tax Settings API uses to locate the tax document. If you update your tax registration, the existing taxDocumentAccessToken won't be valid. To get the latest token, call the GetTaxRegistration or ListTaxRegistrations API operation. This token is valid for 24 hours. - tax_registration.tax_document_metadatas[].tax_document_name
The name of your tax document.
|