|
Posted by Rob on March 27, 2006, 12:33 pm
Please log in for more thread options
[Order] and OrderEntry tables, the same as WorkOrders and Layaways. It is
the [Order].Type that determines that if it is a BackOrder or not.
Order.Type
2: Work Order
3: Quote
4: Back Order
5: Layaway
Rob
> Does anyone know where the backorder information is stored in the SQL
> database? I have a custom intranet designed around RMS, one area that
> shows
> the customer purchase history for each customer. It would be nice to show
> the backorders each customer has also. I know it can be looked up directly
> in RMS, but not every computer has RMS installed, but all computers can
> get
> on the intranet.
>
> Thanks,
> Nick
>
>
>
|