Announcement

Collapse
No announcement yet.

Order Status Database Field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Order Status Database Field

    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

    #2
    It probably means normal, which really means not shipped or cancelled.
    Bob Ladden

    Comment


      #3
      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,
      Jan Strassen, Mole End

      Comment

      Working...
      X