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