INF Export File Data Definition
The INF data export is used when the Infinium add-on license (OPP_INF) is active. The INF data export file consists of 1 record type as described below.
Note: Amounts do not include a decimal (e.g., if the commission amount is $21.75, the Actual Commission Due amount is shown as 000002175) in the Infinium export.
Position |
Length |
Description |
1 |
12 |
IATA # or if commission code not = "Z" = AREA CODE/TELEPHONE # |
13 |
30 |
Travel Agent Name |
43 |
6 |
Departure Date |
49 |
12 |
OPERA Profile ID |
61 |
30 |
Guest Name |
91 |
6 |
Guest Folio |
97 |
3 |
Active/Inactive |
100 |
1 |
List Number |
101 |
1 |
Folio Reservation Status |
102 |
1 |
"H" or "R" |
103 |
30 |
Travel Agent Address1 |
133 |
30 |
Travel Agent Address2 |
163 |
20 |
Travel Agent City |
183 |
10 |
Travel Agent Zip |
193 |
3 |
Travel Agent Country |
196 |
10 |
Travel Agent Phone # |
206 |
30 |
Travel Agent Contact Name |
236 |
2 |
Travel Agent State |
238 |
5 |
Audit Date |
243 |
5 |
Audit Date |
248 |
5 |
Number of Rooms |
253 |
5 |
Number of Guests |
258 |
6 |
Nothing gets moved into the field |
264 |
1 |
Nothing gets moved into the field |
265 |
2 |
Commission Percentage |
267 |
2 |
Commission Percentage |
269 |
2 |
Commission Percentage |
271 |
2 |
Commission Percentage |
273 |
2 |
Commission Percentage |
275 |
2 |
Commission Percentage |
277 |
2 |
Commission Percentage |
280 |
9 |
Room Rate |
290 |
9 |
Actual Rate |
300 |
9 |
Net Amount Due |
309 |
6 |
Primary Folio |
315 |
2 |
Number of Rooms |
317 |
1 |
Blank or "-" for negative |
318 |
2 |
Number of Guests |
320 |
6 |
Booking Date |
326 |
5 |
Audit Date |
331 |
6 |
Arrival Date |
337 |
2 |
Number of Nights |
339 |
10 |
Same as tap phone Agent Phone # |
349 |
5 |
Actual Number of Nights |
354 |
5 |
Expected number of Nights |
359 |
1 |
Blank or "-" for negative |
360 |
1 |
Actual Room Revenue |
369 |
9 |
Blank or "-" for negative |
370 |
9 |
Non Room Revenue |
379 |
5 |
Number of Guests in Room |
384 |
9 |
Actual Commission Due |
393 |
9 |
Deducted Amount |
402 |
1 |
Asterisk |
403 |
15 |
SSN or TIN |
418 |
13 |
OPERA Confirmation Number |
431 |
55 |
Filler |
See Also