Import Order
The tables have dependencies between them. Import in this order to avoid validation errors.
Step-by-step sequence
1. Country/Region (run "Setup AIR Regions" action after import)
2. Items (needed by Item Mapping and Posting Setup)
3. G/L Accounts (standard BC — needed by Posting Setup, Commission Codes, AIR Setup)
4. No. Series (standard BC — needed by AIR Setup voucher number series)
5. Gen. Business Posting Groups (standard BC — needed by Posting Setup)
6. Vendors (with travel-specific fields)
7. Customers (with travel-specific fields)
8. Salesperson/Purchaser (with Old Code field if applicable)
9. AIR Destination (large table, ~16,000 rows)
10. AIR Commission Code (references G/L Accounts)
11. AIR Setup (references Items, Customers, Salespersons, No. Series, G/L Accounts)
12. AIR Posting Setup (references Gen. Bus. Posting Groups, G/L Accounts)
13. AIR Order Item Mapping (references Items)
Dependency diagram
| Table | Depends on |
|---|---|
| Country/Region (AIR Region field) | — (no dependencies) |
| Item (custom fields) | — (no dependencies) |
| Vendor (custom fields) | — (no dependencies) |
| Customer (custom fields) | — (no dependencies) |
| Salesperson (Old Code) | — (no dependencies) |
| AIR Destination | Country/Region |
| AIR Commission Code | G/L Account |
| AIR Setup | Item, Customer, Salesperson/Purchaser, No. Series, G/L Account |
| AIR Posting Setup | Gen. Business Posting Group, G/L Account |
| AIR Order Item Mapping | Item |
Notes
- Country/Region: After importing, open the Countries/Regions page and use the "Setup AIR Regions" action to auto-classify all countries. This sets the AIR Region field based on built-in rules (Sweden = Domestic, DK/FI = Nordic, NO/IS = Nordic Non-EU, etc.). You can also set these manually per country.
- AIR Destination: This is a large dataset (~16,000 IATA/Protas codes). It is typically provided as a CSV and imported via config package or RapidStart. The same dataset is used across all customers.
- Standard BC tables (G/L Accounts, No. Series, Gen. Bus. Posting Groups) are assumed to already exist from the base BC setup. They are listed here only to clarify dependencies.