Database Backorder Fields

[T.J]

Hi,

Does any one know how actinic stores the backorder values in the database? Trying to create an access query that compares this number to the stock in hand and hopfully automate part of the backorder proccess.

Thanks in advance
Liam

[cdicken]

The relevant fields are...

sBackOrderNumber - Order number of the back-order containing the back-ordered lines. Default: null.

nParentSequenceNumber - The OrderSequenceNumber of the parent order for a back-order. Default: zero.

nTotalItemsBackOrdered - The total number of items back-ordered in all lines for this order. Default: zero.

These are all in the 'Order' table.