JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ProductionResourcesLaborInstanceLaborInstanceDFF

ProductionResourcesLaborInstanceLaborInstanceDFF

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long ProductionResourcesResourceId of ProductionResourcesLaborInstanceLaborInstanceDFF
LaborinstanceLaborInstanceId [KEY] Long LaborinstanceLaborInstanceId of ProductionResourcesLaborInstanceLaborInstanceDFF
LaborInstanceId [KEY] Long Value that uniquely identifies the labor resource instance. It is a primary key that the application generates when it creates a labor instance.
_FLEX_Context String Descriptive flexfield context name for labor instances.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for labor instances.

Pseudo-Columns

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

Name Type Description
AssetItemId Long AssetItemId
AssetItemNumber String AssetItemNumber
AssetNumber String AssetNumber
ChangedDate Date ChangedDate
EquipmentIdentifier String EquipmentIdentifier
EquipmentInstanceId Long EquipmentInstanceId
FirstName String FirstName
LaborIdentifier String LaborIdentifier
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