JDBC Driver for Oracle SCM

Build 22.0.8462

SupplierProductsrevisions

The Revisions resource is used to manage revisions of supplier products.

Columns

Name Type Description
SupplierProductsTransactionId String SupplierProductsTransactionId of SupplierProductsrevisions
CreatedBy String CreatedBy of SupplierProductsrevisions
CreationDate Datetime CreationDate of SupplierProductsrevisions
ItemRevisionDescription String Description of the item revision.
EffectivityDate Datetime Date when the revision goes into effect.
ItemNumber String Name or number of the part, item, product, or service.
LastUpdateDate Datetime LastUpdateDate of SupplierProductsrevisions
LastUpdatedBy String LastUpdatedBy of SupplierProductsrevisions
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.
RevisionCode String Value that identifies the revision.
RevisionTransactionId String Value that uniquely identifies the revision row in staging.
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.
RevisionReasonValue String Value that indicates the reason for the revision. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
CategoryCode String Item class associated with the revision extensible flexfields.
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.

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