JDBC Driver for Oracle SCM

Build 22.0.8462

WorkDefinitions

The Work Definitions resource gets the details of the work definition. This resource cannot be used to create and update the work definitions.

Columns

Name Type Description
WorkDefinitionId [KEY] String WorkDefinitionId of WorkDefinitions
OrganizationId String OrganizationId of WorkDefinitions
OrganizationCode String OrganizationCode of WorkDefinitions
WorkDefinitionNameId String WorkDefinitionNameId of WorkDefinitions
WorkDefinitionName String WorkDefinitionName of WorkDefinitions
WorkDefinitionNameDescription String WorkDefinitionNameDescription of WorkDefinitions
WorkDefinitionCode String WorkDefinitionCode of WorkDefinitions
WorkDefinitionTypeCode String WorkDefinitionTypeCode of WorkDefinitions
WorkDefinitionType String WorkDefinitionType of WorkDefinitions
UsedInPlanningFlag Bool UsedInPlanningFlag of WorkDefinitions
SeededFlag Bool SeededFlag of WorkDefinitions
EffectiveFromDate Date EffectiveFromDate of WorkDefinitions
EffectiveToDate Date EffectiveToDate of WorkDefinitions
ProductionPriority String ProductionPriority of WorkDefinitions
CostingPriority String CostingPriority of WorkDefinitions
InventoryItemId String InventoryItemId of WorkDefinitions
ItemNumber String ItemNumber of WorkDefinitions
ItemDescription String ItemDescription of WorkDefinitions
TransformFromItemId String TransformFromItemId of WorkDefinitions
TransformFromItemNumber String TransformFromItemNumber of WorkDefinitions
ItemStructureId String ItemStructureId of WorkDefinitions
ItemStructureName String ItemStructureName of WorkDefinitions
ItemStructureType String ItemStructureType of WorkDefinitions
WorkDefinitionVersionId String WorkDefinitionVersionId of WorkDefinitions
VersionNumber String VersionNumber of WorkDefinitions
VersionEffectiveFromDate Datetime VersionEffectiveFromDate of WorkDefinitions
VersionEffectiveToDate Datetime VersionEffectiveToDate of WorkDefinitions
CompletionLocatorId String CompletionLocatorId of WorkDefinitions
CompletionLocator String CompletionLocator of WorkDefinitions
CompletionSubinventoryCode String CompletionSubinventoryCode of WorkDefinitions
SystemGeneratedFlag Bool SystemGeneratedFlag of WorkDefinitions
SerialTrackingFlag Bool SerialTrackingFlag of WorkDefinitions
CostingBatchOutputSize String CostingBatchOutputSize of WorkDefinitions
WorkMethodId String WorkMethodId of WorkDefinitions
WorkMethodCode String WorkMethodCode of WorkDefinitions
WorkMethodName String WorkMethodName of WorkDefinitions
WorkMethodDescription String WorkMethodDescription of WorkDefinitions
ProcessName String ProcessName of WorkDefinitions
BatchUOMCode String BatchUOMCode of WorkDefinitions
BatchQuantity String BatchQuantity of WorkDefinitions
CreatedBy String CreatedBy of WorkDefinitions
CreationDate Datetime CreationDate of WorkDefinitions
LastUpdatedBy String LastUpdatedBy of WorkDefinitions
LastUpdateDate Datetime LastUpdateDate of WorkDefinitions
StatusCode String StatusCode of WorkDefinitions
InactiveDate Date InactiveDate of WorkDefinitions
Status String Status of WorkDefinitions
WorkOrderType String WorkOrderType of WorkDefinitions
WorkOrderSubType String WorkOrderSubType of WorkDefinitions
PreassignLotFlag Bool PreassignLotFlag of WorkDefinitions

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462