Project Attribute Defaults

The Project Attribute Defaults view object manages the ability to model default values for the projects, tasks, and expenditure organizations that are used in supply chain transactions. The defaults are modeled hierarchically to allow greater specificity when more inputs to the combination of project, task, and organization are supplied.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.DefaultProjectAttributesExtractPVO

Primary Keys : AttributeDefaultId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
AttributeDefaultId Value that uniquely identifies the set of attribute defaults for a combination of project, task and organization. It's a primary key that the application generates.
CreatedBy User who created the row.
CreationDate Date and time of the creation of the row.
LastUpdateDate Date and time of the last update of the row.
LastUpdateLogin Session login associated to the user who last updated the row.
LastUpdatedBy User who last updated the row.
ObjectVersionNumber Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
OrganizationId Value that uniquely identifies the expenditure organization if one is part of the record defining the set of defaults. Either this attribute, OrganizationName, or OrganizationCode is required to identify an organization.
PjcBillableFlag Contains one of the following values: true or false. If true, then a project-related item is available to be billed to customers. If false, then it's not available to be billed. The default value is false.
PjcCapitalizableFlag Contains one of the following values: true or false. If true, then a project-related item is eligible for capitalization. If false, then the item isn't eligible. The default value is false.
PjcContextCategory Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.
PjcContractId Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed.
PjcContractLineId Value that tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed.
PjcExpenditureItemDate Date on which a project-related transaction is incurred.
PjcExpenditureTypeId Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions.
PjcFundingAllocationId Name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed
PjcOrganizationId Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions.
PjcProjectId Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions.
PjcReservedAttribute1 Reserved for future project-related functionality
PjcReservedAttribute10 Reserved for future project-related functionality
PjcReservedAttribute2 Reserved for future project-related functionality
PjcReservedAttribute3 Reserved for future project-related functionality
PjcReservedAttribute4 Reserved for future project-related functionality
PjcReservedAttribute5 Reserved for future project-related functionality
PjcReservedAttribute6 Reserved for future project-related functionality
PjcReservedAttribute7 Reserved for future project-related functionality
PjcReservedAttribute8 Reserved for future project-related functionality
PjcReservedAttribute9 Reserved for future project-related functionality
PjcTaskId Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions.
PjcUserDefAttribute1 Reserved for user-definable project information
PjcUserDefAttribute10 Reserved for user-definable project information
PjcUserDefAttribute2 Reserved for user-definable project information
PjcUserDefAttribute3 Reserved for user-definable project information
PjcUserDefAttribute4 Reserved for user-definable project information
PjcUserDefAttribute5 Reserved for user-definable project information
PjcUserDefAttribute6 Reserved for user-definable project information
PjcUserDefAttribute7 Reserved for user-definable project information
PjcUserDefAttribute8 Reserved for user-definable project information
PjcUserDefAttribute9 Reserved for user-definable project information
PjcWorkTypeId Identifier for project-related classification of the worked performed.
ProjectId Value that uniquely identifies the project if one is part of the record defining the set of defaults. Either this attribute or ProjectNumber is required to identify a project. When both are null, you can't add task information.
TaskId Value that uniquely identifies the task if one is part of the record defining the set of defaults. Either this attribute or TaskNumber is required to identify a project task.