Secondary Ledger Conversion Rules
The secondary ledger conversion rules view object contains the relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency. It also contains the chart of accounts mapping, conversion, and initialization rules necessary to convert data from the source ledger to its secondary ledger or reporting currency.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerRelationshipExtractPVO
Primary Keys : GlLedgerRelationshipsRelationshipId
Initial Extract Date : GlLedgerRelationshipsCreationDate
Incremental Extract Date : GlLedgerRelationshipsLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| GlLedgerRelationshipsAlcDefaultConvRateType | The default conversion rate type for the secondary ledger or reporting currency journal. |
| GlLedgerRelationshipsAlcInheritConversionType | Indicates whether the secondary ledger or reporting currency should inherit the conversion rate type from the source ledger. Valid values are Y or N. |
| GlLedgerRelationshipsAlcInitConvOptionCode | The historical conversion option defined for the chart of account mapping rules when converting a source ledger to its secondary ledger or reporting currency. A list of accepted values is defined in the lookup type ALC_CONVERSION_OPTION. |
| GlLedgerRelationshipsAlcInitDate | The first accounting date for the reporting currency. |
| GlLedgerRelationshipsAlcInitPeriod | The first accounting period for the reporting currency |
| GlLedgerRelationshipsAlcInitializingRateDate | The conversion date used to initialize historical transactions or balances. |
| GlLedgerRelationshipsAlcInitializingRateType | The conversion rate type used to initialize historical transactions or balances. |
| GlLedgerRelationshipsAlcMaxDaysRollRate | The maximum number of allowed days to roll back a conversion rate. |
| GlLedgerRelationshipsAlcNoRateActionCode | The action to take when no rate exists such as report an error or use the last available rate. A list of accepted values is defined in the lookup type GL_ASF_ALC_RATE_ACTION. |
| GlLedgerRelationshipsAlcPeriodAverageRateType | The period average rate type for the reporting currency. |
| GlLedgerRelationshipsAlcPeriodEndRateType | The period end rate type for the reporting currency. |
| GlLedgerRelationshipsApplicationId | The application identifier of the defined ledger relationship. |
| GlLedgerRelationshipsAttribute1 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute10 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute11 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute12 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute13 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute14 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute15 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute2 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute3 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute4 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute5 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute6 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute7 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute8 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttribute9 | A segment for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAttributeCategory | The descriptive flexfield context name for the Secondary Ledger Conversion Rules descriptive flexfield. |
| GlLedgerRelationshipsAutomaticPostFlag | Indicates whether to post the journal automatically in the target secondary ledger or reporting currency. Valid values are Y or N. The default value is Y. |
| GlLedgerRelationshipsCreatedBy | The user who created the ledger relationship. |
| GlLedgerRelationshipsCreationDate | The date and time when the ledger relationship was created. |
| GlLedgerRelationshipsDisableConversionDate | The date when the conversion was disabled. |
| GlLedgerRelationshipsGlJeConversionSetId | The identifier for the journal conversion rule. |
| GlLedgerRelationshipsInheritCreationUserFlag | Indicates whether the secondary ledger or reporting currency should inherit the user creation name from the source ledger. Valid values are Y or N. The default value is Y. |
| GlLedgerRelationshipsLastUpdateDate | The date and time when the ledger relationship row was last updated. |
| GlLedgerRelationshipsLastUpdateLogin | The session login of the user who last updated the ledger relationship. |
| GlLedgerRelationshipsLastUpdatedBy | The user who last updated the ledger relationship row. |
| GlLedgerRelationshipsObjectVersionNumber | The number of times the ledger relationship row has been updated. |
| GlLedgerRelationshipsOrgId | The identifier of the business unit associated with the row. |
| GlLedgerRelationshipsOwnerEquityXlationRuleCode | The owner equity translation rule. |
| GlLedgerRelationshipsPrimaryLedgerId | The ledger identifier for the primary ledger defined in the accounting configuration. |
| GlLedgerRelationshipsRelationshipEnabledFlag | Indicates whether the ledger relationship is enabled. Valid values are Y or N. The default value is N. |
| GlLedgerRelationshipsRelationshipId | The unique identifier for the ledger relationship. |
| GlLedgerRelationshipsRelationshipTypeCode | The relationship level between the source and target ledger. A list of accepted values is defined in the lookup type GL_ASF_ALC_RELATIONSHIP_LEVEL. The default value is BALANCE |
| GlLedgerRelationshipsRevExpXlationRuleCode | The revenue or expense translation rule. |
| GlLedgerRelationshipsSlCoaMappingId | The identifier of the key flexfield structure. |
| GlLedgerRelationshipsSlaLedgerId | The ledger identifier in subledger transactions used for creating subledger accounting entries. |
| GlLedgerRelationshipsSourceLedgerId | The ledger identifier of the transactions, journals, or balances used for reporting currency conversions. |
| GlLedgerRelationshipsStatusCode | The indication for whether the ledger relationship between the primary and secondary ledger or between the ledger and reporting currency is complete. The possible value is CONFIRMED or the attribute is blank. |
| GlLedgerRelationshipsTargetCurrencyCode | The currency of the target ledger. |
| GlLedgerRelationshipsTargetLedgerCategoryCode | The category of the target ledger. A list of accepted values is defined in the lookup type GL_ASF_LEDGER_CATEGORY. The default value is ALC, which represents reporting currency. |
| GlLedgerRelationshipsTargetLedgerId | The identifier of the target ledger for the conversion of transactions, journals or balances. |
| GlLedgerRelationshipsTargetLedgerName | The name that the user entered for the target ledger. |
| GlLedgerRelationshipsTargetLedgerShortName | The short name that the user entered for the target ledger. |