Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9111

TaxRegistrations

The tax registrations resource is used to query, update, and create tax registrations.

Table Specific Information

Select

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

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 any extra GET request to retrieve the UniqId.

Alternatively, if you want to apply any other filter. Please 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 API, use the child tables to add/update/delete aggregates.

Columns

Name Type ReadOnly Description
PartyTypeCode String False

The party type code of the party tax profile.

PartyName String False

The name of the party for which the party tax profile is defined.

PartyNumber String False

The party number for which the party tax profile is defined.

PartySiteNumber String False

The party site number for which the party tax profile is defined.

TaxRegimeCode String False

The tax regime code associated with a tax registration.

Tax String False

The tax code associated with a tax registration.

TaxJurisdictionCode String False

The location for which a tax registration is defined.

TaxPointBasis String False

The point in the receipt transaction process where taxes are accounted and reported to the tax authorities. Tax points can be classified into delivery-based and invoice-based categories.

RegistrationTypeCode String False

The tax registration type represents the legal type of tax for which a tax registration is issued, such as VAT.

RegistrationStatusCode String False

The registration status code for tax registrations.

RepresentativePartyTaxName String False

The name of the reporting party for tax registrations.

RegistrationReasonCode String False

The registration reason code for tax registrations.

EffectiveFrom Date False

The date when the tax registration for a period starts being effective.

EffectiveTo Date False

The date when the tax registration for a period stops being effective.

LegalRegistrationAddress String False

The address of the legal tax registration that is defined.

ValidationType String False

The validation type for tax registrations.

ValidationLevel String False

The level at which validation for duplicate registration numbers are raised to users. Possible values are ERROR and WARNING.

ValidationRule String False

The code for the validation that is to be applied to tax registration numbers for a tax regime.

RegistrationNumber String False

The company tax registration number assigned by a tax authority.

RegistrationSourceCode String False

The registration source code for tax registrations.

IssuingTaxAuthority String False

The issuing tax authority for a tax registration.

DefaultRegistrationFlag Bool False

Indicates whether a tax registration is set as default registration. The default value is FALSE.

RoundingRuleCode String False

The rule that defines how the rounding must be performed on a value involved in a taxable transaction. Possible values range from the next highest value to the next lowest or nearest value.

InclusiveTaxFlag Bool False

Indicates whether a tax registration is tax inclusive. The default value is FALSE.

BankAccountNumber String False

The bank account number associated with a tax registration.

TaxClassificationCode String False

The tax classification code associated with a tax registration.

UniquenessValidationLevel String False

The types of parties to be checked for duplicate tax registration numbers entered on a tax registration record.

Country String True

Country

PartyCountryCode String True

PartyCountryCode

BankBranchId Long False

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

BankId Long False

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

CollTaxAuthorityId Long False

The unique identifier for the collecting tax authority.

LegalLocationId Long False

The unique identifier of the legal location for a tax registration.

PartyTaxProfileId Long False

The unique identifier for the party tax profile.

RoundingLevelCode String False

The value that specifies the rounding to apply to tax amounts on a transaction. The valid values are HEADER and LINE.

TaxAuthorityId Long False

The unique identifier of the tax authority associated with an existing tax registration.

RegistrationId [KEY] Long False

The unique identifier of the system-generated primary key column.

RegistrationUniqId [KEY] String True

Use this column's value in insert, update and delete operations, wherever applicable, instead of RegistrationId

PartyTaxAllowOffsetTaxFlag Bool False

Indicates whether the party tax profile is set up to allow offset tax. The default value is FALSE.

PartyTaxRoundingLevelCode String False

The rounding level code defined for a tax registration associated with a party tax profile.

PartyTaxInclusiveTaxFlag Bool False

Indicates whether a party tax profile supports inclusive taxes. The default value is FALSE.

PartyTaxClassificationCode String False

The tax classification code for the party tax profile associated with a tax registration.

PartyTaxRoundingRuleCode String False

The rounding rule code for the party tax profile associated with a tax registration.

PartyTaxProcessForApplicabilityFlag Bool False

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

CountryCode String False

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

Finder String True

finder

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