logoChat01.ai

ACT AS AN EXPERT JDE and IATA Standard fuel invoic...

Created on: June 23, 2025

Answered using O3 by Chat01

Question

ACT AS AN EXPERT JDE and IATA Standard fuel invoice xml.
the attach xml is generated using jde database data, but the customer system rejected the file due to UOM "GA"(Gallon) in the xml (from JDE F4211 UOM field) not valid in the IATA, what is the equivalent to "GA" Gallon in IATA Standard fuel invoice xml

Thought

Mapping IATA codes for fuel invoices

In the context of the IATA XML Fuel Invoice, the UOM field uses codes based on Section E of UN/ECE Rec 20. The JD Edwards (JDE) code "GA" should be mapped to "GLL" for US gallon. If using imperial gallon (UK), the code "GLI" or similar might be considered, but the majority in aviation fueling still uses US gallons (e.g., Jet A1 fueling in the US). For other cases, liters may apply.

Thought for 1m 36s

Answer

In the IATA Aviation Fuel Invoice XML (IS-XML) the unit-of-measure field must take one of the three-character codes published in Section E (UOM) of the IATA Code Directory.
These codes mirror the UN/CEFACT Recommendation 20 list, which is why your customer’s validator rejected the two-character “GA” that comes out of JDE.

Quantity you are expressingCorrect IATA UOM codeNotes
Gallon (US liquid)GLLStandard volume unit for fuelling in the Americas and most airlines that trade in US gal. docs.peppol.eu
Gallon (UK / Imperial)GLIRarely used for jet-fuel invoices; be sure both parties expect an Imperial gallon. docs.peppol.eu
Barrel (42 US gal)BRLIf your contract prices in barrels, switch to this code (not to be confused with “BBL”). docs.peppol.eu
LitreLTRPreferred outside the US; keep DensityInformation in the XML if you convert.

What to change in your XML

  1. In every element that carries a volume Quantity or Pricing UOM (e.g., ItemQuantityUOM, ItemPricingUOM, SubTaxPricingUOM, etc.) replace GA with GLL.
  2. Do not change the numeric quantity—only the code.
  3. Re-validate against the IATA Fuel Invoice XSD; the file should now pass.

Why “GLL”?

  • IATA adopted the UN/ECE three-letter codes to avoid ambiguity (there are several different “gallon” definitions worldwide).
  • “GLL” is explicitly defined in the code list as “gallon (US)”. docs.peppol.eu

With that substitution your customer’s system will recognise the unit, and no other structural changes are required.

Share this Q&A