You say to you have no other information, then you say that you do have order details... Why not adding the total amount of the order with the date? What about the customer? No customers are attached to your orders?

>No, no other information. I was thinking adding back the ID since my colleague just told me it doesn't matter, only PK field really matters for sync, but I already re-did everyting, so even though we have VSS and I can go back easily I would have to make a change back in the table.
>
>Let me figure out again if adding ID back is OK.
>
>I do have details in the OrderDetails table (the items with the price).