Long back story, however, I need to be able to track back and uncover the fare that was booked on a number of Delta tickets. I have confirmation #s , ticket #s and fare details. I'm thinking Fare Details are the only piece of data needed to specify the actual fare class that was purchased (?).
For example: the below is a $671 one-way flight to DTW from LAG June 2019. What from this string can I interpret what class was purchased?
Fare Details: NYC DL X/DTT DL SAN602.79KA0VA0FJ USD602.79END ZP LGADTW XF LGA4.5DTW4.5

Here is another example: this is a nearly $1400 RT SAN/ATL July 2019
Fare Details: SAN DL ATL458.61UAUQA0FB DL SAN798.14BA0PA0FL USD1256.75END ZP SANATL XF SAN4.5ATL4.5

Is there anything else on a trip confirmation email from Delta that I could look at in order to confirm this? Of course I don't believe the seat numbers that are showing as these could be easily adjusted. I realize things were different a year ago but these prices for economy class seem outrageous. I have plenty more examples if they would help!

Thanks in advance!

All the information you need is right there in the Fare Details string.

Fare KA0VA0FJ - the seventh character in this fare code means First Class F-Upsell fare

Fare UAUQA0FB and BA0PA0FL - the seventh character in these two codes means First Class F-Upsell fare

Reference:
https://pro.delta.com/content/agency...structure.html

While the second to last letter in fare basis codes tells you these are all First Class fares, it doesn't tell you the actual booking class if that is what you want to know. KA0VA0FJ fares book into 'I' booking class. UAUQA0FB fares book into 'Z' booking class. And BA0PA0FL fares book into 'C' booking class. There is a dual-inventory check made when selling these fares. There must both be inventory in the coach bucket indicated by the first letter of the fare basis code, as well as inventory in the booking class bucket for the fare. Basic Economy and Comfort+ fares work the same way. So when a particular coach bucket zeros out, the BE, C+, and FC fares automatically also increment to higher fares along with the main cabin coach fares. So if a flight has inventory in 'Z' FC bucket, but no inventory in the coach 'U' bucket, you won't be able to buy the UAUQA0FB fare on it. At any rate, while DL uses the term 'upsell' fares and the fare basis codes start with coach class letters, these are all considered true FC fares and not coach fares as indicated by second to last letter in fare basis code.

This sounds like a business auditing tickets. As such it should be noted that if the employee paid to upfare to F the last ticket will show the full price of the ticket, not necessarily what the company paid.

If OP paid to upfare after purchase, presumably OP would have original receipts with original coach fares listed. Not exactly clear why OP seems to think these are coach fares (is it because of the fare basis codes?). If the Fare Details section is coming from the Delta email receipt, the main itin section of the receipt should list class of service booked along with booking class for each flight -- First Class (I), First Class (Z), and First Class (C).

Makes sense... but if the itinerary/receipt provided includes the F code within Fare Details, that would indicate that First was actually purchased correct? And yes, similar to business auditing tickets that were submitted... it's all about digging into whether someone is falsifying documentation related to business travel yet not smart enough to change more than just the seat numbers included on the Delta confirmation.

I think these are coach fares as that is what the flyer submitted these as.... some portions of the Delta receipt have been modified.

If the company paid for a economy ticket and flier paid to upgrade then a new ticket is issued. The original ticket paid by company is simply used as a credit for the new one. They should only be claiming a portion of what is shown if that is the case.

The fares you list are first class fares. If they're claiming the total fare listed is a coach fare, they're lying.

These are what used to be called UP-fares. Basically as noted above in another post, they used to be economy tickets with an instant upgrade to F if the correct F fare class was available. However over two years ago DL did away with the nonsense of calling them economy fares that allow you to sit in F. These are straight up F fares. The fare starts with an economy fare class(K in your case), but the F towards end denote that this is really a First Class fare. Basically these fares require availability of both the economy fare class (K) and the corresponding First fare class (CIDZ). This basically allows DL to tie the price of a First class seat to the availability of the economy cabin
. The higher the fare in economy available, the higher the fare for First. (In most cases anyway)

Note that it can be the case (not frequently) that the available F fare is lower than economy. This is rare due to the way most F fares are setup nowadays. (As I described right above)

Appreciate all the input on this -- now I'll let my attorney take over from here!

Bumping this as I'm in a similar predicament to look for a fare basis. This is all I see on the receipt


NONEND/REFISSEAGY/L-973E/APZX

Fare Details: LAX DL X/ATL DL SCL250.75DL X/ATL DL LAX250.75NUC501.50END ROE1.00 XFLAX4.5ATL4.5ATL4.5

You seem to have a RT fare from LAX to SCL with a connection in ATL in each direction. The basic fare is $250.75 each way, for a total fare of $501.50.

My guess is that the fare code is XFLAX, which would be X class, but it looks too short. The NUC also doesn't look like a fare code, and N class should be coach award class, but this isn't an award ticket. I'm guessing that the 4.5ATL stuff is some sort of airport fee or tax. ROE1.00 could also be some fee or tax. The puzzle is that NUC appears where I would expect to find the fare code.

NONEND means that the ticket cannot be endorsed over to another carrier.

I'm sure that someone who's more of an expert than I am will be along soon.

The fare basis codes are missing (they should come right after fare amounts if you look at the above examples), so it's difficult to make heads or tails out this. The "XF" is supposed to have a space after it and is the two-letter code for the Passenger Facility Charge (PFC) which are $4.50 for LAX and ATL. The "X" has nothing to do with the fare class.

This appears to be some type of special ticket. Note its marked to refund issuing agency and appears to have some type of certificate/discount/whatever code applied.

What specifispecifically are you looking to know.

Is the above a cut/paste from an email from Delta Air Lines, or was this ticket purchased from a travel agency of some kind?

I'm guessing it was this fare -- [PREM FARE GONE] DL: LAX to SCL in J from $695
EF shows a short-lived Z fare available around 1/22 with fare basis code ZNNJ3SDZ. EF no longer has the fare rules.