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. |