previous

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