Order-to-Cash Process
Overview
End-to-end order fulfillment and payment collection process. This dataset covers the full lifecycle from sales order creation through delivery, invoicing, and payment.
Download: order-to-cash.csv (54 MB)
Dataset Summary
| Metric | Value |
|---|---|
| Events | 88,924 |
| File Size | 54 MB |
| Process Type | Order Fulfillment and Payment |
Columns
| Column | Description |
|---|---|
| CaseId | Unique order line identifier |
| ActivityName | Order processing step (e.g., CreateSalesOrder) |
| ActivityTime | Timestamp of the activity |
| Resource | Person or system performing the activity |
| SalesOrderId | Sales order number |
| Currency | Transaction currency |
| ItemName | Ordered item |
| Quantity | Ordered quantity |
| TotalLineValue | Line item value |
| Customer | Customer name |
| CustomerLocation | Customer country |
| DeliveryAddress | Shipping destination |
| Plant | Fulfillment plant |
| CompanyCode | Company code |
| OrderStatus | Current order status |
| Has Release Credit Block | Credit block flag |
| Has Release Delivery Block | Delivery block flag |
| Has Release Billing Block | Billing block flag |
| Created By | User who created the order |
| Shipment Date | Scheduled shipment date |
| InvoiceType | Type of invoice |
| InvoiceAmount | Invoice value |
| InvoiceDate | Invoice date |
Suggested Analyses
- Process Map: Visualize the order-to-cash flow from creation to payment
- Block Analysis: Filter by credit, delivery, or billing blocks to understand delays
- Cycle Time: Measure order-to-invoice and order-to-delivery durations
- Plant Performance: Compare fulfillment efficiency across plants
- Currency Analysis: Analyze order patterns by currency and customer location
This documentation is part of the mindzie Studio process mining platform.