JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ProductionResourcesEquipmentInstanceEquipmentInstanceDFF

ProductionResourcesEquipmentInstanceEquipmentInstanceDFF

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long ProductionResourcesResourceId of ProductionResourcesEquipmentInstanceEquipmentInstanceDFF
EquipmentinstanceEquipmentInstanceId [KEY] Long EquipmentinstanceEquipmentInstanceId of ProductionResourcesEquipmentInstanceEquipmentInstanceDFF
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.
_FLEX_Context String Descriptive flexfield context name for equipment instances.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for equipment instances.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AssetItemId Long AssetItemId
AssetItemNumber String AssetItemNumber
AssetNumber String AssetNumber
ChangedDate Date ChangedDate
EquipmentIdentifier String EquipmentIdentifier
FirstName String FirstName
LaborIdentifier String LaborIdentifier
LaborInstanceId Long LaborInstanceId
LastName String LastName
MiddleName String MiddleName
OrganizationId Long OrganizationId
PartyId Long PartyId
PersonName String PersonName
PersonType String PersonType
PrimaryWorkCenterCode String PrimaryWorkCenterCode
PrimaryWorkCenterId Long PrimaryWorkCenterId
ResourceId Long ResourceId
ResourceType String ResourceType
Finder String finder

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