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_GROUP_ID |
FILE_TYPE_DESC |
FILE_NAME |
FILE_EXTENSION |
MISC |
General Inhouse Resv Export |
'INH'||(SUBSTR(PROPERTY_CODE,1,5)) |
'TXT' |
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