Reservations : Reservation status codes
 
Reservation status codes
 
You can use Helper utility to view reservation status codes (resrvatn.res_status). The status codes and their meanings are as shown in the following table. Information about using Helper utility can be found in the Salesware User Guide for Advanced Users.
 
res_status
Description
0
Undefined
1
Live
5
No show
10
Items finalized
15
Cancelled with forfeit
20
Cancelled with refund
25
Pending
100
Reservation finalized
 
Notes:
If any items in the sale are un-finalized, the status is live. (Not everything has been finalized.)
If all items in the sale have been finalized, the status is reservation finalized. Reservation finalized means that the whole sale went through and no items were cancelled.
If any items in the sale have been finalized, the status is items finalized. Items finalized means that some items have been finalized, but there was at least one cancellation.
If any items are no shows, the status is no show.
If any items are forfeited, the status is cancelled with forfeit (and if all items are cancelled). Cancelled with forfeit means that all items were cancelled in some way.
If any items are refunded, the status is cancelled with refund (if all items are cancelled and none are forfeited). Cancelled with refund means that all items were cancelled in some way.
Otherwise, the status is pending.
 
Examples:
A sale contains a finalized line item, an un-finalized line item and a forfeit. Status=live.
A sale contains a no-show and a forfeit. Status= no show.
A sale contains a finalized item and a forfeit. Status=items finalized.
A sale contains a refund and a forfeit. Status=cancelled with forfeit.
A sale contains two refunds. Status=cancelled with refund.
A sale contains four finalized line items. Status=reservation finalized.