SubledgerAccountingMappingSetValue

A subledger mapping set value contains the output values that map to each combination of input values for subledger mapping sets. It consists of details such as the mapping set short name, application identifier, mapping set value identifier, input values, output value and other such information associated with the mapping set value.

Expand all

Collapse all

Business Views

** Available for extracting data

• subledgerMappingSetValuesExtract**

  A subledger mapping set value contains the output values that map to each combination of input values for subledger mapping sets. It consists of details such as the mapping set short name, application identifier, mapping set value identifier, input values, output value and other such information associated with the mapping set value.

  Label

  Subledger Mapping Set Values

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • ambContextCode (string)

    The accounting method builder context.

    Label

    Accounting Method Builder Context

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

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

    The date until which the mapping is effective.

    Label

    Effective Start Date

    Properties

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

    The date from which the mapping is effective.

    Label

    Effective End Date

    Properties

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

    Indicates whether the mapping set is enabled. A list of accepted values is defined in the lookup type YES_NO.

    Label

    Enabled

    Properties

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

    The value of the first input source.

    Label

    Source Value 1

    Properties

    • searchable
    • sortable
  • inputValueConstant10 (string)

    The value of the tenth input source.

    Label

    Source Value 10

    Properties

    • searchable
    • sortable
  • inputValueConstant2 (string)

    The value of the second input source.

    Label

    Source Value 2

    Properties

    • searchable
    • sortable
  • inputValueConstant3 (string)

    The value of the third input source.

    Label

    Source Value 3

    Properties

    • searchable
    • sortable
  • inputValueConstant4 (string)

    The value of the fourth input source.

    Label

    Source Value 4

    Properties

    • searchable
    • sortable
  • inputValueConstant5 (string)

    The value of the fifth input source.

    Label

    Source Value 5

    Properties

    • searchable
    • sortable
  • inputValueConstant6 (string)

    The value of the sixth input source.

    Label

    Source Value 6

    Properties

    • searchable
    • sortable
  • inputValueConstant7 (string)

    The value of the seventh input source.

    Label

    Source Value 7

    Properties

    • searchable
    • sortable
  • inputValueConstant8 (string)

    The value of the eighth input source.

    Label

    Source Value 8

    Properties

    • searchable
    • sortable
  • inputValueConstant9 (string)

    The value of the ninth input source.

    Label

    Source Value 9

    Properties

    • searchable
    • sortable
  • mappingSetCode (string)

    The short name of the mapping set.

    Label

    Mapping Set Short Name

    Properties

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

    The unique identifier of mapping.

    Label

    Mapping Set Value Identifier

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

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

    The output value assigned to the combination of input values. Populated only if the mapping set is defined to return GL account segment value

    Label

    Default GL Account

    Properties

    • searchable
    • sortable

  Expand all

  Collapse all

  Reference Object

  • subledgerValueCodeCombination (GeneralLedgerAccount)

    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.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • transactionChartOfAccount (KeyFlexfieldStructureInstance)

    The key flexfield structure instance resource is used to query the list of key flexfield structure instances.

    Business Object

    KeyFlexfieldStructureInstance

    Expand all

    Collapse all

    Fields

    • structureInstanceNumber (int64)

      The structure instance number of the structure instance.

      Label

      Structure Instance Number

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top