TaxRate
The tax rate is a percentage of an amount, a value per unit quantity, or a fixed sum per transaction at which an individual or corporation is taxed and is effective for a period of time.
Business Views
** Available for extracting data- taxRateExtract**
The tax rate is a percentage of an amount, a value per unit quantity, or a fixed sum per transaction at which an individual or corporation is taxed and is effective for a period of time.
Label, Plural Label
Tax Rates, Tax Rates
Data Source
Read-optimized data store
Fields
- activeFlag (boolean)
Indicates whether this tax rate is active. A list of accepted values is defined in the lookup type YES_NO.
Label
Active
Properties
- searchable
- sortable
- adjustedForAdhocAmountCode (enumeration: AdjustmentForAdhocAmountCode)
Indicates whether tax rate or taxable basis is to be adjusted when tax amount is changed for tax lines with ad hoc tax rate.
Label
Adjustment for Ad Hoc Tax Amounts
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: AdjustmentForAdhocAmountCode
Valid Values
- TAXABLE_BASIS
- TAX_RATE
-
- allowAdhocTaxRateFlag (boolean)
Indicates whether override of the default tax rate is allowed on individual tax lines.
Label
Allow Ad Hoc Tax Rate
- allowExceptionsFlag (boolean)
Indicates whether tax exceptions can be set up for this tax rate.
Label
Allow Tax Exceptions
- allowExemptionsFlag (boolean)
Indicates whether tax exemptions can be set up for taxes.
Label
Allow Tax Exemptions
- code (string)
A unique code for a tax rate. A tax rate is the rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity.
Label
Tax Rate Code
Properties
- searchable
- sortable
- not nullable
- defaultFlagEffectiveFrom (date)
The date that defines when the tax rate designated as the default becomes applicable when no other tax rate can be determined.
Label
Default Start Date
- defaultFlagEffectiveTo (date)
The date that defines when the tax rate designated as the default stops being applicable when no other tax rate can be determined.
Label
Default End Date
- defaultRateFlag (boolean)
Designates a tax rate as the default, which should become applicable on a transaction when all of the defined tax rules to identify the tax rate aren't applicable.
Label
Set as default rate
- defaultRecoverySettlementOptionCode (enumeration: RecoverySettlementOptionCode)
The default used for recovery settlement which is either immediate (typically invoice time) or deferred (typically when payment is made).
Label
Default Settlement Option
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: RecoverySettlementOptionCode
Valid Values
- ACCOUNTING
- DEFERRED
- DELIVERY
- IMMEDIATE
- PAYMENT
-
- effectiveFrom (date)
Date at the beginning of the date range during which a given record will be available for transacting for date effective entities.
Label
Effective Start Date
Properties
- searchable
- sortable
- not nullable
- effectiveTo (date)
Date at the end of a date range during which a given record is be available for transacting. Use for date effective entities only.
Label
Effective End Date
- id (int64)
The unique identifier of the tax rate.
Label
Rate ID
Properties
- searchable
- sortable
- not nullable
- inclusiveTaxType (enumeration: InclusiveTaxTypeCode)
Defines the nature of tax inclusive handling for the tax rate.
Label
Tax Inclusion Method
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: InclusiveTaxTypeCode
Valid Values
- N
- S
- Y
-
- percentageRate (big-decimal)
The percentage applied to the taxable basis, which is the taxable amount, to arrive at the calculated tax amount.
Label
Rate Percentage
- quantityRate (big-decimal)
The rate that becomes applicable on the quantity involved in a transaction for the calculation of the tax involved. For example, if the quantity rate is 50 USD per unit and if a taxable transaction has 100 units, then the calculated tax would be 5000 USD.
Label
Rate Quantity
- recoveryTypeCode (enumeration: TaxRecoveryTypeCode)
The mechanism to administer the recovery process for a specific tax.
Label
Recovery Type Code
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: TaxRecoveryTypeCode
Properties
- searchable
- sortable
Valid Values
- Average
- PREC
- PREC1
- RECOVERABLE
- SREC
- SREC1
- STANDARD
-
- taxClass (string)
Indicates if the tax rate code is applicable for procure-to-pay, order-to-cash flows, or both.
Label
Tax Class
Properties
- searchable
- sortable
- taxInclusiveOverrideFlag (boolean)
Indicates whether changing the setting for tax inclusive handling is allowed at the tax level.
Label
Allow Override and Entry of Inclusive Tax Lines
- timeCreated (date-time)
The date and time when the tax rate row was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the tax rate row was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- typeCode (enumeration: TaxRateType)
A classification to indicate whether the tax rate is a percentage or a quantity based rate.
Label
Tax Rate Type
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: TaxRateType
Properties
- searchable
- sortable
Valid Values
- GROSS_AMT_SCHEDULE_RATE
- LINE_AMT_SCHEDULE_RATE
- PERCENTAGE
- QUANTITY
- RECOVERY
- SCHEDULE_RATE
- SCHEDULE_RECOVERY_RATE
- UNIT_PRICE_SCHEDULE_RATE
- WITHHELD_AMT_SCHEDULE_RATE
-
- vatTransactionTypeCode (enumeration: VatTransactionCode)
A lookup code that can be assigned to tax rate codes to define local tax authority codes both for reporting purposes and for controlling which rates appear on an invoice.
Label
Tax Transaction Type
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: VatTransactionCode
Valid Values
- 100
- 110
- 120
- 1P
- 1S
- 200
- 210
- 220
- 2P
- 2S
For a complete list of valid values, see the VatTransactionCode enumeration type.
-
Reference Object
- contentOwner (TaxProfile)
The unique identifier of the party tax profile of the first party organization of the transaction.
Business Object
TaxProfileFields
- id (int64)
The unique identifier of the party of the tax profile.
Label
Party Tax Profile ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- defaultRecoveryRate (TaxRate)
Indicates whether a default tax recovery rate is defined for the tax.
Business Object
TaxRateFields
- code (string)
A unique code for a tax rate. A tax rate is the rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity.
Label
Tax Rate Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- offsetStatus (TaxStatus)
A unique code for the taxable nature of a product in the context of a transaction for a tax. An offset rate is a negative tax rate used to fully or partially reduce the value of another tax.
Business Object
TaxStatusFields
- code (string)
The unique identifier of the tax status row when combined with tax regime code, tax, and content owner.
Label
Tax Status Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- offsetTaxRate (TaxRate)
The code for the tax rate that acts as a negative tax to fully or partially reduce another tax.
Business Object
TaxRateFields
- code (string)
A unique code for a tax rate. A tax rate is the rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity.
Label
Tax Rate Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- sourceTax (TransactionTax)
The source from which the tax code is migrated. It's only applicable for migrated tax codes.
Business Object
TransactionTaxFields
- id (int64)
The unique identifier of the tax. This is a primary key of the Transaction Taxes view object.
Label
Tax ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- taxInformation (TransactionTax)
A tax is a classification of a charge imposed by a government through a fiscal or tax authority.
Business Object
TransactionTaxFields
- tax (string)
The classification of a charge imposed by a government through a fiscal or tax authority.
Label
Tax
Properties
- searchable
- sortable
- not nullable
- tax (string)
- taxJurisdiction (TaxJurisdiction)
Tax jurisdiction represents a geographic area where a tax is levied by a specific tax authority.
Business Object
TaxJurisdictionFields
- code (string)
A unique code for a tax jurisdiction. A tax jurisdiction is a geographic area where a tax is levied by a specific tax authority.
Label
Tax Jurisdiction Code
Properties
- not nullable
- code (string)
- taxRegime (TaxRegime)
The tax regime is a set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
Business Object
TaxRegimeFields
- code (string)
A unique code for a tax regime. A tax regime is the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
Label
Tax Regime Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- taxStatus (TaxStatus)
The tax status represents the taxable nature of a product in the context of a transaction for a tax.
Business Object
TaxStatusFields
- code (string)
The unique identifier of the tax status row when combined with tax regime code, tax, and content owner.
Label
Tax Status Code
Properties
- searchable
- sortable
- not nullable
- code (string)
- taxableBasisFormula (TaxFormula)
A formula that defines the taxable basis which is the amount upon which to apply the tax rate.
Business Object
TaxFormulaFields
- code (string)
The unique code for a tax formula. A tax formula is used to define the taxable basis and tax calculation for a given tax.
Label
Tax Formula Code
Properties
- not nullable
- code (string)
- uom (UnitOfMeasure)
Unit of Measure - A predetermined amount or quantity or quality, such as of length, time, heat, value that's adopted as a standard of measurement.
Business Object
UnitOfMeasureFields
- name (string)
Name of the unit of measure. This attribute is required.
Label
Name
Properties
- creatable
- translatable
- not nullable
- name (string)
- activeFlag (boolean)