JDBC Driver for Oracle SCM

Build 22.0.8462

CollaborationSupplierOnHandQuantities

The Collaboration Supplier On-Hand Quantities resource manages supplier on-hand quantities for items at supplier sites.

Columns

Name Type Description
SupplierOnHandId [KEY] String Value that uniquely identifies the supplier on-hand quantity.
SupplierId String Value that uniquely identifies the supplier in the collaboration order forecast. This supplier sends the shipment. It is a primary key that the application generates when it creates the supplier.
SupplierName String Name of the supplier that holds the on-hand inventory for the item.
SupplierSiteId String Value that uniquely identifies the supplier site. This supplier site holds the on-hand inventory for the item. It is a primary key that the application generates when it creates the supplier site.
SupplierSiteName String Name of the supplier site that holds the on-hand inventory for the item.
InventoryItemId String Value that uniquely identifies the inventory item for the supplier on-hand quantity.
PlanningItemId String Value that uniquely identifies the planning item for the supplier on-hand quantity.
CollaborationItemId String Value that uniquely identifies the collaboration item for the supplier on-hand quantity.
ItemNumber String Number that identifies the item.
SupplierItemNumber String Number that identifies the item referred to by the supplier.
Quantity String Quantity of the on-hand inventory for the item.
UOMCode String Abbreviation that identifies the unit of measure for the item.
UnitOfMeasure String Unit of measure for the item.
BaseQuantity String Quantity of the on-hand inventory for the item in the base unit of measure.
BaseUOMCode String Abbreviation that identifies the base unit of measure for the item.
BaseUnitOfMeasure String Base unit of measure for the item.
ProcurementBUId String Value that uniquely identifies the business unit.
ProcurementBUName String Name of the business unit. The application assigns the supplier to this business unit.
PublishedDate Datetime Date when the on-hand quantity was published.
PublishedBy String User who most recently published the on-hand quantity.
PublishSourceCode String Abbreviation that identifies the type of user who performed the publish action. A list of accepted values is defined in the lookup type ORA_VCS_PARTY_ORIGIN. Review and update the values for this attribute using the Setup and Maintenance work area, and the Manage Supply Chain Collaboration Lookups task.
PublishSource String Value that indicates the type of user who performed the publish action. Values include Enterprise or Supplier.
CreatedBy String User who created the on-hand quantity.
CreationDate Datetime Date and time when the user created the on-hand quantity.
LastUpdatedBy String Login of the user who most recently updated the on-hand quantity.
LastUpdateDate Datetime Date and time when the user most recently updated the on-hand quantity.

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