Buy From Supplier Dim

Created by Robert Cross, Modified on Wed, 9 Jul, 2025 at 7:50 AM by Robert Cross

Buy From Supplier Dim

This dimension captures key information about suppliers from whom purchases are made in the Infor Birst data warehouse. It consolidates unique identifiers, codes, names, statuses, types, deletion flags, and timestamps for last modifications related to each 'Buy From Supplier' entity. This allows users to analyze and report on supplier-related activities effectively.

Output Column	Database Logic	Description
Buy From Supplier Key	Unique identifier for each supplier from whom the company purchases goods or services.	This is the unique key assigned to each supplier, allowing precise identification of the source from which purchases are made.
Buy From Supplier Code	Code designated to each supplier for easier reference and tracking in procurement processes.	This code simplifies supplier identification and tracking across various business systems and reports.
Buy From Supplier Name	Name of the supplier entity from which the company procures goods or services.	The registered name of the supplier, important for recognition and validation in procurement and reporting.
Buy From Status	Status indicator reflecting whether the supplier is active, inactive, or on hold.	This status helps determine if a supplier is currently available for making purchases or transactions.
Buy From Type	Classification type of the supplier based on predefined categories within the procurement system.	Categorizes suppliers by type, aiding in segmentation and analysis for procurement strategies.
Deleted	Flag indicating whether the supplier record has been marked as deleted in the system.	Shows if a supplier record is active or has been removed, helping maintain data integrity and historical context.
Last Modified Datetime	Timestamp indicating the last time the supplier record was updated in the database.	Records when the supplier information was last changed, supporting data accuracy and audit tracking.