Previous Topic

Next Topic

Generic Inhouse Resv File Data Definitions

In the Miscellaneous>File Export>General or Configuration>External>Export Files, select the Generic Inhouse Resv export to view information about the guests reservation, such as the first and last name of the guest, arrival and departure date, room number of the reservation, and revenue buckets 11-15 amounts.

File Header

FILE_GROUP_ID

FILE_TYPE_DESC

FILE_NAME

FILE_EXTENSION

MISC

General Inhouse Resv Export

'INH'||(SUBSTR(PROPERTY_CODE,1,5))

'TXT'

File Details

COL_NAME

COL_LENGTH

COL_TYPE

FORMULA

GUEST_FIRST_NAME

20

VARCHAR2

'H'

GUEST_LAST_NAME

20

VARCHAR2

 

ARRIVAL_DATE

8

DATE

 

DEPARTURE_DATE

8

DATE

 

ROOM

5

VARCHAR2

 

REVENUE_BKT_AMOUNT_11

13

NUMBER

 

REVENUE_BKT_AMOUNT_12

13

NUMBER

 

REVENUE_BKT_AMOUNT_13

13

NUMBER

 

REVENUE_BKT_AMOUNT_14

13

NUMBER

 

REVENUE_BKT_AMOUNT_15

13

NUMBER

 

 See Also