Here is what i'm trying to do.

We do pulls 4 times a day on the mom foxpro databases.

We do one pull that checks for orders shipped. Another that gets inventory levels.

We need to add a third on that checks for backorders.

My Question for you guys is where is this stored if an order goes to back order? I'm guessing part of it is in the Box or CMS table. But I'm sure there is one more to get items that are back ordered.

I'm guessing in the box table Status = N and Auxstatus = B would mean back order but i want to confirm this.

Any have any ideas on this?

Thanks