Sold To Customer Dim

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

Sold To Customer Dim

This dimension consolidates key attributes related to customers classified as 'Sold To' within the Infor LN system. It integrates core customer identifiers, status, location, and channel information with geographic continent data to provide a comprehensive view for business analytics and decision-making.

Output Column	Database Logic	Description
Sold To Customer Code	Unique code identifying each Sold To Customer from the source Sold To Customer table.	This represents the unique identifier assigned to each customer who purchases products or services, allowing precise tracking and management.
Sold To Customer Type	Type classification of the Sold To Customer, extracted from the Sold To Customer data source.	Categorizes customers by type to help understand different segments or groups based on defined business criteria.
Sold To Customer Key	Primary key for the Sold To Customer record in the database, uniquely identifying each entry.	A unique key ensuring each customer record is distinct, supporting accurate data management and retrieval.
Sold To Customer Ranking Key	Ranking indicator key related to the customer’s business importance or priority.	This key ranks customers according to their business value or priority level, which helps in focusing sales or service efforts.
Deleted	Flag indicating whether a customer record is marked as deleted or inactive.	Indicates if the customer record is considered deleted or inactive, ensuring reports reflect current and valid data.
Last Modified Datetime	Timestamp of the last update made to the customer record.	Records when the customer information was last updated, supporting data freshness and audit tracking.
Sold To Customer Status	Current status of the customer such as active, inactive, or suspended.	Shows the operational status of the customer, helping to identify their current engagement level.
Sold To Customer Channel	Channel through which the customer typically purchases or interacts.	The business channel used by the customer to make purchases or interact with the company, useful for channel performance analysis.
Sold To Customer Name	Official name of the Sold To Customer.	The formal name of the customer, providing a clear and recognizable reference in reports and analyses.
Sold To Customer Country	Country code indicating the customer's country location.	Identifies the country in which the customer is located, enabling geographic segmentation and regional analysis.
Sold To Customer Continent	Continent associated with the Sold To Customer’s country, based on a lookup from the country-list reference.	This maps the customer's country to its continent, assisting in higher-level geographic reporting and strategic planning.
Sold To Customer City	City location of the Sold To Customer.	Specifies the customer's city to allow more granular geographic analysis and localized business insights.
Sold To Customer State	State or region where the customer is located.	Indicates the state or administrative region of the customer, further refining geographic segmentation.
Line of Business	Business segment or unit the customer is associated with.	Represents the specific business line the customer relates to, aiding in segment-specific performance monitoring.