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