ReceivablesLockboxTransmissionFormatField

The Receivables lockbox transmission format field provides the details of each field in a lockbox transmission, including field type, field starting position, field ending position, description, data type formats, and other information.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesLockboxTransmissionFormatFieldsExtract**

  The Receivables lockbox transmission format field provides the details of each field in a lockbox transmission, including field type, field starting position, field ending position, description, data type formats, and other information.

  Label, Plural Label

  Transmission Fields, Transmission Fields

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of a lockbox transmission format field.

    Label

    Description

  • endPosition (big-decimal)

    Ending position of a lockbox transmission field type within a lockbox transmission record.

    Label

    End Position

    Properties

    • not nullable
  • formatAmountCode (string)

    Indicates whether to format the transmitted amount to the ledger currency precision. If Yes, the lockbox process rounds the format amount to the same degree of precision and the same number of decimal places as the ledger currency. If No, the lockbox process keeps the existing amount without rounding it.

    Label

    Format Amount

  • overflowRecordFlag (boolean)

    Record that stores additional information about a receipt in the lockbox transmission. If there are multiple overflow records for a receipt, each overflow record is assigned an overflow sequence number.

    Label

    Overflow Record

  • startPosition (big-decimal)

    Starting position of a lockbox transmission field type within a lockbox transmission record.

    Label

    Start Position

    Properties

    • not nullable
  • 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 Updated Date

    Properties

    • not nullable
  • transmissionFormatFieldId (int64)

    Identifier of the lockbox transmission format field.

    Label

    Transmission Format Field ID

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • dateFormat (ERPLookupCode)

    Indicates the date format to be used during the 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

  • fieldType (ERPLookupCode)

    Code that identifies a specific field type in a lockbox transmission format, for example, batch header, batch trailer, lockbox header, transmission header, and receipt.

    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

  • fillSymbol (ERPLookupCode)

    Indicates whether the lockbox transmission field type contains blank spaces or zeroes to fill out extra spaces.

    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

  • justify (ERPLookupCode)

    Indicates from which side to read data in the transmission field, either left or right.

    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

  • timeFormat (ERPLookupCode)

    Indicates the time format to be used during the 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

  • transmissionFormat (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

  • transmissionRecord (ReceivablesLockboxTransmissionFormatRecord)

    The Receivables lockbox transmission format record provides the details of each record in a lockbox transmission format, including record identifier, record type, and description. Lockbox receipt processing makes use of transmission formats, also called control files (.ctl), to specify how the data in a bank file is organized for import into the Receivables interface tables.

    Business Object

    ReceivablesLockboxTransmissionFormatRecord

    Expand all

    Collapse all

    Fields

    • transmissionFormatRecordId (int64)

      Identifier of the lockbox transmission format record.

      Label

      Transmission Format Record ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top