General Ledger Accounts

The general ledger accounts view object contains information about account combinations for each accounting flexfield structure that are used for accounting transactions.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVO

Primary Keys : CodeCombinationCodeCombinationId

Initial Extract Date : CodeCombinationCreationDate

Incremental Extract Date : CodeCombinationLastUpdateDate

Attributes

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

Name Description
CodeCombinationAccountType Indicates accounting nature such as asset, liability, revenue, and so on, of the transaction account. A list of accepted values is defined in the lookup type ACCOUNT TYPE.
CodeCombinationAlternateCodeCombinationId The alternate account combination to use when the specified account combination is end-dated or disabled.
CodeCombinationAttribute1 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute10 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute2 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute3 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute4 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute5 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute6 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute7 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute8 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttribute9 A segment for the General Ledger Accounts descriptive flexfield.
CodeCombinationAttributeCategory The descriptive flexfield context name for the General Ledger Accounts descriptive flexfield.
CodeCombinationChartOfAccountsId The unique identifier of the accounting flexfield used for the ledger. This is a foreign key to the KeyFlexStructure Instances view object.
CodeCombinationCodeCombinationId The unique identifier of the general ledger accounts view object. This is a primary key of the General Ledger Accounts view object.
CodeCombinationCreatedBy The user who created the general ledger account.
CodeCombinationCreationDate The date and time when the general ledger account was created.
CodeCombinationDetailBudgetingAllowedFlag Indicates whether budgeting is allowed for the account combination. A list of accepted values is defined in the lookup type YES_NO.
CodeCombinationDetailPostingAllowedFlag Indicates whether posting is allowed for the account combination. A list of accepted values is defined in the lookup type YES_NO.
CodeCombinationEnabledFlag Indicates whether the account combination is enabled. A list of accepted values is defined in the lookup type GL_ACCT_COMB_ATTR.
CodeCombinationEndDateActive The date after which the general ledger account is invalid.
CodeCombinationFinancialCategory The financial category of the account combination.
CodeCombinationJgzzReconFlag Indicates whether reconciliation is enabled. A list of accepted values is defined in the lookup type YES_NO.
CodeCombinationLastUpdateDate The date when the general ledger account row was last updated.
CodeCombinationLastUpdateLogin The session login associated with the user who last updated the general ledger account.
CodeCombinationLastUpdatedBy The user who last updated the general ledger account.
CodeCombinationObjectVersionNumber The number of times the general ledger account row has been updated.
CodeCombinationPreserveFlag Indicates whether to preserve account combinations against attribute updates when you run the Inherit Segment Value Attributes process. A list of accepted values is defined in the lookup type GL_ACCT_COMB_ATTR.
CodeCombinationSegment1 The segment of the accounting flexfield structure.
CodeCombinationSegment10 The segment of the accounting flexfield structure.
CodeCombinationSegment11 The segment of the accounting flexfield structure.
CodeCombinationSegment12 The segment of the accounting flexfield structure.
CodeCombinationSegment13 The segment of the accounting flexfield structure.
CodeCombinationSegment14 The segment of the accounting flexfield structure.
CodeCombinationSegment15 The segment of the accounting flexfield structure.
CodeCombinationSegment16 The segment of the accounting flexfield structure.
CodeCombinationSegment17 The segment of the accounting flexfield structure.
CodeCombinationSegment18 The segment of the accounting flexfield structure.
CodeCombinationSegment19 The segment of the accounting flexfield structure.
CodeCombinationSegment2 The segment of the accounting flexfield structure.
CodeCombinationSegment20 The segment of the accounting flexfield structure.
CodeCombinationSegment21 The segment of the accounting flexfield structure.
CodeCombinationSegment22 The segment of the accounting flexfield structure.
CodeCombinationSegment23 The segment of the accounting flexfield structure.
CodeCombinationSegment24 The segment of the accounting flexfield structure.
CodeCombinationSegment25 The segment of the accounting flexfield structure.
CodeCombinationSegment26 The segment of the accounting flexfield structure.
CodeCombinationSegment27 The segment of the accounting flexfield structure.
CodeCombinationSegment28 The segment of the accounting flexfield structure.
CodeCombinationSegment29 The segment of the accounting flexfield structure.
CodeCombinationSegment3 The segment of the accounting flexfield structure.
CodeCombinationSegment30 The segment of the accounting flexfield structure.
CodeCombinationSegment4 The segment of the accounting flexfield structure.
CodeCombinationSegment5 The segment of the accounting flexfield structure.
CodeCombinationSegment6 The segment of the accounting flexfield structure.
CodeCombinationSegment7 The segment of the accounting flexfield structure.
CodeCombinationSegment8 The segment of the accounting flexfield structure.
CodeCombinationSegment9 The segment of the accounting flexfield structure.
CodeCombinationStartDateActive The date before which the general ledger account is invalid.
CodeCombinationSummaryFlag Indicates whether summary is allowed for the account combination. A list of accepted values is defined in the lookup type YES_NO.