ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

ProcurementApprovedSupplierListEntries

Tracks relationships between suppliers and the items or categories they’re approved to supply, ensuring compliance and vendor checks.

Columns

Name Type Description
AslId [KEY] Long The unique identifier for each entry in the approved supplier list, linking it to a specific supplier and item.
ProcurementBUId Long The unique identifier for the business unit responsible for managing and owning the approved supplier list entry.
ProcurementBU String The name of the procurement business unit that owns and manages the approved supplier list entry.
AslScopeCode String A code that identifies whether the approved supplier list entry is specific to a particular ship-to organization or applicable to all organizations served by the procurement business unit.
Scope String Indicates whether the approved supplier list entry applies to a specific ship-to organization or to all ship-to organizations associated with the procurement business unit.
ShipToOrganizationId Long The unique identifier for the inventory organization that receives the goods supplied by the supplier.
ShipToOrganization String The name of the inventory organization that should receive the items supplied by the supplier.
Item String The goods, services, or products that the business makes, purchases, or sells, including components, subassemblies, finished products, or supplies.
ItemId Long The unique identifier for the item listed in the approved supplier list entry.
Supplier String The organization or individual that provides goods or services to the buying organization under a contractual obligation.
SupplierId Long The unique identifier for the supplier fulfilling the order, distinguishing them from other suppliers.
SupplierSite String The location or entity through which the buying organization conducts business with the supplier.
SupplierSiteId Long The unique identifier for the location from which the supplier fulfills the order.
PrimaryVendorItem String The item number assigned by the supplier for the item listed on the approved supplier list.
Status String The approval status of the approved supplier list entry, indicating whether the supplier is authorized to supply the specified item or items.
AslStatusId Long The unique identifier for the status of the approved supplier list entry.
ReviewDueDate Date The date by which the approved supplier list entry should be reviewed, typically for supplier recertification or approval renewal.
DisableFlag Bool Indicates whether the approved supplier list entry is still active or has been disabled and is no longer in use.
Comments String Any additional notes or comments related to the approved supplier list entry, typically entered during review or approval.
AslCreationDate Datetime The date and time when the approved supplier list entry was created.
PurchasingUOMCode String The code representing the unit of measure used for purchase orders derived from the approved supplier list entry.
PurchasingUOM String The unit of measure used for purchase orders placed using the approved supplier list entry (for example, each, box, kg).
CountryOfOriginCode String The code representing the country from which the goods are exported by the supplier.
CountryOfOrigin String The name of the country from which the goods are exported by the supplier.
MinimumOrderQuantity Decimal The minimum quantity that must be ordered from the supplier on purchase orders originating from the approved supplier list entry.
FixedLotMultiple Decimal The incremental order quantity that must be used for purchase orders sourced from the approved supplier list entry.
Finder String The function or mechanism used to search for approved supplier list entries.
EffectiveDate Date The date used to fetch resources that are effective as of this specified start date.

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