Power BI Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines

Stores tax line details for credit memo lines, specifying calculated taxes, jurisdictions, and associated rates.

Columns

Name Type Description
ReceivablesCreditMemosCustomerTransactionId [KEY] Long The unique identifier for the customer transaction associated with the credit memo line tax details.
ReceivablescreditmemolinesCustomerTransactionLineId [KEY] Long The unique identifier for the specific credit memo line related to the customer transaction, used to link it with tax information.
CustomerTrxLineId [KEY] Long The identifier for the customer transaction line that the tax line corresponds to, providing a detailed breakdown of the transaction.
CreatedBy String The user who created the tax line record for the credit memo, allowing traceability of data entry.
CreationDate Datetime The date and time when the tax line record for the credit memo was created.
LastUpdateDate Datetime The most recent date and time when the tax line for the credit memo was updated, reflecting changes in tax data.
LastUpdatedBy String The user who last updated the tax line record for the credit memo, aiding in tracking modifications.
TaxJurisdictionCode String The code indicating the tax jurisdiction under which the tax line for the credit memo is assessed, ensuring compliance with local tax laws.
TaxRate Decimal The applicable tax rate for the credit memo line, used to calculate the tax amount on the transaction.
TaxRateCode String The code representing the tax rate, used for categorization and reference in tax calculations.
TaxRegimeCode String The code representing the tax regime applied to the credit memo line, determining the tax rules for the transaction.
TaxStatusCode String The status of the tax line, such as 'Active' or 'Inactive', indicating the validity of the tax details.
Tax String The tax code assigned to the credit memo line, identifying the specific tax type applied to the transaction.
TaxAmount Decimal The total tax amount calculated for the credit memo line in the entered currency.
TaxableAmount Decimal The taxable amount for the credit memo line, before the tax is applied, determining the base for tax calculation.
TaxPointBasis String The basis for determining the tax point, indicating whether the tax applies at the point of sale, shipment, or other relevant events.
TaxPointDate Date The date that determines when the tax point is triggered for the credit memo line, crucial for tax reporting.
TaxLineNumber Int The unique identifier for the tax line within the credit memo, used for tracking multiple tax lines associated with the same credit memo.
PlaceOfSupply Int The location where the supply of goods or services is considered to take place for tax purposes, determining the applicable tax rates.
TaxInclusiveIndicator String Indicates whether the credit memo line amount includes tax, or if tax is calculated separately. Valid values are 'Yes' or 'No'.
BindAccountingDate Date The accounting date for the credit memo line tax, used to record the tax event in the correct financial period.
BindAllowCompletion String Indicates whether the tax line for the credit memo can be completed. Typically set to 'Y' for yes or 'N' for no.
BindBillToCustomer String The customer associated with the credit memo, indicating which party is responsible for the tax obligations.
BindBillToCustomerNumber String The unique number identifying the bill-to customer for the credit memo line, used for reference in accounting and tax processing.
BindBillToSite String The site number associated with the bill-to customer for the credit memo, used for identifying the specific location of the billed customer.
BindBusinessUnit String The business unit under which the credit memo and its associated tax are processed, ensuring proper financial categorization.
BindCreditMemoCurrency String The currency in which the credit memo tax line is calculated, ensuring consistency with the business's financial transactions.
BindCreditMemoStatus String The current status of the credit memo line, such as 'Pending', 'Completed', or 'Cancelled', determining if the tax line can be processed.
BindCrossReference String A cross-reference code linking the tax line of the credit memo to other associated documents or transactions.
BindDeliveryMethod String The method used to deliver the credit memo, such as 'Email' or 'Printed', determining how the tax details are communicated to the customer.
BindDocumentNumber Long The unique number assigned to the credit memo document, used for tracking and referencing the tax line within the system.
BindIntercompany String Indicates whether the credit memo line is part of an intercompany transaction, enabling correct accounting treatment for internal transfers.
BindPrimarySalesperson String The salesperson associated with the credit memo line, tracking sales commissions or other relevant attributes.
BindPrintStatus String The print status of the credit memo line, indicating whether it has been printed or is pending printing.
BindPurchaseOrder String The purchase order number associated with the credit memo line, linking it to the original sales transaction.
BindShipToCustomerName String The name of the customer receiving the goods or services associated with the credit memo line.
BindShipToSite String The site number where the goods or services associated with the credit memo line are delivered.
BindTransactionDate Date The date when the transaction occurred, used for tax reporting and accounting purposes.
BindTransactionNumber String The transaction number of the credit memo, providing a reference to track the specific transaction in the system.
BindTransactionSource String The source document or system from which the credit memo originated, used to link the credit memo back to its original source.
BindTransactionType String The type of transaction for the credit memo line, such as 'Return' or 'Adjustment', used for categorizing the tax treatment.
CustomerTransactionId Long The identifier for the customer transaction associated with the credit memo, linking the tax line to the original transaction.
Finder String A search term used to locate specific credit memo lines and tax details within the system.

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