JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ProductionResourcesLaborInstance

The Labor Instances resource manages instances of a labor resource.

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long ProductionResourcesResourceId of ProductionResourcesLaborInstance
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.
LaborIdentifier String Abbreviation that identifies the labor resource instance.
LaborInstanceName String Name of the labor resource instance.
PartyId Long Value that identifies the party table in Oracle Trading Community Architecture. It is a foreign key.
RegistryId String Value that identifies the registry from the Oracle Trading Community Architecture. This attribute is a foreign key.
PersonName String PersonName of ProductionResourcesLaborInstance
PersonType String PersonType of ProductionResourcesLaborInstance
OrganizationId Long Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization.
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 ProductionResourcesLaborInstance
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 assigned to this equipment instance.
PrimaryWorkCenterCode String Abbreviation that identifies the primary work center.
InactiveDate Date Date when the labor instance becomes inactive.
AssetItemId Long AssetItemId of ProductionResourcesLaborInstance
AssetItemNumber String AssetItemNumber of ProductionResourcesLaborInstance
AssetNumber String AssetNumber of ProductionResourcesLaborInstance
ChangedDate Date ChangedDate of ProductionResourcesLaborInstance
EquipmentIdentifier String EquipmentIdentifier of ProductionResourcesLaborInstance
EquipmentInstanceId Long EquipmentInstanceId of ProductionResourcesLaborInstance
Finder String Finder of ProductionResourcesLaborInstance
FirstName String FirstName of ProductionResourcesLaborInstance
LastName String LastName of ProductionResourcesLaborInstance
MiddleName String MiddleName of ProductionResourcesLaborInstance
ResourceType String ResourceType of ProductionResourcesLaborInstance
WorkCenterId Long WorkCenterId of ProductionResourcesLaborInstance

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