PSP Pending Database Question

[fife]

Which field in the Actinic database dictates if an order shows up in the "PSP Pending" tab? In other words, what column and in that column, what value indicates a "PSP Pending" order?

I'm trying to do some reporting on the backend and do not want the orders that appear in this tab to show in the report.

Thanks in advance for your help.

Jeremy

[Jan]

I think that this is payment type = 0.

Regards,

[fife]

Thanks Jan. That helps me out immensely. Also, in another post that you wrote last year you stated the following definitions for values in the Status Field in the Actinic Database:

-----------------------------------------------------------------
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.
-----------------------------------------------------------------
This helps me out however, what does "Normal", "Shipped" and "Finished" mean? We have a LOT of orders that have shipped, yet they are still marked "Finished" or sometimes "Normal". What does all this mean? Is there a resource that defines this for us? I've looked everywhere and cannot find any help.

Thanks,

Jeremy

[Bruce]

Hi Jeremy,

'Normal' means not complete and 'Finished' means complete. If you check the 'N' ones you might find the odd missing payment / excess payment received or something similar that has prevented the order from being completed.

Kind regards,