ReceivablesLockboxTransmission

The Receivables Lockbox Transmission business object provides the details of the validation of the data imported from the bank file using a lockbox file transmission.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesLockboxTransmissionsExtract**

  The Receivables Lockbox Transmission business object provides the details of the validation of the data imported from the bank file using a lockbox file transmission.

  Label, Plural Label

  Receivables Lockbox Transmissions, Receivables Lockbox Transmissions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • bankOriginationNumber (string)

    The identifier of the originating organization of the lockbox transmission.

    Label

    Bank Origination Number

  • comments (string)

    The user-entered comments for the lockbox transmission.

    Label

    Comments

  • controlAmount (big-decimal)

    The total amount of all receipts in the lockbox transmission.

    Label

    Control Amount

  • controlCount (int64)

    The number of records read in the lockbox transmission.

    Label

    Control Count

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • destinationBankAccount (string)

    The destination bank account for the lockbox transmission.

    Label

    Destination Bank Account

  • documentFormat (string)

    Business or banking format of the inbound file, such as CAMT52, BAI2, lockbox format, bank statement format, or remittance advice format.

    Label

    Document Format

    Properties

    • creatable
    • updatable
  • documentName (string)

    Name of the inbound file received for processing, as uploaded, transmitted, or imported into the application.

    Label

    Document Name

    Properties

    • creatable
    • updatable
  • documentStatusCode (string)

    Status of the inbound file transfer or ingestion activity, indicating whether the file was received, transferred, failed, or completed before product-level processing.

    Label

    Document Status Code

    Properties

    • creatable
    • updatable
  • fileType (string)

    File extension or physical file type of the inbound file, such as PDF, CSV, TXT, or XML.

    Label

    File Type

    Properties

    • creatable
    • updatable
  • incomingDocumentReference (int64)

    Identifier of the corresponding Doc IO document, when the inbound file is stored or tracked through Doc IO. This enables linkage between product processing records and Doc IO ingestion - transmission details.

    Label

    Document ID

    Properties

    • creatable
    • updatable
  • numberOfExceptions (int64)

    The number of error records in the lockbox transmission.

    Label

    Number of Exceptions

  • objectStoreReference (int64)

    Reference identifier for the file object stored in object storage or Doc IO-backed storage. Used to locate or retrieve the physical file content or related stored object.

    Label

    Object Store Reference ID

    Properties

    • creatable
    • updatable
  • processingSummary (string)

    Summary of file processing outcome, including success, warning, or failure details captured during import or downstream processing. This can include high-level error context when transactional parent records aren't created.

    Label

    Processing Summary

    Properties

    • creatable
    • updatable
  • requestedAccountingDate (date)

    The accounting date of the receipts in the lockbox transmission.

    Label

    Requested Accounting Date

  • sourceType (enumeration: SourceTypeIndicator)

    The lockbox transmission source type.

    Label

    Source Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: SourceTypeIndicator

    Valid Values

    • L
  • time (string)

    The deposit time of the lockbox transmission.

    Label

    Time

  • 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
  • transmissionDate (date)

    The deposit date of the lockbox transmission.

    Label

    Transmission Date

  • transmissionId (int64)

    The unique identifier of the lockbox transmission.

    Label

    Transmission ID

    Properties

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

    The lockbox transmission name.

    Label

    Transmission Name

    Properties

    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • validatedAmount (big-decimal)

    The total validated payment amount in the lockbox transmission.

    Label

    Validated Amount

  • validatedCount (int64)

    The total number of validated records in the lockbox transmission.

    Label

    Validated Count

  Expand all

  Collapse all

  Reference Object

  • 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

  • processStatus (ERPLookupCode)

    The lockbox transmission status.

    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

  • requestedTransmissionFormat (ReceivablesLockboxTransmissionFormat)

    The Receivables Lockbox Transmission Format business object provides the details of the predefined lockbox transmission formats.

    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