Excel Add-In for Oracle Fusion Cloud SCM

Build 25.0.9434

AvailableSupplySources

Identifies optimal supply sources or lists all possible supply sources for internal material transfer requests.

Columns

Name Type Description
ResponseId Long The unique identifier for the supply source response, linking a request for available supply options to a specific system-generated response. This identifier enables tracking of supply availability and supports data-driven decision-making for inventory fulfillment.
OptionId [KEY] Long The unique identifier for a supply option, representing a potential source from which the requested inventory can be fulfilled. Supply options are determined based on factors such as stock availability, supplier contracts, and business rules.
OptionRank Int The unique ranking assigned to each supply option, prioritizing sourcing choices based on criteria such as cost, lead time, proximity, supplier preference, and contractual agreements.
ItemId Long The unique identifier for the inventory item being sourced. This identifier ensures precise tracking of stock, demand planning, and fulfillment across supply chain networks.
ItemNumber String The unique alphanumeric code assigned to an inventory item. This code is used for product identification across procurement, warehouse management, logistics, and order fulfillment processes.
DestinationOrganizationId Long The unique identifier for the organization receiving the supply. This identifier ensuresthat inventory transfers, shipments, and allocations are accurately recorded in the system and attributed to the correct business entity.
DestinationOrganizationCode String The unique alphanumeric code representing the destination organization. This code is used to link shipments, warehouse transfers, and fulfillment records, ensuring proper routing of supplies.
DestinationOrganizationName String The unique full name of the organization receiving the inventory. This field provides clear ownership details in multi-entity supply chain environments to ensure proper accountability and stock allocation.
Quantity Decimal The unique quantity of the item requested for fulfillment. This quantity ensures accurate demand planning, order allocation, and inventory control to meet supply chain requirements.
UOMCode String The unique unit of measure (UOM) code assigned to the item. This field defines the standard measurement (for example, 'EA' for each, 'KG' for kilograms, or 'L' for liters) used in stock transactions and procurement.
UOMName String The unique name of the UOM associated with the requested quantity. This name ensures consistency in inventory management, procurement, and fulfillment processes.
NeedByDate Date The unique date by which the requested supply must be delivered. This date supports timely fulfillment for production planning, sales commitments, and customer satisfaction.
SourceOrganizationId Long The unique identifier for the organization supplying the inventory. This identifier ensures accurate attribution of stock movements to the appropriate supplier, warehouse, or manufacturing facility.
SourceOrganizationCode String The unique alphanumeric code representing the source organization. This code is used to streamline order fulfillment processes, supplier collaboration, and stock transfers.
SourceOrganizationName String The unique full name of the organization providing the supply. This name ensures clarity in sourcing decisions, supplier performance tracking, and inventory management in multi-tiered supply chains.
ExpectedDeliveryDate Datetime The unique date and time when the supply is expected to arrive at the destination organization. This timestamp is used for planning warehouse operations, labor scheduling, and stock replenishment.
TotalAvailableQuantity Decimal The unique total quantity of the item available from the supply source. This quantity helps determine whether the requested demand can be met based on real-time stock levels and procurement planning.
TotalAvailableQuantityUOMCode String The unique UOM code for the total available quantity. This code ensuring consistency in inventory tracking, unit conversion calculations, and reporting across supply chain systems.
TotalAvailableQuantityUOMName String The unique name of the UOM used for the total available quantity. This UOM maintains standardization in stock valuation, order fulfillment, and inventory movement analysis.
ShipModeOfTransport String The unique mode of transport used for shipping the supply (for example, 'Air', 'Sea', 'Rail', or 'Truck'). This selection impacts delivery speed, transportation cost, and route optimization.
ShipClassOfService String The unique classification of the shipping service. This classification defines priority levels (for example, 'Standard', 'Expedited', or 'Overnight') and any special handling requirements associated with the shipment.
CarrierId Long The unique identifier for the shipping carrier responsible for transporting the supply. This identifier is used to track shipments, manage logistics providers, and coordinate deliveries.
CarrierCode String A unique alphanumeric code representing the carrier. This code allows businesses to efficiently reference logistics providers within transportation management systems.
RetrieveAvailableOnhandQuantityFlag Bool A unique flag indicating whether on-hand inventory availability should be retrieved before considering external supply sources. Enabling this flag helps businesses optimize inventory usage and reduce unnecessary procurement.
RetrieveAllSupplySourcesFlag Bool A unique flag specifying whether all potential supply sources should be retrieved. Enabling this flag allows businesses to explore a broader range of fulfillment options for enhanced supply chain flexibility.
ApplicationCode String A unique code identifying the application processing the supply source request. This code ensures proper integration with inventory, procurement, and enterprise resource planning (ERP) systems.
DestinationType String The unique classification of the destination type. This classification indicates whether the supply is being directed to a warehouse, production facility, retail location, or customer site for fulfillment.
MessageCode String A unique system-generated code providing information about the supply source request. This code is used for logging errors, warnings, or confirmations in procurement workflows and order processing.
MessageText String The unique descriptive text explaining the system-generated message. This descriptive text provides actionable insights into supply sourcing, fulfillment issues, or confirmation of successful transactions.
ShippingMethod String The unique shipping method selected for delivering the supply, such as 'Ground', 'Freight', or 'Courier'. This choice affects transportation timelines, logistics costs, and shipment handling requirements.
Finder String The unique searchable reference used to quickly locate specific supply source records within the system. This feature improves operational efficiency in procurement, fulfillment, and logistics management by enabling rapid data retrieval based on key attributes.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434