Subledger Mapping Set Values

The Subledger Mapping Set Values view object contains output values map to each combination of input values for subledger mapping sets.

Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerMappingSetValueExtractPVO

Primary Keys : MappingSetValueMappingSetValueId

Initial Extract Date : MappingSetValueCreationDate

Incremental Extract Date : MappingSetValueLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
MappingSetValueAmbContextCode The accounting method builder context for the mapping set. This attribute is a part of the composite key of the translated mapping sets view object.
MappingSetValueApplicationId The identifier of the application. This attribute is a part of the composite key of the mapping sets view object.
MappingSetValueConcatInput Concatenated input values from all the input sources.
MappingSetValueCreatedBy Indicates the user who created the mapping.
MappingSetValueCreationDate The date and time when the mapping was created.
MappingSetValueEffectiveEndDate The date until which the mapping is effective.
MappingSetValueEffectiveStartDate The date from which the mapping is effective.
MappingSetValueEnabledFlag Indicates whether the mapping is enabled. A list of accepted values is defined in the lookup type YES_NO.
MappingSetValueInputHash The data set mapping algorithm for InputValueConstant1 through 10.
MappingSetValueInputValueConstant1 The value of the first input source.
MappingSetValueInputValueConstant10 The value of the tenth input source.
MappingSetValueInputValueConstant2 The value of the second input source.
MappingSetValueInputValueConstant3 The value of the third input source.
MappingSetValueInputValueConstant4 The value of the fourth input source.
MappingSetValueInputValueConstant5 The value of the fifth input source.
MappingSetValueInputValueConstant6 The value of the sixth input source.
MappingSetValueInputValueConstant7 The value of the seventh input source.
MappingSetValueInputValueConstant8 The value of the eighth input source.
MappingSetValueInputValueConstant9 The value of the ninth input source.
MappingSetValueLastUpdateDate The date and time when the mapping was last updated.
MappingSetValueLastUpdateLogin The session login associated with the user who last updated the mapping.
MappingSetValueLastUpdatedBy The user who last updated the mapping.
MappingSetValueMapPrec The number of wildcards used in a mapping.
MappingSetValueMappingSetCode The short name of the mapping set.
MappingSetValueMappingSetFlavorId This is the foreign key to the Subledger Mapping Set Flavors view object.
MappingSetValueMappingSetValueId The unique identifier of mapping.
MappingSetValueObjectVersionNumber The number of times the mapping has been updated.
MappingSetValueStripeId Indicates with which chart of accounts or value set the output value is associated.
MappingSetValueTransactionCoaId The chart of accounts identifier associated with the input value. Populated only if the input source stores a code combination identifier.
MappingSetValueValueCodeCombinationId The output code combination identifier assigned to the combination of input values. Populated only if the mapping set is defined to return a GL account combination.
MappingSetValueValueConstant The output value assigned to the combination of input values. Populated only if the mapping set is defined to return GL account segment value.