Order Changes Log Table

I just learned today that in V15, changes to service orders are stored in the order_changes_log (Active) and c_order_changes_log (History) tables.

In previous versions of Alliance, these changes were stored in the demand (Active) and demand_done (History) tables and can be retrieved with the following queries:

select * from demand with (nolock) where demand.order_id = 'Order ID' and bpart_gcl_id = 'Mngt';


select * from demand_done with (nolock) where demand.order_id = 'Order ID' and bpart_gcl_id = 'Mngt';

For V15 and later, the Trans. Log entries can be found with the following:

select * from order_changes_log with (nolock) where order_id = 'Order ID'

select * from c_order_changes_log with (nolock) where order_id = 'Order ID'