CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ReceivablesCreditMemos

Manages credit memo records in Receivables, including creation, retrieval, and referencing for financial adjustments.

Columns

Name Type ReadOnly Description
CustomerTransactionId [KEY] Long False

The unique identifier of the credit memo transaction, used to link and reference the specific credit memo in the system.

CustomerTransactionUniqId [KEY] String True

The unique identifier of the credit memo. Use this value for insert, update, and delete operations, wherever applicable, instead of CustomerTransactionId.

TransactionNumber String False

The unique number assigned to the credit memo, used to track and identify the credit memo for financial processing.

TransactionDate Date False

The date when the credit memo was created or processed, serving as the reference date for accounting and payment activities.

CreatedBy String True

The user who created the credit memo record, providing an audit trail for the creation process.

CreationDate Datetime True

The date and time when the credit memo was created, which helps in tracking the timeline of credit memo entries.

LastUpdatedBy String True

The user who last updated the credit memo record, ensuring traceability of modifications.

LastUpdateDate Datetime True

The date and time when the credit memo was last updated, marking the latest modification.

CreditMemoCurrency String False

The currency code representing the currency in which the credit memo was issued, essential for multi-currency transactions.

BusinessUnit String False

The business unit under which the credit memo is created. It defines the division within the organization that manages the transaction.

TransactionType String False

The type of transaction assigned to the credit memo, such as Refund, Adjustment, or Reversal, which classifies the purpose of the credit memo.

TransactionSource String False

The source system or process that generated the credit memo, helping to track and categorize the origin of the transaction.

AccountingDate Date False

The accounting date for the credit memo, used for posting to financial ledgers and determining the relevant period for recognition.

LegalEntityIdentifier String False

The identifier of the legal entity under which the credit memo is created, distinguishing the entity for legal and tax purposes.

CreditReason String False

The reason provided for creating the credit memo, such as a pricing error, customer refund, or returned goods.

BillToCustomerNumber String False

The account number of the bill-to customer, representing the customer who is being billed for the credit memo.

BillToSite String False

The site number of the bill-to customer, specifying the physical location or branch where the billing occurs.

BillToCustomerName String False

The name of the bill-to customer, used for addressing the credit memo to the correct entity.

EnteredAmount Decimal True

The amount of the credit memo in the entered currency, reflecting the financial value being credited.

DocumentNumber Long False

The document sequence number assigned to the credit memo, serving as a unique reference for document tracking and filing.

CrossReference String False

A reference field from the transaction source used to track the original transaction or related documents for auditing purposes.

CustomerReference String False

An additional reference document or code used by the customer to provide further context or details regarding the credit memo.

CustomerReferenceDate Date False

The date when the customer requested the credit memo, used to establish the timeline for customer interactions.

BillingDate Date False

The balance-forward bill date, relevant if the credit memo applies to an ongoing billing cycle.

PurchaseOrder String False

The purchase order number linked to the credit memo, allowing for reconciliation between purchase and payment records.

SpecialInstructions String False

Any special instructions accompanying the credit memo, providing additional guidance for processing or customer service.

CreditMemoComments String False

The user-provided comments detailing important notes about the credit memo, useful for internal reference or customer communication.

DefaultTaxationCountry String False

The country used for tax purposes related to the credit memo, determining the applicable tax jurisdiction.

FreightShipDate Date False

The date when the items associated with the credit memo were shipped, used for freight and shipping reconciliations.

Carrier String False

The shipping carrier responsible for transporting goods related to the credit memo.

FreightShippingReference String False

The waybill reference number for the freight shipment, used to track the movement of goods.

FreightFOB String False

The point of transfer for ownership of goods, indicating where the risk and responsibility shift from seller to buyer.

ConversionRateType String False

Defines the method of currency conversion used for the credit memo, such as Spot, Corporate, User, or Fixed, for multi-currency transactions.

ConversionRate Decimal False

The currency conversion rate applied to the credit memo transaction, converting it to the ledger currency.

ConversionRateDate Date False

The date used to determine the conversion rate for the credit memo transaction, ensuring accurate exchange rate usage.

FirstPartyRegistrationNumber String False

The tax registration number of the company issuing the credit memo, used for tax reporting and compliance.

ThirdPartyRegistrationNumber String False

The tax registration number of the customer receiving the credit memo, necessary for tax reporting and compliance.

ShipToCustomerName String False

The name of the customer receiving the goods or services billed in the credit memo.

ShipToCustomerNumber String False

The account number of the customer receiving the goods or services in the credit memo.

ShipToCustomerSite String False

The site number where the goods or services are shipped to the customer.

FreightCreditAmount String False

The amount of freight credited by the credit memo, typically related to shipping adjustments or refunds.

PrimarySalesperson String False

The number identifying the primary salesperson associated with the credit memo transaction.

