Ledger Set Assignments

The ledger set assignments view object contains information about each ledger or ledger set that's contained within a ledger set. It stores the flattened information from the GL_LEDGER_SET_NORM_ASSIGN table. Each ledger set contained within another ledger set in the GL_LEDGER_SET_NORM_ASSIGN table will be expanded into the corresponding ledgers before it's stored in this table. The combination of LedgerSetAsgmtLedgerId, and LedgerSetAsgmtLedgerSetId forms the unique identifier of the Ledger Set Assignments view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerSetAssignmentExtractPVO

Primary Keys : LedgerSetAsgmtLedgerId, LedgerSetAsgmtLedgerSetId

Initial Extract Date : LedgerSetAsgmtCreationDate

Incremental Extract Date : LedgerSetAsgmtLastUpdateDate

Attributes

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

Name	Description
LedgerSetAsgmtCreatedBy	The user who created the ledger set assignment.
LedgerSetAsgmtCreationDate	The date and time when the ledger set assignment was created.
LedgerSetAsgmtEndDate	The date when the ledger set assignment was inactive.
LedgerSetAsgmtLastUpdateDate	The date when the ledger set assignment row was last updated.
LedgerSetAsgmtLastUpdateLogin	The session login associated with the user who last updated the ledger set assignment.
LedgerSetAsgmtLastUpdatedBy	The user who last updated the ledger set assignment row.
LedgerSetAsgmtLedgerId	The unique identifier of the ledger of the ledger set assignments view object. This is a foreign key of the Ledgers view object. This attribute is a part of the composite key of the Ledger Set Assignments view object.
LedgerSetAsgmtLedgerSetId	The identifier of the Ledger Set Assignments view object. This is a foreign key of the Ledgers view object. This attribute is a part of the composite key of the Ledger Set Assignments view object.
LedgerSetAsgmtObjectVersionNumber	The number of times the ledger set assignment row has been updated.
LedgerSetAsgmtStartDate	The date from which the ledger set assignment was active.
LedgerSetAsgmtStatusCode	Indicates the status of the ledger set assignment. A list of accepted values is defined in the lookup type GL_CONFIG_STATUS.