Travel Agent Import
Information on the requirements for the Travel Agent Import available in RMS.
Import Information
- The file to be imported must be in a comma delimited .csv format.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
- Country names in the 'Country' field must match the RMS List of Countries.xlsx.
Field Order
Order | Field Name | Field Type | Required | Unique | Max Characters | RMS Equivalent |
---|---|---|---|---|---|---|
1 |
Agent Name |
Alpha Numeric |
Y | Y | 50 | Short Description |
2 |
Address Line 1 |
Alpha Numeric |
N |
N |
50 | Address Line 1 |
3 |
Address Line 2 |
Alpha Numeric |
N |
N |
50 | Address Line 2 |
4 |
Town/Suburb |
Alpha Numeric |
N |
N |
50 | Town/Suburb |
5 |
State |
Alpha Numeric |
N |
N |
3 | State |
6 |
Postcode |
Alpha Numeric |
N |
N |
15 | Postcode |
7 |
Phone |
Alpha Numeric |
N |
N |
15 | Phone |
8 |
Fax |
Alpha Numeric |
N |
N |
15 | Fax |
9 |
Alpha Numeric |
N |
N |
100 | ||
10 |
GL Acc Code |
Alpha Numeric |
N |
N |
50 | GL code for Commission |
11 |
Notes |
Alpha Numeric |
N |
N |
None |
|
12 |
Legacy Agent ID |
Alpha Numeric |
N |
N |
20 | Travel Agent Spare1 |
13 |
IATA |
Alpha Numeric |
N |
N |
50 |
|
14 |
Wholesaler |
Yes/No |
N |
N |
1 | 1 for Wholesaler | Blank or 0 for Travel Agent |
15 | Address Line 3 | Alpha Numeric | N | N | 20 | Address Line 3 |
16 | Trading As | Alpha Numeric | N | N | 50 | Trading As |
17 | Spare 2 |
Alpha Numeric | N | N | 50 | Spare 2 |
18 | Spare 3 | Alpha Numeric | N | N | 50 | Spare 3 |
19 | Spare 4 | Alpha Numeric | N | N | 50 | Spare 4 |
20 | Spare 5 | Alpha Numeric | N | N | 50 | Spare 5 |
21 | Credit Hold | Yes/No | N | N | 3 | |
22 | Billing Note | Alpha Numeric | N | N | No Max | |
23 | External Ref No | Alpha Numeric | N | N | N/A | |
24 | Booking Source | Alpha Numeric | N | N | N/A | |
25 | City Master | Alpha Numeric | N | N | N/A | |
26 | Hide from Guest Portal | Yes/No | N | N | N/A | |
27 | Agent Allotment | Yes/No | N | N | N/A | |
28 | Country | Alpha Numeric | N | N | N/A | RMS List of Countries.xlsx |
29 |
Status |
String |
Y |
Y |
Value = Active or Inactive |