JDBC Driver for Oracle SCM

Build 22.0.8462

SupplierProductsassociatedSupplierOrganizations

The Associated Supplier Organizations resource is used to manage supplier organization associations of supplier products.

Columns

Name Type Description
SupplierProductsTransactionId String SupplierProductsTransactionId of SupplierProductsassociatedSupplierOrganizations
AssociationTransactionId String Value that uniquely identifies the supplier organization association row in staging.
CreatedBy String CreatedBy of SupplierProductsassociatedSupplierOrganizations
CreationDate Datetime CreationDate of SupplierProductsassociatedSupplierOrganizations
GlobalLocationNumber String Number used to uniquely identify trading parties and locations across the global data synchronization network (GDSN). Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task.
ItemNumber String Name or number of the part, item, product, or service.
LastUpdateDate Datetime LastUpdateDate of SupplierProductsassociatedSupplierOrganizations
LastUpdatedBy String LastUpdatedBy of SupplierProductsassociatedSupplierOrganizations
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.
PrimaryFlag Bool Contains one of the following values: true or false. If true, then the association is primary for the item. If false, then the association is not primary for the item. This attribute does not have a default value.
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.
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.
ProductNumber String Name or number of the spoke part, item, product, or service.
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.
SupplierNumber String Number that identifies the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task.
SupplierSiteId String Value that uniquely identifies a supplier site.
PartySiteNumber String Number that identifies the supplier site for the supplier site association.
TransactionId String Value that identifies the product row in staging.
SupplierSiteAssociationStatus String Status of the item supplier association.
CategoryCode String Abbreviation that identifies the item class associated with the supplier organization association extensible flexfields.
AddressName String Name of the supplier address. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task.
Address String Address 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