CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

TaxRegistrations

Controls creation and updates of tax registrations, linking registered entities to corresponding tax codes and authorities.

Table-Specific Information

Select

The connector uses the Oracle Fusion Cloud Financials API to process some of the filters having 'queryable'='true' in metadata. The connector processes other filters within the connector.

For example, the following query is processed server-side: 

SELECT * FROM [Cdata].[Financials].[TaxRegistrations] WHERE RegistrationId = 10003

Insert

Create a TaxRegistrations. 

INSERT INTO [Cdata].[Financials].[TaxRegistrations] (PartyTypeCode,PartySiteNumber,TaxRegimeCode) VALUES ('THIRD_PARTY_SITE', '1151', 'US SALES AND USE TAX')

Update

The Oracle Fusion Cloud Financials API uses RegistrationUniqId instead of RegistrationId as a path parameter in the URL to update the record.

If you want to update a record directly using the Id (without any other filter), you can update the record in the following way: 

Update [Cdata].[Financials].[TaxRegistrations] SET RegistrationNumber='67794246-AL' WHERE RegistrationUniqId = 454545454;

Note: This does not require an extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter, use RegistrationId instead of RegistrationUniqId. You can update the record in the following way: 

Update [Cdata].[Financials].[TaxRegistrations] SET RegistrationNumber='67794246-AL' WHERE RegistrationId = 454545454 and CustomerName='Test';

Note: Update on aggregates are not allowed by the API. Use the child tables to add/update/delete aggregates.

Columns

Name Type ReadOnly Description
PartyTypeCode String False

The code that defines the party type (for example, 'Supplier',' Customer') for the tax profile.

PartyName String False

The name of the party (company or individual) associated with the tax profile.

PartyNumber String False

The unique identifier for the party to which the tax registration belongs.

PartySiteNumber String False

The site number associated with the party's tax registration.

TaxRegimeCode String False

The code representing the tax regime under which the registration is issued, such as VAT.

Tax String False

The tax code applicable to the tax registration for the party.

TaxJurisdictionCode String False

The code indicating the tax jurisdiction (location) where the tax registration is valid.

TaxPointBasis String False

Specifies the basis of the tax point (for example, delivery-based or invoice-based) for tax reporting.

RegistrationTypeCode String False

The type of tax registration, such as VAT or Sales Tax, that is associated with the party.

RegistrationStatusCode String False

The status of the tax registration, indicating whether it is active or pending.

RepresentativePartyTaxName String False

The name of the party representing the taxpayer in the registration.

RegistrationReasonCode String False

The reason for obtaining the tax registration, such as starting business operations.

EffectiveFrom Date False

The date from which the tax registration is valid.

EffectiveTo Date False

The date until which the tax registration is valid.

LegalRegistrationAddress String False

The registered address associated with the tax registration.

ValidationType String False

The type of validation used for ensuring the correctness of the tax registration.

ValidationLevel String False

The level of validation applied to prevent duplicate tax registration numbers (for example, ERROR, WARNING).

ValidationRule String False

The code for the specific validation rule applied to tax registration numbers.

RegistrationNumber String False

The unique tax registration number assigned by the tax authority.

RegistrationSourceCode String False

The source code indicating where the tax registration originates from.

IssuingTaxAuthority String False

The tax authority responsible for issuing the tax registration.

DefaultRegistrationFlag Bool False

Indicates whether this is the default registration for the party. The default is FALSE.

RoundingRuleCode String False

The rounding rule applied to tax calculations for this registration. Defines how rounding is performed (for example, round up, round down).

InclusiveTaxFlag Bool False

Indicates whether the tax registration includes tax in its calculations (default is FALSE).

BankAccountNumber String False

The bank account number associated with the tax registration.

TaxClassificationCode String False

The tax classification code relevant to this tax registration.

UniquenessValidationLevel String False

The validation level applied to ensure no duplicate tax registration numbers are used.

Country String True

The country where the tax registration is applicable.

PartyCountryCode String True

The country code used to identify the tax registration jurisdiction.

BankBranchId Long False

The unique identifier for the bank branch associated with the tax registration.

BankId Long False

The unique identifier for the bank where the party's tax-related transactions are managed.

CollTaxAuthorityId Long False

The unique identifier for the collecting tax authority associated with the registration.

LegalLocationId Long False

The unique identifier for the legal location tied to the tax registration.

PartyTaxProfileId Long False

The unique identifier for the tax profile associated with the party.

RoundingLevelCode String False

Defines the level of rounding applied to tax amounts during calculations, such as HEADER or LINE.

TaxAuthorityId Long False

The unique identifier of the tax authority managing the tax registration.

RegistrationId [KEY] Long False

The system-generated identifier for the tax registration record.

RegistrationUniqId [KEY] String True

A unique identifier to be used for insert, update, and delete operations, instead of RegistrationId.

PartyTaxAllowOffsetTaxFlag Bool False

Indicates whether the party tax profile allows offset tax calculations. Default is FALSE.

PartyTaxRoundingLevelCode String False

Specifies the rounding level for taxes in the party's tax profile.

PartyTaxInclusiveTaxFlag Bool False

Indicates whether the party's tax profile supports inclusive tax calculations. Default is FALSE.

PartyTaxClassificationCode String False

The classification code for tax purposes associated with the party's tax profile.

PartyTaxRoundingRuleCode String False

The rounding rule code associated with the party's tax profile.

PartyTaxProcessForApplicabilityFlag Bool False

Indicates whether the party tax profile is applied during the tax determination process.

CountryCode String False

The code used to validate the tax registration number for the party.

Finder String True

A helper field for searching or filtering tax registration records.

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