SubledgerSource

A subledger source contains all predefined subledger sources and user-defined sources which are used to configure accounting rules. It stores details such as the application identifier, source type, data type and other relevant information associated with the source.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerSourcesExtract**

  A subledger source contains all predefined subledger sources and user-defined sources which are used to configure accounting rules. It stores details such as the application identifier, source type, data type and other relevant information associated with the source.

  Label

  Subledger Sources

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • applicationId (int64)

    The unique identifier of the source application that represents a functional area.

    Label

    Application

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

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

    The data type code of the subledger source.

    Label

    Data Type

    Properties

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

    The translated description of the source.

    Label

    Description

    Properties

    • translatable
  • dimensionFlag (boolean)

    Indicates whether this is used as a dimension in the Supporting Reference Balance analytic view.

    Label

    Dimension

    Properties

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

    The short name of the value set that stores the supporting reference values for which balances are maintained.

    Label

    Dimension Value Set Code

    Properties

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

    Indicates whether the source is enabled.

    Label

    Active

    Properties

    • searchable
    • sortable
    • not nullable
  • keyFlexfieldFlag (boolean)

    Indicates whether a key flexfield is assigned to the source.

    Label

    Key Flexfield Indicator

    Properties

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

    The name of the transaction information that's used to create journal entries.

    Label

    Source Name

    Properties

    • translatable
    • not nullable
  • segmentCode (string)

    The accounting flexfield segment associated with the subledger source.

    Label

    Flexfield Segment Name

    Properties

    • searchable
    • sortable
  • sourceCode (string)

    The short name of the transaction information that's used to create journal entries.

    Label

    Object Column Name

    Properties

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

    The column name of the source table from which the source value is derived.

    Label

    Source Column Name

    Properties

    • searchable
    • sortable
  • sourceTableName (string)

    The source table from which the source value is derived.

    Label

    Source Table Name

    Properties

    • searchable
    • sortable
  • sourceTypeCode (string)

    Indicates whether the source is a standard or system source.

    Label

    Source Type

    Properties

    • searchable
    • sortable
    • not nullable
  • sumFlag (boolean)

    Indicates whether the source value will be summed.

    Label

    Summed

    Properties

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

    The date and time when the record was created.

    Label

    Creation Date

    Properties

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

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • translatedFlag (boolean)

    Indicates whether the source is translatable.

    Label

    Translated

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable
  • visibleFlag (boolean)

    Indicates whether the source value will be displayed in the list of values.

    Label

    Displayed

    Properties

    • searchable
    • sortable
    • not nullable
  • $language (string)

    The language of the record.

    Label

    Language

    Properties

    • creatable
    • translatable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • flexValueSet (ValueSet)

    The value sets resource is used to query the list of value sets.

    Business Object

    ValueSet

    Expand all

    Collapse all

    Fields

    • valueSetId (int64)

      The primary unique identifier of the value set.

      Label

      Value Set ID

      Properties

      • searchable
      • sortable
      • not nullable

  • sourceLookupType (LookupType)

    The lookup type assigned to the subledger source.

    Business Object

    LookupType

    Expand all

    Collapse all

    Fields

    • lookupCategoryId (int64)

      The lookup category of the Lookup Code.

      Label

      Lookup Category

      Properties

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

      The unique identifier of the Lookup Type.

      Label

      Lookup Type ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top