Customer.OrderStatus

Purpose

The Customer Order Status view provides comprehensive insights into the operational state of customer orders. By tracking statuses, user actions, error messages, and lifecycle changes, it enables monitoring and reporting on the order lifecycle. This view is essential for identifying and addressing operational issues or errors that may impact order processing.

Use Case

Owner: Soon Tan
Typical Use Case: Ideal for applications and dashboards that require real-time tracking of order statuses, error identification, and detailed reporting on order lifecycle changes.
Style: Fact, Each row represents an Order with associated status, user action details, and timestamps.

This Customer Order Status view supports operational reporting by enabling teams to monitor order progression, detect issues, and take corrective actions promptly. The JSON-formatted sequence and user details enhance compatibility with reporting systems, ensuring structured and detailed data for operational insights.

Source

QFACT_CUSTOMER_ORDER_HISTO_OL$

Join Table: ifs.QFACT_CUSTOMER_ORDER_CFV_OL$ for enriching order details.

Key Parameters

Company
Details

Sample Exec

EXEC get.myView @dataMart = 'Customer', @viewName = 'OrderStatus', @token = '<myToken>', @version = '<202404>'

Response

Identifiers

• COMPANY: Company associated with the order.
• ORDER_NO: Unique identifier for the customer order.

SEQ

ORDER_SEQ (JSON Format): Structured sequence for order tracking, including:

• COMPANY: Company identifier.
• ORDER_NO: Order number.

Status

• HIST_STATE: Operational state of the order, reflecting its current or previous lifecycle stage.Dates
• DATE_ENTERED: The date the status or action was recorded.
• HISTORY_NO: History sequence number, providing chronological tracking of order changes.

User and Actions (JSON format)

• MESSAGE_TEXT: Additional message or error description associated with the action.
• TIME_ENTERED: Timestamp of when the status or action was recorded.
• USER_ID: Identifier of the user who performed the action.

SQL

To access the full SQL structure, refer to…

BMT-DWH-DEV/Customer_OrderStatus.sql