Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

TaxPayerIdentifiers

Stores taxpayer identification data (for example, TIN, VAT ID), facilitating correct tax reporting for businesses or individuals.

Columns

Name Type Description
PartyTypeCode String The code indicating the type of party (for example, 'Supplier', 'Customer') for which the tax profile is defined.
PartyName String The name of the party (for example, organization or individual) associated with the tax profile.
PartyNumber String The unique number assigned to the party for tax purposes.
PartySiteNumber String The site number associated with the party, identifying a specific location for tax registration.
ValidationType String The type of validation applied to ensure the correctness of the taxpayer identifier.
TaxPayerNumber String The tax identification number assigned to the party for tax reporting and compliance.
ValidationDigit String A validation digit used as part of the Tax Indentification Number (TIN) to confirm its validity.
EffectiveFrom Date The start date when the taxpayer identifier becomes valid for the specified period.
EffectiveTo Date The end date when the taxpayer identifier is no longer valid.
ReportingTypeCode String The code indicating the reporting type for the taxpayer identifier, used in tax filings.
CountryCode String The country code for the country where the tax registration number is issued or applicable.
ValidationLevel String The level at which validations are applied to avoid duplicates in registration numbers.
UniquenessValidationLevel String The specific level at which the system performs checks to identify duplicate tax registration numbers.
RegistrationTypeCode String The classification of the tax registration specified by the tax authority for reporting purposes.
CountryName String The name of the country where the taxpayer is registered for tax purposes.
EntityId Long The unique identifier for the entity linked to the taxpayer identifier.
PartyTaxpayerIdntfsId [KEY] Long The system-generated primary key identifier for the taxpayer record.
TaxpayerCountry String The country where the taxpayer is registered for tax purposes.
PartyTaxAllowOffsetTaxFlag Bool Indicates whether the party's tax profile allows for offset tax calculation. Default is NO.
PartyTaxRoundingLevelCode String Specifies the rounding rules applied to party tax amounts during transactions.
PartyTaxInclusiveTaxFlag Bool Indicates whether the party's tax profile allows for inclusive tax calculation. Default is NO.
PartyTaxClassificationCode String The tax classification code used for the party's tax profile associated with the taxpayer identifier.
PartyTaxRoundingRuleCode String The rounding rule applied to the party's tax profile associated with the taxpayer identifier.
PartyTaxProcessForApplicabilityFlag Bool Indicates whether the party tax profile is used in the tax determination process for transactions.
Country String The country associated with the taxpayer identifier.
Finder String A helper field used for searching and filtering taxpayer identifiers.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454