ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

TaxExemptions

Manages records of exempted transactions or entities, allowing authorized users to view, add, or modify tax exemption details.

Columns

Name Type Description
PartyTypeCode String The code indicating the type of party associated with the tax exemption, such as supplier or customer.
PartyName String The name of the party granted the tax exemption.
PartyNumber String The unique identifier number associated with the party receiving the tax exemption.
PartySiteNumber String The site number of the party related to the tax exemption, used to identify the specific location of the party.
PartyType String The type of party (for example, Customer or Supplier) associated with the tax exemption.
ExemptionUsageCode String The code used to define the specific activity or purpose for which a tax exemption is granted.
TaxRegimeCode String The tax regime under which the tax exemption is applied, helping to determine its applicability and calculation.
ContentOwner String The owner responsible for configuring or managing the tax exemption, such as a legal entity or department.
Tax String The specific tax or category of tax for which the exemption is applicable.
TaxStatusCode String The status of the tax exemption, indicating its validity or any special conditions like 'approved', 'rejected', etc.
TaxRateCode String The tax rate code associated with the tax exemption, defining the rate at which tax is applied to transactions.
TaxJurisdictionCode String The code identifying the geographic jurisdiction for which the tax exemption is granted.
ItemNumber String The item number for which the tax exemption applies, especially relevant for product-specific exemptions.
Organization String The name of the inventory organization associated with the exempted item, relevant for inventory-based tax exemptions.
EffectiveFrom Date The start date from which the tax exemption is effective and valid.
EffectiveTo Date The date when the tax exemption expires or stops being valid.
ExemptCertificateNumber String The unique certificate number identifying the tax exemption, typically issued by the tax authority.
RecordingDate Date The date when the tax exemption was recorded in the system.
IssueDate Date The date when the tax exemption was officially issued by the relevant tax authority.
ExemptionTypeCode String The type of exemption granted, such as DISCOUNT, SURCHARGE, or SPECIAL RATE, indicating how the exemption is applied.
RateModifier Decimal The percentage rate or modification applied to the tax exemption, such as the exemption percentage.
ExemptionStatusCode String The status of the exemption, such as PRIMARY, MANUAL, DISCONTINUED, REJECTED, or UNAPPROVED.
IssuingTaxAuthority String The tax authority that granted the exemption, indicating where the exemption was issued.
ApplyToLowerLevelsFlag Bool A flag indicating whether the exemption applies to lower tax levels in the tax hierarchy (for example, state, county).
SuspendFromDate Date The date from which the exemption status is suspended, often due to non-compliance or changes in tax laws.
SuspendToDate Date The date until which the exemption is suspended, after which the exemption may be reinstated or discontinued.
LimitAmount Decimal The dollar amount limit associated with the tax exemption, above which the exemption no longer applies.
ExemptReasonCode String The reason code explaining why the exemption was granted, such as for a particular activity or condition.
ClauseReference String A reference to the legal clause that justifies or mandates the tax exemption under specific regulations.
IssueFlag Bool Indicates whether the Letter of Intent for the tax exemption is created and ready for issuance.
PartyTypeFlag Bool Indicates whether the exemption is applicable to a customer or a supplier, with the default typically set to CUSTOMER.
PrintFlag Bool A flag that marks whether the tax exemption letter is ready for printing, used for compliance documentation.
PartyUsage String The intended use of the party (for example, 'Retail', 'Wholesale') related to the tax exemption.
Country String The country where the tax exemption applies, typically corresponding to national tax regulations.
ContentOwnerId Long The unique identifier of the content owner responsible for the tax exemption configuration.
CustomerAccountId Long The unique identifier of the customer account associated with the tax exemption.
CustomChargeFlag Bool Indicates whether the exemption should apply to custom charges or if it applies to standard tax amounts.
DetFactorTemplCode String The determining factor template code linked to the tax exemption, helping to define how the exemption is applied.
InventoryOrgId Long The unique identifier of the inventory organization associated with an item that benefits from the tax exemption.
IssuingTaxAuthorityId Long The unique identifier of the tax authority that issued the exemption.
PartyTaxProfileId Long The unique identifier of the party tax profile, providing detailed tax settings for the exemption.
ProductId Long The unique identifier of the product that the tax exemption applies to, if the exemption is product-specific.
RecordTypeCode String The code indicating the record type of the tax exemption, used to categorize different exemption types.
SiteUseId Long The unique identifier of the site use associated with the tax exemption, relevant for location-based exemptions.
TaxJurisdictionId Long The unique identifier of the tax jurisdiction where the exemption is applicable.
TaxExemptionId [KEY] Long The unique identifier of the tax exemption record, typically generated by the system.
ReportingTypeId Long The unique identifier of the reporting type associated with the tax exemption, used for reporting purposes.
ReportingCodeId Long The unique identifier of the reporting code associated with the tax exemption.
ReportingTypeName String The name of the reporting type linked to the tax exemption, used for classification in reports.
ReportingCodeName String The name of the reporting code linked to the tax exemption.
ReportingCodeChar String The value of the reporting code used for reporting tax exemption details.
PartyTaxAllowOffsetTaxFlag Bool Indicates whether the party's tax profile allows the use of offset tax calculations for transactions.
PartyTaxRoundingLevelCode String The rounding level to be applied to the party tax amounts, ensuring compliance with local tax rounding rules.
PartyTaxInclusiveTaxFlag Bool Indicates whether the party's tax profile has been configured for inclusive tax calculations.
PartyTaxClassificationCode String The classification code indicating the specific tax treatment for the party's tax profile.
PartyTaxRoundingRuleCode String The rounding rule applied to party tax amounts, ensuring that tax amounts are rounded correctly.
PartyTaxProcessForApplicabilityFlag Bool Indicates whether the party's tax profile is part of the tax determination process for transactions.
Finder String A search helper field to assist with querying tax exemptions based on specific criteria.

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