JDBC Driver for Oracle SCM

Build 22.0.8462

StandardOperationsStandardOperationResource

The Resources resource manages resources that the standard operation uses.

Columns

Name Type Description
StandardOperationsStandardOperationId String StandardOperationsStandardOperationId of StandardOperationsStandardOperationResource
OrganizationId String OrganizationId of StandardOperationsStandardOperationResource
ResourceSequenceNumber String Number that the application uses to determine the step in the sequence it must use to make sure resources work together correctly to finish the operation. If multiple resource lines include the same resource sequence number, then the application schedules them to occur at the same time.
StandardOperationResourceId String StandardOperationResourceId of StandardOperationsStandardOperationResource
ResourceId String Value that uniquely identifies the production resource. It is a primary key that the application generates when it creates the production resource.
ResourceCode String Abbreviation that identifies the resource.
ResourceName String ResourceName of StandardOperationsStandardOperationResource
ResourceDescription String ResourceDescription of StandardOperationsStandardOperationResource
ResourceType String ResourceType of StandardOperationsStandardOperationResource
WorkAreaId String WorkAreaId of StandardOperationsStandardOperationResource
WorkAreaName String WorkAreaName of StandardOperationsStandardOperationResource
WorkAreaCode String WorkAreaCode of StandardOperationsStandardOperationResource
WorkAreaDescription String WorkAreaDescription of StandardOperationsStandardOperationResource
WorkCenterId String WorkCenterId of StandardOperationsStandardOperationResource
WorkCenterName String WorkCenterName of StandardOperationsStandardOperationResource
WorkCenterCode String WorkCenterCode of StandardOperationsStandardOperationResource
WorkCenterDescription String WorkCenterDescription of StandardOperationsStandardOperationResource
StandardOperationName String StandardOperationName of StandardOperationsStandardOperationResource
StandardOperationId String StandardOperationId of StandardOperationsStandardOperationResource
StandardOperationCode String StandardOperationCode of StandardOperationsStandardOperationResource
PrincipalFlag Bool Contains one of the following values: true or false. If true, then this resource is the principal resource among a group of simultaneous resources. If false, then this resource is not the principal resource. At least one of the simultaneous resources must be a principal resource. The default value is false.
UsageRate String Resource usage that the plant requires to make each unit of the item.
BasisType String Indicates whether the resource usage is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE.
InverseUsageRate String Resource usage that the plant uses to make each unit of the item. This value is the inverse of the usage rate. The application uses this inverse value when the resource usage rate is a fraction, but the inverse of this rate is an integer.
UOMCode String UOMCode of StandardOperationsStandardOperationResource
UnitOfMeasure String UnitOfMeasure of StandardOperationsStandardOperationResource
ChargeType String Indicates how the resource is charged during work execution. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE.
AssignedUnits String Number of resource units the application assigns to perform the operation.
ResourceActivityCode String Abbreviation that Indicates the activity this production resource is going to perform at this operation. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_ACTIVITY.
ScheduledIndicator String Value that indicates if this resource is scheduled or not. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_SCHEDULE.
AlternateResourcesExistFlag Bool AlternateResourcesExistFlag of StandardOperationsStandardOperationResource
CostedFlag Bool CostedFlag of StandardOperationsStandardOperationResource

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