Work Order Operation Transaction
The Work Order Operation Transaction view object contains information about the quantity change that occurs between the from dispatch state and the to dispatch state of a work order operation.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationTransactionExtractPVO
Primary Keys : OpTrxPEOWoOperationTransactionId
Initial Extract Date : OpTrxPEOCreationDate
Incremental Extract Date : OpTrxPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| OpTrxPEOAssemblyAssetId | 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. |
| OpTrxPEOAttributeCategory | Context name for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar1 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar10 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar11 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar12 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar13 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar14 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar15 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar16 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar17 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar18 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar19 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar2 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar20 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar3 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar4 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar5 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar6 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar7 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar8 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeChar9 | Character segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeDate1 | Date segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeDate2 | Date segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeDate3 | Date segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeDate4 | Date segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeDate5 | Date segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber1 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber10 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber2 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber3 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber4 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber5 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber6 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber7 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber8 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeNumber9 | Number segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeTimestamp1 | Date and time segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeTimestamp2 | Date and time segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeTimestamp3 | Date and time segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeTimestamp4 | Date and time segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOAttributeTimestamp5 | Date and time segment for the Work Order Operation Transaction descriptive flexfield. |
| OpTrxPEOComplLocatorId | Value that uniquely identifies the locator the product is completed into. It's a foreign key to the Locator object. |
| OpTrxPEOComplSubinventoryCode | Subinventory in which the product is stored after product completion. |
| OpTrxPEOCreatedBy | User who created the operation transaction. |
| OpTrxPEOCreationDate | Date when the user created the operation transaction. |
| OpTrxPEOCstInterfacedFlag | Indicates whether the operation transaction is interfaced to costing or not. |
| OpTrxPEOFromDispatchState | Status of the operation transaction quantity moved from. A list of accepted values is defined in the lookup type ORA_WIE_DISPATCH_STATE. |
| OpTrxPEOInspectionEventId | Value that uniquely identifies the quality inspection results that were collected while performing this transaction. |
| OpTrxPEOInterfaceBatchId | Value that uniquely identifies the batch of the operation transaction record that was interfaced. |
| OpTrxPEOInterfaceRowId | Value that uniquely identifies the operation transaction record that was interfaced. |
| OpTrxPEOInvTransactionId | Value that uniquely identifies the inventory transaction that's created for the operation transaction. This is a foreign key of the inventory material transactions object. |
| OpTrxPEOInventoryItemId | Value that uniquely identifies the item, product, or assembly in the inventory organization. |
| OpTrxPEOJobDefinitionName | Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| OpTrxPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| OpTrxPEOLastUpdateDate | Date and time when the user last updated the operation transaction record. |
| OpTrxPEOLastUpdateLogin | Session login associated with the user who last updated the operation transaction record. |
| OpTrxPEOLastUpdatedBy | User who last updated the operation transaction record. |
| OpTrxPEOObjectVersionNumber | 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. |
| OpTrxPEOOrganizationId | Value that uniquely identifies the manufacturing plant where the operation transaction is performed. |
| OpTrxPEOPoHeaderId | Value that uniquely identifies the contract manufacturer's purchase order. This is a foreign key to the Purchase Order object. |
| OpTrxPEOPoLineId | Value that uniquely identifies the contract manufacturer's purchase order line. This is a foreign key to the Purchase Order Line object. |
| OpTrxPEOPrimaryQuantity | Quantity of the product that's transacted in the primary unit of measure. |
| OpTrxPEOPrimaryUomCode | Primary unit of measure of the product that's transacted. |
| OpTrxPEOReasonCode | Reason why the quantities were rejected or scrapped at the operation. |
| OpTrxPEORequestId | Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| OpTrxPEOSourceHeaderRef | Reference to the operation transaction header in the source system. |
| OpTrxPEOSourceHeaderRefId | Value that uniquely identifies the operation transaction header in the source system. |
| OpTrxPEOSourceLineRef | Reference to the operation transaction line in the source system. |
| OpTrxPEOSourceLineRefId | Value that uniquely identifies the operation transaction line in the source system. |
| OpTrxPEOSourceSystemCode | Indicates the source system from which the operation 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. |
| OpTrxPEOSourceSystemId | Value that uniquely identifies the source system. |
| OpTrxPEOSourceSystemType | Indicates the type of source system, internal or external, from which work order operation transaction is imported. A list of accepted values is defined in the lookup type ORA_WIE_SOURCE_SYSTEM_TYPE. |
| OpTrxPEOToDispatchState | Status of the operation transaction quantity moved to. A list of accepted values is defined in the lookup type ORA_WIE_DISPATCH_STATE. |
| OpTrxPEOTransactionDate | Date when the operation transaction is performed. |
| OpTrxPEOTransactionNote | Note captured while reporting the operation transaction. |
| OpTrxPEOTransactionQuantity | Quantity of the product that's transacted in the transactional unit of measure. |
| OpTrxPEOTransactionTypeCode | Indicates the type of operation transaction. A list of accepted values is defined in the lookup type ORA_WIE_DISPATCH_STATE. |
| OpTrxPEOTransactionUomCode | Unit of measure of the quantity that's transacted. |
| OpTrxPEOWoOperationId | Value that uniquely identifies the work order operation for which the operation transaction is created. This is a foreign key to the Work Order Operation view object. |
| OpTrxPEOWoOperationTransactionId | Value that uniquely identifies the work order operation transaction. This is the primary key of the Work Order Operation Transaction view object. |
| OpTrxPEOWorkOrderId | Value that uniquely identifies the work order for which the operation transaction is created. This is a foreign key to the Work Order view object. |