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