|
|
|
E-Folio Export - American Express
FILE_TYPE |
EXP_EFOLIO_DETAILS |
SOURCE_VIEW_CODE |
EXP_EFOLIO_DETAILS |
FILE_TYPE_DESC |
Efolio Detail Export |
PRE_EXP_PROC |
"exp_efolio_data.create_efolio_data(pms_p.business_date-20,pms_p.business_date)" |
POST_EXP_PROC |
exp_create_data.delete_report_table |
PARAMETER_FORM |
|
FILE_NAME |
'EFOLIO'||pms_p.resort |
FILE_EXTENSION |
'TXT' |
COL_NAME |
COL_LENGTH |
COL_FORMAT |
COL_TYPE |
FORMULA |
REC_TYPE |
1 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL('F',' '),1,' '),null)" |
MERCHANT_NO |
10 |
|
FORMULA |
"decode(export_type,'R',RPAD(' ',10,' '),null)" |
HOTELNM |
50 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(Hotel_name,' '),50,' '),null)" |
HOTELCD |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(Hotel_code,' '),15,' '),null)" |
LEGALOWN |
40 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(LEGAL_OWNER,' '),40,' '),null)" |
HOTEL_TYPE |
40 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(RESORT_TYPE,' '),40,' '),null)" |
PROP_STREET |
152 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(STREET,' '),152,' '),null)" |
PROP_CITY |
38 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(CITY,' '),38,' '),null)" |
PROP_REGION |
6 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(REGION_CODE,' '),6,' '),null)" |
PROP_POSTAL |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(POST_CODE,' '),15,' '),null)" |
COUNTRY_NM |
35 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(NULL,' '),35,' '),null)" |
PROP_COUNTRY |
4 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(COUNTRY_CODE,' '),3,' '),null)" |
PROP_TELPHONE |
20 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(TELEPHONE,' '),20,' '),null)" |
GUEST_NAME |
65 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(upper(Guest_last_name||' '||Guest_first_name),' '),65,' '),null)" |
RESV_FOLIO_NO |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(TO_CHAR(RESV_FOLIO_NO),' '),15,' '),null)" |
RESV_CURRENCY |
3 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(RESV_CURRENCY_CODE,' '),3,' '),null)" |
SIGN_RESV_TOTAL |
1 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(decode(sign(resv_total_folio_amt),-1,'+','-'),' '),1,' '),null)" |
RESV_FOLIO_AMT |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(to_char(NVL(RESV_TOTAL_FOLIO_AMT,0),'FM000000000000D00'),15,' '),null)" |
ARRIVALDT |
8 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(TO_CHAR(ARRIVAL_DATE, 'YYYYMMDD'),' '),8,' '),null)" |
ARRIVAL_TIME |
4 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(TO_CHAR(ARRIVAL_DATE, 'HH24MI'),' '),4,' '),null)" |
DEPARTUREDT |
8 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(TO_CHAR(DEPARTURE_DATE, 'YYYYMMDD'),' '),8,' '),null)" |
DEPARTURE_TIME |
4 |
|
FORMULA |
"decode(export_type,'R',RPAD(nvl(TO_CHAR(DEPARTURE_DATE, 'HH24MI'),' '),4,' '),null)" |
BOOKING_NO |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(CONFIRMATION_NO,' '),15,' '),null)" |
ROOMTYPE |
15 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(RATE_ROOM_TYPE,' '),15,' '),null)" |
FILL2 |
100 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(NULL,' '),100,' '),null)" |
ROOM_RATE |
15 |
|
FORMULA |
"decode(export_type,'R',to_char(NVL(SHARE_AMOUNT,0),'FM000000000000D00'),null)" |
NO_OF_GUEST |
4 |
|
FORMULA |
"decode(export_type,'R',to_char(NVL(ADULTS+CHILDREN,0),'FM0000'),null)" |
NO_OF_STAY_NIGHTS |
3 |
|
FORMULA |
"decode(export_type,'R',to_char(NVL(room_nights_total,0),'FM0000'),null)" |
TAX_REG_NO |
45 |
|
FORMULA |
"decode(export_type,'R',RPAD(NVL(TO_CHAR(TAX_REGISTRATION_NO),' '),45,' '),null)" |
REC_2 |
1 |
|
FORMULA |
"decode(export_type,'T',RPAD(NVL('P',' '),1,' '),null)" |
F_SEQ_NO |
8 |
|
FORMULA |
"decode(export_type,'T',TO_CHAR(nvl(F_CC_ROW_SEQ,0),'FM00000000'),null)" |
F_CC_NO |
19 |
|
FORMULA |
"decode(export_type,'T',lpad('*',15,'*')||RPAD(NVL(substr(f_payment_credit_card_no,-3),' '),19,' '),null)" |
F_CURR_CODE |
3 |
|
FORMULA |
"decode(export_type,'T',RPAD(NVL(F_CURRENCY_CODE,' '),3,' '),null)" |
F_SIGN |
1 |
|
FORMULA |
"decode(export_type,'T',RPAD(NVL(F_SIGN,' '),1,' '),null)" |
F_TOTAL_CHRG_AMT |
15 |
|
FORMULA |
"decode(export_type,'T',to_char(nvl(F_TOTAL_CHRG_AMT,0),'FM000000000000D00'),null)" |
ROCID |
13 |
|
FORMULA |
"decode(export_type,'T',RPAD(NVL(NULL,' '),13,' '),null)" |
F_CHR_DT |
8 |
|
FORMULA |
"decode(export_type,'T',RPAD(NVL(TO_CHAR(F_CHRG_TRNS_DT, 'YYYYMMDD'),' '),8,' '),null)" |
REC_3 |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL('D',' '),1,' '),null)" |
ITEM_CODE |
6 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_ITEM_CODE),' '),6,' '),null)" |
SUB_SEQ |
8 |
|
FORMULA |
"decode(export_type,'D',TO_CHAR(SUB_SEQ,'FM00000000'),null)" |
ITEM_REFNO |
15 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(NULL,' '),15,' '),null)" |
ITEM_DESC |
40 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_ITEM_DESC,' '),40,' '),null)" |
D_SIGN_IND |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_SIGN_INDICATOR,' '),1,' '),null)" |
ITEM_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_ITEM_AMOUNT,0),'FM000000000000D00'),null)" |
ITEM_DT |
8 |
|
FORMULA |
"decode(export_type,'D',RPAD(TO_CHAR(T_ITEM_DATE, 'YYYYMMDD'),8,' '),null)" |
TAX_1_CODE |
6 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE1_CODE),' '),6,' '),null)" |
TAX_1_RATE |
7 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE1_RATE),' '),7,' '),null)" |
TAX_1_SIGN |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_TAX_TYPE1_SIGN_IND,' '),1,' '),null)" |
TAX_1_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_TAX_TYPE1_AMT,0),'FM000000000000D00'),null)" |
TAX_2_CODE |
0 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE2_CODE),' '),6,' '),null)" |
TAX_2_RATE |
7 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE2_RATE),' '),7,' '),null)" |
TAX_2_SIGN |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_TAX_TYPE2_SIGN_IND,' '),1,' '),null)" |
TAX_2_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_TAX_TYPE2_AMT,0),'FM000000000000D00'),null)" |
TAX_3_CODE |
6 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE3_CODE),' '),6,' '),null)" |
TAX_3_RATE |
7 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE3_RATE),' '),7,' '),null)" |
TAX_3_SIGN |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_TAX_TYPE3_SIGN_IND,' '),1,' '),null)" |
TAX_3_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_TAX_TYPE3_AMT,0),'FM000000000000D00'),null)" |
TAX_4_CODE |
6 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE4_CODE),' '),6,' '),null)" |
TAX_4_RATE |
7 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE4_RATE),' '),7,' '),null)" |
TAX_4_SIGN |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_TAX_TYPE4_SIGN_IND,' '),1,' '),null)" |
TAX_4_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_TAX_TYPE4_AMT,0),'FM000000000000D00'),null)" |
TAX_5_CODE |
6 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE5_CODE),' '),6,' '),null)" |
TAX_5_RATE |
7 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(TO_CHAR(T_TAX_TYPE5_RATE),' '),7,' '),null)" |
TAX_5_SIGN |
1 |
|
FORMULA |
"decode(export_type,'D',RPAD(NVL(T_TAX_TYPE5_SIGN_IND,' '),1,' '),null)" |
TAX_5_AMT |
15 |
|
FORMULA |
"decode(export_type,'D',to_char(nvl(T_TAX_TYPE5_AMT,0),'FM000000000000D00'),null)" |
See Also
