GeneralLedgerAllSegmentsAccount

A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

Expand all

Collapse all

Business Views

** Available for extracting data

• generalLedgerAccountsAllSegmentsExtract**

  A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

  Label

  General Ledger Accounts All Segments

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • chartOfAccountsId (string)

    The unique identifier of the chart of accounts.

    Label

    Chart of Accounts

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
    • not nullable
  • codeCombinationId (int64)

    The unique identifier of the account combination.

    Label

    Account ID

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable
  • detailBudgetingAllowedFlag (boolean)

    Indicates whether budgeting is allowed for the account combination.

    Label

    Allow Budgeting

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
    • not nullable
  • detailPostingAllowedFlag (boolean)

    Indicates whether the account can be used for posting.

    Label

    Allow Posting

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
    • not nullable
  • enabledFlag (boolean)

    Indicates whether the account can be used in transactions.

    Label

    Enabled

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
    • not nullable
  • endDateActive (date)

    The date when the account combination is no longer active.

    Label

    To Date

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
  • preserveFlag (boolean)

    Prevents updates to attribute values on account combinations.

    Label

    Preserve Attributes

    Properties

    • inherited
    • searchable
    • sortable
  • reconciliationContext (string)

    Descriptive flexfield context name for General Ledger Account.

    Label

    Reconciliation Context

    Properties

    • inherited
    • searchable
    • sortable
  • reconciliationFlag (boolean)

    The name of the column that indicates whether reconciliation is enabled for the account.

    Label

    Reconciliation

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
  • refreshFlag (boolean)

    Indicates whether the segment value attributes can be reloaded.

    Label

    Refresh Segment Value Attribute

    Properties

    • inherited
    • searchable
    • sortable
  • segment1 (string)

    Segment 1 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 1

    Properties

    • searchable
    • sortable
  • segment10 (string)

    Segment 10 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 10

    Properties

    • searchable
    • sortable
  • segment11 (string)

    Segment 11 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 11

    Properties

    • searchable
    • sortable
  • segment12 (string)

    Segment 12 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 12

    Properties

    • searchable
    • sortable
  • segment13 (string)

    Segment 13 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 13

    Properties

    • searchable
    • sortable
  • segment14 (string)

    Segment 14 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 14

    Properties

    • searchable
    • sortable
  • segment15 (string)

    Segment 15 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 15

    Properties

    • searchable
    • sortable
  • segment16 (string)

    Segment 16 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 16

    Properties

    • searchable
    • sortable
  • segment17 (string)

    Segment 17 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 17

    Properties

    • searchable
    • sortable
  • segment18 (string)

    Segment 18 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 18

    Properties

    • searchable
    • sortable
  • segment19 (string)

    Segment 19 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 19

    Properties

    • searchable
    • sortable
  • segment2 (string)

    Segment 2 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 2

    Properties

    • searchable
    • sortable
  • segment20 (string)

    Segment 20 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 20

    Properties

    • searchable
    • sortable
  • segment21 (string)

    Segment 21 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 21

    Properties

    • searchable
    • sortable
  • segment22 (string)

    Segment 22 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 22

    Properties

    • searchable
    • sortable
  • segment23 (string)

    Segment 23 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 23

    Properties

    • searchable
    • sortable
  • segment24 (string)

    Segment 24 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 24

    Properties

    • searchable
    • sortable
  • segment25 (string)

    Segment 25 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 25

    Properties

    • searchable
    • sortable
  • segment26 (string)

    Segment 26 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 26

    Properties

    • searchable
    • sortable
  • segment27 (string)

    Segment 27 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 27

    Properties

    • searchable
    • sortable
  • segment28 (string)

    Segment 28 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 28

    Properties

    • searchable
    • sortable
  • segment29 (string)

    Segment 29 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 29

    Properties

    • searchable
    • sortable
  • segment3 (string)

    Segment 3 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 3

    Properties

    • searchable
    • sortable
  • segment30 (string)

    Segment 30 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 30

    Properties

    • searchable
    • sortable
  • segment4 (string)

    Segment 4 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 4

    Properties

    • searchable
    • sortable
  • segment5 (string)

    Segment 5 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 5

    Properties

    • searchable
    • sortable
  • segment6 (string)

    Segment 6 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 6

    Properties

    • searchable
    • sortable
  • segment7 (string)

    Segment 7 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 7

    Properties

    • searchable
    • sortable
  • segment8 (string)

    Segment 8 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 8

    Properties

    • searchable
    • sortable
  • segment9 (string)

    Segment 9 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 9

    Properties

    • searchable
    • sortable
  • startDateActive (date)

    Indicates whether the account combination is a summary account.

    Label

    From Date

    Properties

    • inherited
    • creatable
    • searchable
    • sortable
  • summaryFlag (boolean)

    Indicates whether the account combination is a summary account.

    Label

    Summary

    Properties

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

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • inherited
    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountTypeInformation (StandardLookupCode)

    Category that the account belongs to such as assets, liabilities, revenue, expense, or owner's equity.

    Business Object

    StandardLookupCode

    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

  • financialCategoryInformation (StandardLookupCode)

    The name of the column that lists the financial category of the account.

    Business Object

    StandardLookupCode

    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