ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

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 [KEY] Long ItemsV2ItemId of ItemsV2ItemSupplierAssociation
ItemsV2OrganizationId [KEY] Long ItemsV2OrganizationId of ItemsV2ItemSupplierAssociation
AssociationId Long Value that uniquely identifies an item-supplier association.
ItemId [KEY] Long Value that uniquely identifies the part, item, product, or service.
OrganizationId [KEY] Long OrganizationId of ItemsV2ItemSupplierAssociation
SupplierId [KEY] Long This attribute is not currently used.
SupplierName String Name of the supplier. Review and update the value for this attribute using the Suppliers work area, and the Manage Suppliers task.
AlternateSupplierNumber String Alternate number that identifies the supplier. Review and update the value for this attribute using the Suppliers work area, and the Manage suppliers task.
SupplierSiteId [KEY] Long Value that uniquely identifies a supplier address. Review and update the value for this attribute using the Suppliers work area, and the Manage suppliers task.
PartySiteNumber String Number that identifies the supplier site.
AddressName String Name of the supplier address. Review and update the value for this attribute using the Suppliers work area, and the Manage Suppliers task.
Address String Address of the supplier. Review and update the value for this attribute using the Suppliers work area, and the Manage Suppliers task.
SupplierItemNumber String This attribute is not currently used.
PrimaryFlag Bool Contains one of the following values: true or false. If true, then it is a primary supplier association. If false, then it is not a primary supplier association. The default value is false.
SupplierExtensibleFlexfieldCategoryCode String Value that uniquely identifies the item class associated with the item revision extensible flexfield. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
CreationDateTime Datetime CreationDateTime of ItemsV2ItemSupplierAssociation
LastUpdateDateTime Datetime LastUpdateDateTime of ItemsV2ItemSupplierAssociation
RegistryId String RegistryId of ItemsV2ItemSupplierAssociation
SupplierSiteAssociationStatusValue String Status of item supplier association.
RequestId Long RequestId of ItemsV2ItemSupplierAssociation
AcdType String AcdType of ItemsV2ItemSupplierAssociation
ChangeLineId Long ChangeLineId of ItemsV2ItemSupplierAssociation
Finder String Finder of ItemsV2ItemSupplierAssociation
InventoryOrganizationId Long InventoryOrganizationId of ItemsV2ItemSupplierAssociation
ItemNumber String ItemNumber of ItemsV2ItemSupplierAssociation
OrganizationCode String OrganizationCode of ItemsV2ItemSupplierAssociation
VersionId Long VersionId of ItemsV2ItemSupplierAssociation

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062