FireDAC Components for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemsV2ItemRevisionItemRevisionDFF

ItemsV2ItemRevisionItemRevisionDFF

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemRevisionItemRevisionDFF
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemRevisionItemRevisionDFF
ItemrevisionInventoryItemId [KEY] Long ItemrevisionInventoryItemId of ItemsV2ItemRevisionItemRevisionDFF
ItemrevisionOrganizationId [KEY] Long ItemrevisionOrganizationId of ItemsV2ItemRevisionItemRevisionDFF
ItemrevisionRevisionId [KEY] Long ItemrevisionRevisionId of ItemsV2ItemRevisionItemRevisionDFF
RevisionId [KEY] Long Value that uniquely identifies the revision of the item.
_FLEX_ValidationDate Date _FLEX_ValidationDate of ItemsV2ItemRevisionItemRevisionDFF
_FLEX_Context String Descriptive flexfield context name for item revision.
_FLEX_NumOfSegments Int _FLEX_NumOfSegments of ItemsV2ItemRevisionItemRevisionDFF
_FLEX_NumOfVisibleSegments Int _FLEX_NumOfVisibleSegments of ItemsV2ItemRevisionItemRevisionDFF

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
VersionId Long VersionId
Finder String finder

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