Work Definition
The Work Definition view object contains information about how to produce a product, or process a batch in manufacturing, or execute a maintenance work with a predefined ordered set of operations. It also contains information about the material and labor required at every operation step.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkDefinitionExtractPVO
Primary Keys : WorkDefinitionId
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 descriptive flexfield. |
AttributeChar1 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar10 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar11 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar12 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar13 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar14 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar15 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar16 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar17 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar18 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar19 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar2 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar20 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar3 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar4 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar5 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar6 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar7 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar8 | Character segment for the Work Definition descriptive flexfield. |
AttributeChar9 | Character segment for the Work Definition descriptive flexfield. |
AttributeDate1 | Date segment for the Work Definition descriptive flexfield. |
AttributeDate2 | Date segment for the Work Definition descriptive flexfield. |
AttributeDate3 | Date segment for the Work Definition descriptive flexfield. |
AttributeDate4 | Date segment for the Work Definition descriptive flexfield. |
AttributeDate5 | Date segment for the Work Definition descriptive flexfield. |
AttributeNumber1 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber10 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber2 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber3 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber4 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber5 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber6 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber7 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber8 | Number segment for the Work Definition descriptive flexfield. |
AttributeNumber9 | Number segment for the Work Definition descriptive flexfield. |
AttributeTimestamp1 | Date and Time segment for the Work Definition descriptive flexfield. |
AttributeTimestamp2 | Date and Time segment for the Work Definition descriptive flexfield. |
AttributeTimestamp3 | Date and Time segment for the Work Definition descriptive flexfield. |
AttributeTimestamp4 | Date and Time segment for the Work Definition descriptive flexfield. |
AttributeTimestamp5 | Date and Time segment for the Work Definition descriptive flexfield. |
BillSequenceId | Value that uniquely identifies the item structure used in the work definition to define material requirements. |
CostingPriority | Value used in costing planning scenario to determine which work definition to use when rolling up costs for an item. |
CreatedBy | User who created the work definition. |
CreationDate | Date when the work definition was created. |
InactiveDate | Date when this work definition has become inactive. |
InventoryItemId | Value that uniquely identifies the primary output, assembly, subassembly, or model item in the inventory organization. |
LastUpdateDate | Date and time when the user last updated the work definition. |
LastUpdateLogin | Session login associated with the user who last updated the work definition. |
LastUpdatedBy | User who last updated the work definition. |
MinimumTransferQuantity | Indicates the minimum quantity defined in order for an item in the Work Definition to schedule overlapping and sequential operations of work orders. |
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 belongs. |
PreassignLotFlag | Indicates if work orders created from this work definition can have preassigned lot numbers for primary product and outputs. |
ProductionPriority | Indicates the relative rank of the work definition compared to other work definitions for the item. The work definition with a priority of 1 for an item is considered the primary work definition. |
Quantity | Quantity of the production batch used for batch sizing and scaling based on which all input and output quantities are defined. |
ResequenceFlag | Indicates if the work definition has resequence enabled operations. |
SerialTrackingFlag | Indicates if the work definition is serial tracked where the item is tracked by serial numbers during work execution. |
StatusCode | Indicates the status of the work definition. A list of accepted values is defined in the lookup type ORA_WIS_WD_APPROVAL_STATUS. |
SystemGeneratedFlag | Indicates if the work definition was automatically created by the application. |
TransformFromItemId | Value that uniquely identifies the item that's transformed to a new item on a Transform work definition. |
UomCode | Unit of measure code of the work definition quantity. |
WdMntNameId | Value that uniquely identifies the name of the maintenance work definition. This is a foreign key to the Maintenance Work Definition Name view object. |
WorkDefinitionHeaderName | Name of the process associated to the process manufacturing work definition. |
WorkDefinitionId | Value that uniquely identifies the work definition. This is the primary key of the Work Definition view object. |
WorkDefinitionNameId | Value that uniquely identifies the work definition name assigned to the work definition. This is a foreign key to the Work Definition Name view object. |
WorkDefinitionType | Indicates the type of work definition. A list of accepted values is defined in the lookup type ORA_WIS_WORK_DEFINITION_TYPE. |
WorkMethodId | Value that uniquely identifies the work method of the work definition. This is a foreign key to the Work Method view object. |
WorkOrderSubType | Work order subtype associated to the work definition that's defaulted at the time of creating a maintenance work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_SUB_TYPE. |
WorkOrderType | Work order type associated to the work definition that's defaulted at the time of creating a maintenance work order. A list of accepted values is defined in the lookup type ORA_WIE_WO_TYPE. |