JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial

The Substitute Materials resource gets the substitute materials that the work order operation uses.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
ProcessworkordermaterialWorkOrderOperationMaterialId [KEY] Long ProcessworkordermaterialWorkOrderOperationMaterialId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
OrganizationId Long OrganizationId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
OrganizationCode String OrganizationCode of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
InventoryItemId Long InventoryItemId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
ItemNumber String ItemNumber of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkOrderOperationMaterialId Long WorkOrderOperationMaterialId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkOrderOperationSubstituteMaterialId [KEY] Long WorkOrderOperationSubstituteMaterialId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
Priority Decimal Priority of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
InverseQuantity Decimal InverseQuantity of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
QuantityPERProduct Decimal QuantityPERProduct of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
RequiredQuantity Decimal RequiredQuantity of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SubstituteFlag Bool SubstituteFlag of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
UOMCode String UOMCode of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
UnitOfMeasure String UnitOfMeasure of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
CreatedBy String CreatedBy of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
CreationDate Datetime CreationDate of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
LastUpdatedBy String LastUpdatedBy of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
DueDays Int DueDays of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
Finder String Finder of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
MaterialItemId Long MaterialItemId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
PlannedCompletionDate Datetime PlannedCompletionDate of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
PlannedStartDate Datetime PlannedStartDate of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
ProductSerialId Long ProductSerialId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
ResourceId Long ResourceId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SerialNumber String SerialNumber of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
SourceSystemId Long SourceSystemId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
Tolerance Int Tolerance of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkAreaId Long WorkAreaId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkCenterId Long WorkCenterId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkOrderId Long WorkOrderId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersProcessWorkOrderMaterialSubstituteMaterial

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060