ReceivablesLockbox

The Receivables Lockbox provides details about the lockbox service, which is offered by commercial banks to corporate customers for outsourcing their accounts receivable payment processing. Oracle Fusion Receivables ensures that the data is valid before creating receipt batches. This verification occurs using Lockbox definitions when transferring receipts from your bank file into the Receivables system.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesLockboxesExtract**

  The Receivables Lockbox provides details about the lockbox service, which is offered by commercial banks to corporate customers for outsourcing their accounts receivable payment processing. Oracle Fusion Receivables ensures that the data is valid before creating receipt batches. This verification occurs using Lockbox definitions when transferring receipts from your bank file into the Receivables system.

  Label, Plural Label

  Receivables Lockboxes, Receivables Lockboxes

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeFlag (boolean)

    Indicates the state of an application object. An active object can be used in transactions.

    Label

    Active

    Properties

    • not nullable
  • batchSize (int64)

    The maximum number of receipts that can be included in a lockbox batch.

    Label

    Batch Size

  • createClaimsFlag (boolean)

    Indicates whether to enable claim creation in Channel Revenue Management for receipts or remittances processed by this lockbox.

    Label

    Create claims

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • invalidTransactionNumberHandlingFlag (boolean)

    Indicates whether to process receipts that couldn't be fully applied because of invalid transaction numbers. Valid values are Y or N.

    Label

    Invalid Transaction Number Handling

  • lockboxId (int64)

    The identifier of the lockbox associated with the receipt batch.

    Label

    Lockbox ID

    Properties

    • searchable
    • sortable
    • not nullable
  • lockboxNumber (string)

    Lockbox batch number.

    Label

    Lockbox Number

    Properties

    • not nullable
  • requireBillingLocation (string)

    Indicates whether the Lockbox only validates receipts that have a billing location.

    Label

    Require billing location

    Properties

    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • useAutoApplyFlag (boolean)

    Indicates whether to activate the Receipt AutoApply feature for the specified business unit.

    Label

    Use AutoApply

  • useMatchCriteriaToDetermineCustomerFlag (boolean)

    Indicates whether the Lockbox can determine the customer of a lockbox file based on the match criteria.

    Label

    Use match criteria to determine customer

  Expand all

  Collapse all

  Reference Object

  • accountingDateSource (ERPLookupCode)

    Accounting date source for receipts in a lockbox transmission.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • applicationExceptionRule (ReceivablesApplicationExceptionRule)

    The receivables application exception rule setup describes and groups rules for handling underpayments or overpayments, such as adjusting underpayments or issuing refunds for overpayments.

    Business Object

    ReceivablesApplicationExceptionRule

    Expand all

    Collapse all

    Fields

    • exceptionRuleId (int64)

      The identifier of the receipt application exception rule.

      Label

      Exception Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • matchReceiptsBy (ERPLookupCode)

    Document reference used to match receipts with transactions.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • matchonCorrespondingDate (ERPLookupCode)

    Indicates how to match dates in a lockbox transmission when the matching document date is the same as the lockbox transmission date. A list of accepted values is defined in the ARLPLB_USE_MATCHING_DATE lookup type.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
    • lookupType (string)

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • receiptMethod (ReceivablesReceiptMethod)

    The receipt method contains information that defines how payments are applied or allocated within receivables. The information includes the receipt class, receipt method name and description, the option for debit memos to inherit receipt numbers, the option for receipt to inherit transaction numbers, grouping number of receipts rule, receipt maturity date rule, and lead days. For automatically created receipts, receipt methods define the rules for creating these receipts. For manually created receipts, receipt methods define user-definable receipt types. Each receipt method is linked with a specific set of remittance bank accounts, which can be assigned to a receipt. For instance, if you receive lockbox transmissions from multiple banks, you can create a lockbox receipt method with the bank accounts from the banks assigned to them.

    Business Object

    ReceivablesReceiptMethod

    Expand all

    Collapse all

    Fields

    • receiptMethodId (int64)

      The identifier of the receipt method.

      Label

      Receipt Method ID

      Properties

      • searchable
      • sortable
      • not nullable

  • receiptSource (ReceivablesReceiptSource)

    The Receivables Receipt Source outlines the default values for the receipt class, bank account, and payment method for each receipt within a receipt batch, which are grouped for batch processing. This functionality also assists Oracle Receivables in managing the grouping, processing, and accounting of receipts effectively.

    Business Object

    ReceivablesReceiptSource

    Expand all

    Collapse all

    Fields

    • receiptSourceSequenceId (int64)

      Identifier of the payment batch source sequence.

      Label

      Receipt Source Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • setIdSet (SetIdSet)

    The set is a logical group used for partitioning and sharing reference data across transactional entities, depending on the business context. The common set indicates that data isn't partitioned and is globally shared.

    Business Object

    SetIdSet

    Expand all

    Collapse all

    Fields

    • setId (int64)

      The unique identifier of the set ID set.

      Label

      Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • transmissionFormat (ReceivablesLockboxTransmissionFormat)

    Business Object

    ReceivablesLockboxTransmissionFormat

    Expand all

    Collapse all

    Fields

    • transmissionFormatId (int64)

      The identifier of the lockbox transmission format.

      Label

      Transmission Format ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top