CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

TransactionTaxLines

Allows the creation, retrieval, and modification of manual tax lines for a transaction, ensuring accurate tax posting.

Columns

Name Type Description
TaxLineId [KEY] Long The unique identifier of the tax line in a transaction.
TrxId Long The identifier of the transaction to which the tax line is associated.
TrxLineId Long The identifier of the transaction line associated with this tax line.
TrxLineNumber Long The number of the transaction line that corresponds to the tax line.
TaxLineNumber Int The unique number assigned to the tax line for identification.
TaxRateName String The name of the tax rate applied to the transaction line.
TaxRateId Long The identifier of the tax rate applied to the transaction line.
TaxRateCode String The code for the tax rate applied to the transaction line.
TaxRate Decimal The percentage or amount of the tax rate applied.
TaxAmount Decimal The total tax amount applied to the transaction line.
TaxableAmount Decimal The amount on which the tax is calculated (i.e., the taxable base).
UnroundedTaxAmount Decimal The tax amount before rounding adjustments are made.
UnroundedTaxableAmount Decimal The taxable amount before rounding adjustments are made.
Cancelled String Indicates whether the tax line has been cancelled (for example, 'Y' for yes, 'N' for no).
TaxAmountIncluded String Indicates whether the tax amount is included in the price (for example, 'Y' or 'N').
SelfAssessed String Indicates whether the tax was self-assessed (for example, 'Y' or 'N').
TaxOnlyLine String Indicates whether the line is for tax only (for example, 'Y' or 'N').
TaxRegimeCode String The code identifying the tax regime applicable to the transaction line.
TaxRegimeId Long The identifier of the tax regime applicable to the transaction.
Tax String The tax code applied to the transaction line.
TaxId Long The unique identifier for the specific tax applied.
TaxJurisdictionCode String The code of the jurisdiction where the tax is applicable.
TaxJurisdictionId Long The unique identifier of the tax jurisdiction.
TaxStatusCode String The code representing the status of the tax line (for example, 'COMPLETED', 'PENDING').
TaxStatusId Long The unique identifier of the tax status applied to the line.
WhtTaxClassificationCode String The withholding tax classification code for the tax line.
ExemptCertificateNumber String The certificate number indicating an exemption from tax.
TaxPointBasis String The basis for determining the tax point, such as 'Invoice' or 'Delivery'.
TaxPointDate Date The date when the tax point occurs, which may differ from the transaction date.
PlaceOfSupplyTypeCode String The type code for the place of supply (for example, 'DOMESTIC', 'EXPORT').
TrxLevelType String The level at which the tax line is applied (for example, 'LINE', 'HEADER').
InternalOrganizationId Long The unique identifier of the internal organization within the system.
ApplicationId Long The identifier of the application under which the tax line is processed.
EntityCode String The entity code that is related to the tax line.
EventClassCode String The event class code associated with the transaction tax line.
WhtGroupId Long The group identifier for withholding tax related to the tax line.
TrxNumber String The transaction number associated with the tax line.
TaxJurisdictionName String The name of the tax jurisdiction where the tax is applied.
TaxRegimeName String The name of the tax regime applicable to the transaction.
TaxStatusName String The name of the status associated with the tax line.
SummaryTaxLineId Long The identifier of the summary tax line, if applicable.
LineAmount Decimal The amount of the transaction line to which the tax is applied.
TaxDetermineDate Date The date when the tax was determined, which may differ from the transaction date.
TaxDate Date The date when the tax is due for payment or reporting.
TaxRateType String The type of tax rate applied (for example, 'STANDARD', 'REDUCED').
ContentOwnerId Long The unique identifier of the content owner associated with the tax line.
Finder String A search field for locating specific tax lines within the system.

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