TransactionTax

A tax is a classification of a charge imposed by a government through a fiscal or tax authority.

Expand all

Collapse all

Business Views

** Available for extracting data

• transactionTaxExtract**

  A tax is a classification of a charge imposed by a government through a fiscal or tax authority.

  Label, Plural Label

  Taxes, Transaction Taxes

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • 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

  • allowManualEntryFlag (boolean)

    Indicates whether the user can enter manual tax lines for transactions for the event class, in addition to automatically calculated tax lines.

    Label

    Allow entry of manual tax lines

  • allowRecoverabilityFlag (boolean)

    Indicates whether tax recovery is determined for the event class.

    Label

    Allow tax recovery

  • allowTaxOverrideFlag (boolean)

    Indicates whether the user can override automatically calculated tax lines for transactions for the event class.

    Label

    Allow override of calculated tax lines

    Properties

    • not readable
  • applicabilityRuleFlag (boolean)

    Indicates whether rules are defined to determine applicability of this tax. Valid values are Y and N.

    Label

    Applicability Rule

  • appliedAmountHandlingCode (enumeration: AppliedAmountHandlingCode)

    Lookup code to indicate how the tax amount of a prepayment in Payables is to be handled when it's applied to an invoice.

    Label

    Applied Amount Handling

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: AppliedAmountHandlingCode

    Properties

    • not readable

    Valid Values

    • P
    • R
  • compoundingPrecedence (big-decimal)

    Indicates the order in which taxes should be calculated when compounding of taxes is defined.

    Label

    Compounding Precedence

  • contentOwnerId (int64)

    The unique identifier of the party tax profile of the first party organization of the transaction.

    Label

    Configuration Owner

    Properties

    • not nullable
  • defaultPlaceOfSupplyTypeCode (enumeration: PlaceOfSupplyType)

    The specific tax jurisdiction where the supply of goods or services is deemed to have taken place.

    Label

    Default Place of Supply

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: PlaceOfSupplyType

    Properties

    • not readable

    Valid Values

    • BILL_FROM
    • BILL_TO
    • FINAL_DISCHARGE
    • POA
    • POO
    • SHIP_FROM
    • SHIP_TO
    • SHIP_TO_BILL_TO
    • TAX_REG_NUMBER_FIRST_PARTY
    • TAX_REG_NUMBER_THIRD_PARTY
  • defaultTaxCalculationFormula (string)

    A formula used in tax calculation. The standard tax formula multiplies the tax rate by the line amount to get the tax amount.

    Label

    Tax Calculation Formula

  • defaultTaxableBasisFormula (string)

    A formula that defines the taxable basis which is the amount upon which to apply the tax rate.

    Label

    Taxable Basis Formula

  • effectiveFrom (date)

    The date on which a task, event or business process begins. Use for date enabled entities for which histories aren't stored.

    Label

    Start Date

  • effectiveTo (date)

    The date on which a task, event or business process ends. Use for date enabled entities for which histories aren't stored.

    Label

    End Date

  • 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
  • liveForApplicabilityFlag (boolean)

    For internal use to handle location based taxes migrated from prior releases for Receivables.

    Label

    Live for Applicability

    Properties

    • not readable
  • liveForProcessingFlag (boolean)

    Indicates whether this tax is ready to be processed during tax calculation. Before this flag can be set to Y, the application validates that the basic configuration like default status, and others for this tax is complete. Valid values Y and N.

    Label

    Enable tax for transactions

  • maximumTaxAmountThreshold (big-decimal)

    The maximum tax amount threshold value.

    Label

    Maximum Tax Amount Threshold

  • maximumTaxRateThreshold (big-decimal)

    The maximum tax rate used as threshold.

    Label

    Maximum Tax Rate Threshold

  • maximumTaxableBasisThreshold (big-decimal)

    The maximum taxable basis used as threshold amount.

    Label

    Maximum Taxable Basis Threshold

  • minimumAccountableTaxableAmount (big-decimal)

    The minimum accountable unit for rounding the taxable amount.

    Label

    Taxable Basis Minimum Accountable Unit

  • minimumAccountableUnit (big-decimal)

    The minimum accountable unit for the currency that doesn't correspond to the standard precision, for example, if the currency represents 0.001 and minimum accountable unit may represent 0.025 then calculations for this currency would be rounded off to 0.025 (minimum accountable unit), not 0.001 (standard precision).

    Label

    Minimum Accountable Unit

  • minimumTaxAmountThreshold (big-decimal)

    The minimum tax amount threshold value.

    Label

    Minimum Tax Amount Threshold

  • minimumTaxableBasisThreshold (big-decimal)

    The minimum taxable basis used as threshold amount.

    Label

    Minimum Taxable Basis Threshold

  • offsetTaxFlag (boolean)

    A tax rate that acts as a negative tax to fully or partially reduce another tax.

    Label

    Set as offset tax

  • primaryRecoveryTypeCode (enumeration: TaxRecoveryTypeCode)

    The primary recovery type code that's applicable for this tax.

    Label

    Primary Recovery Type

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: TaxRecoveryTypeCode

    Properties

    • not readable

    Valid Values

    • Average
    • PREC
    • PREC1
    • RECOVERABLE
    • SREC
    • SREC1
    • STANDARD
  • recoveryRateOverrideFlag (boolean)

    Indicates whether the tax recovery rate can be overridden for this tax. Valid values are Y and N.

    Label

    Allow tax recovery rate override

  • reportingOnlyFlag (boolean)

    Indicates whether this tax line is created for reporting only.

    Label

    Set tax for reporting purposes only

  • roundingRuleCode (enumeration: RoundingRuleCode)

    The rule that defines how the rounding should be performed on a value involved in a taxable transaction.

    Label

    Rounding Rule

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: RoundingRuleCode

    Valid Values

    • DOWN
    • NEAREST
    • UP
  • tax (string)

    The classification of a charge imposed by a government through a fiscal or tax authority.

    Label

    Tax

    Properties

    • searchable
    • sortable
    • not nullable
  • taxAccountCreateMethodCode (enumeration: TaxAccountCreationMethodCode)

    Lookup code to indicate whether for this tax, the user will define GL account defaults specific to this tax, or will make use of the defaults specified for another tax

    Label

    Tax Accounts Creation Method

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: TaxAccountCreationMethodCode

    Valid Values

    • CREATE_ACCOUNTS
    • USE_ACCOUNTS
  • taxExemptionCreationMethodCode (enumeration: TaxExemptCreationMethodCode)

    Lookup code to indicate whether for this tax, the user will define exemptions specific to this tax, or will also make use of the exemptions specified for another tax if an exemption specific to this tax isn't found.

    Label

    Use tax exemptions from an existing tax

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: TaxExemptCreationMethodCode

    Valid Values

    • CREATE_EXEMPTIONS
    • USE_EXEMPTIONS
  • 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

  • taxPointBasis (enumeration: TaxPointBasis)

    Indicates the event on which the tax is levied, accounted in the books and reported to the tax authorities. The tax point basis can be accounting, delivery, invoice or payment.

    Label

    Tax Point Basis

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: TaxPointBasis

    Properties

    • not readable

    Valid Values

    • ACCOUNTING
    • DELIVERY
    • INVOICE
    • PAYMENT
  • taxPrecision (big-decimal)

    A one-digit whole number to indicate the decimal place for tax rounding.

    Label

    Tax Precision

  • taxRateThresholdFlag (boolean)

    Indicates whether tax rate threshold is applicable for this tax. Valid values are Y and N.

    Label

    Tax Rate Threshold

  • taxRegimeCode (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
  • taxTypeCode (enumeration: TaxTypeCategory)

    The code for a grouping of taxes into a high level classification, not bounded to a tax regime.

    Label

    Tax Type

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: TaxTypeCategory

    Valid Values

    • AWT
    • CRE-M
    • CUSTOMS DUTY
    • DEB-M
    • DED
    • EDP
    • EEC
    • ENVIRONMENTAL
    • EXCISE
    • Excise tax

    For a complete list of valid values, see the TaxTypeCategory enumeration type.

  • taxableBasisThresholdFlag (boolean)

    Indicates whether taxable basis threshold is applicable for this tax. Valid values are Y and N.

    Label

    Taxable Basis Threshold

  • thresholdGroupingLevelCode (enumeration: ThresholdBucketLevelCode)

    The lookup code to indicate grouping level for applying thresholds across or within documents, lines, or calendar periods for this tax regime.

    Label

    Threshold Grouping Level Code

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: ThresholdBucketLevelCode

    Properties

    • not readable

    Valid Values

    • A
    • P
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • not readable
    • not nullable
  • uniquenessValidationLevelCode (enumeration: UniquenessValidationLevel)

    The types of parties checked for duplicate tax registration numbers on a registration record. If values aren't specified at the tax regime, tax, or tax jurisdiction levels, the value defined at the tax reporting type level will be used.

    Label

    Duplicate Validation Level

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: UniquenessValidationLevel

    Properties

    • not readable

    Valid Values

    • ALL_PARTIES
    • ALL_THIRD_PARTIES
    • CUSTOMERS
    • NONE
    • SAME_PARTY
    • SUPPLIERS
  • validationLevelCode (enumeration: ValidationLevel)

    A lookup code to indicate whether validation is based on an error or a warning.

    Label

    Validation Level

    Type

    • Module: oraErpCoreTaxSetup

    • Enumeration Type: ValidationLevel

    Properties

    • not readable

    Valid Values

    • ERROR
    • NONE
    • WARNING

Back to Top