SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersProcessWorkOrderMaterial

The Work Order Materials resource manages materials that the operations use to process the work order.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersProcessWorkOrderMaterial
OrganizationId Long OrganizationId of ProcessWorkOrdersProcessWorkOrderMaterial
WorkOrderId Long WorkOrderId of ProcessWorkOrdersProcessWorkOrderMaterial
WorkOrderOperationId Long WorkOrderOperationId of ProcessWorkOrdersProcessWorkOrderMaterial
OperationSequenceNumber Decimal OperationSequenceNumber of ProcessWorkOrdersProcessWorkOrderMaterial
OperationName String OperationName of ProcessWorkOrdersProcessWorkOrderMaterial
StandardOperationId Long StandardOperationId of ProcessWorkOrdersProcessWorkOrderMaterial
StandardOperationCode String StandardOperationCode of ProcessWorkOrdersProcessWorkOrderMaterial
WorkAreaId Long WorkAreaId of ProcessWorkOrdersProcessWorkOrderMaterial
WorkAreaName String WorkAreaName of ProcessWorkOrdersProcessWorkOrderMaterial
WorkCenterId Long WorkCenterId of ProcessWorkOrdersProcessWorkOrderMaterial
WorkCenterName String WorkCenterName of ProcessWorkOrdersProcessWorkOrderMaterial
WorkOrderOperationMaterialId [KEY] Long WorkOrderOperationMaterialId of ProcessWorkOrdersProcessWorkOrderMaterial
MaterialSequenceNumber Decimal MaterialSequenceNumber of ProcessWorkOrdersProcessWorkOrderMaterial
MaterialType String MaterialType of ProcessWorkOrdersProcessWorkOrderMaterial
InventoryItemId Long InventoryItemId of ProcessWorkOrdersProcessWorkOrderMaterial
ItemNumber String ItemNumber of ProcessWorkOrdersProcessWorkOrderMaterial
ItemDescription String ItemDescription of ProcessWorkOrdersProcessWorkOrderMaterial
ItemRevision String ItemRevision of ProcessWorkOrdersProcessWorkOrderMaterial
BasisType String BasisType of ProcessWorkOrdersProcessWorkOrderMaterial
Quantity Decimal Quantity of ProcessWorkOrdersProcessWorkOrderMaterial
UOMCode String UOMCode of ProcessWorkOrdersProcessWorkOrderMaterial
UnitOfMeasure String UnitOfMeasure of ProcessWorkOrdersProcessWorkOrderMaterial
RequiredDate Datetime RequiredDate of ProcessWorkOrdersProcessWorkOrderMaterial
YieldFactor Decimal YieldFactor of ProcessWorkOrdersProcessWorkOrderMaterial
IncludeInPlanningFlag Bool IncludeInPlanningFlag of ProcessWorkOrdersProcessWorkOrderMaterial
SupplyType String SupplyType of ProcessWorkOrdersProcessWorkOrderMaterial
SupplyTypeDescription String SupplyTypeDescription of ProcessWorkOrdersProcessWorkOrderMaterial
SupplySubinventory String SupplySubinventory of ProcessWorkOrdersProcessWorkOrderMaterial
SupplyLocatorId Long SupplyLocatorId of ProcessWorkOrdersProcessWorkOrderMaterial
SupplyLocator String SupplyLocator of ProcessWorkOrdersProcessWorkOrderMaterial
ReservedQuantity Decimal ReservedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
IssuedQuantity Decimal IssuedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
ProducedQuantity Decimal ProducedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
AllocatedQuantity Decimal AllocatedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
PickedQuantity Decimal PickedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
RemainingAllocatedQuantity Decimal RemainingAllocatedQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
CreatedBy String CreatedBy of ProcessWorkOrdersProcessWorkOrderMaterial
CreationDate Datetime CreationDate of ProcessWorkOrdersProcessWorkOrderMaterial
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersProcessWorkOrderMaterial
LastUpdatedBy String LastUpdatedBy of ProcessWorkOrdersProcessWorkOrderMaterial
SecondaryQuantity Decimal SecondaryQuantity of ProcessWorkOrdersProcessWorkOrderMaterial
SecondaryUOMCode String SecondaryUOMCode of ProcessWorkOrdersProcessWorkOrderMaterial
SubstituteFlag Bool SubstituteFlag of ProcessWorkOrdersProcessWorkOrderMaterial
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersProcessWorkOrderMaterial
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersProcessWorkOrderMaterial
DueDays Int DueDays of ProcessWorkOrdersProcessWorkOrderMaterial
Finder String Finder of ProcessWorkOrdersProcessWorkOrderMaterial
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersProcessWorkOrderMaterial
MaterialItemId Long MaterialItemId of ProcessWorkOrdersProcessWorkOrderMaterial
PlannedCompletionDate Datetime PlannedCompletionDate of ProcessWorkOrdersProcessWorkOrderMaterial
PlannedStartDate Datetime PlannedStartDate of ProcessWorkOrdersProcessWorkOrderMaterial
ProductSerialId Long ProductSerialId of ProcessWorkOrdersProcessWorkOrderMaterial
ResourceId Long ResourceId of ProcessWorkOrdersProcessWorkOrderMaterial
SerialNumber String SerialNumber of ProcessWorkOrdersProcessWorkOrderMaterial
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersProcessWorkOrderMaterial
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersProcessWorkOrderMaterial
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersProcessWorkOrderMaterial
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersProcessWorkOrderMaterial
SourceSystemId Long SourceSystemId of ProcessWorkOrdersProcessWorkOrderMaterial
Tolerance Int Tolerance of ProcessWorkOrdersProcessWorkOrderMaterial
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersProcessWorkOrderMaterial
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersProcessWorkOrderMaterial
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersProcessWorkOrderMaterial
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersProcessWorkOrderMaterial

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