Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

ProductionResourcesEquipmentInstance

ProductionResourcesEquipmentInstance

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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ChangedDate Date ChangedDate
FirstName String FirstName
LaborIdentifier String LaborIdentifier
LaborInstanceId Long LaborInstanceId
LastName String LastName
MiddleName String MiddleName
PartyId Long PartyId
PersonName String PersonName
PersonType String PersonType
ResourceType String ResourceType
Finder String finder

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