Ledger Assignments for the Post Accounting Programs

The view object which contains the ledger assignments for the post accounting programs.

Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.AssignmentDefinitionExtractPVO

Primary Keys : AssignmentDefinitionProgramCode, AssignmentDefinitionAssignmentOwnerCode, AssignmentDefinitionProgramOwnerCode, AssignmentDefinitionAssignmentCode

Initial Extract Date : AssignmentDefinitionCreationDate

Incremental Extract Date : AssignmentDefinitionLastUpdateDate

Attributes

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

Name	Description
AssignmentDefinitionAssignmentCode	The language independent accounting class assignment code.
AssignmentDefinitionAssignmentId	The unique identifier of ledger assignment for the post accounting program.
AssignmentDefinitionAssignmentOwnerCode	Indicates whether the assignment is seeded by Oracle or created by a user. Possible values are S: Oracle or C: User.
AssignmentDefinitionCreatedBy	The user who created the assignment.
AssignmentDefinitionCreationDate	The date and time when the assignment was created.
AssignmentDefinitionEnabledFlag	Indicates whether the assignment is active.
AssignmentDefinitionLastUpdateDate	The date when the assignment row was last updated.
AssignmentDefinitionLastUpdateLogin	The session login associated with the user who last updated the assignment.
AssignmentDefinitionLastUpdatedBy	The user who last updated the assignment.
AssignmentDefinitionLedgerId	The unique identifier of a ledger.
AssignmentDefinitionObjectVersionNumber	The number of times the assignment row has been updated.
AssignmentDefinitionProgramCode	The language independent post accounting program code.
AssignmentDefinitionProgramOwnerCode	Indicates whether the program is seeded by Oracle or created by a user. Possible values are S: Oracle or C: User.
AssignmentDefinitionTLAssignmentCode	The language independent accounting class assignment code.
AssignmentDefinitionTLAssignmentOwnerCode	Indicates whether the assignment is seeded by Oracle or created by a user. Possible values are S: Oracle or C: User.
AssignmentDefinitionTLCreatedBy	The user who created the translated assignment.
AssignmentDefinitionTLCreationDate	The date and time when the translated assignment was created.
AssignmentDefinitionTLLanguage	Indicates the code of the language into which the contents of the translatable columns are translated. This attribute is a part of the composite key of the Translated Ledger Assignment for Post Accounting Programs view object.
AssignmentDefinitionTLLastUpdateDate	The date when the translated assignment row was last updated.
AssignmentDefinitionTLLastUpdateLogin	The user who last updated the translated assignment.
AssignmentDefinitionTLLastUpdatedBy	The session login associated with the user who last updated the translated assignment.
AssignmentDefinitionTLName	Translated name of the ledger assignment for the post accounting program.
AssignmentDefinitionTLProgramCode	The language independent post accounting program code.
AssignmentDefinitionTLProgramOwnerCode	Indicates whether the program is seeded by Oracle or created by a user. Possible values are S: Oracle or C: User.
AssignmentDefinitionTLSourceLang	The code of the language in which the contents of the translatable attributes were originally created.
AssignmentDefinitionUserLanguage	The code of the language set up by the user into which the contents of the translatable attributes are translated.