Costing Work Order Resource Transactions
The Costing Work Order Resource Transactions view object contains information about the resource transactions interfaced from source manufacturing systems.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstWOResourceTxnsExtractPVO
Primary Keys : CstWOResourceTxnsPEOCstWoResourceTxnId
Initial Extract Date : CstWOResourceTxnsPEOCreationDate
Incremental Extract Date : CstWOResourceTxnsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CstWOResourceTxnsPEOBaseTxnActionId | Value that uniquely identifies the transaction action. |
| CstWOResourceTxnsPEOBaseTxnSourceTypeId | Value that uniquely identifies the source type of the resource transaction. |
| CstWOResourceTxnsPEOBaseTxnTypeId | Value that uniquely identifies the type of resource transaction. |
| CstWOResourceTxnsPEOBasisType | Basis type indicates whether the resource quantity is fixed or variable. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. |
| CstWOResourceTxnsPEOChargeType | Charge type indicates whether the resource transaction was automatically generated and at what stage. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE. |
| CstWOResourceTxnsPEOCreatedBy | User who created the costing work order resource transaction. |
| CstWOResourceTxnsPEOCreationDate | Date and time when the costing work order resource transaction was created. |
| CstWOResourceTxnsPEOCstWoOperationTxnId | Value that uniquely identifies the work order operation transaction in costing which triggered the resource transaction. This is the primary key of the Costing Work Order Operation Transactions view object. |
| CstWOResourceTxnsPEOCstWoResourceTxnId | Value that uniquely identifies the work order resource transaction in costing. This is the primary key of the Costing Work Order Resource Transactions view object. |
| CstWOResourceTxnsPEOCstWorkOrderId | Value that uniquely identifies the work order in costing. This is the primary key of the Costing Work Orders view object. |
| CstWOResourceTxnsPEOCstWorkOrderOperationId | Value that uniquely identifies the operation in the work order associated with the resource. This is the primary key of the Costing Work Order Operations view object. |
| CstWOResourceTxnsPEOEquipmentInstanceId | Value that uniquely identifies the equipment instance. |
| CstWOResourceTxnsPEOExternalSystemRefId | Value that unique identifies the resource transaction in the source system. |
| CstWOResourceTxnsPEOExternalSystemReference | Code that identifies the external system owning the resource transaction. |
| CstWOResourceTxnsPEOInventoryItemId | Value that uniquely identifies the primary product of the work order. |
| CstWOResourceTxnsPEOInventoryOrganizationId | Value that uniquely identifies the plant where the resource is consumed. |
| CstWOResourceTxnsPEOLaborInstanceId | Value that uniquely identifies the labor instance. |
| CstWOResourceTxnsPEOLastUpdateDate | Date when the costing work order resource transaction was last updated. |
| CstWOResourceTxnsPEOLastUpdateLogin | Session login associated with the user who last updated the costing work order resource transaction. |
| CstWOResourceTxnsPEOLastUpdatedBy | User who last updated the costing work order resource transaction. |
| CstWOResourceTxnsPEOPjcBillableFlag | Contains one of the following values: Y or N. If Y, then the project-related item can be billed to customer. If N, then the project-related item can't be billed to customer. This attribute doesn't have a default value. |
| CstWOResourceTxnsPEOPjcCapitalizableFlag | 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. |
| CstWOResourceTxnsPEOPjcContextCategory | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. |
| CstWOResourceTxnsPEOPjcContractId | Value that uniquely identifies the contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWOResourceTxnsPEOPjcContractLineId | Value that uniquely identifies the contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWOResourceTxnsPEOPjcExpenditureItemDate | Date when the project-related transaction is incurred. |
| CstWOResourceTxnsPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
| CstWOResourceTxnsPEOPjcFundingAllocationId | Value that uniquely identifies the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| CstWOResourceTxnsPEOPjcOrganizationId | Value that uniquely identifies the expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
| CstWOResourceTxnsPEOPjcProjectId | Value that uniquely identifies the project against which the work order resource transaction was performed. |
| CstWOResourceTxnsPEOPjcReservedAttribute1 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute10 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute2 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute3 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute4 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute5 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute6 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute7 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute8 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcReservedAttribute9 | Segment for the Project Costing Details descriptive flexfield. Reserved for functionality provided by Oracle Projects Cloud. |
| CstWOResourceTxnsPEOPjcTaskId | Value that uniquely identifies the task against which the work order resource transaction was performed. |
| CstWOResourceTxnsPEOPjcUserDefAttribute1 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute10 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute2 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute3 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute4 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute5 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute6 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute7 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute8 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcUserDefAttribute9 | Segment for the Project Costing Details descriptive flexfield. |
| CstWOResourceTxnsPEOPjcWorkTypeId | Value that uniquely identifies the project-related classification of the work performed. |
| CstWOResourceTxnsPEOPrimaryQuantity | Resource usage in the primary unit of measure. |
| CstWOResourceTxnsPEOPrimaryUomCode | Code that identifies the primary unit of measure for the resource. |
| CstWOResourceTxnsPEOProcessedByCaFlag | Contains one of the following values N or NULL. If N, then the work order resource transaction isn't yet processed by cost accounting. If NULL, then the work order resource transaction is processed by cost accounting. This attribute doesn't have a default value. |
| CstWOResourceTxnsPEOResourceActivityCode | Code that identifies a step within the operation or any custom run steps, which the user would like to track at the resource level. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_ACTIVITY. |
| CstWOResourceTxnsPEOResourceId | Value that uniquely identifies the resource in the manufacturing organization. |
| CstWOResourceTxnsPEOTransactionDate | Date and time when the work order resource transaction was performed. |
| CstWOResourceTxnsPEOTransactionQuantity | Resource usage in transaction unit of measure. |
| CstWOResourceTxnsPEOTransactionTypeCode | Code that identifies the transaction type. Currently, the only applicable value is RESOURCE. |
| CstWOResourceTxnsPEOTransactionUomCode | Code that identifies the transaction unit of measure. |
| CstWOResourceTxnsPEOWoOperationResourceId | Value that uniquely identifies an operation resource reference on the work order. |
| CstWOResourceTxnsPEOWoOperationTransactionId | Value that uniquely identifies the operation transaction that triggered the work order resource transaction. |
| CstWOResourceTxnsPEOWorkCenterId | Value that uniquely identifies the work center where the resource is consumed. |
| CstWOResourceTxnsPEOWorkOrderId | Value that uniquely identifies the work order in manufacturing. |
| CstWOResourceTxnsPEOWorkOrderOperationId | Value that uniquely identifies the work order operation in manufacturing. |