PayablesInvoiceBatch

Invoice batch stores summary information about invoices entered in batches when the Batch Control Payables option is enabled. There is one row for each batch of invoices entered in system. It uses this information to group together invoices that a person entered in one batch.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesInvoiceBatchesExtract**

  Invoice batch stores summary information about invoices entered in batches when the Batch Control Payables option is enabled. There is one row for each batch of invoices entered in system. It uses this information to group together invoices that a person entered in one batch.

  Label, Plural Label

  Payables Invoice Batches, Payables Invoice Batches

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • batchDate (date)

    The date when the invoice group was created.

    Properties

    • searchable
    • sortable
    • not nullable
  • batchId (int64)

    The unique identifier of the invoice group.

    Label

    Invoice Group

    Properties

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

    The name of the invoice group.

    Label

    Invoice Group

    Properties

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

    The user who created the record.

    Label

    Created By

    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

  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

  • invoiceCurrency (Currency)

    The currency in which a supplier invoice is received.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceTypeCode (ERPLookupCode)

    The code representing the type of invoice. Valid values are STANDARD, PREPAYMENT, CREDIT MEMO, and DEBIT MEMO. This attribute value can either be provided while creating the invoice or derived based on the invoice amount. The positive invoice amount is considered as standard invoice and negative values are considered as credit memo. A list of accepted values are defined in the lookup INVOICE TYPE. Review and update the list of values using the Setup and Maintenance work area, and the Manage Payables Lookups task.

    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
    • meaning (string)

      The translated meaning of the Lookup Code.

      Label

      Lookup Code Meaning

      Properties

      • inherited
      • translatable
      • not nullable

  • paymentCurrency (Currency)

    The code representing the currency that the payment is made in.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top