JDBC Driver for Oracle SCM

Build 22.0.8462

ItemsV2ItemSupplierAssociation

The Item-Supplier Associations resource manages the item-supplier associations. Supplier association is the association of an item with a supplier who provides that item; for examples, the association of item CAR with supplier Seven Corporation.

Columns

Name Type Description
ItemsV2ItemId String ItemsV2ItemId of ItemsV2ItemSupplierAssociation
ItemsV2OrganizationId String ItemsV2OrganizationId of ItemsV2ItemSupplierAssociation
AssociationId String An unique identifier for the item supplier association.
ItemId String An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
OrganizationId String An unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
SupplierId String Value that uniquely identifies a supplier.
SupplierName String An attribute value for the vender that will supply the item.
AlternateSupplierNumber String This refers to Supplier number of Supplier in procurement.
SupplierSiteId String Value that uniquely identifies a supplier address.
PartySiteNumber String An attribute value that represents the supplier site name for the supplier site association.
AddressName String An attribute that represents the name of the supplier address.
Address String An attribute that represents the street address where asset party is located.
SupplierItemNumber String This attribute is not used.Use ItemRelationshipService to obtain the supplier items.
PrimaryFlag Bool A flag that indicates whether the association is primary for the item.
SupplierExtensibleFlexfieldCategoryCode String An unique identifier for the EFF category code for the Item supplier.
CreationDateTime Datetime Who column: An attribute that indicates the date and time of the creation of the item supplier.
LastUpdateDateTime Datetime Who column: An attribute which indicates the date and time of the last update of the item supplier.
RegistryId String Registry ID of a supplier party is a number that uniquely identifies a party. Review and update the value for this attribute using the Manage suppliers task.
SupplierSiteAssociationStatusValue String Status of item supplier association.
RequestId String This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

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