Number/Letter values in Actinic Access Database status fields

[Ian Clyde]

Hi,

Slightly strange question, within the Actinic Access Database there is a table called 'Order' and two fields are 'Status' and 'nPaymentStatus' fileds with varous indicator values used in each field (i.e. nPaymentStatus uses 0,6,4,9, 10 or 11). Does anyone out there know about these values and what they represent? I have asked Actinic support but a little oddly they claim they don't know.

I'm trying to create my own reports on order values/quantities by month/year etc so equally if there are any other solutions out there could someone please advise?

Many thanks....

Ian.

[malbro]

Hi,

Slightly strange question, within the Actinic Access Database there is a table called 'Order' and two fields are 'Status' and 'nPaymentStatus' fileds with varous indicator values used in each field (i.e. nPaymentStatus uses 0,6,4,9, 10 or 11). Does anyone out there know about these values and what they represent? I have asked Actinic support but a little oddly they claim they don't know.

I'm trying to create my own reports on order values/quantities by month/year etc so equally if there are any other solutions out there could someone please advise?

Many thanks....

Ian.

nPaymentstatus
0 - OCC pending
4 - Pre Authorised
6 - Pending
10 - Full Payment
11 - Excess Payment

Status
N=Normal
F=Finished
S=Shipped

[Duncan Rounding]

nPayment Status:

Enumeration detailing payment status
0 – OCC Pending
1 – Accepted/Rec’d
2 – Rejected
3 – Error
4 – Pre-Authorised
5 – Waiting for CC details
6 – Pending
8 – Test mode
9 – Partial PaymentReceived.
10 – Full Payment Received
11 - Excess Paymrnt Received.
12 – Payment Sent
Default: 0

-------------
Status:

Status of record
N = normal
F = finished
S = shipped
Default: N

EDIT: Snap - Posted together Malcolm!

[Ian Clyde]

Thanks!

Duncan/Malcom,

My thanks to both of you...great stuff!

Ian.

[malbro]

EDIT: Snap - Posted together Malcolm!

Took you as long as me to find the documents then

[Jan]

Actinic can supply a document with database definations, it might be worth getting hold of a copy just in case you need to know more in the future.

Regards,

[malbro]

Actinic can supply a document with database definations, it might be worth getting hold of a copy just in case you need to know more in the future.

Regards,

But does support know that !!

I have asked Actinic support but a little oddly they claim they don't know.

[Jan]

I have a similar conversation going on with support at the moment as well, they refuse to support something because it's a plugin but actually it's part of the standard software - customers been held up by 2 months now because of this, I think that there might be a new person on board.

Regards,