JDBC Driver for Oracle SCM

Build 22.0.8462

ItemCategoryAssignments

The Item Category Assignments resource manages the relationship between an item and the category it's assigned to.

Columns

Name Type Description
CatalogId String Value that uniquely identifies the catalog.
CatalogCode String Abbreviation that identifies the catalog.
CatalogName String Name of the catalog. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task.
CategoryId String Value that uniquely identifies the category.
CategoryCode String Abbreviation that identifies the category.
CategoryName String Name of the category. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task.
ItemId String Value that uniquely identifies the item.
OrganizationId String Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
Item String Value that uniquely identifies the part, item, product, or service.
OrganizationCode String Abbreviation that identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
ItemDescription String Description of the item.
ItemClassId String Value that uniquely identifies the item class.
ItemClassName String Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
StartDate Date Date when the item category assignment becomes active.
EndDate Date Date when the item category assignment becomes inactive.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462