Anyone know how / when / by what method the premium values in T_ACK_EXT are updated?
I see TP_ORDER_CONT_ACK, which adds the rows to the mirror table, TM_ACK_EXT. But when they are inserted in that proc, all 10 of the premium columns + the goods_services_value column are set to NULL (from what I can tell).
Then I see AP_MOVE_FROM_MIRROR, which takes the rows out of TM_ACK_EXT and stuffs them into T_ACK_EXT. But the premium fields don't seem to be updated in there either.
And I don't see any triggers on T_ACK_EXT.
Thanks!
Frannie