JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ItemsV2ItemCategory

The Item-Category Assignments resource manages the item catalog category associations.

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 OrganizationId of ItemsV2ItemCategory
ItemCatalog String Name of the item catalog.
CategoryName String Name of the item category.
SequenceNumber Int Not exposed in code.
ItemCategoryAssignmentId [KEY] Long Value that uniquely identifies the item category assignment.
CreationDateTime Datetime CreationDateTime of ItemsV2ItemCategory
LastUpdateDateTime Datetime LastUpdateDateTime of ItemsV2ItemCategory
CategoryCode String Abbreviation that identifies the item category. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage catalogs task.
CreatedBy String CreatedBy of ItemsV2ItemCategory
LastUpdateLogin String LastUpdateLogin of ItemsV2ItemCategory
LastUpdatedBy String LastUpdatedBy of ItemsV2ItemCategory
ItemCategoryHierarchyName String ItemCategoryHierarchyName of ItemsV2ItemCategory
ItemCategoryHierarchyCode String ItemCategoryHierarchyCode of ItemsV2ItemCategory
StartDate Date Date when the item association begins. The start date cannot 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 cannot be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area.
RequestId Long Value that uniquely identifies the request. This attribute is generated during import. This value is used to verify import, when items are published.
AcdType String AcdType of ItemsV2ItemCategory
ChangeLineId Long ChangeLineId of ItemsV2ItemCategory
Finder String Finder of ItemsV2ItemCategory
InventoryOrganizationId Long InventoryOrganizationId of ItemsV2ItemCategory
ItemNumber String ItemNumber of ItemsV2ItemCategory
OrganizationCode String OrganizationCode of ItemsV2ItemCategory
VersionId Long VersionId of ItemsV2ItemCategory

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