WithholdingTaxLine
Withholding tax line represents the withholding tax for an item line.
Business Views
** Available for extracting data- withholdingTaxLineExtract**
Withholding tax line represents the withholding tax for an item line.
Label, Plural Label
Withholding Tax Lines, Withholding Tax Lines
Data Source
Read-optimized data store
Fields
- accumulatedTaxAmountTaxCurrency (big-decimal)
The accumulated tax amount at the time when the current tax line is created or updated.
Label
Accumulated Tax Amount in the Tax Currency
- accumulatedTaxableAmountTaxCurrency (big-decimal)
The accumulated taxable amount at the time when the current tax line is created or updated.
Label
Accumulated Taxable Amount in the Tax Currency
- applicationId (int64)
The unique identifier of the application such as Payables or Receivables for which the tax options are configured.
Label
Application ID
Properties
- searchable
- sortable
- not nullable
- calculatedTaxAmount (big-decimal)
The calculated tax amount prior to rounding.
Label
Calculated Tax Amount
- calculatedTaxAmountFunctionalCurrency (big-decimal)
The system calculated tax amount in ledger currency. This is same as the tax amount in ledger currency if there is no user override.
Label
Calculated Tax Amount in Functional Currency
- calculatedTaxAmountTaxCurrency (big-decimal)
The system calculated tax amount in ledger currency. This is the same as the tax amount in ledger currency if not overridden by the user.
Label
Calculated Tax Amount in Tax Currency
- calculatedTaxableAmount (big-decimal)
The calculated taxable amount for a particular withholding tax line.
Label
Calculated Taxable Amount
- cancelFlag (boolean)
Indicates whether this tax line was canceled by the user. Valid values are Yes and No.
Label
Cancel
- currencyConversionDate (date)
The date as of which a conversion rate is used to convert an amount into another currency.
Label
Currency Conversion Date
- currencyConversionRate (big-decimal)
The ratio at which the principal unit of one currency can be converted into another currency.
Label
Currency Conversion Rate
- discountAmount (big-decimal)
Indicates the discount amount associated with a specific withholding tax line when the withholding tax amount is calculated for documents.
Label
Discount Amount
- entityCode (enumeration: EntityCode)
The entity code of the transaction indicates the type of transaction being created. Entity codes standardize the interaction with applications.
Label
Entity Code
Type
-
Module: oraErpCoreTax
-
Enumeration Type: EntityCode
Properties
- searchable
- sortable
- 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.
-
- establishmentFirstPartyRegistrationNumber (string)
The tax registration number of the first-party headquarters establishment in the transaction.
Label
Headquarters Registration Number
Properties
- allowAccessWithSkipDataSecurity
- eventClassCode (enumeration: EventClassCode)
A business classification used to categorize a group of documents (application event classes) in one or more Oracle Fusion applications. These documents are essentially the same from a tax perspective, including invoices, purchase orders, or inventory issues.
Label
Event Class Code
Type
-
Module: oraErpCoreTax
-
Enumeration Type: EventClassCode
Properties
- searchable
- sortable
- 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.
-
- exceptionRate (big-decimal)
The applicable tax rate before the tax exception is applied.
Label
Exception Rate
- exemptCertificateNumber (string)
The certificate number associated with a tax exemption for the withholding transaction.
Label
Exemption Certificate Number
- exemptRateModifier (big-decimal)
The percentage number associated with a specific tax exemption on the original tax.
Label
Exempt Percentage
- exemptReason (string)
The identifier for the process result obtained from exemption evaluation process for this tax line.
Label
Tax Exemption Reason
- exemptReasonCode (string)
The reason a tax exemption was granted or taken. The allowed values include Discontinued, Primary, Manual, Rejected, and Unapproved.
Label
Tax Exempt Reason Code
- id (int64)
The identifier for withholding tax line.
Label
Tax Line ID
Properties
- searchable
- sortable
- not nullable
- legalEntityTaxRegistrationNumber (int64)
A unique identifier for a party obligated by a tax authority to manage an indirect tax liability for a specific jurisdiction, such as U.S. Sales Tax and UK Value-Added Tax. In some countries, a single tax registration number may cover both direct and indirect tax obligations, such as corporation and value-added taxes.
Label
Legal Entity Tax Registration Number
Properties
- allowAccessWithSkipDataSecurity
- lineAmount (big-decimal)
A monetary amount associated with the transaction line.
Label
Line Amount
- lineAssessableValue (big-decimal)
The deemed price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities.
Label
Assessable Value
- originalAccumulatedTaxAmountTaxCurrency (big-decimal)
The original accumulated tax amount at the time when the current tax line is canceled.
Label
Original Accumulated Tax Amount in the Tax Currency
- originalAccumulatedTaxableAmountTaxCurrency (big-decimal)
The original accumulated taxable amount at the time when the current tax line is canceled.
Label
Original Accumulated Taxable Amount in the Tax Currency
- originalTaxAmount (big-decimal)
Value of tax amount in entered currency prior to user override.
Label
Original Tax Amount in Entered Currency
- originalTaxAmountTaxCurrency (big-decimal)
Value of tax amount in tax currency before user override.
Label
Original Tax Amount in Tax Currency
- originalTaxJurisdictionCode (string)
Value of tax jurisdiction code before user override.
Label
Original Tax Jurisdiction Code
- originalTaxRate (big-decimal)
Value of tax rate before user override.
Label
Original Tax Rate
- originalTaxRateCode (string)
Value of tax rate code before user override.
Label
Original Tax Rate Code
- originalTaxStatusCode (string)
Value of tax status code before user override.
Label
Original Tax Status Code
- originalTaxableAmount (big-decimal)
Value of tax status identifier before user override.
Label
Original Tax Status ID
- originalTaxableAmountTaxCurrency (big-decimal)
Value of tax amount in tax currency before user override.
Label
Original Tax Amount in Tax Currency
- otherDocumentLineAmount (big-decimal)
The line amount on the other document for the withholding detailed tax line.
Label
Other Document Line Amount
- otherDocumentLineTaxAmount (big-decimal)
The line tax amount on the other document for the withholding detailed tax line.
Label
Other Document Line Tax Amount
- otherDocumentLineTaxableAmount (big-decimal)
The taxable amount on the other document for the withholding detailed tax line.
Label
Other Document Line Taxable Amount
- paymentAmount (big-decimal)
The payment amount associated with a particular withholding tax line.
Label
Payment Amount
- paymentDate (date)
The payment date associated with a particular withholding tax line.
Label
Payment Date
- paymentId (int64)
The payment identifier associated with a particular withholding tax line.
Label
Payment ID
Properties
- searchable
- sortable
- paymentNumber (int64)
The payment number associated with the withholding tax line.
Label
Payment Number
Properties
- searchable
- sortable
- placeOfSupplyTypeCode (enumeration: PlaceOfSupplyTypeCode)
The specific tax jurisdiction where the supply of goods or services is deemed to have taken place.
Label
Place of Supply Type Code
Type
-
Module: oraErpCoreTax
-
Enumeration Type: PlaceOfSupplyTypeCode
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
-
- proratedTotalTaxAmount (big-decimal)
Tax amount derived by the tax rate on prepayment based on applied amount handling method.
Label
Prorated Total Tax Amount
- proratedTotalTaxAmountFunctionalCurrency (big-decimal)
Tax amount in entered currency converted into ledger currency.
Label
Prorated Total Tax Amount in Ledger Currency
- proratedTotalTaxAmountTaxCurrency (big-decimal)
Tax amount in entered currency converted into tax currency.
Label
Prorated Total Tax Amount in Tax Currency
- registrationPartyType (enumeration: RegistrationPartyTypecode)
The lookup code for party type that's used to determine the tax registration number.
Label
Registration Party Type
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: RegistrationPartyTypecode
Valid Values
- BILL_FROM_PARTY
- BILL_FROM_SITE
- BILL_TO_PARTY
- BILL_TO_SITE
- SHIP_FROM_PARTY
- SHIP_FROM_SITE
- SHIP_TO_PARTY
- SHIP_TO_SITE
- TAX_REG_NUMBER_FIRST_PARTY
- TAX_REG_NUMBER_THIRD_PARTY
-
- taxAmount (big-decimal)
Tax amount in entered currency, which is the currency used in transactions.
Label
Tax Amount in Entered Currency
- 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
- taxAmountTaxCurrency (big-decimal)
Tax amount in tax currency which is the amount in entered currency converted into tax currency.
Label
Tax Amount in Tax Currency
- taxApportionmentFlag (boolean)
Indicates whether multiple tax lines were created during migration from previous releases. Valid values are Yes and No.
Label
Tax Apportionment
- taxApportionmentLineNumber (int64)
The apportionment line number for this tax line when multiple tax lines are created for the same tax during migration from prior releases. If tax information on a frozen line is changed, the frozen line is retained with a negative value.
Label
Apportionment Line Number for the Tax Line
Properties
- searchable
- sortable
- taxBaseModifierRate (big-decimal)
The modifier rate used for taxable basis determination.
Label
Modifier Rate for Taxable Basis
- taxCalculationFormula (string)
The formula code used to determine the tax amount.
Label
Tax Calculation Formula
- taxCode (string)
The tax classification code that's used for the withholding tax.
Label
Tax Classification Code
- taxCurrencyConversionDate (date)
The date on which the conversion rate is used to convert an amount from entered currency to tax currency.
Label
Tax Currency Conversion Date
- taxCurrencyConversionRate (big-decimal)
The ratio at which the principal unit of entered currency can be converted into tax currency.
Label
Tax Currency Conversion Rate
- taxDate (date)
The date of the current transaction on which applicable tax rates and rules are determined.
Label
Tax Date
- taxDetermineDate (date)
The actual date used to determine applicable tax rates and rules. If an adjusted document is present, this date corresponds to the tax date of the adjusted document, otherwise, it's the same as the tax date of this tax line.
Label
Tax Determination Date
- taxLineNumber (int64)
The number of the particular tax line in a table.
Label
Tax Line Number
- taxName (string)
The classification of a charge imposed by a government through a fiscal or tax authority on a withholding transaction line.
Label
Tax
- taxPointDate (date)
Date on which the taxpayer becomes liable for paying the tax to the tax authority. It can be the delivery date, the invoice date or the pickup date.
Label
Tax Point Date
- taxRate (big-decimal)
A unique code for a tax rate. A tax rate is the rate specified for a tax status for an effective time period.
Label
Tax Rate
- taxRateBeforeException (big-decimal)
The tax rate that's applicable before the tax exception is applied.
Label
Tax Rate Determined Before Applying the Tax Exception
- taxRateBeforeExemption (big-decimal)
The tax rate that's determined before applying the tax exemption.
Label
Tax Rate Determined Before Applying the Tax Exemption
- taxRateNameBeforeException (string)
The name of the tax rate that's applicable before the tax exception is applied.
Label
Tax Rate Name Determined Before Applying the Tax Exception
- taxRateNameBeforeExemption (string)
The name of the tax rate that's applicable before the tax exemption is applied.
Label
Tax Rate Name Determined Before Applying the Tax Exemption
- taxRegistrationNumber (string)
The withholding tax registration number of party determined in the transaction based on tax rules.
Label
Tax Registration Number
Properties
- allowAccessWithSkipDataSecurity
- taxTypeCode (enumeration: TaxTypeCategory)
The code for a grouping of withholding taxes into a high level classification, not bounded to a tax regime.
Label
Tax Type Code
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.
-
- taxableAmount (big-decimal)
The value, quantity, or action on which tax is calculated after considering the applicable tax rules for a specific tax. These rules may include deductions, modifications, exemptions, and discounts, also known as the taxable basis. The amount is shown in entered currency.
Label
Taxable Amount in Entered Currency
- taxableAmountFunctionalCurrency (big-decimal)
The value, quantity, or action on which tax is calculated after considering the applicable tax rules for a specific tax. These rules may include deductions, modifications, exemptions, and discounts, also known as the taxable basis. The amount is shown in ledger currency.
Label
Taxable Amount in Ledger Currency
- taxableAmountTaxCurrency (big-decimal)
The value, quantity, or action on which tax is calculated after considering the applicable tax rules for a specific tax. These rules may include deductions, modifications, exemptions, and discounts, also known as the taxable basis. The amount is shown in tax currency.
Label
Taxable Amount in Tax Currency
- taxableThresholdGroupLevelCode (enumeration: ThresholdScheduleGroupsCode)
The taxable threshold grouping level code. Possible values are NULL, L (line), P (period), D (document), U (unit) and S (set).
Label
Taxable Threshold Group Level Code
Type
-
Module: oraErpCoreTaxSetup
-
Enumeration Type: ThresholdScheduleGroupsCode
Valid Values
- A
- D
- L
- P
- S
- U
-
- thresholdScheduleGroupLevel (enumeration: ThresholdScheduleGroupCode)
The option indicates whether the threshold schedule grouping level is enabled at the Payment, Document, Line, Period, Set or Per unit level.
Label
Threshold Schedule Group Level
Type
-
Module: oraErpCoreTax
-
Enumeration Type: ThresholdScheduleGroupCode
Valid Values
- A
- D
- L
- P
- S
- U
-
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- transactionDate (date)
The date the transaction occurred.
Label
Transaction Date
- transactionId (int64)
The transaction ID is a system-generated identification number of a transaction.
Label
Transaction ID
Properties
- searchable
- sortable
- not nullable
- transactionLevelType (enumeration: TransactionLevelTypeCode)
The level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT, FREIGHT and TAX.
Label
Transaction Level Type
Type
-
Module: oraErpCoreTax
-
Enumeration Type: TransactionLevelTypeCode
Properties
- searchable
- sortable
- not nullable
Valid Values
- FREIGHT
- LINE
- TAX
-
- transactionLineDate (date)
The line date of the associated adjusted transaction line.
Label
Transaction Line Date
- transactionLineId (int64)
The transaction line ID is the identifier for a particular transaction line in a table.
Label
Transaction Line ID
Properties
- searchable
- sortable
- not nullable
- transactionLineNumber (string)
The number identifying a line in an Oracle applications transaction, which consists of one or more transaction lines.
Label
Transaction Line Number
- transactionLineQuantity (int64)
The quantity of the associated transaction line.
Label
Transaction Line Quantity
- transactionNumber (string)
The numeric identifier for a transaction.
Label
Transaction Number
- unitPrice (big-decimal)
The price charged per unit of a good or service.
Label
Unit Price
- unroundedTaxAmount (big-decimal)
The unrounded tax amount for a particular tax line.
Label
Unrounded Tax Amount
- unroundedTaxableAmount (big-decimal)
The unrounded taxable amount for a particular tax line.
Label
Unrounded Taxable Amount
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)
- contentOwner (TaxProfile)
The unique identifier of the party tax profile of the first party organization of the transaction.
Business Object
TaxProfileFields
- id (int64)
The unique identifier of the party of the tax profile.
Label
Party Tax Profile ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- erpAssignments (ERPDataAccessAssignedBusinessUnit)
The business unit assigned to a specific user in the user definition within the application. This value can be used as a filter criteria when assigning data access to a user name.
Business Object
ERPDataAccessAssignedBusinessUnitFields
- orgId (int64)
Indicates the identifier of the business unit associated to the row.
Label
Business Unit ID
Properties
- searchable
- sortable
- not nullable
- orgId (int64)
- establishment (TaxProfile)
The unique identifier of the Legal reporting unit.
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)
- ledgerName (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
- ledgerId (int64)
- rateCode (TaxRate)
A unique code for a withholding tax rate. A withholding 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)
- summaryTaxLine (WithholdingSummaryTaxLine)
The summary tax line identifier for a particular tax line.
Business Object
WithholdingSummaryTaxLineFields
- id (int64)
The unique identifier of the withholding summary tax line.
Label
Summary Tax Line ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- tax (TransactionTax)
The classification of a charge imposed by a government through a fiscal or tax authority on a withholding transaction line.
Business Object
TransactionTaxFields
- id (int64)
The unique identifier of the tax. This is a primary key of the Transaction Taxes view object.
Label
Tax ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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
- 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
- id (int64)
- taxRateOriginal (TaxRate)
Value of tax rate before user override.
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
- 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
- id (int64)
The unique identifier of the tax regime.
Label
Tax Regime ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- 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)
A unique code for a tax status, indicating the taxable nature of a product within the context of a transaction for a withholding transaction line.
Business Object
TaxStatusFields
- 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
- id (int64)
- transactionLineTaxDeterminingFactor (TransactionLineTaxDeterminingFactor)
An attribute value on a transaction line that's used in the tax determination process.
Business Object
TransactionLineTaxDeterminingFactorFields
- transactionLineId (int64)
The unique identifier of the transaction line associated with the tax line.
Label
Transaction Line ID
Properties
- searchable
- sortable
- transactionLineId (int64)
- accumulatedTaxAmountTaxCurrency (big-decimal)