ReceivablesCustomerUploadBatchOverview

The Receivables Customer Upload Batch Overview table provides summary information about customer upload batches. When a batch name and compressed file are submitted through the Upload Customers window and confirmed, the batch details are stored in both the Upload Customers Overview and History tables.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesCustomerUploadBatchesOverviewExtract**

  The Receivables Customer Upload Batch Overview table provides summary information about customer upload batches. When a batch name and compressed file are submitted through the Upload Customers window and confirmed, the batch details are stored in both the Upload Customers Overview and History tables.

  Label, Plural Label

  Customer Upload Batches Overview, Customer Upload Batches Overview

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • batchId (int64)

    Identifier of the receipt batch.

    Label

    Batch ID

    Properties

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

    Name of the batch submitted by the user.

    Label

    Batch Name

    Properties

    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • dataFile (string)

    Name of the spreadsheet upload batch file.

    Label

    Data File

  • sourceSystem (string)

    Original source system for the batch data.

    Label

    Source System

    Properties

    • not nullable
  • submissionTime (date-time)

    Date and time the batch was submitted for processing.

    Label

    Submission Time

  • successfulRecords (int64)

    Count of records successfully uploaded in the batch.

    Label

    Successful Records

  • 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
  • unsuccessfulRecords (int64)

    Count of records uploaded with errors in the batch.

    Label

    Unsuccessful Records

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • status (ERPLookupCode)

    Identifier of the customer batch posting 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

Back to Top