SalesTransactionTaxLine
A sales transaction tax line represents the tax information associated with a transaction line of a sales transaction.
Business Views
** Available for extracting data- salesTransactionTaxLineExtract**
A sales transaction tax line represents the tax information associated with a transaction line of a sales transaction.
Label, Plural Label
Sales Transaction Tax Line, Sales Transaction Tax Lines
Data Source
Read-optimized data store
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
- exemptCertificateNumber (string)
A number associated with the tax certificate issued by the taxing authority.
Label
Tax Exemption Certificate Number
Properties
- inherited
- exemptRateModifier (big-decimal)
The number associated with a specific tax exemption.
Label
Exempt Percentage
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
- 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
- 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
- providerRecoveryRateCode (string)
The recovery rate code returned by the tax provider for generating recoverable tax distributions.
Label
Provider Recovery Rate Code
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
- 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
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
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- 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
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)
- 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
LedgerFields
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
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
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- ledgerId (int64)
- 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
LegalEntityFields
- 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
- legalEntityId (int64)
- taxCurrency (Currency)
A unique identifier of a currency in which the tax transactions are to be reported.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- 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
TaxExceptionFields
- id (int64)
The unique identifier of the tax exception.
Label
Tax Exception ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
TaxExemptionFields
- id (int64)
The unique identifier for a tax exemption.
Label
Exemption ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
- 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
- code (string)
- 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
TaxRateFields
- id (int64)
The unique identifier of the tax rate.
Label
Rate ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
TaxRateScheduleFields
- id (int64)
The unique identifier of the rate schedule associated with the tax line.
Label
Tax Rate Schedule ID
Properties
- searchable
- sortable
- not nullable
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
TaxRateFields
- id (int64)
The unique identifier of the tax rate.
Label
Rate ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- id (int64)
- 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
- id (int64)
The unique identifier of the tax regime.
Label
Tax Regime ID
Properties
- searchable
- sortable
- not nullable
- code (string)
- 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
TaxRegistrationFields
- id (int64)
The unique identifier of the tax registration.
Label
Registration ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
- 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
- code (string)
- taxThresholdScheduleControl (TaxThreshold)
The unique identifier for the tax schedule threshold controls.
Business Object
TaxThresholdFields
- id (int64)
The unique identifier for the tax schedule threshold controls.
Label
Tax Threshold Schedule Controls ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- transactionLineTaxDeterminingFactor (TransactionLineTaxDeterminingFactor)
An attribute value on a transaction line that's used in the tax determination process.
Business Object
TransactionLineTaxDeterminingFactorFields
- linesDetFactorId (int64)
The unique identifier for this line determining factor.
Label
Line Determining Factor
Properties
- searchable
- sortable
- not nullable
Reference Object
- adjustedDocumentApplication (SubledgerApplication)
The unique identifier for the adjusted document application.
Business Object
SubledgerApplicationFields
- applicationId (int64)
The unique identifier of the source application that represents a functional area.
Label
Application
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)
- appliedFromApplication (SubledgerApplication)
The unique identifier for applied from document application.
Business Object
SubledgerApplicationFields
- applicationShortName (string)
The short name of the subledger application.
Label
Short Name
Properties
- searchable
- sortable
- not nullable
- applicationShortName (string)
- appliedToApplication (SubledgerApplication)
The unique identifier for the applied-to application.
Business Object
SubledgerApplicationFields
- applicationId (int64)
The unique identifier of the source application that represents a functional area.
Label
Application
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)
- billThirdPartySiteUse (CustomerAccountSitePurpose)
The bill-to third-party site use number associated with the bill-to third-party of the taxable transaction.
Business Object
CustomerAccountSitePurposeFields
- siteUseId (int64)
Identifier of the customer account site business purpose.
Label
Site Use ID
Properties
- searchable
- sortable
- not nullable
Reference Object
- customerAccountSite (CustomerAccountSite)
The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.
Business Object
CustomerAccountSiteFields
- customerAccountSiteId (int64)
Identifier of the customer account site.
Label
Customer Account Site ID
Properties
- searchable
- sortable
- not nullable
- customerAccountSiteId (int64)
- siteUseId (int64)
- billToCustomerAccount (CustomerAccount)
The customer account number associated with the bill-to customer of the taxable transaction.
Business Object
CustomerAccountFields
- customerAccountId (int64)
Identifier of the customer account.
Label
Customer Account ID
Properties
- searchable
- sortable
- not nullable
Reference Object
- customer (Customer)
Business Object
CustomerFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- registryId (string)
The public key generated or user-entered for a given party.
Label
Registry ID
Properties
- inherited
- searchable
- not nullable
- overridable
- taxPayerId (string)
The taxpayer identification number, often the unique identifier of person or organization. This can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe.
Label
Taxpayer Identification Number
Properties
- inherited
- not nullable
- overridable
- id (int64)
- customerAccountId (int64)
- 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
TaxRegistrationFields
- id (int64)
The unique identifier of the tax registration.
Label
Registration ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- merchantPartyTaxProfile (TaxProfile)
Party tax profile identifier for merchant party of the transaction line.
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)
- receivablesTransactionType (ReceivablesTransactionType)
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.
Business Object
ReceivablesTransactionTypeFields
- customerTransactionTypeSequenceId (int64)
The sequence identifier of the transaction type.
Label
Customer Transaction Type Sequence ID
Properties
- searchable
- sortable
- not nullable
- name (string)
The name of the transaction type.
Label
Name
- customerTransactionTypeSequenceId (int64)
- relatedDocumentApplication (SubledgerApplication)
- shipThirdPartySiteUse (CustomerAccountSitePurpose)
The ship-to third-party site use number associated with the ship-to third-party of the taxable transaction.
Business Object
CustomerAccountSitePurposeFields
- siteUseId (int64)
Identifier of the customer account site business purpose.
Label
Site Use ID
Properties
- searchable
- sortable
- not nullable
Reference Object
- customerAccountSite (CustomerAccountSite)
The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.
Business Object
CustomerAccountSiteFields
- customerAccountSiteId (int64)
Identifier of the customer account site.
Label
Customer Account Site ID
Properties
- searchable
- sortable
- not nullable
- customerAccountSiteId (int64)
- siteUseId (int64)
- shipToCustomerAccount (CustomerAccount)
The customer account number associated with the ship-to customer of the taxable transaction.
Business Object
CustomerAccountFields
- customerAccountId (int64)
Identifier of the customer account.
Label
Customer Account ID
Properties
- searchable
- sortable
- not nullable
Reference Object
- customer (Customer)
Business Object
CustomerFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- registryId (string)
The public key generated or user-entered for a given party.
Label
Registry ID
Properties
- inherited
- searchable
- not nullable
- overridable
- taxPayerId (string)
The taxpayer identification number, often the unique identifier of person or organization. This can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe.
Label
Taxpayer Identification Number
Properties
- inherited
- not nullable
- overridable
- id (int64)
- customerAccountId (int64)
- taxableAccount (GeneralLedgerAccount)
A tax account is an account defined to capture the financial implications of a tax.
Business Object
GeneralLedgerAccountFields
- 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
- chartOfAccountsId (string)
- thirdPartyRegistration (TaxRegistration)
The third party tax registration number of the transaction.
Business Object
TaxRegistrationFields
- id (int64)
The unique identifier of the tax registration.
Label
Registration ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- linesDetFactorId (int64)
- transactionTax (TransactionTax)
A tax is a classification of a charge imposed by a government through a fiscal or tax authority.
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
- tax (string)
The classification of a charge imposed by a government through a fiscal or tax authority.
Label
Tax
Properties
- searchable
- sortable
- not nullable
- id (int64)
- appliedFromEntityCode (string)