Work Order Resource Transaction
The Work Order Resource Transaction view object contains information about the resource usages reported for a work order operation.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOResourceTransactionExtractPVO
Primary Keys : ResTrxPEOWoResourceTransactionId
Initial Extract Date : ResTrxPEOCreationDate
Incremental Extract Date : ResTrxPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ResTrxPEOAssemblyAssetId | Value that uniquely identifies the asset number that was transacted in the work order. This is a foreign key to the Installed Base Asset view object. |
| ResTrxPEOAttributeCategory | Context name for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar1 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar10 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar11 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar12 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar13 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar14 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar15 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar16 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar17 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar18 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar19 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar2 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar20 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar3 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar4 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar5 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar6 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar7 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar8 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeChar9 | Character segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeDate1 | Date segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeDate2 | Date segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeDate3 | Date segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeDate4 | Date segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeDate5 | Date segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber1 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber10 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber2 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber3 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber4 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber5 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber6 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber7 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber8 | Number segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeNumber9 | Number segment for the Resource Transaction descriptive flexfield |
| ResTrxPEOAttributeTimestamp1 | Date and time segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeTimestamp2 | Date and time segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeTimestamp3 | Date and time segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeTimestamp4 | Date and time segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAttributeTimestamp5 | Date and time segment for the Resource Transaction descriptive flexfield. |
| ResTrxPEOAutoTransactFlag | Indicates if the work order operation is automatically completed when the next count point operation in sequence is completed. |
| ResTrxPEOBasisType | Indicates if the resource usage is dependent on quantity of product produced. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. |
| ResTrxPEOChargeType | Indicates if the resource is transacted automatically or manually. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE. |
| ResTrxPEOCreatedBy | User who created the resource transaction. |
| ResTrxPEOCreationDate | Date when the resource transaction was created. |
| ResTrxPEOCstInterfacedFlag | Indicates whether the resource transaction is interfaced to costing. |
| ResTrxPEOEquipmentInstanceId | Value that uniquely identifies the equipment resource instance. This is a foreign key to the Equipment Instance view object. |
| ResTrxPEOInterfaceBatchId | Value that uniquely identifies the batch of the resource transaction record that was interfaced. |
| ResTrxPEOInterfaceRowId | Value that uniquely identifies the resource transaction record that was interfaced. |
| ResTrxPEOInventoryItemId | Value that uniquely identifies the item, product, or assembly in the inventory organization. This is a foreign key to the Item object. |
| ResTrxPEOJobDefinitionName | Indicates the name of the job that created or last updated the resource transaction record. This information is populated through the Enterprise Service Scheduler. |
| ResTrxPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the resource transaction record. |
| ResTrxPEOLaborInstanceId | Value that uniquely identifies the labor resource instance. This is a foreign key to the Labor Instance view object. |
| ResTrxPEOLastUpdateDate | Date and time when the user last updated the resource transaction record. |
| ResTrxPEOLastUpdateLogin | Session login associated with the user who last created the resource transaction record. |
| ResTrxPEOLastUpdatedBy | User who last updated the resource transaction record. |
| ResTrxPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| ResTrxPEOOperationSeqNumber | Sequence of the work order operation for which the resource transaction is created. |
| ResTrxPEOOrganizationId | Value that uniquely identifies the manufacturing plant where the resource transaction is created. |
| ResTrxPEOPjcBillableFlag | Indicates if a project-related item is available to be billed to customers. The valid values are Y and N. |
| ResTrxPEOPjcCapitalizableFlag | Indicates if a project-related item is eligible for capitalization. The valid values are Y and N. |
| ResTrxPEOPjcContextCategory | Context name of the Project Costing descriptive flexfield used for project-related cost collection. |
| ResTrxPEOPjcContractId | Value that uniquely identifies the contract number associated to the resource transaction.This attribute is used for sponsored projects when Oracle Grants Management is enabled. |
| ResTrxPEOPjcContractLineId | Value that uniquely identifies the contract line number associated to the resource transaction.This attribute is used for sponsored projects when Oracle Grants Management is enabled. |
| ResTrxPEOPjcExpenditureItemDate | Date when the project-related transaction is incurred. |
| ResTrxPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type of the resource transaction. |
| ResTrxPEOPjcFundingAllocationId | Value that uniquely identifies the name of the project funding override.This attribute is used for sponsored projects when Oracle Grants Management is enabled. |
| ResTrxPEOPjcOrganizationId | Value that uniquely identifies the expenditure organization of the resource transaction. |
| ResTrxPEOPjcProjectId | Value that uniquely identifies the project associated to the resource transaction. |
| ResTrxPEOPjcReservedAttribute1 | Name of the funding source associated to the project.This attribute is used for sponsored projects when Oracle Grants Management is enabled. |
| ResTrxPEOPjcReservedAttribute10 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute2 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute3 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute4 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute5 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute6 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute7 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute8 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcReservedAttribute9 | This attribute is reserved for future project related functionality. |
| ResTrxPEOPjcTaskId | Value that uniquely identifies the task associated to the resource transaction. |
| ResTrxPEOPjcUserDefAttribute1 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute10 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute2 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute3 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute4 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute5 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute6 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute7 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute8 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcUserDefAttribute9 | User-definable segment to maintain project information in the project costing descriptive flexfield. |
| ResTrxPEOPjcWorkTypeId | Value that uniquely identifies the project-related classification of the work performed. |
| ResTrxPEOPrimaryQuantity | Quantity of the resource that's transacted in the primary unit of measure. |
| ResTrxPEOPrimaryUomCode | Primary unit of measure of the resource quantity that's transacted at the operation. |
| ResTrxPEORepairTxnCodeId | Value that uniquely identifies the type of repair transaction being performed in the maintenance work order resource transaction. |
| ResTrxPEORequestId | Indicates the request ID of the job that created or last updated the resource transaction record. This is populated through Enterprise Service Scheduler. |
| ResTrxPEORequiredUsage | Required usage for the resource for the work order operation. The planned resource usage is the value determined based on the work order quantity and basis type. |
| ResTrxPEOResourceActivityCode | Activity used to represent any intra operation steps or any other custom run steps to track at the resource level. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_ACTIVITY. |
| ResTrxPEOResourceCode | User-defined code that identifies the resource that's transacted. |
| ResTrxPEOResourceId | Value that uniquely identifies the resource that's transacted. This is a foreign key of the Resource view object. |
| ResTrxPEOResourceSeqNumber | Sequence of the resource associated to the work order operation. |
| ResTrxPEOResourceType | Identifies the type of the resource that's transacted. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_TYPE. |
| ResTrxPEOSourceHeaderRef | Reference to the resource transaction header in the source system. |
| ResTrxPEOSourceHeaderRefId | Value that uniquely identifies the resource transaction header in the source system. |
| ResTrxPEOSourceLineRef | Reference to the resource transaction line in the source system. |
| ResTrxPEOSourceLineRefId | Value that uniquely identifies the resource transaction line in the source system. |
| ResTrxPEOSourceSystemCode | Indicates the source system from which the resource transaction is imported. Depending on the source system type, this value could represent an internal product code or the actual trading community source system reference. |
| ResTrxPEOSourceSystemId | Value that uniquely identifies the source system from which the resource transaction is imported. |
| ResTrxPEOSourceSystemType | Indicates the type of source system, internal or external, from which the resource transaction is imported. A list of accepted values is defined in the lookup type ORA_WIE_SOURCE_SYSTEM_TYPE. |
| ResTrxPEOTransactionDate | Date when the resource transaction is performed. |
| ResTrxPEOTransactionQuantity | Quantity of the resource that's transacted at the operation. |
| ResTrxPEOTransactionTypeCode | Identifies the type of the resource transaction. A list of accepted values is defined in the lookup type ORA_WIE_TRANSACTION_TYPE.. |
| ResTrxPEOTransactionUomCode | Unit of measure of the resource quantity that's transacted at the operation. |
| ResTrxPEOTxnHeaderId | Value that uniquely identifies the resource transaction header. |
| ResTrxPEOUsageRate | Predefined resource usage rate that's required to produce one unit of the product in discrete manufacturing, or a standard batch quantity in process manufacturing. |
| ResTrxPEOWoOperationId | Value that uniquely identifies the work order operation for which the resource transaction is created. This is a foreign key to the Work Order Operation view object. |
| ResTrxPEOWoOperationResourceId | Value that uniquely identifies the parent operation transaction that triggered the automatic creation of the resource transaction. This is a foreign key to the Work Order Operation Transaction view object. |
| ResTrxPEOWoOperationTransactionId | Value that uniquely identifies the work order operation resource for which the resource transaction is created. This is a foreign key to the Work Order Operation Resource view object. |
| ResTrxPEOWoResourceTransactionId | Value that uniquely identifies the work order resource transaction. This is the primary key of the Work Order Resource Transaction view object. |
| ResTrxPEOWorkCenterId | Value that uniquely identifies the work center associated to the operation for which the resource transaction is created. This is a foreign key to the Work Center View object. |
| ResTrxPEOWorkOrderId | Value that uniquely identifies the work order for which the resource transaction is created. This is a foreign key to the Work Order View object. |