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. |