ReceivablesRemittanceReference

The Receivables Receipt Remittance Reference business object provides the number and document reference used to match receipts to transactions.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesReceiptRemittanceReferencesExtract**

  The Receivables Receipt Remittance Reference business object provides the number and document reference used to match receipts to transactions.

  Label, Plural Label

  Receivables Receipt Remittance References, Receivables Receipt Remittance References

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allowPaymentofUnrelatedTransactions (string)

    The Receivables system option that indicates whether payment of unrelated customer transactions is enabled for the business unit associated with the cash remittance reference document.

    Label

    Allow Payment of Unrelated Transactions

  • amountApplied (big-decimal)

    For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross-currency applications, the total amount of the application in the currency of the transaction.

    Label

    Amount Applied

    Properties

    • creatable
    • updatable
  • amountAppliedFrom (big-decimal)

    Amount applied to the transaction in the receipt currency (cross-currency applications only).

    Label

    Amount Applied From

  • autoapply (enumeration: AutoapplyIndicator)

    The option that indicates whether AutoApply is enabled on the cash remittance receipt.

    Label

    AutoApply

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AutoapplyIndicator

    Valid Values

    • N
    • Y
  • balanceFwdBillNumber (string)

    Balance forward bill number from the remittance reference.

    Label

    Balance Forward Bill Number

    Properties

    • creatable
    • updatable
  • contractNumber (string)

    Contract number from the remittance reference.

    Label

    Contract Number

    Properties

    • creatable
    • updatable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerNumber (string)

    Number of the customer account.

    Label

    Customer Account Number

  • customerReason (string)

    Customer reason codes associated with the remittance.

    Label

    Customer Reason

    Properties

    • creatable
    • updatable
  • customerReference (string)

    Customer reference associated with the remittance.

    Label

    Customer Reference

    Properties

    • creatable
    • updatable
  • deductionActivityCode (string)

    Activity code for the deduction amount applied to the transaction or transaction line from the remittance reference. Valid values are derived from the ORA_AR_REM_DEDUCTION_CODE lookup.

    Label

    Deduction Activity Code

    Properties

    • creatable
    • updatable
  • deductionAmount (big-decimal)

    Deduction amount applied to the transaction or transaction line from the remittance reference.

    Label

    Deduction Amount

    Properties

    • creatable
    • updatable
  • deductionDetails (string)

    Details about the deduction amount applied to the transaction or transaction line from the remittance reference.

    Label

    Deduction Details

    Properties

    • creatable
    • updatable
  • discountTaken (big-decimal)

    Discount amount applied to the transaction or transaction line from the remittance reference.

    Label

    Discount Amount

    Properties

    • creatable
    • updatable
  • invoiceCurrencyCode (string)

    Currency code of the transaction that the receipt is applied to.

    Label

    Invoice Currency Code

  • invoiceReference (string)

    Transaction reference number.

    Label

    Reference Number

    Properties

    • creatable
    • updatable
  • lockboxMatchingOption (string)

    Indicates the reference used to match the receipt to an invoice. Valid values are: Transaction Number, Shipping Number, Contract Number, Purchase Order Number and Sales Order Number.

    Label

    Lockbox Matching Option

    Properties

    • creatable
    • updatable
  • matchingReferenceDate (date)

    The date of the matching document belonging to the cash remittance reference.

    Label

    Matching Reference Date

  • purchaseOrderNumber (string)

    Purchase order number from the remittance reference.

    Label

    Purchase Order

    Properties

    • creatable
    • updatable
  • receiptReferenceStatus (string)

    Status of the remittance reference.

    Label

    AutoMatch Application Status

    Properties

    • creatable
    • not nullable
    • updatable
  • referenceDate (date)

    Original transaction date from the remittance reference.

    Label

    Reference Date

    Properties

    • creatable
    • updatable
  • referenceDueDate (date)

    Original transaction due date from the remittance reference.

    Label

    Reference Due Date

    Properties

    • creatable
    • updatable
  • referenceSource (string)

    This is an Oracle internal attribute used to track the source of the remittance reference. Valid values are: Lockbox, Create Spreadsheet, Create Receipt page, Bank Statement, Remittance Advice.

    Label

    Reference Source

    Properties

    • creatable
    • not nullable
  • remittanceReferenceId (int64)

    Identifier of the remittance reference.

    Label

    Remittance Reference Identifier

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
    • updatable
  • resolvedMatchInstallment (int64)

    The cash remittance reference matching transaction selected.

    Label

    Resolved Match Installment

  • resolvedMatchingDate (date)

    The cash remittance reference transaction date of the matching transaction selected.

    Label

    Resolved Matching Date

  • resolvedMatchingNumber (string)

    The cash remittance reference transaction number of the matching transaction selected.

    Label

    Resolved Matching Number

  • salesOrder (string)

    Sales order number from the remittance reference.

    Label

    Sales Order

    Properties

    • creatable
    • updatable
  • structuredPaymentReference (string)

    An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and its payments to the customer and bank.

    Label

    Structured Payment Reference

    Properties

    • creatable
    • updatable
  • taxWithholdingAmount (big-decimal)

    Withholding tax amount on the transaction from the remittance reference.

    Label

    Tax Withholding Amount

    Properties

    • creatable
    • updatable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Update Date

    Properties

    • not nullable
  • transactionNumber (string)

    Indicates the reference used to match the receipt to an invoice. Valid values are: Transaction Number, Shipping Number, Contract Number, Purchase Order Number and Sales Order Number.

    Label

    Transaction Number

    Properties

    • creatable
    • updatable
  • transactionStatus (string)

    The status of the transaction belonging to the cash remittance reference.

    Label

    Transaction Status

  • transactionToReceiptRate (big-decimal)

    Conversion rate used to convert the amount applied in the transaction currency to the amount applied in the receipt currency (cross-currency applications only).

    Label

    Transaction to Receipt Rate

  • transitRoutingNumber (string)

    The cash remittance reference bank routing number.

    Label

    Transit Routing Number

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • vatAmount (big-decimal)

    VAT amount on the transaction from the remittance reference.

    Label

    VAT Amount

    Properties

    • creatable
    • updatable
  • waybillNumber (string)

    Waybill number from the remittance reference.

    Label

    Waybill Number

    Properties

    • creatable
    • updatable

  Expand all

  Collapse all

  Reference Object

  • automatchRuleSet (ReceivablesAutomatchRuleSet)

    The AutoMatch rule set provides the details of the AutoMatch rule set. The details include reference set, name, description, start date, end date, customer recommendation threshold, minimum match hold, combined weighted hold, and days of closed invoices hold.

    Business Object

    ReceivablesAutomatchRuleSet

    Expand all

    Collapse all

    Fields

    • automatchRuleId (int64)

      The identifier of the AutoMatch rule set.

      Label

      AutoMatch Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • cashReceipt (ReceivablesReceipt)

    The receivables receipt contains information about receipts, including receipt number, receipt method, receipt type, status, business unit, customer, receipt date, amount, and total applied amount. One record is created for each receipt.

    Business Object

    ReceivablesReceipt

    Expand all

    Collapse all

    Fields

    • cashReceiptId (int64)

      The identifier of the cash receipt.

      Label

      Cash Receipt ID

      Properties

      • searchable
      • sortable
      • not nullable

  • customerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • paymentSchedule (ReceivablesTransactionPaymentSchedule)

    A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

    Business Object

    ReceivablesTransactionPaymentSchedule

    Expand all

    Collapse all

    Fields

    • paymentScheduleId (int64)

      The identifier of the payment schedule.

      Label

      Payment Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receivablesTransaction (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • remitAdvice (ReceivablesRemittanceAdvice)

    The remittance advice view object contains information that includes payment amount, payment number, currency code, bank transaction ID, and customer details.

    Business Object

    ReceivablesRemittanceAdvice

    Expand all

    Collapse all

    Fields

    • remittanceAdviceId (int64)

      Identifier of the remittance advice.

      Label

      Remittance Advice ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

Back to Top