The default value for the column IsApproved on C_Order, C_Invoice and C_CashPlan is defined as @IsApproved@ - at the moment this is harmless, but it’s misleading as in principle is just copying into new records the value of the IsApproved flag from the current record. So, if you’re looking an order that is approved and creates a new order, the flag is set to Y, which is wrong because the order is in draft and has not been approved.

The default for these columns must be N