JDBC Driver for Oracle SCM

Build 22.0.8462

WorkDefinitionsWorkDefinitionMaterial

The Work Definition Materials resource gets all the materials of a work definition across the operations.

Columns

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

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