Order Projects

The Order Projects view object that extracts project details from sales orders.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.ProjectExtractPVO

Primary Keys : ProjectDooOrderPrjId

Initial Extract Date : ProjectCreationDate

Incremental Extract Date : ProjectLastUpdateDate

Attributes

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

Name	Description
ProjectCreatedBy	User who created the order project row.
ProjectCreationDate	Date when the order project row was created.
ProjectDooOrderPrjId	Value that uniquely identifies the order project row. This is the primary key of the order projects view object.
ProjectLastUpdateDate	Date when the order project row was last updated.
ProjectLastUpdateLogin	Session login associated with the user who most recently updated the order project row.
ProjectLastUpdatedBy	User who most recently updated the order project row.
ProjectModifiedFlag	Indicates whether the order project row has been modified. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
ProjectObjectVersionNumber	Number of times the order project row has been updated.
ProjectPJC_BILLABLE_FLAG	Indicates whether the project-related item is available to be billed to the customer. A list of accepted values is defined in the lookup type YES_NO.
ProjectPJC_CAPITALIZABLE_FLAG	Indicates whether the project-related item is eligible for capitalization. A list of accepted values is defined in the lookup type YES_NO.
ProjectPJC_CONTEXT_CATEGORY	Context name for the descriptive flexfield of the project-related transaction.
ProjectPJC_CONTRACT_ID	Value that identifies the contract.
ProjectPJC_EXPENDITURE_ITEM_DATE	Date when the project-related transaction was incurred.
ProjectPJC_EXPENDITURE_TYPE_ID	Value that identifies the expenditure type. It's used to build the transaction descriptive flexfield for project-related transaction distributions.
ProjectPJC_FUNDING_ALLOCATION_ID	Value that identifies name of the project funding override.
ProjectPJC_ORGANIZATION_ID	Value that identifies the expenditure organization. It's used to build the transaction descriptive flexfield for project-related transaction distributions.
ProjectPJC_PROJECT_ID	Value that identifies the project. It's used to build the transaction descriptive flexfield for project-related transaction distributions.
ProjectPJC_TASK_ID	Value that identifies the task. It's used to build the transaction descriptive flexfield for project-related transaction distributions.
ProjectPJC_WORK_TYPE_ID	Value that identifies the project-related classification of the work performed.
ProjectParentEntityCode	Code of the parent entity.
ProjectParentEntityId	Value that identifies the parent entity associated to the order project row.
ProjectRefDooOrderPrjId	Value that identifies the previous order project. Order Management uses this values when processing change order.