PayablesAgingPeriodLine

An aging period line stores details about an individual aging period. The Invoice Aging Report retrieves data based on multiple aging period lines defined in this table. Each row represents a date range used by the report to assign invoices.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesAgingPeriodLinesExtract**

  An aging period line stores details about an individual aging period. The Invoice Aging Report retrieves data based on multiple aging period lines defined in this table. Each row represents a date range used by the report to assign invoices.

  Label, Plural Label

  Payables Aging Period Lines, Payables Aging Period Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • agingPeriodLineId (int64)

    Unique identifier of the aging period line. This is the primary key of the Aging Period Lines view object.

    Label

    Aging Period Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • columnOrder (int32)

    The order of this particular date range for the aging period line within the entire period.

    Label

    Column Order

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • daysStart (int32)

    The starting day number for aging period line.

    Label

    From

  • daysTo (int32)

    The ending day number for aging period line.

    Label

    To

  • firstColumnHeading (string)

    First column heading for the aging period line.

    Label

    First

  • secondColumnHeading (string)

    Second column heading for the aging period line.

    Label

    Second

  • thirdColumnHeading (string)

    Third column heading for the aging period line.

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

    The type of aging period.

    Label

    Aging Period Type

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • agingPeriod (PayablesAgingPeriod)

    Unique identifier of aging period for which aging lines are defined.

    Business Object

    PayablesAgingPeriod

    Expand all

    Collapse all

    Fields

    • agingPeriodId (int64)

      The unique identifier of the aging period. This is the primary key of the Aging Periods view object.

      Label

      Aging Period ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top