JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ProductionResourcesEquipmentInstance

The Equipment Instances resource manages instances of an equipment resource.

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long ProductionResourcesResourceId of ProductionResourcesEquipmentInstance
EquipmentInstanceId [KEY] Long Value that uniquely identifies the equipment resource instance. It is a primary key that the application generates when it creates a equipment instance.
EquipmentIdentifier String Abbreviation that identifies the equipment resource instance.
EquipmentInstanceName String Name of the equipment resource instance.
AssetId Long Value that uniquely identifies the item associated with the asset in the maintenance organization.
AssetNumber String Unique asset number that identifies the equipment instance.
AssetDescription String AssetDescription of ProductionResourcesEquipmentInstance
AssetItemId Long AssetItemId of ProductionResourcesEquipmentInstance
AssetItemNumber String AssetItemNumber of ProductionResourcesEquipmentInstance
AssetItemDescription String AssetItemDescription of ProductionResourcesEquipmentInstance
OrganizationId Long OrganizationId of ProductionResourcesEquipmentInstance
ResourceId Long Value that uniquely identifies the production resource. It is a primary key that the application generates when it creates a production resource.
ResourceCode String ResourceCode of ProductionResourcesEquipmentInstance
PrimaryWorkCenterId Long Value that uniquely identifies the work center. It is a primary key that the application generates when it creates a work center. This is the default work center that the application assigns to this equipment instance.
PrimaryWorkCenterCode String Abbreviation that identifies the primary work center.
InactiveDate Date Date when the equipment instance becomes inactive.
ChangedDate Date ChangedDate of ProductionResourcesEquipmentInstance
Finder String Finder of ProductionResourcesEquipmentInstance
FirstName String FirstName of ProductionResourcesEquipmentInstance
LaborIdentifier String LaborIdentifier of ProductionResourcesEquipmentInstance
LaborInstanceId Long LaborInstanceId of ProductionResourcesEquipmentInstance
LastName String LastName of ProductionResourcesEquipmentInstance
MiddleName String MiddleName of ProductionResourcesEquipmentInstance
PartyId Long PartyId of ProductionResourcesEquipmentInstance
PersonName String PersonName of ProductionResourcesEquipmentInstance
PersonType String PersonType of ProductionResourcesEquipmentInstance
ResourceType String ResourceType of ProductionResourcesEquipmentInstance
WorkCenterId Long WorkCenterId of ProductionResourcesEquipmentInstance

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