Defining Change Order and Sequence Numbers

A change order number identifies the batch of changes that you submit to the supplier for a purchase order after its initial dispatch. The first time that you update a dispatched purchase order, the system displays Change Order 1 next to the purchase order number in the purchase order header. Each time you update the purchase order after dispatching a batch of changes to the supplier, the change order number is increased by one.

A change sequence number tracks the sequence of changes made within each purchase order at the header, line, and schedule levels. After the initial dispatch of a purchase order, a change sequence number is assigned to each change. These sequence numbers don't appear on the purchase order, but appear in the purchase order history.

Example

Here is an example of batch changes:

1. You dispatch a purchase order containing three lines.

2. You create a change on line 1.

   The header change order batch number is set to 1; the change sequence number for the first line is also 1.

   Note:

   A historical row is created to store original values for line 1. The header change order batch number is 0 and change sequence number for the first line is 0.

3. After you dispatch the first batch of changes (change order batch number 1), you change lines 1 and 3.

   • The change order batch number is 2, because you are making changes after dispatching change order number 1.

   • Because this is the second time that you have changed line 1, its change sequence is 2.

   • Because you have changed line 3 for the first time, its change sequence is 1.

     Note:

     The system creates a historical row to store original values for line 3. The header change order batch number is 0 and the change sequence number for the first line is 0.

This diagram illustrates how the PO_CHNG_LINE table helps track the batch and sequence changes discussed in the example:

Similar changes are stored in PO_CHNG_HDR, PO_CHNG_SHIP, and PO_CHNG_ADDR tables when changes are made to header, schedule, and one time address fields that are eligible for change order tracking.