SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersProcessWorkOrderResource

The Work Order Resources resource manages resources that the operations use to process the work order.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersProcessWorkOrderResource
OrganizationId Long OrganizationId of ProcessWorkOrdersProcessWorkOrderResource
ResourceSequenceNumber Decimal ResourceSequenceNumber of ProcessWorkOrdersProcessWorkOrderResource
WorkOrderOperationResourceId [KEY] Long WorkOrderOperationResourceId of ProcessWorkOrdersProcessWorkOrderResource
ResourceId Long ResourceId of ProcessWorkOrdersProcessWorkOrderResource
ResourceCode String ResourceCode of ProcessWorkOrdersProcessWorkOrderResource
ResourceDescription String ResourceDescription of ProcessWorkOrdersProcessWorkOrderResource
ResourceName String ResourceName of ProcessWorkOrdersProcessWorkOrderResource
ResourceType String ResourceType of ProcessWorkOrdersProcessWorkOrderResource
WorkAreaId Long WorkAreaId of ProcessWorkOrdersProcessWorkOrderResource
WorkAreaName String WorkAreaName of ProcessWorkOrdersProcessWorkOrderResource
WorkAreaCode String WorkAreaCode of ProcessWorkOrdersProcessWorkOrderResource
WorkAreaDescription String WorkAreaDescription of ProcessWorkOrdersProcessWorkOrderResource
WorkCenterId Long WorkCenterId of ProcessWorkOrdersProcessWorkOrderResource
WorkCenterName String WorkCenterName of ProcessWorkOrdersProcessWorkOrderResource
WorkCenterCode String WorkCenterCode of ProcessWorkOrdersProcessWorkOrderResource
WorkCenterDescription String WorkCenterDescription of ProcessWorkOrdersProcessWorkOrderResource
WorkOrderId Long WorkOrderId of ProcessWorkOrdersProcessWorkOrderResource
WorkOrderOperationId Long WorkOrderOperationId of ProcessWorkOrdersProcessWorkOrderResource
OperationSequenceNumber Decimal OperationSequenceNumber of ProcessWorkOrdersProcessWorkOrderResource
OperationName String OperationName of ProcessWorkOrdersProcessWorkOrderResource
StandardOperationId Long StandardOperationId of ProcessWorkOrdersProcessWorkOrderResource
StandardOperationCode String StandardOperationCode of ProcessWorkOrdersProcessWorkOrderResource
PrincipalFlag Bool PrincipalFlag of ProcessWorkOrdersProcessWorkOrderResource
BasisType String BasisType of ProcessWorkOrdersProcessWorkOrderResource
RequiredUsage Decimal RequiredUsage of ProcessWorkOrdersProcessWorkOrderResource
UOMCode String UOMCode of ProcessWorkOrdersProcessWorkOrderResource
UnitOfMeasure String UnitOfMeasure of ProcessWorkOrdersProcessWorkOrderResource
ChargeType String ChargeType of ProcessWorkOrdersProcessWorkOrderResource
AssignedUnits Decimal AssignedUnits of ProcessWorkOrdersProcessWorkOrderResource
PlannedStartDate Datetime PlannedStartDate of ProcessWorkOrdersProcessWorkOrderResource
PlannedCompletionDate Datetime PlannedCompletionDate of ProcessWorkOrdersProcessWorkOrderResource
ResourceActivityCode String ResourceActivityCode of ProcessWorkOrdersProcessWorkOrderResource
ScheduledIndicator String ScheduledIndicator of ProcessWorkOrdersProcessWorkOrderResource
PhantomFlag Bool PhantomFlag of ProcessWorkOrdersProcessWorkOrderResource
ActualResourceUsage Decimal ActualResourceUsage of ProcessWorkOrdersProcessWorkOrderResource
CreatedBy String CreatedBy of ProcessWorkOrdersProcessWorkOrderResource
CreationDate Datetime CreationDate of ProcessWorkOrdersProcessWorkOrderResource
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersProcessWorkOrderResource
LastUpdatedBy String LastUpdatedBy of ProcessWorkOrdersProcessWorkOrderResource
ProfileId Long ProfileId of ProcessWorkOrdersProcessWorkOrderResource
ProfileCode String ProfileCode of ProcessWorkOrdersProcessWorkOrderResource
EquipmentProfileId Long EquipmentProfileId of ProcessWorkOrdersProcessWorkOrderResource
EquipmentProfileCode String EquipmentProfileCode of ProcessWorkOrdersProcessWorkOrderResource
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersProcessWorkOrderResource
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersProcessWorkOrderResource
DueDays Int DueDays of ProcessWorkOrdersProcessWorkOrderResource
Finder String Finder of ProcessWorkOrdersProcessWorkOrderResource
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersProcessWorkOrderResource
InventoryItemId Long InventoryItemId of ProcessWorkOrdersProcessWorkOrderResource
ItemNumber String ItemNumber of ProcessWorkOrdersProcessWorkOrderResource
MaterialItemId Long MaterialItemId of ProcessWorkOrdersProcessWorkOrderResource
ProductSerialId Long ProductSerialId of ProcessWorkOrdersProcessWorkOrderResource
SerialNumber String SerialNumber of ProcessWorkOrdersProcessWorkOrderResource
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersProcessWorkOrderResource
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersProcessWorkOrderResource
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersProcessWorkOrderResource
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersProcessWorkOrderResource
SourceSystemId Long SourceSystemId of ProcessWorkOrdersProcessWorkOrderResource
Tolerance Int Tolerance of ProcessWorkOrdersProcessWorkOrderResource
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersProcessWorkOrderResource
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersProcessWorkOrderResource
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersProcessWorkOrderResource
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersProcessWorkOrderResource

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