When a line item is entered it is assigned an SKOELineItem record number.  To get the file in the order it was entered you would sort on the SKOELineItem field.

SKOELIneItem does not take into account when a line item is "inserted" on a sales order after the fact.  BW orders line items somehow on invoices and sales orders... but there does not seem to be a simple way to do this outside of BW.

SKOELIneItem does not take into account when a line item is "inserted" on a sales order after the fact.  BW orders line items somehow on invoices and sales orders... but there does not seem to be a simple way to do this outside of BW.

The SKOELineitem will take into account when a line is inserted after the fact.  When you insert a line item on an order after it has been saved it removes the existing SKOELineitem records and writes new ones.  So if you have part A, B and C as line items and they were entered in that order then it would assign say SKOELineitem 291 to part A, 292 to part B and 293 to part C.

Then if you save the order and go back in and insert part D in between part A and B and save it. It will remove SKOELineitem 291, 292 and 293 and assign 294 to part A, 295 to part C, 296 to part B and 297 to part C.  It will always be in the order entered.

When I delete a row in a order, it remain in the sage db.

If i made a select with sql i see in oelineitem the new rows and the deleted rows.