| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|
Sales Order Bookings have many status and important data changes. These need to be recorded, displayed to the user and be reportable, so that the historical journey can be analysed.
dt= datetime
op = operator (user)
...
State
...
Action
...
Record
...
These values will need to be recorded for each row
Datetime
Operator (user or automated process)
Status prior to event
Status after event
Date | Operator | Action | Status Before | Status After | Values |
|---|---|---|---|---|---|
12/12/2022 18:31 | James | Sales Order Details Saved |
New | New Status | Final Mile |
Facility, Scheduled Dispatch |
12/12/2022 18:31 | Lauren | Sales Order Sent To Warehouse |
New | New Status | Final Mile |
Facility, Scheduled Dispatch | |||
12/12/2022 18:31 | Katie | Dispatch Details Saved | Sales Order Sent |
Dispatch Details Saved
New Status | Packaging Info, Delivery, ETA Success/Failure + Reason | ||||
12/12/2022 18:31 | Graham | Rescind Sales Order | Sales Order Sent | New Status | Success (set to New)/Failure |
12/12/2022 18:31 | James | Rescind Sales Order |
Sales Order Sent | New Status | Success (set |
to New) |
by manual confirmation | |||||
12/12/2022 18:31 | Lauren | Dispatch Details Saved | ANY | New Status | Packaging Info, Delivery, ETA, All Costs Added |
12/12/2022 18:31 | Katie | Manual Pre-Alert Sent |
Dispatched | New Status | Packaging Info, Delivery, ETA, All Costs Added | |||
12/12/2022 18:31 | Graham | Pre-Alert Resent | ANY | New Status | Packaging Info, Delivery, ETA, All Costs Added |
12/12/2022 18:31 | James | Booking Confirmation Sent | ANY | New Status | email recipients |
12/12/2022 18:31 | Lauren | Purchase Order Sent | ANY | New Status | email recipients |
12/12/2022 18:31 | Katie | Booking Confirmation Received |
dt, op
ANY | New Status | Receipt Success/failure ( | |
12/12/2022 18:31 | Graham | Work Complete option clicked |
Work Scheduled | New Status | Work Complete options | |
12/12/2022 18:31 | James | Revised Purchase Order Sent | Work Complete |
Revised PO Sent
dt, po
Any
Closed
dt, po
Any
Cancelled
dt, po
New Status | email recipients | ||||
12/12/2022 18:31 | Lauren | Closed | ANY | New Status |
|
12/12/2022 18:31 | Katie | Cancelled | ANY | New Status |
|
12/12/2022 18:31 | Graham | Add/Amend/Delete |
Cost Line | New Status | Values | |||
12/12/2022 18:31 | James | Picked Notification Received | ANY | New Status | |
12/12/2022 18:31 | Lauren | Dispatch Notification Received | ANY | New Status | |
12/12/2022 18:31 | Katie | New Booking Received | ANY | New Status | |
12/12/2022 18:31 | Graham | Updated Booking Received | ANY | New Status | Any Fields changed (if possible) |
12/12/2022 18:31 | James | Restored from Archive | ANY | ANY |