JDBC Driver for Oracle SCM

Build 22.0.8462

SupplierProductscategories

The Categories resource is used to manage product categories of supplier products.

Columns

Name Type Description
SupplierProductsTransactionId String SupplierProductsTransactionId of SupplierProductscategories
CategoryCode String Abbreviation that identifies the catalog category. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task.
CategoryName String Name of the catalog category. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task.
ItemCatalogId String Value that uniquely identifies the catalog.
ItemCatalog String Name of the catalog. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task.
CreatedBy String CreatedBy of SupplierProductscategories
CreationDate Datetime CreationDate of SupplierProductscategories
InterfaceTableUniqueId String Value that uniquely identifies the category association row in staging.
ItemNumber String Name or number of the part, item, product, or service.
LastUpdateDate Datetime LastUpdateDate of SupplierProductscategories
LastUpdatedBy String LastUpdatedBy of SupplierProductscategories
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.
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.
SpokeSystemCode String Abbreviation that identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task.
SpokeSystemId String Value that uniquely identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task.
ProductNumber String Name or number of the spoke part, item, product, or service.
TransactionId String Value that identifies the product row in staging.
TransactionType String Type of action to be taken when importing a record. Valid values include SYNC and DELETE.
SupplierId String Value that uniquely identifies the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task.
SupplierName String Name of the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers 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