Work Definition Operation Output

The Work Definition Operation Output view object contains information about the output items comprising of primary product, coproducts and by-products produced in a process work definition.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationOutputExtractPVO

Primary Keys : WdOperationOutputId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AttributeCategory Context name for the Work Definition Operation Output descriptive flexfield.
AttributeChar1 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar10 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar11 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar12 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar13 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar14 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar15 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar16 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar17 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar18 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar19 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar2 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar20 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar3 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar4 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar5 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar6 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar7 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar8 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeChar9 Character segment for the Work Definition Operation Output descriptive flexfield.
AttributeDate1 Date segment for the Work Definition Operation Output descriptive flexfield.
AttributeDate2 Date segment for the Work Definition Operation Output descriptive flexfield.
AttributeDate3 Date segment for the Work Definition Operation Output descriptive flexfield.
AttributeDate4 Date segment for the Work Definition Operation Output descriptive flexfield.
AttributeDate5 Date segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber1 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber10 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber2 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber3 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber4 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber5 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber6 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber7 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber8 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeNumber9 Number segment for the Work Definition Operation Output descriptive flexfield.
AttributeTimestamp1 Date and Time segment for the Work Definition Operation Output descriptive flexfield.
AttributeTimestamp2 Date and Time segment for the Work Definition Operation Output descriptive flexfield.
AttributeTimestamp3 Date and Time segment for the Work Definition Operation Output descriptive flexfield.
AttributeTimestamp4 Date and Time segment for the Work Definition Operation Output descriptive flexfield.
AttributeTimestamp5 Date and Time segment for the Work Definition Operation Output descriptive flexfield.
ComplLocatorId Value that uniquely identifies the default subinventory locator to which the output item will be completed.
ComplSubinventoryCode Code that uniquely identifies the default subinventory to which the output item will be completed.
CompletionType Value that indicates the type of output completion. A list of accepted values is defined in the lookup type ORA_WIS_OUTPUT_COMPL_TYPE.
CostAllocationPercentage Cost percentage share of this output across all outputs. This attribute is null for manually-entered costs. The total cost allocation percentage for all the output items assigned to an operation can't exceed 100%.
CostingPriority Priority to use when determining which work definition to use while calculating the standard cost by using rolling up costs during costing. Upon exploding the bill of materials, the child work definitions are threaded using the priority number selected at the top.
CreatedBy User who created the work definition operation output record.
CreationDate Date and time when the work definition operation output record was created.
InventoryItemId Value that uniquely identifies the output item.
JobDefinitionName Indicates the name of the job that created or last updated the work definition operation output record. This is populated through Enterprise Service Scheduler.
JobDefinitionPackage Indicates the package name of the job that created or last updated the work definition operation output record. This is populated through Enterprise Service Scheduler.
LastUpdateDate Date and time when the user last updated the work definition operation output record.
LastUpdateLogin Session login associated with the user who last updated the work definition operation output record.
LastUpdatedBy User who last updated the work definition operation output record.
ObjectVersionNumber 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.
OrganizationId Value that uniquely identifies the manufacturing plant to which this work definition operation output belongs.
OutputQuantity Quantity of output item expected to be produced in this operation.
OutputSeqNumber Number that indicates the output item sequence in an operation.
OutputType Value that indicates the type of output item. A list of accepted values is defined in the lookup type ORA_WIS_WD_OUTPUT_MATERIAL.
PrimaryFlag Indicates whether the output item is the primary output item of the work definition.
RequestId Indicates the request ID of the job that created or last updated work definition operation output record. This is populated through Enterprise Service Scheduler.
UomCode Unit of measure code of the output item quantity.
WdOperationId Value that uniquely identifies the operation in the Work Definition Operation Output view object. This is a foreign key to the Work Definition Operation view object.
WdOperationOutputId Value that uniquely identifies the work definition operation output. This is the primary key of the Work Definition Operation Output view object.
WorkDefinitionId Value that uniquely identifies the work definition in the Work Definition Operation Output view object. This is a foreign key to the Work Definition view object.