CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

WithholdingTaxLines

Maintains entries for withholding tax computations, supporting creation, retrieval, and updates to withholdings on transactions.

Columns

Name Type Description
TaxLineId [KEY] Long The unique identifier for a tax line, used to track and reference individual tax records in the system.
TrxId Long The unique identifier of the transaction to which the tax line is associated, linking the tax line to the specific transaction.
TrxLineId Long The unique identifier of the transaction line, connecting the tax line to a specific item or service in the transaction.
TrxLineNumber String The number of the transaction line, used to identify the order or sequence of transaction lines within a transaction.
TaxLineNumber Long The unique number assigned to the tax line, indicating its position in the list of tax lines for a given transaction.
TaxRateName String The name of the tax rate applied to the transaction, providing a descriptive label for the tax type used (for example, VAT, sales tax).
TaxRateCode String The code representing the tax rate applied, used for referencing specific tax rates in the system.
TaxRateId Long The unique identifier of the tax rate, linking the tax line to a particular rate definition in the system.
TaxRate Long The percentage rate applied to the transaction to calculate the tax amount. This could be a flat rate or variable depending on jurisdiction.
UnroundedTaxAmount Long The calculated tax amount before any rounding is applied, often used for reporting purposes or to adjust for precise tax calculations.
TaxAmount Decimal The final amount of tax calculated for the transaction, taking into account the tax rate and any adjustments or rounding.
Cancelled String Indicates whether the tax line has been cancelled ('Y' for Yes, 'N' for No). This field tracks whether the tax has been voided or reversed.
CalculationPoint String The point in the transaction process at which tax is calculated (for example, invoice date, shipment date). Determines when the tax obligation is recognized.
TaxRegimeCode String The code identifying the tax regime that governs the tax rate applied, such as VAT, sales tax, or other jurisdiction-specific tax rules.
TaxRegimeId Long The unique identifier of the tax regime that applies to the transaction, allowing system users to link tax lines to specific tax policies.
Tax String The specific tax applied to the transaction, such as VAT, sales tax, or excise duty, defining the type of tax being levied.
TaxId Long The unique identifier of the tax associated with the tax line, allowing the system to link the tax line to specific tax rules and calculations.
TaxStatusCode String The status code of the tax line, indicating its current state (for example, applied, unapplied, pending).
TaxStatusId Long The unique identifier of the tax status, used to track the progress of the tax line in the tax processing cycle.
TaxJurisdictionCode String The code identifying the tax jurisdiction, such as the country or region, where the tax is applied, ensuring compliance with local tax laws.
TaxJurisdictionId Long The unique identifier of the tax jurisdiction, which is used to link the tax line to specific geographic tax rules and authorities.
TrxLevelType String The level at which the tax is applied (for example, line level or transaction level). This helps in determining whether tax is calculated for individual items or the whole transaction.
InternalOrganizationId Long The unique identifier of the internal organization responsible for processing the tax line, allowing for the management of tax liabilities by organizational units.
ApplicationId Long The unique identifier of the application that processed the tax line, helping track which module or system component generated the tax entry.
EntityCode String The code representing the entity that owns the tax line, which could refer to different business units, departments, or legal entities.
EventClassCode String The code for the event class associated with the tax line, identifying the type of event (for example, sale, purchase) that triggered the tax calculation.
TaxApportionmentLineNumber Long The line number used for tax apportionment when the tax is shared across multiple transactions or parties.
TaxJurisdictionName String The name of the tax jurisdiction, such as the country or region where the tax is being levied.
TaxRegimeName String The name of the tax regime that governs the tax, such as VAT, which dictates the rules under which the tax is applied.
TaxStatusName String The name of the tax status, indicating the current state of the tax line (for example, applied, unapplied, pending).
SummaryTaxLineId Long The unique identifier of the summary tax line, used when the tax line is part of a summarized or aggregated tax amount.
Finder String A general-purpose field used for searching or filtering tax lines in the system, making it easier for users to find relevant records.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454