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. |