Power BI Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

ItemsV2ItemCategory

ItemsV2ItemCategory

Columns

Name Type Description
ItemsV2ItemId [KEY] Long ItemsV2ItemId of ItemsV2ItemCategory
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemCategory
ItemId Long Value that uniquely identifies the part, item, product, or service.
OrganizationId Long A unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
ItemCatalog String Name of the item catalog.
CategoryName String Name of the category.
SequenceNumber Int Value that indicates the sequence number of the item category assignments.
ItemCategoryAssignmentId [KEY] Long Value that uniquely identifies the item category assignment.
CreationDateTime Datetime Date and time of the creation of the item catalog category assignment.
LastUpdateDateTime Datetime Date and time when the user most recently updated the item-category association.
CategoryCode String A unique code that represents a component of the catalog used for classification of items.
CreatedBy String User who created the item category assignment.
LastUpdateLogin String Login that the user used when updating the item-category association..
LastUpdatedBy String User who most recently updated the item-category association.
ItemCategoryHierarchyName String Value that represents category hierarchy using category names.
ItemCategoryHierarchyCode String Value that represents category hierarchy using category codes.
StartDate Date Date when the item association begins. The start date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area.
EndDate Date Date when the item association ends. The end date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area.
RequestId Long The request ID generated at import. Its use case is to verify the import. The items are published based on RequestID.

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

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