Why doesn't D01 show 'Processed' after D02 has been created?

Question

When I create a new snapshot for my sales order e.g. D03, when I view the previous snapshots there is no status on either D01 or D02.  Why is that?

 

Answer

The status of a sales order is stored against the current snapshot of the sales order in the table SO_Main.  A new snapshot can only ever be created on a snapshot that has the status of Processed - e.g. snapshot 2 can only ever be created if snapshot 1 has the status on 'Processed'.

In the example above, snapshot 2 could only be created because snapshot 1 was 'Processed'.  Snapshot 3 could only be created because snapshot was 'Processed'.