Subledger Sources

The subledger sources view object contains information for subledger sources. These sources can be used to configure accounting rules.

Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerSourcesExtractPVO

Primary Keys : SubledgerSourcesSourceCode, SubledgerSourcesApplicationId, SubledgerSourcesSourceTypeCode

Initial Extract Date : SubledgerSourcesCreationDate

Incremental Extract Date : SubledgerSourcesLastUpdateDate

Attributes

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

Name	Description
SubledgerSourcesApplicationId	The unique identifier of a subledger application associated with the source.
SubledgerSourcesCreatedBy	The user who created the subledger sources.
SubledgerSourcesCreationDate	The date and time when the subledger sources were created.
SubledgerSourcesDatatypeCode	The data type code of the subledger source. Possible values are C: alphanumeric or N: numeric or D: date.
SubledgerSourcesEnabledFlag	Indicates whether the source is enabled.
SubledgerSourcesFlexValueSetId	The unique identifier of the value set assigned to the subledger source.
SubledgerSourcesFlexfieldApplicationId	Stores the flexfield application if a key flexfield has been assigned to the source.
SubledgerSourcesIdFlexCode	The unique identifier of the key flexfield assigned to the source.
SubledgerSourcesKeyFlexfieldFlag	Indicates whether a key flexfield is assigned to the source.
SubledgerSourcesLastUpdateDate	The date when the subledger source was last updated.
SubledgerSourcesLastUpdateLogin	The session login associated with the user who last updated the subledger source.
SubledgerSourcesLastUpdatedBy	The user who last updated the subledger source.
SubledgerSourcesLookupType	The lookup type assigned to the subledger source.
SubledgerSourcesObjectVersionNumber	The number of times the subledger source has been updated.
SubledgerSourcesPlsqlFunctionName
SubledgerSourcesSeedDataSource
SubledgerSourcesSegmentCode	The accounting flexfield segment associated with the subledger source.
SubledgerSourcesSourceCode	Subledger source code.
SubledgerSourcesSourceColumnName	The column name of the source table from which the source value is derived.
SubledgerSourcesSourceId	Unique identifier of the subledger source.
SubledgerSourcesSourceTableName	The source table from which the source value is derived.
SubledgerSourcesSourceTypeCode	Indicates whether the source is a standard or system source. Possible values are S: standard source or Y: system source which can be used by any subledger.
SubledgerSourcesSplitTransactionFlag	Indicates whether the source is used as a criteria when splitting large transactions.
SubledgerSourcesSumFlag	Indicates whether the source value will be summed.
SubledgerSourcesSummarizationFlag	Indicates whether the source is used to summarize source transaction lines.
SubledgerSourcesTranslatedFlag	Indicates whether a source is translatable.
SubledgerSourcesTranslationApplicationId	The unique identifier of a subledger application associated with the subledger source.
SubledgerSourcesTranslationCreatedBy	The user who created the translated information for the subledger source.
SubledgerSourcesTranslationCreationDate	The date and time when translated information of the subledger source was created.
SubledgerSourcesTranslationDescription	Translated description of the source.
SubledgerSourcesTranslationLanguage	Indicates the code of the language into which the contents of the translatable columns are translated.
SubledgerSourcesTranslationLastUpdateDate	The date when translated information of the subledger source was last updated.
SubledgerSourcesTranslationLastUpdateLogin	The session login associated with the user who last updated the translated subledger source.
SubledgerSourcesTranslationLastUpdatedBy	The user who last updated the translated information of the subledger source.
SubledgerSourcesTranslationName	Translated name of the source.
SubledgerSourcesTranslationObjectVersionNumber	The number of times the translated information of the subledger source has been updated.
SubledgerSourcesTranslationSeedDataSource
SubledgerSourcesTranslationSourceCode	Short name of the source.
SubledgerSourcesTranslationSourceLang	Indicates the code of the language in which the contents of the translatable columns were originally created.
SubledgerSourcesTranslationSourceTypeCode	Indicates whether the source is seeded or not. Possible values are S: seeded by Oracle or C: defined by user.
SubledgerSourcesViewApplicationId	The application identifier of the lookup type.
SubledgerSourcesVisibleFlag	Indicates whether the source will be displayed when searching for source in the subledger accounting rules user interface.