FILE_TYPE

IBM EXPORT

FILE_TYPE_DESC

IBM Electronic Folio Export

EXPORT SOURCE

EXP_FINANCIAL_TRANSACTIONS

FILE and ZIP_FILE_NAME

'IBM_'||pms_p.resort||to_char(pms_p.business_date,'MMDDYY')||'EXP'

FILE_EXTENSION

TXT

POST EXPORT PROCEDURE

exp_create_data.delete_report_table

PARAMETER FORM

ADD NEW LINE CHECKBOX

Checked

NIGHT AUDIT EXPORT

Daily

FILTER CONDITION

export_id=exp_create_data.get_last_report_id and resv_name_id in (select resv_name_id from reservation_general_view r where r.company_id = 238207)

Note: Company data will be filtered based on the company id passed in this filter condition.

PRE EXPORT PROCEDURE

exp_create_data.create_report_table

COL_NAME

COL_LENGTH

COL_TYPE

EXISTING MAPPED COLUMN

FORMULA

TOTALRECORDS

6

FORMULA

PROPERTY_CODE

TOTALRECORDS (FM0000)

COL_NAME

POSITION

COL_LENGTH

COL_TYPE

EXISTING MAPPED COLUMN

FORMULA

DESCRIPTION

HOTEL_NUM

1-20

20

VARCHAR2

PROPERTY_CODE

This is the Hotel identifier (ex. STAR142, CPNY,MAR-1035)

ROOM

21-28

8

VARCHAR2

ORIGINAL_ROOM_NUMBER

Room Number

ARRIVAL

29-38

10

FORMULA

to_char(arrival_date,'YYYY-MM-DD')

Arrival Date - format: YYYY-MM-DD (include the '-')

FNAME

39-58

20

VARCHAR2

FIRST_NAME

Employee First Name

LNAME

59-78

20

VARCHAR2

LAST_NAME

Employee Last Name

DEPARTURE

79-88

10

FORMULA

to_char(departure_date,'YYYY-MM-DD')

Departure Date - format: YYYY-MM-DD (include the '-')

FOLIO_NUM

89-98

10

NUMBER

FOLIO_NO

Hotel folio number

ROOM_RATE

99-110

12

NUMBER

SHARE_AMT

Hotel room rate

ACCOUNT

111-120

10

VARCHAR2

RARE_CODE

IBMs account number (ex. IBMA)

MKTSEG

121-130

10

VARCHAR2

MARKET_CODE

Market segment number

PAY_TYPE

131-132

2

VARCHAR2

CREDIT_CARD_TYPE

Charge Card Type (ex. DC = Diners Club, AX = American Express)

PAY_REF

133-152

20

VARCHAR2

SW_CARD_ISSUE_NUMBER

Charge card number

ITEMCODE

153-158

6

VARCHAR2

TRX_CODE

Hotel specific item code

REFERENCE

159-166

8

FORMULA

substr(REFERENCE,1,8)

Hotel specific reference number

ITEM_ID

167-172

6

VARCHAR2

TRX_NO

Hotel specific item ID

DESCRIPTION

173-192

20

FORMULA

substr(TRX_DESCRIPTION,1,20)

Item description

CLIENT

193-196

4

FORMULA

'IBM'

Default to 'IBM'

AMOUNT

197-208

12

NUMBER

TRX_AMOUNT

Item Amount

XMIT_DATE

209-218

10

FORMULA

to_char(business_date,'YYYY-MM-DD')

Date Charge was incurred - format:

YYYY-MM-DD (include the '-')

GROUP_CODE

219-230

12

FORMULA

' '

Group number

ORIG_PAY_REF

231-270

40

FORMULA

' '

Charge card number (############## Ex. 38865589942418)