Skip to main content

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. Unit of Measure         (standard BC — needed by AIR Setup field 60)
7. Gen. Product Posting Groups   (standard BC — needed by AIR Setup field 61)
8. VAT Product Posting Groups    (standard BC — needed by AIR Setup field 62)
9. Vendors                 (with travel-specific fields)
10. Customers              (with travel-specific fields)
11. Salesperson/Purchaser  (with Old Code field if applicable)
12. AIR Destination        (large table, ~16,000 rows)
13. AIR Commission Code    (references G/L Accounts)
14. AIR Setup              (references Items, Customers, Salespersons, No. Series,
                            G/L Accounts, Unit of Measure, Gen./VAT Prod. Posting Groups)
15. AIR Product Posting Setup (references Gen. Bus. Posting Groups, G/L Accounts)
16. AIR Order Item Mapping (references Items)

Dependency diagram​

TableDepends 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 DestinationCountry/Region
AIR Commission CodeG/L Account
AIR SetupItem, Customer, Salesperson/Purchaser, No. Series, G/L Account, Unit of Measure, Gen. Product Posting Group, VAT Product Posting Group
AIR Product Posting SetupGen. Business Posting Group, G/L Account
AIR Order Item MappingItem

Notes​

  • Country/Region: After importing, open the Countries/Regions page and use the "Setup AIR Regions" action to auto-classify all countries. A dialog confirms the home country (pre-filled from Company Information); the home country becomes Domestic and all other countries are classified automatically (see Country/Region). 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.
  • AIR Setup item defaults: fields 60–62 (Item Default Unit of Measure / Gen. Prod. Posting Group / VAT Prod. Posting Group) have table relations to standard BC tables. Those three tables must be populated before AIR Setup is imported, or validation fails. They are typically part of the base BC setup, but on a fresh company they are worth checking explicitly — especially the unit of measure code, which differs by country (STYCK in Sweden, STK in Norway).
  • Standard BC tables (G/L Accounts, No. Series, Gen. Bus. Posting Groups, Unit of Measure, Gen./VAT Product Posting Groups) are assumed to already exist from the base BC setup. They are listed here only to clarify dependencies.