Costing Work Orders
The Costing Work Orders view object contains work order information transferred from the source manufacturing systems to costing.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWorkOrdersExtractPVO
Primary Keys : CstWorkOrdersPEOCstWorkOrderId
Initial Extract Date : CstWorkOrdersPEOCreationDate
Incremental Extract Date : CstWorkOrdersPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CstWorkOrdersPEOClosedDate | Date when the work order is closed. This value is available only when the work order is in the closed status. If a closed work order is reopened, this value is updated accordingly. |
| CstWorkOrdersPEOCompletionDate | Date when the work order is completed. This value is available only when the work order is in the closed or completed status. If a closed work order is reopened then this value is updated accordingly. |
| CstWorkOrdersPEOContractMfgFlag | Contains one of the following values: Y or N. If Y, then the work order is for contract manufacturing. If N, then the work order isn't for contract manufacturing. This attribute doesn't have a default value. |
| CstWorkOrdersPEOContractMfgPoLineLocId | Value that uniquely identifies the purchase order schedule that's created for the contract manufacturing work order. |
| CstWorkOrdersPEOCountryOfOriginCode | Code that identifies the country of manufacture used to stripe inventory transactions. |
| CstWorkOrdersPEOCreatedBy | User who created the costing work order. |
| CstWorkOrdersPEOCreationDate | Date when the costing work order was created. |
| CstWorkOrdersPEOCstWorkOrderId | Value that uniquely identifies the costing work order. This is the primary key of the Costing Work Orders view object. |
| CstWorkOrdersPEOExternalSystemRefId | Value that uniquely identifies of the work order in the source system. This will store the manufacturing work order identifier value. |
| CstWorkOrdersPEOExternalSystemReference | Code that identifies the external system owning the work order definition. |
| CstWorkOrdersPEOInventoryAssetFlag | Contains one of the following values: A or E. If A, then the primary product on the work order is an asset item. If E, then the primary product on the work order is an expense item. This attribute doesn't have a default value. |
| CstWorkOrdersPEOInventoryItemId | Value that uniquely identifies the primary product associated with the work order. |
| CstWorkOrdersPEOInventoryOrganizationId | Value that uniquely identifies the manufacturing organization in which the work order is created. |
| CstWorkOrdersPEOLastUpdateDate | Date when the costing work order was last updated. |
| CstWorkOrdersPEOLastUpdateLogin | Session login associated with the user who last updated the costing work order. |
| CstWorkOrdersPEOLastUpdatedBy | User who last updated the costing work order. |
| CstWorkOrdersPEOPjcBillableFlag | Contains one of the following values: Y or N. If Y, then the project-related item can be billed to customers. If N, then the project-related item can't be billed to customers. This attribute doesn't have a default value. |
| CstWorkOrdersPEOPjcCapitalizableFlag | Contains one of the following values: Y or N. If Y, then the project-related item is eligible for capitalization. If N, then the project-related item isn't eligible for capitalization. This attribute doesn't have a default value. |
| CstWorkOrdersPEOPjcContextCategory | Segment used to identify the descriptive flexfield application context for the project-related standardized cost collection. |
| CstWorkOrdersPEOPjcContractId | Value that uniquely identifies the contract. This is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWorkOrdersPEOPjcContractLineId | Value that uniquely identifies the contract line information. This is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWorkOrdersPEOPjcExpenditureItemDate | Date when the project-related transaction is incurred. |
| CstWorkOrdersPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
| CstWorkOrdersPEOPjcFundingAllocationId | Value that uniquely identifies the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWorkOrdersPEOPjcOrganizationId | Value that uniquely identifies the expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
| CstWorkOrdersPEOPjcProjectId | Value that uniquely identifies the project against which the work order was performed. |
| CstWorkOrdersPEOPjcReservedAttribute1 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute10 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute2 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute3 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute4 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute5 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute6 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute7 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute8 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcReservedAttribute9 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWorkOrdersPEOPjcTaskId | Value that uniquely identifies the task against which the work order was performed. |
| CstWorkOrdersPEOPjcUserDefAttribute1 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute10 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute2 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute3 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute4 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute5 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute6 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute7 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute8 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcUserDefAttribute9 | Segment for the Project Costing Details descriptive flexfield. |
| CstWorkOrdersPEOPjcWorkTypeId | Value that uniquely identifies the project-related classification of the work performed. |
| CstWorkOrdersPEOReleasedDate | Date when the work order is released. |
| CstWorkOrdersPEOWorkDefinitionAsOfDate | Date used to determine the work definition version that was used to create the work order. |
| CstWorkOrdersPEOWorkDefinitionId | Value that uniquely identifies the work definition associated with the work order. |
| CstWorkOrdersPEOWorkDefinitionVersionId | Value that uniquely identifies the work definition version. |
| CstWorkOrdersPEOWorkMethodId | Value that uniquely identifies the work method that's used to carry out the work order. The accepted values are PROCESS_MANUFACTURING indicating process manufacturing, DISCRETE_MANUFACTURING indicating discrete manufacturing, and MAINTENANCE indicating maintenance management. |
| CstWorkOrdersPEOWorkOrderLessFlag | Contains one of the following values: Y or N. If Y, then the work order is created from an orderless transaction. If N, then it's a regular work order. This attribute doesn't have a default value. |
| CstWorkOrdersPEOWorkOrderNumber | Number that uniquely identifies the work order within the manufacturing organization. |
| CstWorkOrdersPEOWorkOrderStatusId | Value that uniquely identifies the work order status. |
| CstWorkOrdersPEOWorkOrderSubType | Code that identifies the specific nature of work being performed such as standard production, prototyping, or repair. For manufacturing work order, a list of accepted values is defined in the lookup type ORA_WIE_WO_SUB_TYPE. For maintenance work order, a list of accepted values is defined in the lookup type ORA_MNT_WO_SUB_TYPE. |
| CstWorkOrdersPEOWorkOrderType | Code that identifies the type of work order. For manufacturing work order, a list of accepted values is defined in the lookup type ORA_WIE_WO_TYPE. For maintenance work order, a list of accepted values is defined in the lookup type ORA_MNT_WO_TYPE. |