Order Status Database Field

[T.J]

Hi all,

Just a quick question..... In the "OrderDetail" table there is a field called "status", does the directly relate to the line status? For example, shipped, cancelled, back ordered etc.

As far as i can work out the status codes are:

F - Line shipped
C - Line cancled
N - No idea?!?

Many Thanks
Liam

[rmladden]

It probably means normal, which really means not shipped or cancelled.

[Jan]

The orderlines have a status and the order also has a status

Order :

N = Normal
F = Complete
S = Shipped

Order Detail :

N = Normal
S = Shipped
C = Cancelled
F = Finished

Order status is also affected by the flag called bOrderIsDeleted (in the order table), if this is true then the order has been marked for deletion.

Regards,