|
|
|
TSA06 Export
The TSA06 Export report contains all arrivals. You can manually export All Arrivals by selecting Miscellaneous > File Export > General or Configuration > External > Export Files.
All UDF fields have been included in this export view. The use of UDF fields is unique to each hotel property. To create the export, you must confirm the UDF fields. UDF fields that are not required can be deleted from the Export Column setup.
TSA06 Fields |
Export Field/Column Name |
Field Type |
SYSDAT |
BUSINESS_DATE |
VARCHAR2(8) |
HOTEL CODE |
RESORT |
VARCHAR2(20) |
NAME |
NAME |
VARCHAR2 |
INSERT_DATE |
CI_DATE |
VARCHAR2(8) |
INSERT_DATE (TIME) (Check in time) |
CI_TIME |
VARCHAR2(8) |
INSERT_USER |
APP_USER |
VARCHAR2(40) |
GUEST_LAST_NAME |
GUEST_LAST_NAME |
VARCHAR2(162) |
GUEST_FIRST_NAME |
GUEST_FIRST_NAME |
VARCHAR2(162) |
MEMBERSHIP TYPE |
MEMBERSHIP_TYPE |
VARCHAR2(4000) |
MEMBERSHIP LEVEL |
MEMBERSHIP_LEVEL |
VARCHAR2(4000) |
CONFIRMATION_NO |
CONFIRMATION_NO |
VARCHAR2(50) |
TRUNC_ACTUAL_CHECK_IN_DATE |
CHKINDTE |
VARCHAR2(8) |
TRUNC_END_DATE |
END_DATE |
VARCHAR2(8) |
ACTION_TYPE |
ACTION_TYPE |
VARCHAR2(100) |
RESV_STATUS |
RESV_STATUS |
VARCHAR2(20) |
ACTUAL_CHECK-OUT_DATE |
CHKOUTDTE |
VARCHAR2(8) |
ROOM |
ROOM |
VARCHAR2(20) |
CREATED DATE |
CREATE_DATE |
VARCHAR2(8) |
BOOKED_ROOM_CATEGORY(ROOM TYPE) |
BOOKED_ROOM_CATEGORY_LABEL |
VARCHAR2(4000) |
ADULT OCCUPANCY |
ADULTS |
NUMBER |
CHILD OCCUPANCY |
CHILDREN |
NUMBER |
MARKET_CODE |
MARKET_CODE |
VARCHAR2(20) |
MARKET_CODE_DESCRIPTION |
MARKET_DESC |
VARCHAR2(4000) |
PRODUCT_ID |
PRODUCTS |
VARCHAR2(4000) |
RATE_CODE |
RATE_CODE |
VARCHAR2(20) |
RATE_CODE_DESCRIPTION |
RATE_DESC |
VARCHAR2(2000) |
RATE_CODE_VALUE |
RATE_VALUE |
NUMBER |
RATE_CODE_CONFIGURED AMOUNT |
CFG_PRICE |
NUMBER |
SOURCE_CODE |
SOURCE_CODE |
VARCHAR2(20) |
SOURCE_DESCRIPTION |
SOURCE_DESC |
VARCHAR2(4000) |
NATIONALITY |
NATIONALITY |
VARCHAR2(20) |
GEOGRAPHICAL_COUNTRY |
GUEST_COUNTRY |
VARCHAR2(4000) |
DISCOUNT_AMT |
DISCOUNT_AMT |
NUMBER |
DISCOUNT_PRCNT |
DISCOUNT_PRCNT |
NUMBER |
DISCOUNT_REASON_CODE |
DISCOUNT_REASON_CODE |
VARCHAR2 |
SPECIAL_REQUESTS |
SPECIAL_REQUESTS |
VARCHAR2 |
|
UDFC01 |
VARCHAR2(200) |
|
UDFC02 |
VARCHAR2(200) |
|
UDFC03 |
VARCHAR2(200) |
|
UDFC04 |
VARCHAR2(200) |
|
UDFC05 |
VARCHAR2(200) |
|
UDFC06 |
VARCHAR2(200) |
|
UDFC07 |
VARCHAR2(200) |
|
UDFC08 |
VARCHAR2(200) |
|
UDFC09 |
VARCHAR2(200) |
|
UDFC10 |
VARCHAR2(200) |
|
UDFC11 |
VARCHAR2(200) |
|
UDFC12 |
VARCHAR2(200) |
|
UDFC13 |
VARCHAR2(200) |
|
UDFC14 |
VARCHAR2(200) |
|
UDFC15 |
VARCHAR2(200) |
|
UDFC16 |
VARCHAR2(200) |
|
UDFC17 |
VARCHAR2(200) |
|
UDFC18 |
VARCHAR2(200) |
|
UDFC19 |
VARCHAR2(200) |
|
UDFC20 |
VARCHAR2(200) |
|
UDFC21 |
VARCHAR2(200) |
|
UDFC22 |
VARCHAR2(200) |
|
UDFC23 |
VARCHAR2(200) |
|
UDFC24 |
VARCHAR2(200) |
|
UDFC25 |
VARCHAR2(200) |
|
UDFC26 |
VARCHAR2(200) |
|
UDFC27 |
VARCHAR2(200) |
|
UDFC28 |
VARCHAR2(200) |
|
UDFC29 |
VARCHAR2(200) |
|
UDFC30 |
VARCHAR2(200) |
|
UDFC31 |
VARCHAR2(200) |
|
UDFC32 |
VARCHAR2(200) |
|
UDFC33 |
VARCHAR2(200) |
|
UDFC34 |
VARCHAR2(200) |
|
UDFC35 |
VARCHAR2(200) |
|
UDFC36 |
VARCHAR2(200) |
|
UDFC37 |
VARCHAR2(200) |
|
UDFC38 |
VARCHAR2(200) |
|
UDFC39 |
VARCHAR2(200) |
|
UDFC40 |
VARCHAR2(200) |
|
UDFD01 |
DATE |
|
UDFD02 |
DATE |
|
UDFD03 |
DATE |
|
UDFD04 |
DATE |
|
UDFD05 |
DATE |
|
UDFD06 |
DATE |
|
UDFD07 |
DATE |
|
UDFD08 |
DATE |
|
UDFD09 |
DATE |
|
UDFD10 |
DATE |
|
UDFD11 |
DATE |
|
UDFD12 |
DATE |
|
UDFD13 |
DATE |
|
UDFD14 |
DATE |
|
UDFD15 |
DATE |
|
UDFD16 |
DATE |
|
UDFD17 |
DATE |
|
UDFD18 |
DATE |
|
UDFD19 |
DATE |
|
UDFD20 |
DATE |
|
UDFN01 |
NUMBER |
|
UDFN02 |
NUMBER |
|
UDFN03 |
NUMBER |
|
UDFN04 |
NUMBER |
|
UDFN05 |
NUMBER |
|
UDFN06 |
NUMBER |
|
UDFN07 |
NUMBER |
|
UDFN08 |
NUMBER |
|
UDFN09 |
NUMBER |
|
UDFN10 |
NUMBER |
|
UDFN11 |
NUMBER |
|
UDFN12 |
NUMBER |
|
UDFN13 |
NUMBER |
|
UDFN14 |
NUMBER |
|
UDFN15 |
NUMBER |
|
UDFN16 |
NUMBER |
|
UDFN17 |
NUMBER |
|
UDFN18 |
NUMBER |
|
UDFN19 |
NUMBER |
|
UDFN20 |
NUMBER |
|
UDFN21 |
NUMBER |
|
UDFN22 |
NUMBER |
|
UDFN23 |
NUMBER |
|
UDFN24 |
NUMBER |
|
UDFN25 |
NUMBER |
|
UDFN26 |
NUMBER |
|
UDFN27 |
NUMBER |
|
UDFN28 |
NUMBER |
|
UDFN29 |
NUMBER |
|
UDFN30 |
NUMBER |
|
UDFN31 |
NUMBER |
|
UDFN32 |
NUMBER |
|
UDFN33 |
NUMBER |
|
UDFN34 |
NUMBER |
|
UDFN35 |
NUMBER |
|
UDFN36 |
NUMBER |
|
UDFN37 |
NUMBER |
|
UDFN38 |
NUMBER |
|
UDFN39 |
NUMBER |
|
UDFN40 |
NUMBER |
This export file is available on-demand, to allow for external and local resources to produce more up to the minute information in case of an emergency. The file transfer from OPERA to the database is completed by using the OPERA OXI_HUB Interface, with an HTTP address that is set up for the actual export file itself (see Export Files for details).
See Also
