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 |