FILE_TYPE

EXP_MC_EFOLIO

SOURCE_VIEW_CODE

EXP_FINANCIAL_TRANSACTIONS

FILE_TYPE_DESC

MasterCard Efolio Export

PRE_EXP_PROC

"exp_create_data.create_export_data(in_from_date => pms_p.business_date - 10,in_to_date => pms_p.business_date - 1,in_export_type => 'F')"

POST_EXP_PROC

exp_create_data.delete_report_table

PARAMETER_FORM

FILE_NAME

"'MC_'||pms_p.resort||to_char(pms_p.business_date,'MMDDYY')"

FILE_EXTENSION

'TXT'

COL_NAME

COL_LENGTH

COL_FORMAT

COL_TYPE

FORMULA

TOTALRECORDS

6

FM000000

FORMULA

PROPERTY_CODE

20

VARCHAR2

ORIGINAL_ROOM_NUMBER

8

VARCHAR2

ARRIVAL

10

FORMULA

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

FIRST_NAME

20

FORMULA

upper(first_name)

LAST_NAME

20

FORMULA

upper(last_name)

DEPARTURE

10

FORMULA

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

BILL_NO

10

NUMBER

ROOMRATE

12

FORMULA

"to_char(SHARE_AMT,'FM999999990D00')"

RATE_CODE

10

VARCHAR2

MARKET_CODE

10

VARCHAR2

CREDIT_CARD_TYPE

2

VARCHAR2

CREDIT_CARDNO

20

VARCHAR2

'*************'||credit_card_no

TRX_CODE

6

VARCHAR2

REFERENCE

8

FORMULA

"substr(REFERENCE,1,8)"

TRX_NO

6

NUMBER

DESCRIPTION

20

FORMULA

"upper(substr(TRX_DESCRIPTION,1,20))"

CLIENT

4

FORMULA

'MC'

AMOUNT

12

NUMBER

"'-'||to_char(GUEST_ACCOUNT_CREDIT,'FM99999990D00')"

XMIT_DATE

10

FORMULA

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

GROUP_CODE

12

FORMULA

' '

ORIG_PAY_REF

40

FORMULA

' '