CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

StandardReceiptsremittanceReferences

Enables adding references for payments, such as remittance advice numbers, assisting bank reconciliation and inquiries.

Columns

Name Type Description
StandardReceiptsStandardReceiptId [KEY] Long The unique identifier of the standard receipt to which the remittance reference is linked.
RemittanceReferenceId [KEY] Long The unique identifier of the remittance reference, used to track the link between the payment and the corresponding transaction.
ReceiptMatchBy String The method or document type used to match the standard receipt with a specific transaction, such as invoice or credit memo.
ReferenceNumber String The unique identifier of the selected document type used for matching the standard receipt to the transaction (for example, invoice number).
ReferenceAmount Decimal The amount applied to the reference document during the receipt process.
CreatedBy String The user who created the remittance reference entry in the system.
CreationDate Datetime The date and time when the remittance reference was created.
LastUpdatedBy String The user who last updated the remittance reference record.
LastUpdateDate Datetime The date and time when the remittance reference was last updated.
CustomerReason String The customer’s reason for any deductions or overpayments related to the standard receipt, typically used for Channel Revenue Management claims.
CustomerReference String The reference number provided by the customer for tracking or identifying claims related to Channel Revenue Management.
BusinessUnit String The business unit responsible for the standard receipt, helping categorize and manage transactions across different operational units.
CustomerAccountNumber String The account number of the customer associated with the remittance reference, used for payment matching and reconciliation.
CustomerName String The name of the customer to whom the standard receipt is linked.
CustomerSite String The site or location of the customer, which is linked to the standard receipt and remittance reference.
Finder String A field used for searching and locating the remittance reference in queries or reports, typically linked to the remittance reference record.
ReceiptDate Date The date when the standard receipt was created and the remittance reference was associated with it.
ReceiptNumber String The receipt number associated with the remittance reference, which uniquely identifies the payment.
StandardReceiptId Long The unique identifier of the standard receipt to which the remittance reference is linked, providing a direct connection between the payment and the reference.

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