Ledgers

The ledgers view object contains information about the ledgers and the ledger sets. Each row includes the ledger or ledger set name, short name, description, ledger currency, calendar, period type, chart of accounts, and other information.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerExtractPVO

Primary Keys : LedgerLedgerId

Initial Extract Date : LedgerCreationDate

Incremental Extract Date : LedgerLastUpdateDate

Attributes

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

Name	Description
AcctgMethodTLAccountingMethodCode	The short name of the accounting method used to record the financial impact of subledger transactions. This is a primary key of the Translated Accounting Methods view object.
AcctgMethodTLAccountingMethodTypeCode	Indicates whether the accounting method is predefined by subledger application. This is a primary key of the Translated Accounting Methods view object.
AcctgMethodTLDescription	The description of the accounting method used to record the financial impact of subledger transactions.
AcctgMethodTLLanguage	Indicates the code of the language into which the contents of the translatable columns are translated.
AcctgMethodTLName	The name of the accounting method used to record the financial impact of subledger transactions.
LedgerAccountedPeriodType	The accounting period types assigned to the ledger.
LedgerAllowIntercompanyPostFlag	Indicates whether intercompany posting is allowed in the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerApDocSequencingOptionFlag	Indicates whether document sequencing is enforced for Payables. A list of accepted values is defined in the lookup type YES_NO.
LedgerArDocSequencingOptionFlag	Indicates whether document sequencing is enforced for Receivables. A list of accepted values is defined in the lookup type YES_NO.
LedgerAttribute1	A segment for the Ledgers descriptive flexfield.
LedgerAttribute10	A segment for the Ledgers descriptive flexfield.
LedgerAttribute11	A segment for the Ledgers descriptive flexfield.
LedgerAttribute12	A segment for the Ledgers descriptive flexfield.
LedgerAttribute13	A segment for the Ledgers descriptive flexfield.
LedgerAttribute14	A segment for the Ledgers descriptive flexfield.
LedgerAttribute15	A segment for the Ledgers descriptive flexfield.
LedgerAttribute2	A segment for the Ledgers descriptive flexfield.
LedgerAttribute3	A segment for the Ledgers descriptive flexfield.
LedgerAttribute4	A segment for the Ledgers descriptive flexfield.
LedgerAttribute5	A segment for the Ledgers descriptive flexfield.
LedgerAttribute6	A segment for the Ledgers descriptive flexfield.
LedgerAttribute7	A segment for the Ledgers descriptive flexfield.
LedgerAttribute8	A segment for the Ledgers descriptive flexfield.
LedgerAttribute9	A segment for the Ledgers descriptive flexfield.
LedgerAttributeCategory	The descriptive flexfield context name for the Ledgers descriptive flexfield.
LedgerAttributeDate1	A segment for the Ledgers descriptive flexfield.
LedgerAttributeDate2	A segment for the Ledgers descriptive flexfield.
LedgerAttributeDate3	A segment for the Ledgers descriptive flexfield.
LedgerAttributeDate4	A segment for the Ledgers descriptive flexfield.
LedgerAttributeDate5	A segment for the Ledgers descriptive flexfield.
LedgerAttributeNumber1	A segment for the Ledgers descriptive flexfield.
LedgerAttributeNumber2	A segment for the Ledgers descriptive flexfield.
LedgerAttributeNumber3	A segment for the Ledgers descriptive flexfield.
LedgerAttributeNumber4	A segment for the Ledgers descriptive flexfield.
LedgerAttributeNumber5	A segment for the Ledgers descriptive flexfield.
LedgerAutomateSecJrnlRevFlag	Indicates whether a replicated secondary ledger journal should be reversed when the parent primary ledger journal is reversed. A list of accepted values is defined in the lookup type YES_NO.
LedgerAutorevAfterOpenPrdFlag	Indicates whether the AutoReverse Journals process should be submitted for the ledger when a new period is first opened. A list of accepted values is defined in the lookup type YES_NO.
LedgerBalSegColumnName	The name of the Balancing segment of the chart of accounts associated with the ledger.
LedgerBalSegValueOptionCode	Indicates whether all balancing segment values or specific balancing segment values are assigned to a ledger. A list of accepted values is defined in the lookup type GL_ASF_LEDGER_ASSIGN_OPTIONS.
LedgerBalSegValueSetId	The identifier of the value set used by the balancing segment of the chart of account associated with ledger.
LedgerChartOfAccountsId	The unique identifier of the accounting flexfield used for the ledger. This is a foreign key to the KeyFlexStructure Instances view object.
LedgerCompleteFlag	Indicates the completion status of the ledger configuration. A list of accepted values is defined in the lookup type YES_NO.
LedgerCompletionStatusCode	Indicates the completion status of the ledger configuration and whether the ledger balances cube is created. A list of accepted values is defined in the lookup type GL_CONFIG_STATUS.
LedgerConfigurationId	The unique identifier of the ledger configuration that contains the setup information of a ledger.
LedgerCreatedBy	The user who created the ledger.
LedgerCreationDate	The date and time when the ledger was created.
LedgerCriteriaSetId	The identifier of the journal reversal criteria set assigned to a ledger.
LedgerCumTransCodeCombinationId	The identifier of the cumulative translation adjustment account combination. This is a foreign key of the General Ledger Accounts view object.
LedgerCurrencyCode	The currency of the ledger. This is a foreign key to the Currencies view object.
LedgerDailyTranslationRateType	The conversion rate type used for translation of average daily balances.
LedgerDescription	The description of the ledger provided by the user or source application.
LedgerEnableAutomaticTaxFlag	Indicates whether automatic tax is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnableAverageBalancesFlag	Indicates whether average balances are maintained for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnableBudgetaryControlFlag	Indicates whether budgetary control is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnableJeApprovalFlag	Indicates whether journal entry approval is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnableReconciliationFlag	Indicates whether journal reconciliation is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnableRevalSsTrackFlag	Indicates whether revaluation gain or loss tracking using multiple segments is enabled for the ledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerEnfSeqDateCorrelationCode	Indicates whether to enforce a correlation between sequence date and subledger transaction sequence number for subledger transactions. A list of accepted values is defined in the lookup type YES_NO.
LedgerFirstLedgerPeriodName	The name of the first accounting period associated with the ledger.
LedgerFutureEnterablePeriodsLimit	The number of future enterable periods.
LedgerImplicitAccessSetId	The unique identifier of the implicit data access set defined for the ledger.
LedgerIntercoGainLossCcid	Identifier of the intercompany gain or loss account combination. This is a foreign key to the General Ledger Accounts view object.
LedgerJrnlsGroupByDateFlag	Indicates whether the Import Journals process will group journal lines by accounting date. A list of accepted values is defined in the lookup type YES_NO.
LedgerLastUpdateDate	The date when the ledger row was last updated.
LedgerLastUpdateLogin	The session login associated with the user who last updated the ledger.
LedgerLastUpdatedBy	The user who last updated the ledger.
LedgerLatestEncumbranceYear	The latest open year for encumbrances.
LedgerLatestOpenedPeriodName	The name of the latest opened accounting period associated with the ledger.
LedgerLedgerCategoryCode	Identifies the type of ledger. A list of accepted values is defined in the lookup type GL_ASF_LEDGER_CATEGORY.
LedgerLedgerId
LedgerMinimumThresholdAmount	The minimum percentage difference between accounted debits and accounted credits is a rounding error or a balancing issue. The actual threshold used may be larger.
LedgerName	The unique name of the ledger entered by the user.
LedgerNetClosingBalFlag	Indicates whether the closing journals process creates net amount closing journal entries rather than accumulated closing journal entries. A list of accepted values is defined in the lookup type YES_NO.
LedgerNetIncomeCodeCombinationId	The identifier of the net income account combination. This is a foreign key to the General Ledger Accounts view object.
LedgerObjectTypeCode	Indicates the type of ledger. A list of accepted values is defined in the lookup type LEDGERS.
LedgerObjectVersionNumber	The number of times the ledger row has been updated.
LedgerPeriodAverageRateType	The default period average conversion rate type used for translating actual balances.
LedgerPeriodEndRateType	The default period end conversion rate type used for translating actual balances.
LedgerPeriodSetName	The name of the accounting calendar associated with the ledger. The calendar can be divided into accounting periods.
LedgerPopUpStatAccountFlag	Indicates whether users can enter statistical amounts along with monetary amounts while entering journals. A list of accepted values is defined in the lookup type YES_NO.
LedgerPriorPrdNotificationFlag	Indicates whether to notify users when a journal is entered for a prior period. A list of accepted values is defined in the lookup type YES_NO.
LedgerRequireBudgetJournalsFlag	Indicates whether budget amounts must be entered by journals only. A list of accepted values is defined in the lookup type YES_NO.
LedgerResEncumbCodeCombinationId	The identifier of the encumbrances reserve account combination. This is a foreign key to the General Ledger Accounts view object.
LedgerRetEarnCodeCombinationId	The identifier of the retained earnings account combination. This is a foreign key to the General Ledger Accounts view object.
LedgerRevalFromPriLgrCurr	The currency to use when creating revaluation entries for the additional ledger currency.
LedgerRoundingCodeCombinationId	The identifier of the rounding account combination. This is a foreign key to the General Ledger Accounts view object.
LedgerSequencingModeCode	The level of document sequencing for a ledger. A list of accepted values is defined in the lookup type GL_SEQUENCING_OPTIONS.
LedgerShortName	The unique short name of the ledger entered by the user. This attribute is for future use.
LedgerSlaAccountingMethodCode	The short name of the accounting method used to record the financial impact of subledger transactions. This is a foreign key to the Accounting Methods view object.
LedgerSlaAccountingMethodType	Indicates whether the accounting method is predefined by the subledger application. This is a foreign key to the Accounting Methods view object.
LedgerSlaBalByLedgerCurrFlag	Indicates whether the suspense account is enabled for the subledger. A list of accepted values is defined in the lookup type YES_NO.
LedgerSlaDescriptionLanguage	The language of the ledger description.
LedgerSlaEnteredCurBalSusCcid	The identifier of the suspense account combination used for balancing subledger journal entries by entered currency. This is a foreign key to the General Ledger Accounts view object.
LedgerSlaLedgerCashBasisFlag	Indicates whether the ledger operates on a cash basis. A list of accepted values is defined in the lookup type YES_NO.
LedgerSlaLedgerCurBalSusCcid	The identifier of the suspense account combination used for balancing subledger journal entries by ledger currency. This is a foreign key to the General Ledger Accounts view object.
LedgerSlaSequencingFlag	Indicates whether subledger sequencing is required. A list of accepted values is defined in the lookup type YES_NO.
LedgerSuspenseAllowedFlag	Indicates whether suspense posting is allowed. A list of accepted values is defined in the lookup type YES_NO.
LedgerThresholdAmount	The threshold amount for which an additional balancing line is created if the accounted debit and accounted credit offset amount doesn't equal zero.
LedgerTrackRoundingImbalanceFlag	Indicates whether rounding imbalances are tracked. A list of accepted values is defined in the lookup type YES_NO.
LedgerTransactionCalendarId	The unique identifier of the transaction calendar.
LedgerTranslateEodFlag	Indicates whether the end-of-day average balances are translated. A list of accepted values is defined in the lookup type YES_NO.
LedgerTranslateQatdFlag	Indicates whether quarter-to-date Average balances are translated. A list of accepted values is defined in the lookup type YES_NO.
LedgerTranslateYatdFlag	Indicates whether year-to-date Average balances are translated. A list of accepted values is defined in the lookup type YES_NO.
LedgerValidateJournalRefDate	Indicates whether the journal reference date is validated to ensure the date falls into an open or future enterable period.