PurchaseTransactionTaxLine

A purchase transaction tax line represents the tax information associated with a transaction line of a purchase transaction.

Expand all

Collapse all

Business Views

** Available for extracting data

• purchaseTransactionTaxLineExtract**

  A purchase transaction tax line represents the tax information associated with a transaction line of a purchase transaction.

  Label, Plural Label

  Purchase Transaction Tax Lines, Purchase Transaction Tax Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • appliedFromEntityCode (string)

    The entity code of the applied from document.

    Label

    Applied from Document Entity Code

    Properties

    • inherited
  • appliedFromEventClassCode (string)

    The event class code of the applied from document.

    Label

    Applied from Document Event Class Code

    Properties

    • inherited
  • appliedFromTransactionLevelType (string)

    Indicates the level at which the identifier of the applier from document line is stored for the detailed tax line. Possible values are LINE, SHIPMENT, and FREIGHT.

    Label

    Applied from Transaction Level Type

    Properties

    • inherited
  • appliedFromTransactionNumber (string)

    The transaction number of the applied from document.

    Label

    Applied from Document Transaction Number

    Properties

    • inherited
  • calculatedTaxAmount (big-decimal)

    The calculated tax amount prior to rounding.

    Label

    Calculated Tax Amount

    Properties

    • inherited
  • calculatedTaxAmountFunctionalCurrency (big-decimal)

    The system calculated tax amount in ledger currency.

    Label

    Calculated Tax Amount in Ledger Currency

    Properties

    • inherited
  • calculatedTaxAmountTaxCurrency (big-decimal)

    The system calculated tax amount in tax currency.

    Label

    Calculated Tax Amount in Tax Currency

    Properties

    • inherited
  • calculatedTaxableAmount (big-decimal)

    The calculated taxable amount for the tax line.

    Label

    Calculated Taxable Amount

    Properties

    • inherited
  • cancelFlag (boolean)

    Indicates whether the tax line is canceled.

    Label

    Canceled

    Properties

    • inherited
  • compoundingTaxFlag (boolean)

    Indicates whether another tax line is compounded on this tax line.

    Label

    Compound Tax Indicator

    Properties

    • inherited
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • inherited
    • not nullable
  • enforceFromNaturalAccountFlag (boolean)

    Indicates whether this tax line is enforced from the natural account. This indicates whether tax applied to the transaction is assigned to the accounting segment of the transaction line.

    Label

    Enforce from Natural Account

    Properties

    • inherited
  • entityCode (enumeration: EntityCode)

    Entity code of the transaction, which indicates the type of transaction being created. Entity codes standardize the interaction with applications.

    Label

    Entity Code

    Type

    • Module: oraErpCoreTax

    • Enumeration Type: EntityCode

    Properties

    • inherited
    • searchable
    • not nullable

    Valid Values

    • ADJUSTMENTS
    • AP_INVOICES
    • CHARGE_ESTIMATE
    • CONSUMPTION_ADVICE
    • CONSUMPTION_TRANSACTION
    • FISCAL_DOCUMENT
    • INV_MATERIAL_TXNS
    • ORDER
    • PO_RCV_CHARGES
    • PURCHASE_ORDER

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

  • eventClassCode (enumeration: EventClassCode)

    The event class code of the line for the detailed tax transaction.

    Label

    Event Class Code

    Type

    • Module: oraErpCoreTax

    • Enumeration Type: EventClassCode

    Properties

    • inherited
    • searchable
    • not nullable

    Valid Values

    • ADVANCE_RECEIPT
    • CHARGE_ESTIMATE
    • CONSUMPTION_ADVICE
    • CREDIT_MEMO
    • DEBIT_MEMO
    • EXPENSE REPORTS
    • FISCAL_DOCUMENT
    • FISCAL_DOCUMENT_CAPTURE
    • FSCL_SALES_TRANSACTION
    • INVOICE_ADJUSTMENT

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

  • eventTypeCode (string)

    The event type code of the application for the detailed tax transaction.

    Label

    Application Event Type Code

    Properties

    • inherited
  • exceptionRate (big-decimal)

    The rate associated with a tax exception. A tax exception is a condition or combination of conditions that result in a change from the standard values for a particular product.

    Label

    Exception Rate

    Properties

    • inherited
  • exemptRateModifier (big-decimal)

    The number associated with a specific tax exemption.

    Label

    Exempt Percentage

    Properties

    • inherited
  • exemptReason (string)

    The reason a tax exemption was granted and taken.

    Label

    Tax Exemption Reason

    Properties

    • inherited
  • freezeUntilOverriddenFlag (boolean)

    Indicates whether this tax line from the reference document should be applicable to this document even though it isn't found applicable based on the tax determination process.

    Label

    Freeze Until Overridden

    Properties

    • inherited
  • grossNetCode (enumeration: TaxGrossNetCode)

    Indicates whether the tax is applied on the gross amount or net amount on retainage.

    Label

    Gross or Net Indicator

    Type

    • Module: oraErpCoreTax

    • Enumeration Type: TaxGrossNetCode

    Properties

    • inherited

    Valid Values

    • G
    • N
  • hqEstablishmentRegistrationNumber (string)

    The tax registration number of the first-party headquarters establishment in the transaction. This is important for reporting purposes.

    Label

    Headquarters Registration Number

    Properties

    • inherited
    • allowAccessWithSkipDataSecurity
    • searchable
  • lastManualEntry (string)

    Indicates the value last overridden by the user on the tax line. It could either be the tax status, tax rate, tax rate code or tax amount.

    Label

    Last Manual Entry

    Properties

    • inherited
  • legalEntityTaxRegistrationNumber (int64)

    The unique identifier of the legal entity of the transaction.

    Label

    Legal Entity ID

    Properties

    • inherited
    • allowAccessWithSkipDataSecurity
  • legalMessageBasis (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for taxable basis.

    Label

    Legal Message for Taxable Basis

    Properties

    • inherited
  • legalMessageCalc (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for tax calculation.

    Label

    Legal Message for Tax Calculation

    Properties

    • inherited
  • legalMessageException (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for exceptions.

    Label

    Legal Message for Exceptions

    Properties

    • inherited
  • legalMessageExemption (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for exemptions.

    Label

    Legal Message for Exemptions

    Properties

    • inherited
  • legalMessagePos (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for place of supply.

    Label

    Legal Message for Place of Supply

    Properties

    • inherited
  • legalMessageRate (big-decimal)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for tax rate determination.

    Label

    Legal Message for Rate Determination

    Properties

    • inherited
  • legalMessageStatus (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for status determination.

    Label

    Legal Message for Status Determination

    Properties

    • inherited
  • legalMessageTaxRegistrationNumber (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for tax registration numbers.

    Label

    Legal Message for Tax Registration Number

    Properties

    • inherited
  • legalMessageThreshold (int64)

    A mandatory, standardized message provided on a fiscal document to conform to legal requirements for thresholds.

    Label

    Legal Message for Thresholds

    Properties

    • inherited
  • lineAmount (big-decimal)

    A monetary amount associated to the transaction line.

    Label

    Line Amount

    Properties

    • inherited
  • manuallyEnteredFlag (boolean)

    Indicates whether the tax line is manually entered by the user.

    Label

    Manually Entered

    Properties

    • inherited
  • multipleJurisdictionsFlag (boolean)

    Indicates whether the tax of this tax line has multiple jurisdictions.

    Label

    Multiple Jurisdictions

    Properties

    • inherited
  • nonRecoverableTaxAmount (big-decimal)

    Part of the tax amount, that's included in the line amount, that can't be recovered.

    Label

    Nonrecoverable Tax Amount

    Properties

    • inherited
  • nonRecoverableTaxAmountFunctionalCurrency (big-decimal)

    The tax amount that can't be recovered for a tax line. The amount is in the ledger currency.

    Label

    Nonrecoverable Tax Amount in Ledger Currency

    Properties

    • inherited
  • nonRecoverableTaxAmountTaxCurrency (big-decimal)

    The tax amount that can't be recovered for a tax line. The amount is in the tax currency.

    Label

    Nonrecoverable Tax Amount in Tax Currency

    Properties

    • inherited
  • offsetFlag (boolean)

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

    Label

    Offset Tax

    Properties

    • inherited
  • offsetTaxRateCode (string)

    The code for the tax rate that acts as a negative tax to fully or partially reduce another tax.

    Label

    Offset Tax Rate Code

    Properties

    • inherited
  • originalTaxAmount (big-decimal)

    The value of the tax amount in the currency of the transaction currency before the user overrides the detailed tax line.

    Label

    Original Tax Amount in Entered Currency

    Properties

    • inherited
  • originalTaxAmountTaxCurrency (big-decimal)

    The original tax amount in tax currency prior to user override.

    Label

    Original Tax Amount in Tax Currency

    Properties

    • inherited
  • originalTaxJurisdictionCode (string)

    The original tax jurisdiction code prior to user override.

    Label

    Original Tax Jurisdiction Code

    Properties

    • inherited
  • originalTaxPointDate (date)

    The value of the tax point date before the user overrides the detailed tax line.

    Label

    Original Tax Point Date

    Properties

    • inherited
  • originalTaxRate (big-decimal)

    The original tax rate prior to user override.

    Label

    Original Tax Rate

    Properties

    • inherited
  • originalTaxRateCode (string)

    The original tax rate code prior to user override.

    Label

    Original Tax Rate Code

    Properties

    • inherited
  • originalTaxStatusCode (string)

    The original tax status code prior to user override.

    Label

    Original Tax Status Code

    Properties

    • inherited
  • originalTaxableAmount (big-decimal)

    The original taxable amount prior to user override.

    Label

    Original Taxable Amount

    Properties

    • inherited
  • originalTaxableAmountTaxCurrency (big-decimal)

    The original taxable amount in tax currency prior to user override.

    Label

    Original Taxable Amount in Tax Currency

    Properties

    • inherited
  • otherDocumentLineAmount (big-decimal)

    The line amount on the other document for the tax line.

    Label

    Other Document Line Amount

    Properties

    • inherited
  • otherDocumentLineTaxAmount (big-decimal)

    The line tax amount on the other document for the tax line.

    Label

    Other Document Line Tax Amount

    Properties

    • inherited
  • otherDocumentLineTaxableAmount (big-decimal)

    The taxable amount on the other document for the tax line.

    Label

    Other Document Line Taxable Amount

    Properties

    • inherited
  • otherDocumentSource (string)

    The source of the other document.

    Label

    Other Document Source

    Properties

    • inherited
  • overriddenFlag (boolean)

    Indicates whether user has overridden the tax line.

    Label

    Overridden

    Properties

    • inherited
  • placeOfSupply (big-decimal)

    The lookup code for the place of supply of the tax line.

    Label

    Place of Supply

    Properties

    • inherited
  • placeOfSupplyTypeCode (string)

    The identifier for the place of supply type for the detailed tax line.

    Label

    Place of Supply Type Code

    Properties

    • inherited
  • proratedTotalTaxAmount (big-decimal)

    Tax amount derived by the tax rate on prepayment based on applied amount handling method.

    Label

    Prorated Total Tax Amount

    Properties

    • inherited
  • proratedTotalTaxAmountFunctionalCurrency (big-decimal)

    Tax amount in entered currency converted into ledger currency.

    Label

    Prorated Total Tax Amount in Ledger Currency

    Properties

    • inherited
  • proratedTotalTaxAmountTaxCurrency (big-decimal)

    Tax amount in entered currency converted into tax currency.

    Label

    Prorated Total Tax Amount in Tax Currency

    Properties

    • inherited
  • providerRecoveryRate (big-decimal)

    The recovery rate returned by the tax provider for generating recoverable tax distributions.

    Label

    Provider Recovery Rate

    Properties

    • inherited
  • providerRecoveryRateCode (string)

    The recovery rate code returned by the tax provider for generating recoverable tax distributions.

    Label

    Provider Recovery Rate Code

    Properties

    • inherited
  • recTaxAmount (big-decimal)

    The part of the tax amount on a transaction that can be recovered.

    Label

    Recoverable Tax Amount

    Properties

    • inherited
  • recTaxAmountFunctionalCurrency (big-decimal)

    The tax amount that can be recovered for the tax line. The amount is shown in the ledger currency.

    Label

    Recoverable Tax Amount in Ledger Currency

    Properties

    • inherited
  • recTaxAmountTaxCurrency (big-decimal)

    The tax amount that can be recovered for the tax line. The amount is in the tax currency.

    Label

    Recoverable Tax Amount in Tax Currency

    Properties

    • inherited
  • registrationPartyType (string)

    The party type derived from processing the Determine Tax Registration rule.

    Label

    Registration Party Type

    Properties

    • inherited
  • reportableFlag (boolean)

    Indicates whether the tax line is reportable.

    Label

    Reportable

    Properties

    • inherited
  • reportingOnlyFlag (boolean)

    Indicates whether this tax line is created for reporting only.

    Label

    Reporting Only

    Properties

    • inherited
  • roundingLevelCode (string)

    The code for the value that specifies the rounding to apply to tax amounts on a transaction.

    Label

    Rounding Level Code

    Properties

    • inherited
  • roundingLevelPartyType (string)

    Predefined value for type of the party used for determining rounding level code.

    Label

    Rounding Level Party Type

    Properties

    • inherited
  • roundingRuleCode (string)

    The code associated with the rule that defines how the rounding should be performed on a value involved in a taxable transaction. For example, up to the next highest value, down to the next lowest value, or nearest.

    Label

    Rounding Rule Code

    Properties

    • inherited
  • selfAssessedFlag (boolean)

    A tax line calculated on a transaction, which doesn't appear on the documents given by the supplier. The self-assessed tax is directly calculated and remitted to the concerned tax authorities by the customer involved in the transaction.

    Label

    Self-Assessed

    Properties

    • inherited
  • tax (string)

    The tax code associated with the detailed tax line.

    Label

    Tax

    Properties

    • inherited
  • taxAmount (big-decimal)

    The tax amount in the currency of the transaction for the detailed tax line. In case the user overrides the tax amount, this value is updated with the overridden value, and the override mark will indicate that this amount has been overridden.

    Label

    Tax Amount

    Properties

    • inherited
  • taxAmountFunctionalCurrency (big-decimal)

    Tax amount in ledger currency which is the amount in entered currency converted into ledger currency.

    Label

    Tax Amount in Ledger Currency

    Properties

    • inherited
  • taxAmountTaxCurrency (big-decimal)

    Tax amount in entered currency, which is the currency used in transactions.

    Label

    Tax Amount in Tax Currency

    Properties

    • inherited
  • taxApportionmentFlag (boolean)

    Indicates whether there are multiple tax lines created for the tax of this line during migration from prior releases.

    Label

    Tax Apportionment

    Properties

    • inherited
  • taxApportionmentLineNumber (big-decimal)

    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

    Rate

    Properties

    • inherited
  • taxBaseModifierRate (big-decimal)

    The rate by which a line amount is increased or decreased. To calculate tax on a reduced base, the base rate modifier can be entered as a negative number.

    Label

    Tax Base Modifier Rate

    Properties

    • inherited
  • taxCalculationFormula (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

    Properties

    • inherited
  • taxCode (string)

    The tax classification code for the detailed tax line.

    Label

    Tax

    Properties

    • inherited
  • taxCurrencyConversionDate (date)

    The date of the exchange rate for converting the currency of the tax to functional currency for the detailed tax line.

    Label

    Tax Currency Conversion Date

    Properties

    • inherited
  • taxCurrencyConversionRate (big-decimal)

    The ratio at which the principal unit of entered currency can be converted into tax currency.

    Label

    Tax Currency Conversion Rate

    Properties

    • inherited
  • taxCurrencyConversionType (string)

    The source of a currency conversion rate, such as user defined, spot, or corporate.

    Label

    Tax Currency Conversion Type

    Properties

    • inherited
  • taxDate (date)

    Date on the current transaction which applicable tax rates and rules are determined.

    Label

    Tax Date

    Properties

    • inherited
  • taxDetermineDate (date)

    Actual date used to determine applicable tax rates and rules. If an adjusted document is present, this is the tax date of the adjusted document. Otherwise, it's the same as the tax date of this tax line.

    Label

    Tax Determination Date

    Properties

    • inherited
  • taxEventClassCode (string)

    The event class code of the tax for the detailed tax line.

    Label

    Tax Event Class Code

    Properties

    • inherited
  • taxEventTypeCode (string)

    The event type code of the detailed tax transaction.

    Label

    Tax Event Type Code

    Properties

    • inherited
  • taxHoldCode (int64)

    The name of tax hold code for payables for this detailed tax line. Possible values are TAX VARIANCE, TAX AMOUNT RANGE, and sum of TAX VARIANCE and TAX AMOUNT RANGE.

    Label

    Name of Tax Hold Code for Payables

    Properties

    • inherited
  • taxHoldReason (string)

    The reason returned by the tax provider for a hold being placed on the invoice.

    Label

    Tax Hold Reason

    Properties

    • inherited
  • taxHoldReleasedCode (big-decimal)

    The name of tax hold release code for payables for this detailed tax line. Possible values are TAX VARIANCE CORRECTED, TAX AMOUNT RANGE CORRECTED, and sum of TAX VARIANCE and TAX AMOUNT RANGE CORRECTED.

    Label

    Name of Tax Hold Release Code for Payables

    Properties

    • inherited
  • taxJurisdictionCode (string)

    The tax jurisdiction code associated with the detailed tax line.

    Label

    Tax Jurisdiction Code

    Properties

    • inherited
  • taxLineId (int64)

    The unique identifier of the tax line.

    Label

    Tax Line ID

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • taxLineNumber (int64)

    The number of the particular tax line in a table.

    Label

    Tax Line Number

    Properties

    • inherited
    • not nullable
  • taxOnlyLineFlag (boolean)

    A tax line that is not related to any item line on the current invoice. Typically, such lines figure in tax-only invoices, that pertain to purchases that are invoiced separately.

    Label

    Tax Only Tax Line

    Properties

    • inherited
  • taxPointBasis (string)

    The original tax point basis prior to user override.

    Label

    Tax Point Basis

    Properties

    • inherited
  • taxRate (big-decimal)

    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

    Rate

    Properties

    • inherited
  • taxRateBeforeException (big-decimal)

    The tax rate that's applicable before applying the tax exception.

    Label

    Tax Rate Determined Before Applying the Tax Exception

    Properties

    • inherited
  • taxRateBeforeExemption (big-decimal)

    The tax rate that's applicable before the tax exemption is applied.

    Label

    Tax Rate Determined Before Applying the Tax Exemption

    Properties

    • inherited
  • taxRateCode (string)

    The tax rate code associated with the detailed tax line.

    Label

    Tax Rate Code

    Properties

    • inherited
  • taxRateNameBeforeException (string)

    The name of the tax rate that's applicable before applying the tax exception.

    Label

    Tax Rate Name Determined Before Applying the Tax Exception

    Properties

    • inherited
  • taxRateNameBeforeExemption (string)

    The name of the tax rate that's applicable before applying the tax exemption.

    Label

    Tax Rate Name Determined Before Applying the Tax Exemption

    Properties

    • inherited
  • taxRateType (string)

    A classification to indicate whether the tax rate is a percentage, a quantity or a recovery based rate.

    Label

    Tax Rate Type

    Properties

    • inherited
  • taxRegimeCode (string)

    The tax regime code associated with the detailed tax line.

    Label

    Tax Regime Code

    Properties

    • inherited
  • taxRegistrationNumber (string)

    The tax registration number of party determined in the transaction based on tax rules.

    Label

    Tax Registration Number

    Properties

    • inherited
    • allowAccessWithSkipDataSecurity
  • taxStatusCode (string)

    The tax status code associated with the detailed tax line.

    Label

    Tax Status Code

    Properties

    • inherited
  • taxTypeCode (string)

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

    Label

    Tax Type Code

    Properties

    • inherited
  • taxableAmount (big-decimal)

    The value, quantity or action, on which tax is calculated, after the tax rules that affect it are taken into consideration for a specific tax. These rules may include deductions, modifications, exemptions, and discounts. Also known as the taxable basis.

    Label

    Taxable Amount

    Properties

    • inherited
  • taxableAmountFunctionalCurrency (big-decimal)

    The value, quantity or action, on which tax is calculated, after the tax rules that affect it are taken into consideration for a specific tax. These rules may include deductions, modifications, exemptions, and discounts. Also known as the taxable basis. The amount is shown in the ledger currency.

    Label

    Taxable Amount in Ledger Currency

    Properties

    • inherited
  • taxableAmountTaxCurrency (big-decimal)

    The value, quantity or action, on which tax is calculated, after the tax rules that affect it are taken into consideration for a specific tax. These rules may include deductions, modifications, exemptions, and discounts. Also known as the taxable basis. The amount is shown in the tax currency.

    Label

    Taxable Amount in Tax Currency

    Properties

    • inherited
  • taxableBasisFormula (string)

    The formula code used for determining the taxable basis amount for the detailed tax line.

    Label

    Taxable Basis Formula

    Properties

    • inherited
  • thresholdScheduleGroupLevelCode (enumeration: ThresholdScheduleGroupCode)

    The threshold schedule grouping code for the tax line.

    Label

    Threshold Schedule Grouping Level

    Type

    • Module: oraErpCoreTax

    • Enumeration Type: ThresholdScheduleGroupCode

    Properties

    • inherited

    Valid Values

    • A
    • D
    • L
    • P
    • S
    • U
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • inherited
    • not nullable
  • transactionDate (date)

    The date of the transaction for the detailed tax line.

    Label

    Transaction Date

    Properties

    • inherited
  • transactionLevelType (string)

    The level of the transaction line identifier. The level can be line, shipment or freight.

    Label

    Transaction Level Type

    Properties

    • inherited
    • not nullable
  • transactionLineDate (date)

    The line date of the associated adjusted transaction line.

    Label

    Transaction Line Date

    Properties

    • inherited
  • transactionLineNumber (int64)

    The number identifying a line in an Oracle applications transaction, which consists of one or more transaction lines.

    Label

    Transaction Line Number

    Properties

    • inherited
  • transactionNumber (string)

    The numeric identifier on a transaction.

    Label

    Transaction Number

    Properties

    • inherited
    • searchable
    • sortable
  • unroundedTaxAmount (big-decimal)

    The unrounded tax amount for the tax line.

    Label

    Unrounded Tax Amount

    Properties

    • inherited
  • unroundedTaxableAmount (big-decimal)

    The unrounded taxable amount for the tax line.

    Label

    Unrounded Taxable Amount

    Properties

    • inherited
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • inherited
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • hqEstablishmentPartyTaxProfile (TaxProfile)

    Legal reporting unit tax profile represents the tax information for a legal reporting unit, including tax registration and party fiscal classifications.

    Business Object

    TaxProfile

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party of the tax profile.

      Label

      Party Tax Profile ID

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

    Expand all

    Collapse all

    Reference Object

    • currency (Currency)

      A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

      Business Object

      Currency

      Expand all

      Collapse all

      Fields

      • currencyCode (string)

        The currency in which an amount or a conversion rate is denominated.

        Label

        Currency Code

        Properties

        • searchable
        • sortable
        • not nullable

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable
    • legalEntityIdentifier (string)

      The unique number assigned to identify a legal entity.

      Label

      Legal Entity Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • taxCurrency (Currency)

    A unique identifier of a currency in which the tax transactions are to be reported.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • taxException (TaxException)

    A tax exception is an exemption from paying a certain portion of taxes of a state or nation during sales of specific types of goods or services, such as fresh produce or safety equipment.

    Business Object

    TaxException

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax exception.

      Label

      Tax Exception ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxExemption (TaxExemption)

    A tax exemption is an exemption from all or certain taxes of a state or nation in which part of the taxes that would normally be collected from an individual or an organization are instead foregone.

    Business Object

    TaxExemption

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for a tax exemption.

      Label

      Exemption ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxJurisdiction (TaxJurisdiction)

    Tax jurisdiction represents a geographic area where a tax is levied by a specific tax authority.

    Business Object

    TaxJurisdiction

    Expand all

    Collapse all

    Fields

    • 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
    • id (int64)

      The unique identifier of the tax jurisdiction. A tax jurisdiction is a geographic area where a tax is levied by a specific tax authority.

      Label

      Tax Jurisdiction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxRateInfo (TaxRate)

    A unique code for a tax rate. A tax rate is the rate specified for a tax status for an effective time period.

    Business Object

    TaxRate

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax rate.

      Label

      Rate ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxRateSchedule (TaxRateSchedule)

    A rate schedule represents the rates applicable on a transaction based on specified amount ranges, defined for a period of time for a specific tax rate.

    Business Object

    TaxRateSchedule

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the rate schedule associated with the tax line.

      Label

      Tax Rate Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

    Expand all

    Collapse all

    Reference Object

    • taxRate (TaxRate)

      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.

      Business Object

      TaxRate

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the tax rate.

        Label

        Rate ID

        Properties

        • searchable
        • sortable
        • not nullable

  • 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

    TaxRegime

    Expand all

    Collapse all

    Fields

    • 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
    • id (int64)

      The unique identifier of the tax regime.

      Label

      Tax Regime ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxRegistration (TaxRegistration)

    The tax registration is the registration of a party with a tax authority that confers tax rights and imposes certain tax obligations.

    Business Object

    TaxRegistration

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the tax registration.

      Label

      Registration ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxStatus (TaxStatus)

    The tax status represents the taxable nature of a product in the context of a transaction for a tax.

    Business Object

    TaxStatus

    Expand all

    Collapse all

    Fields

    • 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
    • id (int64)

      The unique identifier of the tax status. This is a primary key of the Tax Statuses view object.

      Label

      Tax Status ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxThresholdScheduleControl (TaxThreshold)

    The unique identifier for the tax schedule threshold controls.

    Business Object

    TaxThreshold

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for the tax schedule threshold controls.

      Label

      Tax Threshold Schedule Controls ID

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionCurrency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionLineTaxDeterminingFactor (TransactionLineTaxDeterminingFactor)

    An attribute value on a transaction line that's used in the tax determination process.

    Business Object

    TransactionLineTaxDeterminingFactor

    Expand all

    Collapse all

    Fields

    • linesDetFactorId (int64)

      The unique identifier for this line determining factor.

      Label

      Line Determining Factor

      Properties

      • searchable
      • sortable
      • not nullable

    Expand all

    Collapse all

    Reference Object

    • adjustedDocumentApplication (SubledgerApplication)

      The unique identifier for the adjusted document application.

      Business Object

      SubledgerApplication

      Expand all

      Collapse all

      Fields

      • applicationId (int64)

        The unique identifier of the source application that represents a functional area.

        Label

        Application

        Properties

        • searchable
        • sortable
        • not nullable

    • appliedFromApplication (SubledgerApplication)

      The unique identifier for applied from document application.

      Business Object

      SubledgerApplication

      Expand all

      Collapse all

      Fields

      • applicationId (int64)

        The unique identifier of the source application that represents a functional area.

        Label

        Application

        Properties

        • searchable
        • sortable
        • not nullable

    • appliedToApplication (SubledgerApplication)

      The unique identifier for the applied-to application.

      Business Object

      SubledgerApplication

      Expand all

      Collapse all

      Fields

      • applicationId (int64)

        The unique identifier of the source application that represents a functional area.

        Label

        Application

        Properties

        • searchable
        • sortable
        • not nullable

    • billThirdPartySupplier (Supplier)

      The bill-to third-party supplier number associated with the bill-to third-party of the taxable transaction.

      Business Object

      Supplier

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the organization profile.

        Label

        Organization ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • name (string)

        The name of the organization.

        Label

        Name

        Properties

        • inherited
        • creatable
        • searchable
        • sortable
        • not nullable
        • overridable
        • updatable
      • registryId (string)

        The unique alternate identifier for the account party. You can update the value if the profile option HZ_GENERATE_PARTY_NUMBER is set to True. The default value is a concatenation of the value specified in the profile option ZCA_PUID_PREFIX and a unique system generated sequence number.

        Label

        Registry ID

        Properties

        • inherited
        • creatable
        • searchable
        • sortable
        • not nullable
        • overridable
        • updatable
      • supplierId (int64)

        Value that uniquely identifies the supplier.

        Label

        Supplier ID

        Properties

        • searchable
        • sortable
        • not nullable

      Expand all

      Collapse all

      Reference Object

      • alternateName (AlternateName)

        A supplier alternate name represents the name that a supplier can be alternatively known. For example, a supplier Big Computers can be alternatively known as Big Com, or a supplier Vision Corporation is alternatively known as VC Corporation.

        Business Object

        AlternateName

        Expand all

        Collapse all

        Fields

        • id (int64)

          The unique identifier of the name.

          Label

          Additional Name ID

          Properties

          • inherited
          • searchable
          • sortable
          • not nullable
        • name (string)

          Alternate name of the supplier.

          Label

          Alternate Name

          Properties

          • inherited
          • creatable
          • searchable
          • overridable
          • updatable

    • billThirdPartySupplierSite (SupplierSite)

      The bill-to third-party supplier site number associated with the bill-to third-party of the taxable transaction.

      Business Object

      SupplierSite

      Expand all

      Collapse all

      Fields

      • id (int64)

        Value that uniquely identifies the supplier site.

        Label

        Supplier Site ID

        Properties

        • searchable
        • sortable
        • not nullable

    • firstPartyRegistration (TaxRegistration)

      The tax registration is the registration of a party with a tax authority that confers tax rights and imposes certain tax obligations.

      Business Object

      TaxRegistration

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the tax registration.

        Label

        Registration ID

        Properties

        • searchable
        • sortable
        • not nullable

    • merchantPartyTaxProfile (TaxProfile)

      Party tax profile identifier for merchant party of the transaction line.

      Business Object

      TaxProfile

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the party of the tax profile.

        Label

        Party Tax Profile ID

        Properties

        • searchable
        • sortable
        • not nullable

    • productItem (Item)

      Anything you buy, sell, or handle in your business. An item may be a tangible item in your warehouse, such as a wrench or tractor, or an intangible item, such as a service.

      Business Object

      Item

      Expand all

      Collapse all

      Fields

      • itemId (int64)

        Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.

        Label

        Item

        Properties

        • searchable
        • sortable
        • not nullable
      • organizationId (int64)

        Value that uniquely identifies the organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.

        Label

        Organization

        Properties

        • searchable
        • sortable
        • not nullable

    • purchasingCategory (Category)

      The unique identifier for the item category of a transaction line.

      Business Object

      Category

      Expand all

      Collapse all

      Fields

      • id (int64)

        Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs.

        Label

        Item Category

        Properties

        • searchable
        • sortable
        • not nullable

    • relatedDocumentApplication (SubledgerApplication)

      The unique identifier for the related document application.

      Business Object

      SubledgerApplication

      Expand all

      Collapse all

      Fields

      • applicationId (int64)

        The unique identifier of the source application that represents a functional area.

        Label

        Application

        Properties

        • searchable
        • sortable
        • not nullable

    • shipThirdPartySupplier (Supplier)

      The ship-to third-party supplier number associated with the ship-to third-party of the taxable transaction.

      Business Object

      Supplier

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the organization profile.

        Label

        Organization ID

        Properties

        • inherited
        • searchable
        • sortable
        • not nullable
      • supplierId (int64)

        Value that uniquely identifies the supplier.

        Label

        Supplier ID

        Properties

        • searchable
        • sortable
        • not nullable

      Expand all

      Collapse all

      Reference Object

      • alternateName (AlternateName)

        A supplier alternate name represents the name that a supplier can be alternatively known. For example, a supplier Big Computers can be alternatively known as Big Com, or a supplier Vision Corporation is alternatively known as VC Corporation.

        Business Object

        AlternateName

        Expand all

        Collapse all

        Fields

        • id (int64)

          The unique identifier of the name.

          Label

          Additional Name ID

          Properties

          • inherited
          • searchable
          • sortable
          • not nullable

    • shipThirdPartySupplierSite (SupplierSite)

      The ship-to third-party supplier site number associated with the ship-to third-party of the taxable transaction.

      Business Object

      SupplierSite

      Expand all

      Collapse all

      Fields

      • id (int64)

        Value that uniquely identifies the supplier site.

        Label

        Supplier Site ID

        Properties

        • searchable
        • sortable
        • not nullable

    • taxableAccount (GeneralLedgerAccount)

      A tax account is an account defined to capture the financial implications of a tax.

      Business Object

      GeneralLedgerAccount

      Expand all

      Collapse all

      Fields

      • chartOfAccountsId (string)

        The unique identifier of the chart of accounts.

        Label

        Chart of Accounts

        Properties

        • inherited
        • creatable
        • searchable
        • sortable
        • not nullable
      • codeCombinationId (int64)

        The unique identifier of the account combination.

        Label

        Account ID

        Properties

        • inherited
        • creatable
        • searchable
        • sortable
        • not nullable

    • thirdPartyRegistration (TaxRegistration)

      The third party tax registration number of the transaction.

      Business Object

      TaxRegistration

      Expand all

      Collapse all

      Fields

      • id (int64)

        The unique identifier of the tax registration.

        Label

        Registration ID

        Properties

        • searchable
        • sortable
        • not nullable

  • transactionTax (TransactionTax)

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

    Business Object

    TransactionTax

    Expand all

    Collapse all

    Fields

    • 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
    • tax (string)

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

      Label

      Tax

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top