JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemsV2ItemRevisionItemRevisionEffCategory

ItemsV2ItemRevisionItemRevisionEffCategory

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemRevisionItemRevisionEffCategory
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemRevisionItemRevisionEffCategory
ItemrevisionInventoryItemId [KEY] Long ItemrevisionInventoryItemId of ItemsV2ItemRevisionItemRevisionEffCategory
ItemrevisionOrganizationId [KEY] Long ItemrevisionOrganizationId of ItemsV2ItemRevisionItemRevisionEffCategory
ItemrevisionRevisionId [KEY] Long ItemrevisionRevisionId of ItemsV2ItemRevisionItemRevisionEffCategory
RevisionId [KEY] Long RevisionId of ItemsV2ItemRevisionItemRevisionEffCategory
CategoryCode String CategoryCode of ItemsV2ItemRevisionItemRevisionEffCategory
VersionId Long VersionId of ItemsV2ItemRevisionItemRevisionEffCategory

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
AcdType String AcdType
ChangeLineId Long ChangeLineId
InventoryOrganizationId Long InventoryOrganizationId
ItemId Long ItemId
ItemNumber String ItemNumber
OrganizationCode String OrganizationCode
OrganizationId Long OrganizationId
Finder String finder

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