JDBC Driver for Oracle SCM

Build 22.0.8462

WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial

The Materials for Operations gets the materials that the work definition operation uses.

Columns

Name Type Description
WorkDefinitionsWorkDefinitionId String WorkDefinitionsWorkDefinitionId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkdefinitionoperationWorkDefinitionOperationId String WorkdefinitionoperationWorkDefinitionOperationId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
OrganizationId String OrganizationId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkDefinitionId String WorkDefinitionId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkDefinitionOperationId String WorkDefinitionOperationId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
OperationSequenceNumber String OperationSequenceNumber of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
OperationName String OperationName of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
StandardOperationId String StandardOperationId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
StandardOperationCode String StandardOperationCode of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkAreaId String WorkAreaId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkAreaCode String WorkAreaCode of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkAreaName String WorkAreaName of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkAreaDescription String WorkAreaDescription of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkCenterId String WorkCenterId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkCenterCode String WorkCenterCode of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkCenterName String WorkCenterName of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkCenterDescription String WorkCenterDescription of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
WorkDefinitionOperationMaterialId String WorkDefinitionOperationMaterialId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
MaterialSequenceNumber String MaterialSequenceNumber of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
MaterialType String MaterialType of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
InventoryItemId String InventoryItemId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
ItemNumber String ItemNumber of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
ItemDescription String ItemDescription of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
BasisType String BasisType of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
Quantity String Quantity of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
InverseQuantity String InverseQuantity of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
UOMCode String UOMCode of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
UnitOfMeasure String UnitOfMeasure of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SecondaryQuantity String SecondaryQuantity of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SecondaryUOMCode String SecondaryUOMCode of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SecondaryUnitOfMeasure String SecondaryUnitOfMeasure of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
YieldFactor String YieldFactor of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SupplyType String SupplyType of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SupplyTypeDescription String SupplyTypeDescription of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SupplySubinventory String SupplySubinventory of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SupplyLocatorId String SupplyLocatorId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
SupplyLocator String SupplyLocator of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
ComponentSequenceId String ComponentSequenceId of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
ComponentSequenceIdPath String ComponentSequenceIdPath of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
AdhocItemFlag Bool AdhocItemFlag of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
LastUpdatedBy String LastUpdatedBy of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
LastUpdateDate Datetime LastUpdateDate of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
CreatedBy String CreatedBy of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial
CreationDate Datetime CreationDate of WorkDefinitionsWorkDefinitionOperationWorkDefinitionOperationMaterial

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