Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines

Captures tax calculations and jurisdictions for each invoice line, facilitating accurate compliance and tax reporting.

Columns

Name Type Description
ReceivablesInvoicesCustomerTransactionId [KEY] Long The unique identifier of the customer transaction associated with the tax line of the invoice, linking the tax line to the corresponding transaction.
ReceivablesinvoicelinesCustomerTransactionLineId [KEY] Long The unique identifier of the invoice line associated with the tax line, linking tax details to the specific invoice line.
CustomerTransactionLineId [KEY] Long The unique identifier for each individual tax line of the invoice, providing a distinct reference for managing tax-related information.
CreatedBy String The name or identifier of the user who created the tax line entry, allowing traceability for auditing purposes.
CreationDate Datetime The date and time when the tax line was created, helping to track the creation history of the invoice tax details.
LastUpdatedBy String The name or identifier of the user who last updated the tax line entry, ensuring accountability in the modification process.
LastUpdateDate Datetime The date and time when the tax line was last updated, allowing tracking of changes made to the tax details over time.
TaxJurisdictionCode String The tax jurisdiction code associated with the tax line, defining the geographical area or tax authority under which the tax is applicable.
TaxRate Decimal The tax rate applied to the invoice line for this particular tax line, determining the percentage of tax to be applied based on the taxable amount.
TaxRateCode String The code associated with the tax rate applied, which can be used for referencing the specific tax rate for calculations and reporting.
TaxRegimeCode String The tax regime code assigned to the tax line, representing the set of rules and laws governing tax calculations for the transaction.
TaxStatusCode String The code that represents the tax status for the tax line, such as whether the tax is exempt, standard, or has special handling.
Tax String The code for the type of tax applied to the invoice line, indicating the specific tax being calculated, like VAT or sales tax.
TaxAmount Decimal The total amount of tax applied to the invoice line in the entered currency, reflecting the tax calculated based on the taxable amount.
TaxableAmount Decimal The amount on which tax is calculated for the invoice line, providing the base value before applying the tax rate.
TaxPointBasis String The basis on which tax point is determined, such as delivery or invoice date, which impacts when the tax is applied and reported.
TaxPointDate Date The date when the tax point is recognized, which determines the tax reporting period for the invoice line.
TaxLineNumber Int The unique number assigned to each tax line within the invoice line, ensuring accurate identification and tracking of tax details.
PlaceOfSupply Int The place of supply for the goods or services related to the tax line, determining the jurisdiction in which the tax is applied.
TaxInclusiveIndicator String An indicator specifying whether the amount on the invoice line includes the tax (yes/no), affecting the calculation of tax-inclusive or exclusive pricing.
AccountingDate Date The date when the transaction related to the tax line is accounted for, impacting when the tax is recognized in the accounting system.
AllowCompletion String Indicates whether the tax line entry is eligible for completion in the workflow, providing control over the tax line processing status.
BillingDate Date The billing date of the invoice line, which may affect tax calculation if tax is based on invoice or delivery dates.
BillToCustomerName String The name of the customer responsible for paying the tax on the invoice line, essential for tax reporting and compliance.
BillToCustomerNumber String The unique identifier of the bill-to customer for the tax line, used to manage customer-specific tax obligations.
BillToSite String The site associated with the bill-to customer, identifying the location for which tax is applied or where services/goods are delivered.
BusinessUnit String The business unit under which the tax line is created, used to manage and categorize tax transactions across different departments or segments.
CrossReference String A reference field used to link the tax line to related transactions or documents, enhancing traceability for audits and reporting.
CustomerTransactionId Long The unique identifier for the customer transaction associated with the tax line, ensuring complete traceability of tax information within the transaction.
DocumentNumber Long The unique document number assigned to the invoice line, used for tracking and referencing the specific document in the system.
DueDate Date The date by which payment is due for the tax portion of the invoice line, helping in managing tax-related cash flows.
Finder String A field used for searching or filtering tax lines, aiding in the management and retrieval of tax-related information.
FirstPartyTaxRegistration String The tax registration number of the first party involved in the transaction, used for tax compliance and reporting purposes.
InvoiceCurrencyCode String The currency code associated with the invoice line, indicating the currency in which the tax is calculated and applied.
InvoiceStatus String The status of the invoice line in relation to its tax details, indicating whether it is open, paid, or under review.
LegalEntityIdentifier String The identifier for the legal entity responsible for the tax on the invoice line, ensuring proper tax compliance at the legal entity level.
PaymentTerms String The payment terms for the invoice line, specifying when payment for the tax is due and any applicable discounts or penalties.
PurchaseOrder String The purchase order number associated with the invoice line, linking the invoice to the procurement transaction that triggered it.
ShipToCustomerName String The name of the customer receiving the goods or services for the tax-applied invoice line, useful for shipping and compliance purposes.
ShipToSite String The site where the goods or services related to the tax line are shipped or delivered, impacting tax calculation based on location.
ThirdPartyTaxRegistration String The tax registration number of a third party, if involved, used to manage any applicable third-party tax obligations or exemptions.
TransactionDate Date The date on which the transaction related to the tax line occurred, affecting when tax is reported and due.
TransactionNumber String The transaction number assigned to the tax line, serving as a unique reference for tax reporting and auditing purposes.
TransactionSource String The source of the transaction that generated the tax line, indicating whether it is from a sales order, return, or another source.
TransactionType String The type of transaction associated with the tax line, such as sale, return, or adjustment, affecting how tax is applied.

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