AIR Destination (Table 51305)
The AIR Destination table contains approximately 16,000 destination codes mapped to countries and cities. These codes are used to identify locations in hotel, car rental, and ground transport bookings, and to determine the correct region for item mapping.
Page
Accessible via AIR Destinations page (search for "AIR Destinations" in Business Central). Due to the large volume (~16,000 rows), this table should be imported via config package or RapidStart rather than entered manually.
Field Reference
| Field ID | Field Name | Data Type | Description |
|---|---|---|---|
| 1 | Destination Code | Code[10] | Primary key — the IATA or Protas destination code (e.g., "STO" for Stockholm, "LON" for London) |
| 2 | Country Code | Code[2] | ISO 3166-1 alpha-2 country code. Must reference an existing Country/Region record |
| 3 | Country Name | Text[50] | Human-readable country name |
| 4 | Destination Name | Text[100] | Human-readable destination/city name. This value appears on invoices |
| 5 | City Code | Code[10] | Optional grouping code for cities (~2,100 rows have this populated) |
How Destinations Are Used
- Hotel/Car Rental/Ground Transport processing: When a booking contains a destination code, the system looks it up in this table to determine the country
- Region determination: The country code is then used to look up the AIR Region on the Country/Region table, which determines the correct item mapping
- Invoice display: The Destination Name appears on the invoice as the location for hotel/car rental bookings
- Vendor matching: For hotels, the destination code is part of the Hotel Property Code composite key used for property-level vendor matching
Data Source
This is a reference data table shared across all customers. The dataset comes from IATA/Protas and is typically:
- Provided as a CSV file by Stricct
- Imported via Configuration Package or RapidStart
- Updated periodically when new destination codes are added
Config Package Notes
- This is a large import (~16,000 rows) — use RapidStart or config package import
- The Country Code field (field 2) references the Country/Region table. Make sure all Country/Region records exist before importing
- The same dataset is used for all customers — no customer-specific customization is needed
- If new destination codes are encountered during booking processing (codes not in this table), the booking is placed in the Missing Destination queue for manual resolution
CSV Import Format
If importing from CSV, the expected columns are:
Destination Code,Country Code,Country Name,Destination Name,City Code
STO,SE,Sweden,Stockholm,STO
GOT,SE,Sweden,Gothenburg,GOT
LON,GB,United Kingdom,London,LON
PAR,FR,France,Paris,PAR
Missing destination codes will cause bookings to be placed in the pending queue. Ensure the full destination dataset is imported before processing any live bookings.