AccountingPeriodStatus

The Accounting Period Status stores the statuses of your accounting periods for a ledger and subledger application. Each row includes the accounting period name and status.

Expand all

Collapse all

Business Views

** Available for extracting data

• accountingPeriodStatusesExtract**

  The Accounting Period Status stores the statuses of your accounting periods for a ledger and subledger application. Each row includes the accounting period name and status.

  Label

  Accounting Period Statuses

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • adjustmentPeriodFlag (boolean)

    Indicates whether the accounting period is an adjusting period. Valid values are Y and N. Y indicates that the period is an adjusting period and N indicates that the period is a standard period.

    Label

    Adjusting Period

    Properties

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

    The unique identifier of the application.

    Label

    Application ID

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • effectivePeriodNumber (int64)

    The effective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source.

    Label

    Effective Period Number

    Properties

    • searchable
    • sortable
    • not nullable
  • endDate (date)

    The date when the accounting calendar period ends.

    Label

    End Date

    Properties

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

    The unique identifier of the ledger for which the accounting entry is created.

    Label

    Ledger ID

    Properties

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

    The name of the accounting period. This attribute is a part of the composite key of the Period Statuses view object.

    Label

    Period Name

    Properties

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

    The unique number of the accounting period within the calendar year.

    Label

    Period Number

    Properties

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

    The year for the accounting calendar period represented by a numeric value, such as 2020.

    Label

    Year

    Properties

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

    The number of the quarter in which a particular period falls within the accounting calendar year.

    Label

    Quarter Number

    Properties

    • searchable
    • sortable
    • not nullable
  • quarterStartDate (date)

    The date when the quarter containing this accounting period starts.

    Label

    Accounting Quarter Start Date

    Properties

    • searchable
    • sortable
    • not nullable
  • startDate (date)

    The date when the accounting period begins.

    Label

    Start Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • yearStartDate (date)

    The date when the year containing this accounting period starts.

    Label

    Accounting Year Start Date

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountingPeriodType (AccountingPeriodType)

    An Accounting Period Type contains the details of the system generated period type along with number of periods per year and calendar or fiscal year type of calendar. This determines the system assigned name for the accounting calendar.

    Business Object

    AccountingPeriodType

    Expand all

    Collapse all

    Fields

    • periodType (string)

      The frequency of the accounting period, such as, Weekly, Monthly, and Quarterly. The list of accepted values for period frequency can be found in the lookup type CAL_NON_ADJ_FREQ. When creating a calendar with period frequency codes, the period type is concatenated with a unique number. For example, MONTH2558721688.

      Label

      Period Type

      Properties

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

      The unique identifier of the accounting period type.

      Label

      Period Type ID

      Properties

      • searchable
      • sortable
      • not nullable

  • periodCloseStatus (ERPLookupCode)

    Status of the accounting period. Possible values are defined in the lookup type CLOSING_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

Back to Top