TDV Adapter for Oracle Fusion Cloud Financials

Build 25.0.9434

ReceivablesCreditMemosreceivablesCreditMemoLines

Represents each line item of a credit memo, specifying product, amounts, and adjustments for the transaction.

Columns

Name Type Description
ReceivablesCreditMemosCustomerTransactionId [KEY] Long The unique identifier for the customer transaction associated with the credit memo, linking the credit memo to a specific customer transaction.
CustomerTransactionLineId [KEY] Long The unique identifier for each individual line of the credit memo, ensuring traceability of the specific items or services being credited.
LineNumber Decimal The sequential number of each line in the credit memo, providing an ordered reference for each line item.
LineDescription String A brief description of the product or service associated with the credit memo line, used for identification and reference purposes.
CreatedBy String The user who initially created the credit memo line, providing accountability for the creation process.
CreationDate Datetime The date and time when the credit memo line was created in the system, helping to track the creation timeline.
LastUpdatedBy String The user who last updated the credit memo line, ensuring proper tracking of changes made to the line.
LastUpdateDate Datetime The date and time when the credit memo line was last updated, ensuring that modifications are recorded.
UnitSellingPrice Decimal The price per unit of the product or service listed on the credit memo line, determining the value of the credited item.
LineQuantityCredit Decimal The quantity of items or services credited on the credit memo line, indicating the number of units being adjusted.
LineAmountCredit Decimal The total amount credited on the credit memo line, calculated by multiplying the unit price by the credited quantity.
Warehouse String The warehouse or location from which the items were shipped, relevant for inventory management and logistical tracking.
UnitOfMeasure String The unit of measure used to quantify the product or service on the credit memo line, such as pieces, hours, or kilograms.
ItemNumber String The unique identifier of the inventory item being credited, linking the credit memo line to a specific product in the inventory.
MemoLine String A user-defined identifier or description for the credit memo line, often used when the line is not associated with an inventory item.
LineCreditReason String The reason for crediting all or part of the line amount, providing context for why a credit is being applied.
LineTranslatedDescription String A translation of the credit memo line description, allowing for multi-language support in international transactions.
TaxInvoiceNumber String The unique identifier of the tax invoice related to the credit memo, supporting the credit process by linking it to the original invoice.
TaxInvoiceDate Date The date when the tax invoice, which supports the credit memo, was issued, helping to establish the timing of the original transaction.
TransactionLineAssessableValue Decimal The taxable base amount for the credit memo line, used for calculating tax on the credited items or services.
SalesOrderNumber String The sales order number associated with the credit memo line, linking the credit memo to the original sales order.
SalesOrderDate Date The date the sales order was created, establishing the context for when the order that led to the credit memo was placed.
SalesOrderLine String The line number of the sales order that corresponds to the credit memo line, ensuring the credit memo is matched with the correct order.
SalesOrderRevision Decimal The revision number for the sales order, helping to track updates or changes made to the original order.
SalesOrderChannel String The sales channel through which the sales order was created, providing insight into the medium used to place the order.
TaxClassificationCode String The tax classification code that governs how tax is calculated on the credit memo line, impacting the tax rate applied.
LineFreightCreditAmount Decimal The amount credited for freight charges on the credit memo line, used for adjusting shipping-related charges.
LineProductType String The type of product or service, which may influence how taxes are calculated or how the item is treated in the system. Valid values include 'Goods' and 'Services'.
ProductFiscalClassification String The fiscal classification assigned to the product, which determines its tax treatment based on regulations from tax authorities.
LineProductCategory String The product category for tax purposes, used to define the taxability of non-inventory items on the credit memo line.
TransactionBusinessCategory String The business category of the transaction, which helps categorize the credit memo for tax and reporting purposes.
UserDefinedFiscalClassification String A custom classification for the credit memo line, defined by the user to meet specific tax or regulatory requirements.
LineTaxExemptionHandling String Indicates how tax exemptions should be applied to the credit memo line, with valid values such as 'Standard', 'Require', and 'Exempt'.
LineAmountIncludesTax String Indicates whether the line amount includes tax, excludes tax, or is determined by the tax setup, impacting the calculation of the credited amount.
TaxExemptionReason String The reason why a party or product is exempt from tax, providing context for the tax exemption applied to the credit memo line.
TaxExemptionCertificateNumber String The certificate number that proves a party or product's eligibility for tax exemption, ensuring compliance with tax laws.
LineIntendedUse String The intended use of the product for tax purposes, which may influence the tax rate or exemptions applied to the credit memo line.
BindAccountingDate Date The accounting date that binds the credit memo line for financial reporting, indicating when the transaction is recorded.
BindAllowCompletion String Indicates whether the credit memo line is ready for completion in the system, with valid values such as 'Y' for yes or 'N' for no.
BindBillToCustomer String The customer associated with the credit memo line, specifying the entity to which the credit is applied.
BindBillToCustomerNumber String The unique identifier for the bill-to customer, used to track the credit memo line's relationship with the customer.
BindBillToSite String The site associated with the bill-to customer, ensuring the credit memo line is linked to the correct customer location.
BindBusinessUnit String The business unit responsible for the credit memo line, which may influence the financial and organizational handling of the credit.
BindCreditMemoCurrency String The currency used for the credit memo line, ensuring proper handling of multi-currency transactions.
BindCreditMemoStatus String The status of the credit memo line, such as 'Pending', 'Completed', or 'Cancelled', indicating the processing stage of the credit.
BindCrossReference String A reference that links the credit memo line to related transactions or documents, ensuring traceability.
BindDeliveryMethod String The method of delivering the credit memo to the customer, such as email or printed copy, for customer communication.
BindDocumentNumber Long The document number assigned to the credit memo line, used to uniquely identify and track the credit memo.
BindIntercompany String Indicates whether the credit memo line is part of an intercompany transaction, relevant for transactions between related business entities.
BindPrimarySalesperson String The salesperson responsible for the credit memo line, used for sales tracking and commission purposes.
BindPrintStatus String The status of the print process for the credit memo, indicating whether it has been printed or is still pending.
BindPurchaseOrder String The purchase order number associated with the credit memo line, linking the credit back to the original order.
BindShipToCustomerName String The name of the customer receiving the goods or services associated with the credit memo line.
BindShipToSite String The site number for the ship-to customer, ensuring the correct delivery location for goods or services.
BindTransactionDate Date The date the credit memo transaction occurred, helping with accounting and reporting.
BindTransactionNumber String The unique number for the credit memo transaction, used for tracking and referencing the credit.
BindTransactionSource String The source of the transaction that led to the creation of the credit memo, providing context for how the credit memo was generated.
BindTransactionType String The type of transaction, such as a return or adjustment, which defines how the credit memo is processed.
CustomerTransactionId Long The identifier for the customer transaction related to the credit memo line, ensuring the credit is linked to the appropriate customer record.
Finder String A reference term used to search and identify the credit memo line within the system, facilitating quick retrieval of the record.

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