Sales Order Dim

Sales Order Dim ================ This dimension represents sales order information extracted from the Sales Order source. It includes key attributes such as the order number, origin, type, important dates, currency, involved personnel, and status flags. The purpose is to provide a comprehensive and clean view of sales order data for reporting and analysis in the data warehouse.

Output Column	Database Logic	Description
Sales Order	Sales order number in the source system	This is the unique identifier for each sales order, trimmed of any extra spaces to maintain consistency.
Origin	Sales order origin code	Shows where the sales order originated, such as the channel or system, with formatting trimmed to ensure data cleanliness.
Sales Order Type	Type classification of the sales order	The sales order type indicates the category or classification of the order, helping to differentiate order kinds in analysis.
Order Datetime	Datetime when the order was placed	The exact date and time the sales order was created, providing a timeline for sales activities.
Planned Delivery Datetime	Scheduled delivery datetime for the order	The planned date and time scheduled for delivering the items related to the sales order.
Order Currency	Currency code in which order was placed	Specifies the currency used for the order transaction, ensuring clarity in financial reporting.
Internal Sales Representative	Internal employee responsible for the sale	The internal sales person accountable for managing and processing the sales order.
Planned Receipt Datetime	Scheduled receipt datetime for the order	The planned date and time when the order items are expected to be received internally.
Carrier/LSP	Carrier or Logistics Service Provider handling delivery	The logistics partner or carrier responsible for delivering the order.
Delivery Terms	Terms specified for order delivery	Defines the agreed-upon conditions under which the products will be delivered.
Customer Order	Customer-referenced order number	The order number as referenced by the customer, useful for cross-referencing.
Contract	Contract identifier related to the sale	Relates the sales order to any underlying contractual agreements.
Project	Project associated with the order	Indicates if the order is tied to a specific project or initiative.
Deleted	Flag indicating if the sales order is deleted	Shows whether the sales order has been marked as deleted or is still active.
Sales Order Key	Unique key identifying the sales order record	A unique internal key used to identify and reference the sales order record.
Last Modified Datetime	Timestamp of last modification to the order	Date and time when the sales order data was last updated.
Employee Key	Identifier for employee related to the sales order	Links to the employee associated with the sales order, potentially the creator or handler.
External Sales Rep	External sales representative identifier	Identifies the external sales representative involved with the sales order.