Intercompany String False

Indicates whether the credit memo is part of an intercompany transaction, involving different entities within the same organization.

TransactionBalanceDue Decimal True

The outstanding balance on the credit memo that needs to be paid by the customer.

DeliveryMethod String True

The method used to deliver the credit memo, such as E-Mail, Paper, or XML, for customer communication.

PrintStatus String True

The status indicating whether the credit memo has been printed, for tracking physical document generation.

PrintDate Date True

The date when the credit memo was printed, helping to confirm document dispatch timelines.

GenerateBill String False

Indicates whether a bill should be generated for the credit memo, marking it for further processing in the billing system.

DocumentFiscalClassifcation String True

The tax classification of the credit memo, based on regulatory requirements for special documentation accompanying the transaction.

PayingCustomerName String False

The name of the customer who is responsible for paying for the goods or services covered by the credit memo.

PayingCustomerSite String False

The site number of the customer making the payment for the credit memo.

PayingCustomerAccount String False

The account number of the paying customer, who is responsible for paying the credit memo amount.

BillToContact String False

The contact details for the bill-to customer, used for correspondence regarding the credit memo.

ShipToContact String False

The contact details for the ship-to customer, used for correspondence regarding shipping and delivery.

SoldToPartyNumber String False

The unique number identifying the sold-to customer on the credit memo, used for internal tracking.

PurchaseOrderDate Date False

The date the associated purchase order was created, serving as a reference for the original transaction.

CreditMemoStatus String False

The current status of the credit memo, such as Complete, Incomplete, or Frozen, indicating its processing stage.

InternalNotes String False

Internal user-defined notes related to the credit memo, typically for internal use or clarification.

PurchaseOrderRevision String False

The revision number associated with the purchase order, indicating any changes or updates to the original order.

StructuredPaymentReference String False

An industry-standard reference used for linking credit memo transactions to payments and customer accounts.

AllowCompletion String False

Indicates whether the credit memo has been reviewed and is ready for completion. Valid value is 'Y' for allowed.

ControlCompletionReason String False

The reason provided for determining whether a transaction is allowed to complete, helping track the status of the transaction.

RecipientEmail String False

The email address of the customer or contact who receives notifications or printed versions of the credit memo.

receivablesCreditMemoTransactionDFF String False

A field used exclusively for inserting new records. For updates or deletes, child table operations should be used.

notes String False

Field used exclusively for inserting new records. For updates or deletes, child table operations should be used.

receivablesCreditMemoDistributions String False

This field is for inserting new records only. Use child table operations for updates or deletes.

receivablesCreditMemoDFF String False

This field is for insert-only operations. Use child table operations for updates or deletions.

receivablesCreditMemoGdf String False

This field is for insert-only operations. For updates or deletes, refer to child table operations.

receivablesCreditMemoLines String False

This column is for insert-only use. For updates and deletions, child table operations should be used.

BindAccountingDate Date True

The date used for accounting purposes in credit memo transactions, ensuring the correct accounting period.

BindAllowCompletion String True

Indicates whether the credit memo transaction can be completed. Typically marked as 'Y' for allowed.

BindBillToCustomer String True

The identifier for the bill-to customer associated with the credit memo.

BindBillToCustomerNumber String True

The account number of the bill-to customer for the credit memo.

BindBillToSite String True

The site number for the bill-to customer related to the credit memo.

BindBusinessUnit String True

The business unit associated with the credit memo, tracking which division is handling the transaction.

BindCreditMemoCurrency String True

The currency used for the credit memo, important for multi-currency transactions.

BindCreditMemoStatus String True

The current status of the credit memo, indicating its processing stage.

BindCrossReference String True

A cross-reference number for tracking linked transactions or related documents.

BindDeliveryMethod String True

The delivery method for the credit memo, such as E-Mail or Paper.

BindDocumentNumber Long True

The document number assigned to the credit memo for tracking purposes.

BindIntercompany String True

Indicates whether the credit memo is part of an intercompany transaction, typically marked as 'Y' for intercompany.

BindPrimarySalesperson String True

The primary salesperson associated with the credit memo transaction.

BindPrintStatus String True

Indicates whether the credit memo has been printed.

BindPurchaseOrder String True

The purchase order number linked to the credit memo.

BindShipToCustomerName String True

The name of the ship-to customer for the credit memo.

BindShipToSite String True

The site number of the ship-to customer for the credit memo.

BindTransactionDate Date True

The date when the credit memo transaction occurred.

BindTransactionNumber String True

The transaction number for the credit memo.

BindTransactionSource String True

The source system that generated the credit memo transaction.

BindTransactionType String True

The type of the transaction, such as adjustment or refund, associated with the credit memo.

Finder String True

A reference key or search term used to find the credit memo record in the system.

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