ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderResource

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

Columns

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

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