Ticket Status Updates
When we import data into Travel Analytics, we automatically correct the ticket status based on the following:
Ticket Type = TICKET ISSUE
- If invoiced amount (amount paid) is > 0 then ticket status = Normal
- If invoiced amount (amount paid) is = 0 then ticket status = Exchange Ticket
- If invoiced amount (amount paid) is < 0 then ticket status = Refund
Ticket Type = EMD
- If invoiced amount (amount paid) is > 0 then ticket status = Normal
- If invoiced amount (amount paid) is = 0 then ticket status = Normal
- If invoiced amount (amount paid) is < 0 then ticket status = Refund
Ticket Type = ACM
- If invoiced amount (amount paid) is > 0 then ticket status = Normal
- If invoiced amount (amount paid) is = 0 then ticket status = Normal
- If invoiced amount (amount paid) is < 0 then ticket status = Refund
Ticket Type = REFUND
- If invoiced amount (amount paid) is > 0 then ticket status = Additional Collection
- If invoiced amount (amount paid) is = 0 then ticket status = Additional Collection
- If invoiced amount (amount paid) is < 0 then ticket status = Refund
Ticket Type = TICKET EXCHANGE
- If invoiced amount (amount paid) is > 0 then ticket status = Exchange Ticket
- If invoiced amount (amount paid) is = 0 then ticket status = Exchange Ticket
- If invoiced amount (amount paid) is < 0 then ticket status = Refund
Ticket Type = VOID
- If invoiced amount (amount paid) is > 0 then ticket status = Void
- If invoiced amount (amount paid) is = 0 then ticket status = Void
- If invoiced amount (amount paid) is < 0 then ticket status = Void
Ticket Type = NULL (or Blank)
- If invoiced amount (amount paid) is > 0 then ticket status = Normal
- If invoiced amount (amount paid) is = 0 then ticket status = Exchange Ticket
- If invoiced amount (amount paid) is < 0 then ticket status = Refund