(SELECT MASTER.KEY97 as MASTER_KEY97,Master.Master_Ref as Master_ref,	MASTER.REFNO_MBE as MASTER_REFNO_MBE,	MASTER.REFNO_PFIX as MASTER_REFNO_PFIX,	MASTER.REFNO_BRN as MASTER_REFNO_BRN,	MASTER.REFNO_SERL as MASTER_REFNO_SERL,	MASTER.PRINAME_L1 as MASTER_PRINAME_L1,	MASTER.EXEMPLAR as MASTER_EXEMPLAR,	MASTER.STATUS as MASTER_STATUS,	MASTER.PRDCLASS as MASTER_PRDCLASS,	MASTER.UTILIS_AMT as MASTER_UTILIS_AMT,	MASTER.UTILIS_CCY as MASTER_UTILIS_CCY,	MASTER.ORIG_REF as MASTER_ORIG_REF,	MASTER.PARENT_EV as MASTER_PARENT_EV,	MASTER.INPUT_BRN as MASTER_INPUT_BRN,	MASTER.BHALF_BRN as MASTER_BHALF_BRN,	MASTER.EXPIRY_DAT as MASTER_EXPIRY_DAT,	MASTER.EXPIRY_LOC as MASTER_EXPIRY_LOC,	MASTER.AMOUNT as MASTER_AMOUNT,	MASTER.CCY as MASTER_CCY,	MASTER.AMT_O_S as MASTER_AMT_O_S,	MASTER.DFLT_WKGRP as MASTER_DFLT_WKGRP,	MASTER.PCP_PTY as MASTER_PCP_PTY,	MASTER.NPCP_PTY as MASTER_NPCP_PTY,	MASTER.CHARGE_FOR as MASTER_CHARGE_FOR,	MASTER.USERCODE1 as MASTER_USERCODE1,	MASTER.USERCODE2 as MASTER_USERCODE2,	MASTER.USERCODE3 as MASTER_USERCODE3,	MASTER.RESP_USER as MASTER_RESP_USER,	MASTER.CTRCT_DATE as MASTER_CTRCT_DATE,	MASTER.WORKGROUP as MASTER_WORKGROUP,	MASTER.LIAB_AMT as MASTER_LIAB_AMT,	MASTER.LIAB_CCY as MASTER_LIAB_CCY,	MASTER.TFR_MTHD as MASTER_TFR_MTHD,	MASTER.SHAREDLIAB as MASTER_SHAREDLIAB,	MASTER.MAILTOBRN as MASTER_MAILTOBRN,	MASTER.RELMSTRKEY as MASTER_RELMSTRKEY,	MASTER.RELMSTRREF as MASTER_RELMSTRREF,	MASTER.PRODTYPE as MASTER_PRODTYPE,	MASTER.PRIMARYCUS as MASTER_PRIMARYCUS,	MASTER.USEROPTN1 as MASTER_USEROPTN1,	MASTER.USEROPTN2 as MASTER_USEROPTN2,	MASTER.USEROPTN3 as MASTER_USEROPTN3,	MASTER.USEROPTN4 as MASTER_USEROPTN4,	MASTER.USEROPTN5 as MASTER_USEROPTN5,	MASTER.TOTLIABAMT as MASTER_TOTLIABAMT,	MASTER.TOTLIABCCY as MASTER_TOTLIABCCY,	MASTER.REIMB_CHGS as MASTER_REIMB_CHGS,	MASTER.BILLLEVEL as MASTER_BILLLEVEL,	MASTER.BOOKOFFDAT as MASTER_BOOKOFFDAT,	MASTER.ECFLNK_KEY as MASTER_ECFLNK_KEY,	MASTER.ECFLNK_REF as MASTER_ECFLNK_REF,	MASTER.DEACT_DATE as MASTER_DEACT_DATE,	MASTER.DATATAKEON as MASTER_DATATAKEON,	MASTER.ACTIVE as MASTER_ACTIVE,	MASTER.ELIGFORDEL as MASTER_ELIGFORDEL,	MASTER.PREV_STS as MASTER_PREV_STS,	MASTER.MASTER_REF as MASTER_MASTER_REF,	MASTER.REF_LOCK as MASTER_REF_LOCK,	MASTER.PRICUSTSBB as MASTER_PRICUSTSBB,	MASTER.PRICUSTMNM as MASTER_PRICUSTMNM,	MASTER.VERLEVEL as MASTER_VERLEVEL,	MASTER.CANOURREF as MASTER_CANOURREF,	MASTER.EV_COUNT as MASTER_EV_COUNT,	MASTER.EXTFIELD as MASTER_EXTFIELD,	MASTER.NO_BROWSE as MASTER_NO_BROWSE,	MASTER.PRI_REF as MASTER_PRI_REF,	MASTER.CANPRNREF as MASTER_CANPRNREF,	MASTER.NPR_REF as MASTER_NPR_REF,	MASTER.CANNPRNREF as MASTER_CANNPRNREF,	MASTER.TAKEON as MASTER_TAKEON,	MASTER.TAKE_AMDNO as MASTER_TAKE_AMDNO,	MASTER.TAKE_DATE as MASTER_TAKE_DATE,	MASTER.TAKE_PAYNO as MASTER_TAKE_PAYNO,	MASTER.ORIGNAME as MASTER_ORIGNAME,	MASTER.ORIGTEAM as MASTER_ORIGTEAM,	MASTER.ORIGISUSER as MASTER_ORIGISUSER,	MASTER.ORIGBRANCH as MASTER_ORIGBRANCH,	MASTER.ORIGUSER as MASTER_ORIGUSER,	MASTER.ORIGREF as MASTER_ORIGREF,	MASTER.EBANKMSREF as MASTER_EBANKMSREF,	MASTER.NPRCUSTSBB as MASTER_NPRCUSTSBB,	MASTER.NPRCUSTMNM as MASTER_NPRCUSTMNM,	MASTER.NPRNAME_L1 as MASTER_NPRNAME_L1,	MASTER.TRANS_BRN as MASTER_TRANS_BRN,	MASTER.LOCKED as MASTER_LOCKED,	MASTER.ACCT_BRN as MASTER_ACCT_BRN,	MASTER.TYPEFLAG as MASTER_TYPEFLAG,	MASTER.TSTAMP as MASTER_TSTAMP,	EXMMASTER.KEY97 as EXMMASTER_KEY97,	EXMMASTER.CODE79 as EXMMASTER_CODE79,	EXMMASTER.VERSION as EXMMASTER_VERSION,	EXMMASTER.SHORTN13 as EXMMASTER_SHORTN13,	EXMMASTER.LONGNA85 as EXMMASTER_LONGNA85,	EXMMASTER.EVENTE36 as EXMMASTER_EVENTE36,	EXMMASTER.PRODUC79 as EXMMASTER_PRODUC79,	EXMMASTER.EXCLUSIV as EXMMASTER_EXCLUSIV,	EXMMASTER.SCHEDULE as EXMMASTER_SCHEDULE,	EXMMASTER.LOG_TIME as EXMMASTER_LOG_TIME,	EXMMASTER.INPUT_TIME as EXMMASTER_INPUT_TIME,	EXMMASTER.REVIEWTIME as EXMMASTER_REVIEWTIME,	EXMMASTER.AUTH_TIME as EXMMASTER_AUTH_TIME,	EXMMASTER.RTFIX_TIME as EXMMASTER_RTFIX_TIME,	EXMMASTER.RFAUTHTIME as EXMMASTER_RFAUTHTIME,	EXMMASTER.LOGAPPTIME as EXMMASTER_LOGAPPTIME,	EXMMASTER.LIMAPPTIME as EXMMASTER_LIMAPPTIME,	EXMMASTER.APPRVLTIME as EXMMASTER_APPRVLTIME,	EXMMASTER.FNLPRTTIME as EXMMASTER_FNLPRTTIME,	EXMMASTER.OTHER1TIME as EXMMASTER_OTHER1TIME,	EXMMASTER.OTHER2TIME as EXMMASTER_OTHER2TIME,	EXMMASTER.OTHER3TIME as EXMMASTER_OTHER3TIME,	EXMMASTER.OTHER4TIME as EXMMASTER_OTHER4TIME,	EXMMASTER.OTHER5TIME as EXMMASTER_OTHER5TIME,	EXMMASTER.EXTREVTIME as EXMMASTER_EXTREVTIME,	EXMMASTER.TYPEFLAG as EXMMASTER_TYPEFLAG,	EXMMASTER.TSTAMP as EXMMASTER_TSTAMP,	CPAYMASTER.KEY97 as CPAYMASTER_KEY97,	CPAYMASTER.PAYSTATUS as CPAYMASTER_PAYSTATUS,	CPAYMASTER.RCVCHG_AMT as CPAYMASTER_RCVCHG_AMT,	CPAYMASTER.RCVCHG_CCY as CPAYMASTER_RCVCHG_CCY,	CPAYMASTER.RATECODE as CPAYMASTER_RATECODE,	CPAYMASTER.PAY_DATE as CPAYMASTER_PAY_DATE,	CPAYMASTER.RCV_DATE as CPAYMASTER_RCV_DATE,	CPAYMASTER.FXRATE as CPAYMASTER_FXRATE,	CPAYMASTER.PAY_AMT as CPAYMASTER_PAY_AMT,	CPAYMASTER.PAY_CCY as CPAYMASTER_PAY_CCY,	CPAYMASTER.PAYCHG_AMT as CPAYMASTER_PAYCHG_AMT,	CPAYMASTER.PAYCHG_CCY as CPAYMASTER_PAYCHG_CCY,	CPAYMASTER.RCV_AMT as CPAYMASTER_RCV_AMT,	CPAYMASTER.RCV_CCY as CPAYMASTER_RCV_CCY,	CPAYMASTER.RECEIVE_SI as CPAYMASTER_RECEIVE_SI,	CPAYMASTER.SENDTO_PTY as CPAYMASTER_SENDTO_PTY,	CPAYMASTER.PAY_SI as CPAYMASTER_PAY_SI,	CPAYMASTER.REMIT_PTY as CPAYMASTER_REMIT_PTY,	CPAYMASTER.CHQ_STATUS as CPAYMASTER_CHQ_STATUS,	CPAYMASTER.ISSUE_DATE as CPAYMASTER_ISSUE_DATE,	CPAYMASTER.CHQ_NUM as CPAYMASTER_CHQ_NUM,	CPAYMASTER.LICALLAMT as CPAYMASTER_LICALLAMT,	CPAYMASTER.LICALLCCY as CPAYMASTER_LICALLCCY,	CPAYMASTER.LICRESERV as CPAYMASTER_LICRESERV,	CPAYMASTER.LICALLBAMT as CPAYMASTER_LICALLBAMT,	CPAYMASTER.LICALLBCCY as CPAYMASTER_LICALLBCCY,	CPAYMASTER.NUM_OF_PAY as CPAYMASTER_NUM_OF_PAY,	CPAYMASTER.ADVICEDAY as CPAYMASTER_ADVICEDAY,	CPAYMASTER.AMT_BASIS as CPAYMASTER_AMT_BASIS,	CPAYMASTER.FINALPAY as CPAYMASTER_FINALPAY,	CPAYMASTER.NEXTPAYDAT as CPAYMASTER_NEXTPAYDAT,	CPAYMASTER.PERIODUNIT as CPAYMASTER_PERIODUNIT,	CPAYMASTER.PERIODNUM as CPAYMASTER_PERIODNUM,	CPAYMASTER.DAYINMONTH as CPAYMASTER_DAYINMONTH,	CPAYMASTER.INITPAYDAT as CPAYMASTER_INITPAYDAT,	CPAYMASTER.PAYNUM as CPAYMASTER_PAYNUM,	CPAYMASTER.PREVPAYDAT as CPAYMASTER_PREVPAYDAT,	EXTMASTER.KEY29 as EXTMASTER_KEY29,	EXTMASTER.TYPEFLAG as EXTMASTER_TYPEFLAG,	EXTMASTER.TSTAMP as EXTMASTER_TSTAMP,	EXTMASTER.INITED as EXTMASTER_INITED,	EXTMASTER.MASTER as EXTMASTER_MASTER,	EXTMASTER.DWDATE as EXTMASTER_DWDATE,	EXTMASTER.CDATE as EXTMASTER_CDATE,	EXTMASTER.EDATE as EXTMASTER_EDATE,	EXTBALOFPAY.BID as EXTBALOFPAY_BID,	EXTBALOFPAY.BCODE as EXTBALOFPAY_BCODE,	EXTBALOFPAY.BDESC as EXTBALOFPAY_BDESC,	EXTBALOFPAY.BDIR as EXTBALOFPAY_BDIR,	BASEEVENT.KEY97 as BASEEVENT_KEY97,	BASEEVENT.REFNO_PFIX as BASEEVENT_REFNO_PFIX,	BASEEVENT.REFNO_SERL as BASEEVENT_REFNO_SERL,	BASEEVENT.MASTER_KEY as BASEEVENT_MASTER_KEY,	BASEEVENT.START_DATE as BASEEVENT_START_DATE,	BASEEVENT.START_TIME as BASEEVENT_START_TIME,	BASEEVENT.TIMESTART as BASEEVENT_TIMESTART,	BASEEVENT.STATUS as BASEEVENT_STATUS,	BASEEVENT.TOUCHED as BASEEVENT_TOUCHED,	BASEEVENT.FINISHED as BASEEVENT_FINISHED,	BASEEVENT.FINISHTIME as BASEEVENT_FINISHTIME,	BASEEVENT.TIMEFINISH as BASEEVENT_TIMEFINISH,	BASEEVENT.EXEMPLAR as BASEEVENT_EXEMPLAR,	BASEEVENT.THEIR_REF as BASEEVENT_THEIR_REF,	BASEEVENT.AMOUNT as BASEEVENT_AMOUNT,	BASEEVENT.CCY as BASEEVENT_CCY,	BASEEVENT.TFR_METHOD as BASEEVENT_TFR_METHOD,	BASEEVENT.STATUS_EV as BASEEVENT_STATUS_EV,	BASEEVENT.CROSS_REF as BASEEVENT_CROSS_REF,	BASEEVENT.USER_INP as BASEEVENT_USER_INP,	BASEEVENT.USER_REV as BASEEVENT_USER_REV,	BASEEVENT.USER_AUT as BASEEVENT_USER_AUT,	BASEEVENT.CREATNMTHD as BASEEVENT_CREATNMTHD,	BASEEVENT.SLADATA as BASEEVENT_SLADATA,	BASEEVENT.LAST_STEP as BASEEVENT_LAST_STEP,	BASEEVENT.PSBBCODE as BASEEVENT_PSBBCODE,	BASEEVENT.PRIMNM as BASEEVENT_PRIMNM,	BASEEVENT.EBANKEVREF as BASEEVENT_EBANKEVREF,	BASEEVENT.ANCIL_MST as BASEEVENT_ANCIL_MST,	BASEEVENT.VERLEVEL as BASEEVENT_VERLEVEL,	BASEEVENT.OFAC as BASEEVENT_OFAC,	BASEEVENT.EV_INDEX as BASEEVENT_EV_INDEX,	BASEEVENT.REPAIR as BASEEVENT_REPAIR,	BASEEVENT.POST_WGRP as BASEEVENT_POST_WGRP,	BASEEVENT.EXTFIELD as BASEEVENT_EXTFIELD,	BASEEVENT.BPHASEK as BASEEVENT_BPHASEK,	BASEEVENT.FXRATESET as BASEEVENT_FXRATESET,	BASEEVENT.FIX2DAY as BASEEVENT_FIX2DAY,	BASEEVENT.NEEDCHECK as BASEEVENT_NEEDCHECK,	BASEEVENT.NO_BROWSE as BASEEVENT_NO_BROWSE,	BASEEVENT.SWONCEREL as BASEEVENT_SWONCEREL,	BASEEVENT.PRIADLINE as BASEEVENT_PRIADLINE,	BASEEVENT.ENRRESSTAT as BASEEVENT_ENRRESSTAT,	BASEEVENT.ATTACHD_EV as BASEEVENT_ATTACHD_EV,	BASEEVENT.ORIGNAME as BASEEVENT_ORIGNAME,	BASEEVENT.ORIGTEAM as BASEEVENT_ORIGTEAM,	BASEEVENT.ORIGISUSER as BASEEVENT_ORIGISUSER,	BASEEVENT.ORIGBRANCH as BASEEVENT_ORIGBRANCH,	BASEEVENT.ORIGUSER as BASEEVENT_ORIGUSER,	BASEEVENT.ORIGREF as BASEEVENT_ORIGREF,	BASEEVENT.NPSBBCODE as BASEEVENT_NPSBBCODE,	BASEEVENT.NPRIMNM as BASEEVENT_NPRIMNM,	BASEEVENT.VIOLATION as BASEEVENT_VIOLATION,	BASEEVENT.ORCH_DEFN as BASEEVENT_ORCH_DEFN,	BASEEVENT.ORCH_STEP as BASEEVENT_ORCH_STEP,	BASEEVENT.NPRIADLINE as BASEEVENT_NPRIADLINE,	BASEEVENT.STEPPHASE as BASEEVENT_STEPPHASE,	BASEEVENT.EXTRAINFO as BASEEVENT_EXTRAINFO,	BASEEVENT.FURTHERID as BASEEVENT_FURTHERID,	BASEEVENT.TYPEFLAG as BASEEVENT_TYPEFLAG,	BASEEVENT.TSTAMP as BASEEVENT_TSTAMP,	EXMEVENT.KEY97 as EXMEVENT_KEY97,	EXMEVENT.CODE79 as EXMEVENT_CODE79,	EXMEVENT.VERSION as EXMEVENT_VERSION,	EXMEVENT.SHORTN13 as EXMEVENT_SHORTN13,	EXMEVENT.LONGNA85 as EXMEVENT_LONGNA85,	EXMEVENT.EVENTE36 as EXMEVENT_EVENTE36,	EXMEVENT.PRODUC79 as EXMEVENT_PRODUC79,	EXMEVENT.EXCLUSIV as EXMEVENT_EXCLUSIV,	EXMEVENT.SCHEDULE as EXMEVENT_SCHEDULE,	EXMEVENT.LOG_TIME as EXMEVENT_LOG_TIME,	EXMEVENT.INPUT_TIME as EXMEVENT_INPUT_TIME,	EXMEVENT.REVIEWTIME as EXMEVENT_REVIEWTIME,	EXMEVENT.AUTH_TIME as EXMEVENT_AUTH_TIME,	EXMEVENT.RTFIX_TIME as EXMEVENT_RTFIX_TIME,	EXMEVENT.RFAUTHTIME as EXMEVENT_RFAUTHTIME,	EXMEVENT.LOGAPPTIME as EXMEVENT_LOGAPPTIME,	EXMEVENT.LIMAPPTIME as EXMEVENT_LIMAPPTIME,	EXMEVENT.APPRVLTIME as EXMEVENT_APPRVLTIME,	EXMEVENT.FNLPRTTIME as EXMEVENT_FNLPRTTIME,	EXMEVENT.OTHER1TIME as EXMEVENT_OTHER1TIME,	EXMEVENT.OTHER2TIME as EXMEVENT_OTHER2TIME,	EXMEVENT.OTHER3TIME as EXMEVENT_OTHER3TIME,	EXMEVENT.OTHER4TIME as EXMEVENT_OTHER4TIME,	EXMEVENT.OTHER5TIME as EXMEVENT_OTHER5TIME,	EXMEVENT.EXTREVTIME as EXMEVENT_EXTREVTIME,	EXMEVENT.TYPEFLAG as EXMEVENT_TYPEFLAG,	EXMEVENT.TSTAMP as EXMEVENT_TSTAMP,	REMITPTY.KEY97 as REMITPTY_KEY97,	REMITPTY.ADDR_TYP as REMITPTY_ADDR_TYP,	REMITPTY.ADDRESS1 as REMITPTY_ADDRESS1,	REMITPTY.ADDRESS2 as REMITPTY_ADDRESS2,	REMITPTY.ADDRESS3 as REMITPTY_ADDRESS3,	REMITPTY.ADDRESS4 as REMITPTY_ADDRESS4,	REMITPTY.ADDRESS5 as REMITPTY_ADDRESS5,	REMITPTY.ADDRESSF as REMITPTY_ADDRESSF,	REMITPTY.LANGUAGE as REMITPTY_LANGUAGE,	REMITPTY.PHONE as REMITPTY_PHONE,	REMITPTY.FAX as REMITPTY_FAX,	REMITPTY.TELEX as REMITPTY_TELEX,	REMITPTY.SW_BANK as REMITPTY_SW_BANK,	REMITPTY.SW_CTR as REMITPTY_SW_CTR,	REMITPTY.SW_LOC as REMITPTY_SW_LOC,	REMITPTY.SW_BRANCH as REMITPTY_SW_BRANCH,	REMITPTY.ZIPCODE as REMITPTY_ZIPCODE,	REMITPTY.SALUTATION as REMITPTY_SALUTATION,	REMITPTY.TFRMETHOD as REMITPTY_TFRMETHOD,	REMITPTY.TELEX_ANS as REMITPTY_TELEX_ANS,	REMITPTY.QUALIFIER as REMITPTY_QUALIFIER,	REMITPTY.CUS_SBB as REMITPTY_CUS_SBB,	REMITPTY.CUS_MNM as REMITPTY_CUS_MNM,	REMITPTY.PTY_TYPE as REMITPTY_PTY_TYPE,	REMITPTY.ROLE as REMITPTY_ROLE,	REMITPTY.REFERENCE as REMITPTY_REFERENCE,	REMITPTY.LIAB_AMT as REMITPTY_LIAB_AMT,	REMITPTY.LIAB_CCY as REMITPTY_LIAB_CCY,	REMITPTY.LIAB_PCT as REMITPTY_LIAB_PCT,	REMITPTY.AMT_OR_PCT as REMITPTY_AMT_OR_PCT,	REMITPTY.LIAB_ACCT as REMITPTY_LIAB_ACCT,	REMITPTY.MSTR_PTY as REMITPTY_MSTR_PTY,	REMITPTY.COUNTRY as REMITPTY_COUNTRY,	REMITPTY.SWADDRESS1 as REMITPTY_SWADDRESS1,	REMITPTY.SWADDRESS2 as REMITPTY_SWADDRESS2,	REMITPTY.SWADDRESS3 as REMITPTY_SWADDRESS3,	REMITPTY.SWADDRESS4 as REMITPTY_SWADDRESS4,	REMITPTY.SWADDRESS5 as REMITPTY_SWADDRESS5,	REMITPTY.SWADDRESSF as REMITPTY_SWADDRESSF,	REMITPTY.LIAB_SHARE as REMITPTY_LIAB_SHARE,	REMITPTY.TOTLIABAMT as REMITPTY_TOTLIABAMT,	REMITPTY.TOTLIABCCY as REMITPTY_TOTLIABCCY,	REMITPTY.RSDLIABAMT as REMITPTY_RSDLIABAMT,	REMITPTY.RSDLIABCCY as REMITPTY_RSDLIABCCY,	REMITPTY.OVERRIDDEN as REMITPTY_OVERRIDDEN,	REMITPTY.TAKERNDING as REMITPTY_TAKERNDING,	REMITPTY.REL_P_CNTY as REMITPTY_REL_P_CNTY,	REMITPTY.REL_CUSTYP as REMITPTY_REL_CUSTYP,	REMITPTY.REL_A_CODE as REMITPTY_REL_A_CODE,	REMITPTY.EMAIL as REMITPTY_EMAIL,	REMITPTY.PTNSTARTDT as REMITPTY_PTNSTARTDT,	REMITPTY.TRANSLIT as REMITPTY_TRANSLIT,	REMITPTY.PREF_CCY as REMITPTY_PREF_CCY,	REMITPTY.SUPPR_BILL as REMITPTY_SUPPR_BILL,	REMITPTY.PRI_CCY as REMITPTY_PRI_CCY,	REMITPTY.INT_CCY as REMITPTY_INT_CCY,	REMITPTY.ACTION as REMITPTY_ACTION,	REMITPTY.DATE_MAINT as REMITPTY_DATE_MAINT,	REMITPTY.NOTES1 as REMITPTY_NOTES1,	REMITPTY.NOTES2 as REMITPTY_NOTES2,	REMITPTY.PTNRELEADT as REMITPTY_PTNRELEADT,	SENDTOPTY.KEY97 as SENDTOPTY_KEY97,	SENDTOPTY.ADDR_TYP as SENDTOPTY_ADDR_TYP,	SENDTOPTY.ADDRESS1 as SENDTOPTY_ADDRESS1,	SENDTOPTY.ADDRESS2 as SENDTOPTY_ADDRESS2,	SENDTOPTY.ADDRESS3 as SENDTOPTY_ADDRESS3,	SENDTOPTY.ADDRESS4 as SENDTOPTY_ADDRESS4,	SENDTOPTY.ADDRESS5 as SENDTOPTY_ADDRESS5,	SENDTOPTY.ADDRESSF as SENDTOPTY_ADDRESSF,	SENDTOPTY.LANGUAGE as SENDTOPTY_LANGUAGE,	SENDTOPTY.PHONE as SENDTOPTY_PHONE,	SENDTOPTY.FAX as SENDTOPTY_FAX,	SENDTOPTY.TELEX as SENDTOPTY_TELEX,	SENDTOPTY.SW_BANK as SENDTOPTY_SW_BANK,	SENDTOPTY.SW_CTR as SENDTOPTY_SW_CTR,	SENDTOPTY.SW_LOC as SENDTOPTY_SW_LOC,	SENDTOPTY.SW_BRANCH as SENDTOPTY_SW_BRANCH,	SENDTOPTY.ZIPCODE as SENDTOPTY_ZIPCODE,	SENDTOPTY.SALUTATION as SENDTOPTY_SALUTATION,	SENDTOPTY.TFRMETHOD as SENDTOPTY_TFRMETHOD,	SENDTOPTY.TELEX_ANS as SENDTOPTY_TELEX_ANS,	SENDTOPTY.QUALIFIER as SENDTOPTY_QUALIFIER,	SENDTOPTY.CUS_SBB as SENDTOPTY_CUS_SBB,	SENDTOPTY.CUS_MNM as SENDTOPTY_CUS_MNM,	SENDTOPTY.PTY_TYPE as SENDTOPTY_PTY_TYPE,	SENDTOPTY.ROLE as SENDTOPTY_ROLE,	SENDTOPTY.REFERENCE as SENDTOPTY_REFERENCE,	SENDTOPTY.LIAB_AMT as SENDTOPTY_LIAB_AMT,	SENDTOPTY.LIAB_CCY as SENDTOPTY_LIAB_CCY,	SENDTOPTY.LIAB_PCT as SENDTOPTY_LIAB_PCT,	SENDTOPTY.AMT_OR_PCT as SENDTOPTY_AMT_OR_PCT,	SENDTOPTY.LIAB_ACCT as SENDTOPTY_LIAB_ACCT,	SENDTOPTY.MSTR_PTY as SENDTOPTY_MSTR_PTY,	SENDTOPTY.COUNTRY as SENDTOPTY_COUNTRY,	SENDTOPTY.SWADDRESS1 as SENDTOPTY_SWADDRESS1,	SENDTOPTY.SWADDRESS2 as SENDTOPTY_SWADDRESS2,	SENDTOPTY.SWADDRESS3 as SENDTOPTY_SWADDRESS3,	SENDTOPTY.SWADDRESS4 as SENDTOPTY_SWADDRESS4,	SENDTOPTY.SWADDRESS5 as SENDTOPTY_SWADDRESS5,	SENDTOPTY.SWADDRESSF as SENDTOPTY_SWADDRESSF,	SENDTOPTY.LIAB_SHARE as SENDTOPTY_LIAB_SHARE,	SENDTOPTY.TOTLIABAMT as SENDTOPTY_TOTLIABAMT,	SENDTOPTY.TOTLIABCCY as SENDTOPTY_TOTLIABCCY,	SENDTOPTY.RSDLIABAMT as SENDTOPTY_RSDLIABAMT,	SENDTOPTY.RSDLIABCCY as SENDTOPTY_RSDLIABCCY,	SENDTOPTY.OVERRIDDEN as SENDTOPTY_OVERRIDDEN,	SENDTOPTY.TAKERNDING as SENDTOPTY_TAKERNDING,	SENDTOPTY.REL_P_CNTY as SENDTOPTY_REL_P_CNTY,	SENDTOPTY.REL_CUSTYP as SENDTOPTY_REL_CUSTYP,	SENDTOPTY.REL_A_CODE as SENDTOPTY_REL_A_CODE,	SENDTOPTY.EMAIL as SENDTOPTY_EMAIL,	SENDTOPTY.PTNSTARTDT as SENDTOPTY_PTNSTARTDT,	SENDTOPTY.TRANSLIT as SENDTOPTY_TRANSLIT,	SENDTOPTY.PREF_CCY as SENDTOPTY_PREF_CCY,	SENDTOPTY.SUPPR_BILL as SENDTOPTY_SUPPR_BILL,	SENDTOPTY.PRI_CCY as SENDTOPTY_PRI_CCY,	SENDTOPTY.INT_CCY as SENDTOPTY_INT_CCY,	SENDTOPTY.ACTION as SENDTOPTY_ACTION,	SENDTOPTY.DATE_MAINT as SENDTOPTY_DATE_MAINT,	SENDTOPTY.NOTES1 as SENDTOPTY_NOTES1,	SENDTOPTY.NOTES2 as SENDTOPTY_NOTES2,	SENDTOPTY.PTNRELEADT as SENDTOPTY_PTNRELEADT,	PCPPTY.KEY97 as PCPPTY_KEY97,	PCPPTY.ADDR_TYP as PCPPTY_ADDR_TYP,	PCPPTY.ADDRESS1 as PCPPTY_ADDRESS1,	PCPPTY.ADDRESS2 as PCPPTY_ADDRESS2,	PCPPTY.ADDRESS3 as PCPPTY_ADDRESS3,	PCPPTY.ADDRESS4 as PCPPTY_ADDRESS4,	PCPPTY.ADDRESS5 as PCPPTY_ADDRESS5,	PCPPTY.ADDRESSF as PCPPTY_ADDRESSF,	PCPPTY.LANGUAGE as PCPPTY_LANGUAGE,	PCPPTY.PHONE as PCPPTY_PHONE,	PCPPTY.FAX as PCPPTY_FAX,	PCPPTY.TELEX as PCPPTY_TELEX,	PCPPTY.SW_BANK as PCPPTY_SW_BANK,	PCPPTY.SW_CTR as PCPPTY_SW_CTR,	PCPPTY.SW_LOC as PCPPTY_SW_LOC,	PCPPTY.SW_BRANCH as PCPPTY_SW_BRANCH,	PCPPTY.ZIPCODE as PCPPTY_ZIPCODE,	PCPPTY.SALUTATION as PCPPTY_SALUTATION,	PCPPTY.TFRMETHOD as PCPPTY_TFRMETHOD,	PCPPTY.TELEX_ANS as PCPPTY_TELEX_ANS,	PCPPTY.QUALIFIER as PCPPTY_QUALIFIER,	PCPPTY.CUS_SBB as PCPPTY_CUS_SBB,	PCPPTY.CUS_MNM as PCPPTY_CUS_MNM,	PCPPTY.PTY_TYPE as PCPPTY_PTY_TYPE,	PCPPTY.ROLE as PCPPTY_ROLE,	PCPPTY.REFERENCE as PCPPTY_REFERENCE,	PCPPTY.LIAB_AMT as PCPPTY_LIAB_AMT,	PCPPTY.LIAB_CCY as PCPPTY_LIAB_CCY,	PCPPTY.LIAB_PCT as PCPPTY_LIAB_PCT,	PCPPTY.AMT_OR_PCT as PCPPTY_AMT_OR_PCT,	PCPPTY.LIAB_ACCT as PCPPTY_LIAB_ACCT,	PCPPTY.MSTR_PTY as PCPPTY_MSTR_PTY,	PCPPTY.COUNTRY as PCPPTY_COUNTRY,	PCPPTY.SWADDRESS1 as PCPPTY_SWADDRESS1,	PCPPTY.SWADDRESS2 as PCPPTY_SWADDRESS2,	PCPPTY.SWADDRESS3 as PCPPTY_SWADDRESS3,	PCPPTY.SWADDRESS4 as PCPPTY_SWADDRESS4,	PCPPTY.SWADDRESS5 as PCPPTY_SWADDRESS5,	PCPPTY.SWADDRESSF as PCPPTY_SWADDRESSF,	PCPPTY.LIAB_SHARE as PCPPTY_LIAB_SHARE,	PCPPTY.TOTLIABAMT as PCPPTY_TOTLIABAMT,	PCPPTY.TOTLIABCCY as PCPPTY_TOTLIABCCY,	PCPPTY.RSDLIABAMT as PCPPTY_RSDLIABAMT,	PCPPTY.RSDLIABCCY as PCPPTY_RSDLIABCCY,	PCPPTY.OVERRIDDEN as PCPPTY_OVERRIDDEN,	PCPPTY.TAKERNDING as PCPPTY_TAKERNDING,	PCPPTY.REL_P_CNTY as PCPPTY_REL_P_CNTY,	PCPPTY.REL_CUSTYP as PCPPTY_REL_CUSTYP,	PCPPTY.REL_A_CODE as PCPPTY_REL_A_CODE,	PCPPTY.EMAIL as PCPPTY_EMAIL,	PCPPTY.PTNSTARTDT as PCPPTY_PTNSTARTDT,	PCPPTY.TRANSLIT as PCPPTY_TRANSLIT,	PCPPTY.PREF_CCY as PCPPTY_PREF_CCY,	PCPPTY.SUPPR_BILL as PCPPTY_SUPPR_BILL,	PCPPTY.PRI_CCY as PCPPTY_PRI_CCY,	PCPPTY.INT_CCY as PCPPTY_INT_CCY,	PCPPTY.ACTION as PCPPTY_ACTION,	PCPPTY.DATE_MAINT as PCPPTY_DATE_MAINT,	PCPPTY.NOTES1 as PCPPTY_NOTES1,	PCPPTY.NOTES2 as PCPPTY_NOTES2,	PCPPTY.PTNRELEADT as PCPPTY_PTNRELEADT,	NPCPPTY.KEY97 as NPCPPTY_KEY97,	NPCPPTY.ADDR_TYP as NPCPPTY_ADDR_TYP,	NPCPPTY.ADDRESS1 as NPCPPTY_ADDRESS1,	NPCPPTY.ADDRESS2 as NPCPPTY_ADDRESS2,	NPCPPTY.ADDRESS3 as NPCPPTY_ADDRESS3,	NPCPPTY.ADDRESS4 as NPCPPTY_ADDRESS4,	NPCPPTY.ADDRESS5 as NPCPPTY_ADDRESS5,	NPCPPTY.ADDRESSF as NPCPPTY_ADDRESSF,	NPCPPTY.LANGUAGE as NPCPPTY_LANGUAGE,	NPCPPTY.PHONE as NPCPPTY_PHONE,	NPCPPTY.FAX as NPCPPTY_FAX,	NPCPPTY.TELEX as NPCPPTY_TELEX,	NPCPPTY.SW_BANK as NPCPPTY_SW_BANK,	NPCPPTY.SW_CTR as NPCPPTY_SW_CTR,	NPCPPTY.SW_LOC as NPCPPTY_SW_LOC,	NPCPPTY.SW_BRANCH as NPCPPTY_SW_BRANCH,	NPCPPTY.ZIPCODE as NPCPPTY_ZIPCODE,	NPCPPTY.SALUTATION as NPCPPTY_SALUTATION,	NPCPPTY.TFRMETHOD as NPCPPTY_TFRMETHOD,	NPCPPTY.TELEX_ANS as NPCPPTY_TELEX_ANS,	NPCPPTY.QUALIFIER as NPCPPTY_QUALIFIER,	NPCPPTY.CUS_SBB as NPCPPTY_CUS_SBB,	NPCPPTY.CUS_MNM as NPCPPTY_CUS_MNM,	NPCPPTY.PTY_TYPE as NPCPPTY_PTY_TYPE,	NPCPPTY.ROLE as NPCPPTY_ROLE,	NPCPPTY.REFERENCE as NPCPPTY_REFERENCE,	NPCPPTY.LIAB_AMT as NPCPPTY_LIAB_AMT,	NPCPPTY.LIAB_CCY as NPCPPTY_LIAB_CCY,	NPCPPTY.LIAB_PCT as NPCPPTY_LIAB_PCT,	NPCPPTY.AMT_OR_PCT as NPCPPTY_AMT_OR_PCT,	NPCPPTY.LIAB_ACCT as NPCPPTY_LIAB_ACCT,	NPCPPTY.MSTR_PTY as NPCPPTY_MSTR_PTY,	NPCPPTY.COUNTRY as NPCPPTY_COUNTRY,	NPCPPTY.SWADDRESS1 as NPCPPTY_SWADDRESS1,	NPCPPTY.SWADDRESS2 as NPCPPTY_SWADDRESS2,	NPCPPTY.SWADDRESS3 as NPCPPTY_SWADDRESS3,	NPCPPTY.SWADDRESS4 as NPCPPTY_SWADDRESS4,	NPCPPTY.SWADDRESS5 as NPCPPTY_SWADDRESS5,	NPCPPTY.SWADDRESSF as NPCPPTY_SWADDRESSF,	NPCPPTY.LIAB_SHARE as NPCPPTY_LIAB_SHARE,	NPCPPTY.TOTLIABAMT as NPCPPTY_TOTLIABAMT,	NPCPPTY.TOTLIABCCY as NPCPPTY_TOTLIABCCY,	NPCPPTY.RSDLIABAMT as NPCPPTY_RSDLIABAMT,	NPCPPTY.RSDLIABCCY as NPCPPTY_RSDLIABCCY,	NPCPPTY.OVERRIDDEN as NPCPPTY_OVERRIDDEN,	NPCPPTY.TAKERNDING as NPCPPTY_TAKERNDING,	NPCPPTY.REL_P_CNTY as NPCPPTY_REL_P_CNTY,	NPCPPTY.REL_CUSTYP as NPCPPTY_REL_CUSTYP,	NPCPPTY.REL_A_CODE as NPCPPTY_REL_A_CODE,	NPCPPTY.EMAIL as NPCPPTY_EMAIL,	NPCPPTY.PTNSTARTDT as NPCPPTY_PTNSTARTDT,	NPCPPTY.TRANSLIT as NPCPPTY_TRANSLIT,	NPCPPTY.PREF_CCY as NPCPPTY_PREF_CCY,	NPCPPTY.SUPPR_BILL as NPCPPTY_SUPPR_BILL,	NPCPPTY.PRI_CCY as NPCPPTY_PRI_CCY,	NPCPPTY.INT_CCY as NPCPPTY_INT_CCY,	NPCPPTY.ACTION as NPCPPTY_ACTION,	NPCPPTY.DATE_MAINT as NPCPPTY_DATE_MAINT,	NPCPPTY.NOTES1 as NPCPPTY_NOTES1,	NPCPPTY.NOTES2 as NPCPPTY_NOTES2,	NPCPPTY.PTNRELEADT as NPCPPTY_PTNRELEADT,	PAYCCY.C8CCY as PAYCCY_C8CCY,	PAYCCY.C8CCYN as PAYCCY_C8CCYN,	PAYCCY.C8SCY as PAYCCY_C8SCY,	PAYCCY.C8CED as PAYCCY_C8CED,	PAYCCY.C8CUR as PAYCCY_C8CUR,	PAYCCY.C8PSEI as PAYCCY_C8PSEI,	PAYCCY.C8IDBD as PAYCCY_C8IDBD,	PAYCCY.C8IDBC as PAYCCY_C8IDBC,	PAYCCY.C8SRI as PAYCCY_C8SRI,	PAYCCY.C8DFC as PAYCCY_C8DFC,	PAYCCY.C8ITC as PAYCCY_C8ITC,	PAYCCY.C8RFI as PAYCCY_C8RFI,	PAYCCY.C8SPT as PAYCCY_C8SPT,	PAYCCY.C8SEI as PAYCCY_C8SEI,	PAYCCY.C8NU1S as PAYCCY_C8NU1S,	PAYCCY.C8NU1O as PAYCCY_C8NU1O,	PAYCCY.C8MBR as PAYCCY_C8MBR,	PAYCCY.C8GRP as PAYCCY_C8GRP,	PAYCCY.C8BSEI as PAYCCY_C8BSEI,	PAYCCY.C8BSPT as PAYCCY_C8BSPT,	PAYCCY.C8PSPT as PAYCCY_C8PSPT,	PAYCCY.C8MCD as PAYCCY_C8MCD,	PAYCCY.MNT_IN_BO as PAYCCY_MNT_IN_BO,	RCVCCY.C8CCY as RCVCCY_C8CCY,	RCVCCY.C8CCYN as RCVCCY_C8CCYN,	RCVCCY.C8SCY as RCVCCY_C8SCY,	RCVCCY.C8CED as RCVCCY_C8CED,	RCVCCY.C8CUR as RCVCCY_C8CUR,	RCVCCY.C8PSEI as RCVCCY_C8PSEI,	RCVCCY.C8IDBD as RCVCCY_C8IDBD,	RCVCCY.C8IDBC as RCVCCY_C8IDBC,	RCVCCY.C8SRI as RCVCCY_C8SRI,	RCVCCY.C8DFC as RCVCCY_C8DFC,	RCVCCY.C8ITC as RCVCCY_C8ITC,	RCVCCY.C8RFI as RCVCCY_C8RFI,	RCVCCY.C8SPT as RCVCCY_C8SPT,	RCVCCY.C8SEI as RCVCCY_C8SEI,	RCVCCY.C8NU1S as RCVCCY_C8NU1S,	RCVCCY.C8NU1O as RCVCCY_C8NU1O,	RCVCCY.C8MBR as RCVCCY_C8MBR,	RCVCCY.C8GRP as RCVCCY_C8GRP,	RCVCCY.C8BSEI as RCVCCY_C8BSEI,	RCVCCY.C8BSPT as RCVCCY_C8BSPT,	RCVCCY.C8PSPT as RCVCCY_C8PSPT,	RCVCCY.C8MCD as RCVCCY_C8MCD,	RCVCCY.MNT_IN_BO as RCVCCY_MNT_IN_BO,	payspot.BRANCH as payspot_BRANCH,	payspot.CURRENCY as payspot_CURRENCY,	payspot.SPOTRATE as payspot_SPOTRATE,	payspot.RECIPROCAL as payspot_RECIPROCAL,	payspot.PREV_RATE as payspot_PREV_RATE,	payspot.PREV_RECIP as payspot_PREV_RECIP,	payspot.NONTRADE as payspot_NONTRADE,	payspot.QUOTEUNIT as payspot_QUOTEUNIT,	payspot.MNT_IN_BO as payspot_MNT_IN_BO,	payspot.TYPEFLAG as payspot_TYPEFLAG,	payspot.TSTAMP as payspot_TSTAMP,	rcvspot.BRANCH as rcvspot_BRANCH,	rcvspot.CURRENCY as rcvspot_CURRENCY,	rcvspot.SPOTRATE as rcvspot_SPOTRATE,	rcvspot.RECIPROCAL as rcvspot_RECIPROCAL,	rcvspot.PREV_RATE as rcvspot_PREV_RATE,	rcvspot.PREV_RECIP as rcvspot_PREV_RECIP,	rcvspot.NONTRADE as rcvspot_NONTRADE,	rcvspot.QUOTEUNIT as rcvspot_QUOTEUNIT,	rcvspot.MNT_IN_BO as rcvspot_MNT_IN_BO,	rcvspot.TYPEFLAG as rcvspot_TYPEFLAG,	rcvspot.TSTAMP as rcvspot_TSTAMP,
--PAYSETTLE.KEY97 as PAYSETTLE_KEY97,	PAYSETTLE.SETTLE_PTY as PAYSETTLE_SETTLE_PTY,	PAYSETTLE.PAY_REC as PAYSETTLE_PAY_REC,	PAYSETTLE.CCY as PAYSETTLE_CCY,	PAYSETTLE.MOVEMENT as PAYSETTLE_MOVEMENT,	PAYSETTLE.NOSTRO_MBE as PAYSETTLE_NOSTRO_MBE,	PAYSETTLE.NOSTRO as PAYSETTLE_NOSTRO,	PAYSETTLE.TIMEDET2_1 as PAYSETTLE_TIMEDET2_1,	PAYSETTLE.TIMECOD2_1 as PAYSETTLE_TIMECOD2_1,	PAYSETTLE.TIMEDET3_1 as PAYSETTLE_TIMEDET3_1,	PAYSETTLE.TIMECOD3_1 as PAYSETTLE_TIMECOD3_1,	PAYSETTLE.TIMEDET1_1 as PAYSETTLE_TIMEDET1_1,	PAYSETTLE.TIMECOD1_1 as PAYSETTLE_TIMECOD1_1,	PAYSETTLE.ACCT_NO as PAYSETTLE_ACCT_NO,	PAYSETTLE.TFR_METHOD as PAYSETTLE_TFR_METHOD,	PAYSETTLE.SHAREDAGT as PAYSETTLE_SHAREDAGT,	PAYSETTLE.NARRATIVE as PAYSETTLE_NARRATIVE,	PAYSETTLE.AGENT_NO as PAYSETTLE_AGENT_NO,	PAYSETTLE.USERCODE1 as PAYSETTLE_USERCODE1,	PAYSETTLE.USERCODE2 as PAYSETTLE_USERCODE2,	PAYSETTLE.USERCODE3 as PAYSETTLE_USERCODE3,	PAYSETTLE.ADDPAYINST as PAYSETTLE_ADDPAYINST,	PAYSETTLE.AGENT_SBB as PAYSETTLE_AGENT_SBB,	PAYSETTLE.AGENT_MNM as PAYSETTLE_AGENT_MNM,	PAYSETTLE.AGENT_SWB as PAYSETTLE_AGENT_SWB,	PAYSETTLE.AGENT_SWC as PAYSETTLE_AGENT_SWC,	PAYSETTLE.AGENT_SWL as PAYSETTLE_AGENT_SWL,	PAYSETTLE.AGENT_SWR as PAYSETTLE_AGENT_SWR,	PAYSETTLE.AGENT_ACC as PAYSETTLE_AGENT_ACC,	PAYSETTLE.ADDR_L1 as PAYSETTLE_ADDR_L1,	PAYSETTLE.ADDR_L2 as PAYSETTLE_ADDR_L2,	PAYSETTLE.ADDR_L3 as PAYSETTLE_ADDR_L3,	PAYSETTLE.ADDR_L4 as PAYSETTLE_ADDR_L4,	PAYSETTLE.SSI_A_TLIT as PAYSETTLE_SSI_A_TLIT,	PAYSETTLE.VIANOSTRO as PAYSETTLE_VIANOSTRO,	PAYSETTLE.SLL_SBB as PAYSETTLE_SLL_SBB,	PAYSETTLE.SLL_MNM as PAYSETTLE_SLL_MNM,	PAYSETTLE.SLL_SBANK as PAYSETTLE_SLL_SBANK,	PAYSETTLE.SLL_SCTR as PAYSETTLE_SLL_SCTR,	PAYSETTLE.SLL_SLOC as PAYSETTLE_SLL_SLOC,	PAYSETTLE.SLL_SBRN as PAYSETTLE_SLL_SBRN,	PAYSETTLE.SLL_ACC as PAYSETTLE_SLL_ACC,	PAYSETTLE.SLL_NA1 as PAYSETTLE_SLL_NA1,	PAYSETTLE.SLL_NA2 as PAYSETTLE_SLL_NA2,	PAYSETTLE.SLL_NA3 as PAYSETTLE_SLL_NA3,	PAYSETTLE.SLL_NA4 as PAYSETTLE_SLL_NA4,	PAYSETTLE.SLL_TLIT as PAYSETTLE_SLL_TLIT,	PAYSETTLE.CLEARMBE as PAYSETTLE_CLEARMBE,	PAYSETTLE.CLEARID as PAYSETTLE_CLEARID,	PAYSETTLE.IMED_ACNO as PAYSETTLE_IMED_ACNO,	PAYSETTLE.TIMEDET2_2 as PAYSETTLE_TIMEDET2_2,	PAYSETTLE.TIMECOD2_2 as PAYSETTLE_TIMECOD2_2,	PAYSETTLE.TIMEDET3_2 as PAYSETTLE_TIMEDET3_2,	PAYSETTLE.TIMECOD3_2 as PAYSETTLE_TIMECOD3_2,	PAYSETTLE.TIMEDET1_2 as PAYSETTLE_TIMEDET1_2,	PAYSETTLE.TIMECOD1_2 as PAYSETTLE_TIMECOD1_2,	PAYSETTLE.TIMEDET2 as PAYSETTLE_TIMEDET2,	PAYSETTLE.TIMECODE2 as PAYSETTLE_TIMECODE2,	PAYSETTLE.TIMEDET3 as PAYSETTLE_TIMEDET3,	PAYSETTLE.TIMECODE3 as PAYSETTLE_TIMECODE3,	PAYSETTLE.TIMEDET1 as PAYSETTLE_TIMEDET1,	PAYSETTLE.TIMECODE1 as PAYSETTLE_TIMECODE1,	PAYSETTLE.SDRRECINFO as PAYSETTLE_SDRRECINFO,	PAYSETTLE.SW_CHGFOR as PAYSETTLE_SW_CHGFOR,	PAYSETTLE.AUTOCH53 as PAYSETTLE_AUTOCH53,	PAYSETTLE.IMED_SBB as PAYSETTLE_IMED_SBB,	PAYSETTLE.IMED_MNM as PAYSETTLE_IMED_MNM,	PAYSETTLE.IMED_SWBK as PAYSETTLE_IMED_SWBK,	PAYSETTLE.IMED_SWC as PAYSETTLE_IMED_SWC,	PAYSETTLE.IMED_SWLOC as PAYSETTLE_IMED_SWLOC,	PAYSETTLE.IMED_SWBRN as PAYSETTLE_IMED_SWBRN,	PAYSETTLE.IMED_ACC as PAYSETTLE_IMED_ACC,	PAYSETTLE.IMED_ADDR1 as PAYSETTLE_IMED_ADDR1,	PAYSETTLE.IMED_ADDR2 as PAYSETTLE_IMED_ADDR2,	PAYSETTLE.IMED_ADDR3 as PAYSETTLE_IMED_ADDR3,	PAYSETTLE.IMED_ADDR4 as PAYSETTLE_IMED_ADDR4,	PAYSETTLE.AP_I_TLIT as PAYSETTLE_AP_I_TLIT,	PAYSETTLE.PYMT_DETLS as PAYSETTLE_PYMT_DETLS,	PAYSETTLE.ORDCUS_SBB as PAYSETTLE_ORDCUS_SBB,	PAYSETTLE.ORDCUS_CST as PAYSETTLE_ORDCUS_CST,	PAYSETTLE.OC_BICBANK as PAYSETTLE_OC_BICBANK,	PAYSETTLE.OC_SW_CTRY as PAYSETTLE_OC_SW_CTRY,	PAYSETTLE.OC_SW_LOCN as PAYSETTLE_OC_SW_LOCN,	PAYSETTLE.OC_SW_BCH as PAYSETTLE_OC_SW_BCH,	PAYSETTLE.OC_SW_ACC as PAYSETTLE_OC_SW_ACC,	PAYSETTLE.OC_NM_ADD1 as PAYSETTLE_OC_NM_ADD1,	PAYSETTLE.OC_NM_ADD2 as PAYSETTLE_OC_NM_ADD2,	PAYSETTLE.OC_NM_ADD3 as PAYSETTLE_OC_NM_ADD3,	PAYSETTLE.OC_NM_ADD4 as PAYSETTLE_OC_NM_ADD4,	PAYSETTLE.AP_OC_TLIT as PAYSETTLE_AP_OC_TLIT,	PAYSETTLE.SETTLES_BY as PAYSETTLE_SETTLES_BY,	PAYSETTLE.RC_CUSTSBB as PAYSETTLE_RC_CUSTSBB,	PAYSETTLE.RC_CUST as PAYSETTLE_RC_CUST,	PAYSETTLE.RC_SW_BANK as PAYSETTLE_RC_SW_BANK,	PAYSETTLE.RC_SW_CTRY as PAYSETTLE_RC_SW_CTRY,	PAYSETTLE.RC_SW_LCTN as PAYSETTLE_RC_SW_LCTN,	PAYSETTLE.RC_SW_BRCH as PAYSETTLE_RC_SW_BRCH,	PAYSETTLE.RC_SW_ACC as PAYSETTLE_RC_SW_ACC,	PAYSETTLE.RC_NM_ADD1 as PAYSETTLE_RC_NM_ADD1,	PAYSETTLE.RC_NM_ADD2 as PAYSETTLE_RC_NM_ADD2,	PAYSETTLE.RC_NM_ADD3 as PAYSETTLE_RC_NM_ADD3,	PAYSETTLE.RC_NM_ADD4 as PAYSETTLE_RC_NM_ADD4,	PAYSETTLE.AP_RC_TLIT as PAYSETTLE_AP_RC_TLIT,	PAYSETTLE.CVRTFRMTHD as PAYSETTLE_CVRTFRMTHD,	PAYSETTLE.RC_ACC_NO as PAYSETTLE_RC_ACC_NO,	PAYSETTLE.IR_CUSTSBB as PAYSETTLE_IR_CUSTSBB,	PAYSETTLE.IR_CUST as PAYSETTLE_IR_CUST,	PAYSETTLE.IR_SW_BANK as PAYSETTLE_IR_SW_BANK,	PAYSETTLE.IR_SW_CTRY as PAYSETTLE_IR_SW_CTRY,	PAYSETTLE.IR_SW_LCTN as PAYSETTLE_IR_SW_LCTN,	PAYSETTLE.IR_SW_BRCH as PAYSETTLE_IR_SW_BRCH,	PAYSETTLE.IR_SW_ACC as PAYSETTLE_IR_SW_ACC,	PAYSETTLE.IR_NM_ADD1 as PAYSETTLE_IR_NM_ADD1,	PAYSETTLE.IR_NM_ADD2 as PAYSETTLE_IR_NM_ADD2,	PAYSETTLE.IR_NM_ADD3 as PAYSETTLE_IR_NM_ADD3,	PAYSETTLE.IR_NM_ADD4 as PAYSETTLE_IR_NM_ADD4,	PAYSETTLE.AP_IRBTLIT as PAYSETTLE_AP_IRBTLIT,	PAYSETTLE.MSG_TYPE as PAYSETTLE_MSG_TYPE,	PAYSETTLE.RGLTRY_REP as PAYSETTLE_RGLTRY_REP,	PAYSETTLE.TRANS_TYPE as PAYSETTLE_TRANS_TYPE,	PAYSETTLE.CHG1_AMT as PAYSETTLE_CHG1_AMT,	PAYSETTLE.CHG1_CCY as PAYSETTLE_CHG1_CCY,	PAYSETTLE.CHG2_AMT as PAYSETTLE_CHG2_AMT,	PAYSETTLE.CHG2_CCY as PAYSETTLE_CHG2_CCY,	PAYSETTLE.CHG3_AMT as PAYSETTLE_CHG3_AMT,	PAYSETTLE.CHG3_CCY as PAYSETTLE_CHG3_CCY,	PAYSETTLE.CHG4_AMT as PAYSETTLE_CHG4_AMT,	PAYSETTLE.CHG4_CCY as PAYSETTLE_CHG4_CCY,	PAYSETTLE.CHG5_AMT as PAYSETTLE_CHG5_AMT,	PAYSETTLE.CHG5_CCY as PAYSETTLE_CHG5_CCY,	PAYSETTLE.CHG6_AMT as PAYSETTLE_CHG6_AMT,	PAYSETTLE.CHG6_CCY as PAYSETTLE_CHG6_CCY,	PAYSETTLE.INST_EXRAT as PAYSETTLE_INST_EXRAT,	PAYSETTLE.INST1_TEXT as PAYSETTLE_INST1_TEXT,	PAYSETTLE.INST1_CODE as PAYSETTLE_INST1_CODE,	PAYSETTLE.INST2_TEXT as PAYSETTLE_INST2_TEXT,	PAYSETTLE.INST2_CODE as PAYSETTLE_INST2_CODE,	PAYSETTLE.INST3_TEXT as PAYSETTLE_INST3_TEXT,	PAYSETTLE.INST3_CODE as PAYSETTLE_INST3_CODE,	PAYSETTLE.INST4_TEXT as PAYSETTLE_INST4_TEXT,	PAYSETTLE.INST4_CODE as PAYSETTLE_INST4_CODE,	PAYSETTLE.INST5_TEXT as PAYSETTLE_INST5_TEXT,	PAYSETTLE.INST5_CODE as PAYSETTLE_INST5_CODE,	PAYSETTLE.INST6_TEXT as PAYSETTLE_INST6_TEXT,	PAYSETTLE.INST6_CODE as PAYSETTLE_INST6_CODE,	PAYSETTLE.INST_AMT as PAYSETTLE_INST_AMT,	PAYSETTLE.INST_CCY as PAYSETTLE_INST_CCY,	PAYSETTLE.SRVC_LEVEL as PAYSETTLE_SRVC_LEVEL,	PAYSETTLE.CHEQUE44 as PAYSETTLE_CHEQUE44,	PAYSETTLE.IR_ACC_NO as PAYSETTLE_IR_ACC_NO,	PAYSETTLE.AW_ACC_NO as PAYSETTLE_AW_ACC_NO,	PAYSETTLE.CVR_STR as PAYSETTLE_CVR_STR,	PAYSETTLE.SETTLE_CCY as PAYSETTLE_SETTLE_CCY,	RCVSETTLE.KEY97 as RCVSETTLE_KEY97,	RCVSETTLE.SETTLE_PTY as RCVSETTLE_SETTLE_PTY,	RCVSETTLE.PAY_REC as RCVSETTLE_PAY_REC,	RCVSETTLE.CCY as RCVSETTLE_CCY,	RCVSETTLE.MOVEMENT as RCVSETTLE_MOVEMENT,	RCVSETTLE.NOSTRO_MBE as RCVSETTLE_NOSTRO_MBE,	RCVSETTLE.NOSTRO as RCVSETTLE_NOSTRO,	RCVSETTLE.TIMEDET2_1 as RCVSETTLE_TIMEDET2_1,	RCVSETTLE.TIMECOD2_1 as RCVSETTLE_TIMECOD2_1,	RCVSETTLE.TIMEDET3_1 as RCVSETTLE_TIMEDET3_1,	RCVSETTLE.TIMECOD3_1 as RCVSETTLE_TIMECOD3_1,	RCVSETTLE.TIMEDET1_1 as RCVSETTLE_TIMEDET1_1,	RCVSETTLE.TIMECOD1_1 as RCVSETTLE_TIMECOD1_1,	RCVSETTLE.ACCT_NO as RCVSETTLE_ACCT_NO,	RCVSETTLE.TFR_METHOD as RCVSETTLE_TFR_METHOD,	RCVSETTLE.SHAREDAGT as RCVSETTLE_SHAREDAGT,	RCVSETTLE.NARRATIVE as RCVSETTLE_NARRATIVE,	RCVSETTLE.AGENT_NO as RCVSETTLE_AGENT_NO,	RCVSETTLE.USERCODE1 as RCVSETTLE_USERCODE1,	RCVSETTLE.USERCODE2 as RCVSETTLE_USERCODE2,	RCVSETTLE.USERCODE3 as RCVSETTLE_USERCODE3,	RCVSETTLE.ADDPAYINST as RCVSETTLE_ADDPAYINST,	RCVSETTLE.AGENT_SBB as RCVSETTLE_AGENT_SBB,	RCVSETTLE.AGENT_MNM as RCVSETTLE_AGENT_MNM,	RCVSETTLE.AGENT_SWB as RCVSETTLE_AGENT_SWB,	RCVSETTLE.AGENT_SWC as RCVSETTLE_AGENT_SWC,	RCVSETTLE.AGENT_SWL as RCVSETTLE_AGENT_SWL,	RCVSETTLE.AGENT_SWR as RCVSETTLE_AGENT_SWR,	RCVSETTLE.AGENT_ACC as RCVSETTLE_AGENT_ACC,	RCVSETTLE.ADDR_L1 as RCVSETTLE_ADDR_L1,	RCVSETTLE.ADDR_L2 as RCVSETTLE_ADDR_L2,	RCVSETTLE.ADDR_L3 as RCVSETTLE_ADDR_L3,	RCVSETTLE.ADDR_L4 as RCVSETTLE_ADDR_L4,	RCVSETTLE.SSI_A_TLIT as RCVSETTLE_SSI_A_TLIT,	RCVSETTLE.VIANOSTRO as RCVSETTLE_VIANOSTRO,	RCVSETTLE.SLL_SBB as RCVSETTLE_SLL_SBB,	RCVSETTLE.SLL_MNM as RCVSETTLE_SLL_MNM,	RCVSETTLE.SLL_SBANK as RCVSETTLE_SLL_SBANK,	RCVSETTLE.SLL_SCTR as RCVSETTLE_SLL_SCTR,	RCVSETTLE.SLL_SLOC as RCVSETTLE_SLL_SLOC,	RCVSETTLE.SLL_SBRN as RCVSETTLE_SLL_SBRN,	RCVSETTLE.SLL_ACC as RCVSETTLE_SLL_ACC,	RCVSETTLE.SLL_NA1 as RCVSETTLE_SLL_NA1,	RCVSETTLE.SLL_NA2 as RCVSETTLE_SLL_NA2,	RCVSETTLE.SLL_NA3 as RCVSETTLE_SLL_NA3,	RCVSETTLE.SLL_NA4 as RCVSETTLE_SLL_NA4,	RCVSETTLE.SLL_TLIT as RCVSETTLE_SLL_TLIT,	RCVSETTLE.CLEARMBE as RCVSETTLE_CLEARMBE,	RCVSETTLE.CLEARID as RCVSETTLE_CLEARID,	RCVSETTLE.IMED_ACNO as RCVSETTLE_IMED_ACNO,	RCVSETTLE.TIMEDET2_2 as RCVSETTLE_TIMEDET2_2,	RCVSETTLE.TIMECOD2_2 as RCVSETTLE_TIMECOD2_2,	RCVSETTLE.TIMEDET3_2 as RCVSETTLE_TIMEDET3_2,	RCVSETTLE.TIMECOD3_2 as RCVSETTLE_TIMECOD3_2,	RCVSETTLE.TIMEDET1_2 as RCVSETTLE_TIMEDET1_2,	RCVSETTLE.TIMECOD1_2 as RCVSETTLE_TIMECOD1_2,	RCVSETTLE.TIMEDET2 as RCVSETTLE_TIMEDET2,	RCVSETTLE.TIMECODE2 as RCVSETTLE_TIMECODE2,	RCVSETTLE.TIMEDET3 as RCVSETTLE_TIMEDET3,	RCVSETTLE.TIMECODE3 as RCVSETTLE_TIMECODE3,	RCVSETTLE.TIMEDET1 as RCVSETTLE_TIMEDET1,	RCVSETTLE.TIMECODE1 as RCVSETTLE_TIMECODE1,	RCVSETTLE.SDRRECINFO as RCVSETTLE_SDRRECINFO,	RCVSETTLE.SW_CHGFOR as RCVSETTLE_SW_CHGFOR,	RCVSETTLE.AUTOCH53 as RCVSETTLE_AUTOCH53,	RCVSETTLE.IMED_SBB as RCVSETTLE_IMED_SBB,	RCVSETTLE.IMED_MNM as RCVSETTLE_IMED_MNM,	RCVSETTLE.IMED_SWBK as RCVSETTLE_IMED_SWBK,	RCVSETTLE.IMED_SWC as RCVSETTLE_IMED_SWC,	RCVSETTLE.IMED_SWLOC as RCVSETTLE_IMED_SWLOC,	RCVSETTLE.IMED_SWBRN as RCVSETTLE_IMED_SWBRN,	RCVSETTLE.IMED_ACC as RCVSETTLE_IMED_ACC,	RCVSETTLE.IMED_ADDR1 as RCVSETTLE_IMED_ADDR1,	RCVSETTLE.IMED_ADDR2 as RCVSETTLE_IMED_ADDR2,	RCVSETTLE.IMED_ADDR3 as RCVSETTLE_IMED_ADDR3,	RCVSETTLE.IMED_ADDR4 as RCVSETTLE_IMED_ADDR4,	RCVSETTLE.AP_I_TLIT as RCVSETTLE_AP_I_TLIT,	RCVSETTLE.PYMT_DETLS as RCVSETTLE_PYMT_DETLS,	RCVSETTLE.ORDCUS_SBB as RCVSETTLE_ORDCUS_SBB,	RCVSETTLE.ORDCUS_CST as RCVSETTLE_ORDCUS_CST,	RCVSETTLE.OC_BICBANK as RCVSETTLE_OC_BICBANK,	RCVSETTLE.OC_SW_CTRY as RCVSETTLE_OC_SW_CTRY,	RCVSETTLE.OC_SW_LOCN as RCVSETTLE_OC_SW_LOCN,	RCVSETTLE.OC_SW_BCH as RCVSETTLE_OC_SW_BCH,	RCVSETTLE.OC_SW_ACC as RCVSETTLE_OC_SW_ACC,	RCVSETTLE.OC_NM_ADD1 as RCVSETTLE_OC_NM_ADD1,	RCVSETTLE.OC_NM_ADD2 as RCVSETTLE_OC_NM_ADD2,	RCVSETTLE.OC_NM_ADD3 as RCVSETTLE_OC_NM_ADD3,	RCVSETTLE.OC_NM_ADD4 as RCVSETTLE_OC_NM_ADD4,	RCVSETTLE.AP_OC_TLIT as RCVSETTLE_AP_OC_TLIT,	RCVSETTLE.SETTLES_BY as RCVSETTLE_SETTLES_BY,	RCVSETTLE.RC_CUSTSBB as RCVSETTLE_RC_CUSTSBB,	RCVSETTLE.RC_CUST as RCVSETTLE_RC_CUST,	RCVSETTLE.RC_SW_BANK as RCVSETTLE_RC_SW_BANK,	RCVSETTLE.RC_SW_CTRY as RCVSETTLE_RC_SW_CTRY,	RCVSETTLE.RC_SW_LCTN as RCVSETTLE_RC_SW_LCTN,	RCVSETTLE.RC_SW_BRCH as RCVSETTLE_RC_SW_BRCH,	RCVSETTLE.RC_SW_ACC as RCVSETTLE_RC_SW_ACC,	RCVSETTLE.RC_NM_ADD1 as RCVSETTLE_RC_NM_ADD1,	RCVSETTLE.RC_NM_ADD2 as RCVSETTLE_RC_NM_ADD2,	RCVSETTLE.RC_NM_ADD3 as RCVSETTLE_RC_NM_ADD3,	RCVSETTLE.RC_NM_ADD4 as RCVSETTLE_RC_NM_ADD4,	RCVSETTLE.AP_RC_TLIT as RCVSETTLE_AP_RC_TLIT,	RCVSETTLE.CVRTFRMTHD as RCVSETTLE_CVRTFRMTHD,	RCVSETTLE.RC_ACC_NO as RCVSETTLE_RC_ACC_NO,	RCVSETTLE.IR_CUSTSBB as RCVSETTLE_IR_CUSTSBB,	RCVSETTLE.IR_CUST as RCVSETTLE_IR_CUST,	RCVSETTLE.IR_SW_BANK as RCVSETTLE_IR_SW_BANK,	RCVSETTLE.IR_SW_CTRY as RCVSETTLE_IR_SW_CTRY,	RCVSETTLE.IR_SW_LCTN as RCVSETTLE_IR_SW_LCTN,	RCVSETTLE.IR_SW_BRCH as RCVSETTLE_IR_SW_BRCH,	RCVSETTLE.IR_SW_ACC as RCVSETTLE_IR_SW_ACC,	RCVSETTLE.IR_NM_ADD1 as RCVSETTLE_IR_NM_ADD1,	RCVSETTLE.IR_NM_ADD2 as RCVSETTLE_IR_NM_ADD2,	RCVSETTLE.IR_NM_ADD3 as RCVSETTLE_IR_NM_ADD3,	RCVSETTLE.IR_NM_ADD4 as RCVSETTLE_IR_NM_ADD4,	RCVSETTLE.AP_IRBTLIT as RCVSETTLE_AP_IRBTLIT,	RCVSETTLE.MSG_TYPE as RCVSETTLE_MSG_TYPE,	RCVSETTLE.RGLTRY_REP as RCVSETTLE_RGLTRY_REP,	RCVSETTLE.TRANS_TYPE as RCVSETTLE_TRANS_TYPE,	RCVSETTLE.CHG1_AMT as RCVSETTLE_CHG1_AMT,	RCVSETTLE.CHG1_CCY as RCVSETTLE_CHG1_CCY,	RCVSETTLE.CHG2_AMT as RCVSETTLE_CHG2_AMT,	RCVSETTLE.CHG2_CCY as RCVSETTLE_CHG2_CCY,	RCVSETTLE.CHG3_AMT as RCVSETTLE_CHG3_AMT,	RCVSETTLE.CHG3_CCY as RCVSETTLE_CHG3_CCY,	RCVSETTLE.CHG4_AMT as RCVSETTLE_CHG4_AMT,	RCVSETTLE.CHG4_CCY as RCVSETTLE_CHG4_CCY,	RCVSETTLE.CHG5_AMT as RCVSETTLE_CHG5_AMT,	RCVSETTLE.CHG5_CCY as RCVSETTLE_CHG5_CCY,	RCVSETTLE.CHG6_AMT as RCVSETTLE_CHG6_AMT,	RCVSETTLE.CHG6_CCY as RCVSETTLE_CHG6_CCY,	RCVSETTLE.INST_EXRAT as RCVSETTLE_INST_EXRAT,	RCVSETTLE.INST1_TEXT as RCVSETTLE_INST1_TEXT,	RCVSETTLE.INST1_CODE as RCVSETTLE_INST1_CODE,	RCVSETTLE.INST2_TEXT as RCVSETTLE_INST2_TEXT,	RCVSETTLE.INST2_CODE as RCVSETTLE_INST2_CODE,	RCVSETTLE.INST3_TEXT as RCVSETTLE_INST3_TEXT,	RCVSETTLE.INST3_CODE as RCVSETTLE_INST3_CODE,	RCVSETTLE.INST4_TEXT as RCVSETTLE_INST4_TEXT,	RCVSETTLE.INST4_CODE as RCVSETTLE_INST4_CODE,	RCVSETTLE.INST5_TEXT as RCVSETTLE_INST5_TEXT,	RCVSETTLE.INST5_CODE as RCVSETTLE_INST5_CODE,	RCVSETTLE.INST6_TEXT as RCVSETTLE_INST6_TEXT,	RCVSETTLE.INST6_CODE as RCVSETTLE_INST6_CODE,	RCVSETTLE.INST_AMT as RCVSETTLE_INST_AMT,	RCVSETTLE.INST_CCY as RCVSETTLE_INST_CCY,	RCVSETTLE.SRVC_LEVEL as RCVSETTLE_SRVC_LEVEL,	RCVSETTLE.CHEQUE44 as RCVSETTLE_CHEQUE44,	RCVSETTLE.IR_ACC_NO as RCVSETTLE_IR_ACC_NO,	RCVSETTLE.AW_ACC_NO as RCVSETTLE_AW_ACC_NO,	RCVSETTLE.CVR_STR as RCVSETTLE_CVR_STR,	RCVSETTLE.SETTLE_CCY as RCVSETTLE_SETTLE_CCY,
MTRCPBENPTY.BENPARTY_KEY97 as BENPARTY_KEY97,	MTRCPBENPTY.BENPARTY_ADDR_TYP as BENPARTY_ADDR_TYP,	MTRCPBENPTY.BENPARTY_ADDRESS1 as BENPARTY_ADDRESS1,	MTRCPBENPTY.BENPARTY_ADDRESS2 as BENPARTY_ADDRESS2,	MTRCPBENPTY.BENPARTY_ADDRESS3 as BENPARTY_ADDRESS3,	MTRCPBENPTY.BENPARTY_ADDRESS4 as BENPARTY_ADDRESS4,	MTRCPBENPTY.BENPARTY_ADDRESS5 as BENPARTY_ADDRESS5,	MTRCPBENPTY.BENPARTY_ADDRESSF as BENPARTY_ADDRESSF,	MTRCPBENPTY.BENPARTY_LANGUAGE as BENPARTY_LANGUAGE,	MTRCPBENPTY.BENPARTY_PHONE as BENPARTY_PHONE,	MTRCPBENPTY.BENPARTY_FAX as BENPARTY_FAX,	MTRCPBENPTY.BENPARTY_TELEX as BENPARTY_TELEX,	MTRCPBENPTY.BENPARTY_SW_BANK as BENPARTY_SW_BANK,	MTRCPBENPTY.BENPARTY_SW_CTR as BENPARTY_SW_CTR,	MTRCPBENPTY.BENPARTY_SW_LOC as BENPARTY_SW_LOC,	MTRCPBENPTY.BENPARTY_SW_BRANCH as BENPARTY_SW_BRANCH,	MTRCPBENPTY.BENPARTY_ZIPCODE as BENPARTY_ZIPCODE,	MTRCPBENPTY.BENPARTY_SALUTATION as BENPARTY_SALUTATION,	MTRCPBENPTY.BENPARTY_TFRMETHOD as BENPARTY_TFRMETHOD,	MTRCPBENPTY.BENPARTY_TELEX_ANS as BENPARTY_TELEX_ANS,	MTRCPBENPTY.BENPARTY_QUALIFIER as BENPARTY_QUALIFIER,	MTRCPBENPTY.BENPARTY_CUS_SBB as BENPARTY_CUS_SBB,	MTRCPBENPTY.BENPARTY_CUS_MNM as BENPARTY_CUS_MNM,	MTRCPBENPTY.BENPARTY_PTY_TYPE as BENPARTY_PTY_TYPE,	MTRCPBENPTY.BENPARTY_ROLE as BENPARTY_ROLE,	MTRCPBENPTY.BENPARTY_REFERENCE as BENPARTY_REFERENCE,	MTRCPBENPTY.BENPARTY_LIAB_AMT as BENPARTY_LIAB_AMT,	MTRCPBENPTY.BENPARTY_LIAB_CCY as BENPARTY_LIAB_CCY,	MTRCPBENPTY.BENPARTY_LIAB_PCT as BENPARTY_LIAB_PCT,	MTRCPBENPTY.BENPARTY_AMT_OR_PCT as BENPARTY_AMT_OR_PCT,	MTRCPBENPTY.BENPARTY_LIAB_ACCT as BENPARTY_LIAB_ACCT,	MTRCPBENPTY.BENPARTY_MSTR_PTY as BENPARTY_MSTR_PTY,	MTRCPBENPTY.BENPARTY_COUNTRY as BENPARTY_COUNTRY,	MTRCPBENPTY.BENPARTY_SWADDRESS1 as BENPARTY_SWADDRESS1,	MTRCPBENPTY.BENPARTY_SWADDRESS2 as BENPARTY_SWADDRESS2,	MTRCPBENPTY.BENPARTY_SWADDRESS3 as BENPARTY_SWADDRESS3,	MTRCPBENPTY.BENPARTY_SWADDRESS4 as BENPARTY_SWADDRESS4,	MTRCPBENPTY.BENPARTY_SWADDRESS5 as BENPARTY_SWADDRESS5,	MTRCPBENPTY.BENPARTY_SWADDRESSF as BENPARTY_SWADDRESSF,	MTRCPBENPTY.BENPARTY_LIAB_SHARE as BENPARTY_LIAB_SHARE,	MTRCPBENPTY.BENPARTY_TOTLIABAMT as BENPARTY_TOTLIABAMT,	MTRCPBENPTY.BENPARTY_TOTLIABCCY as BENPARTY_TOTLIABCCY,	MTRCPBENPTY.BENPARTY_RSDLIABAMT as BENPARTY_RSDLIABAMT,	MTRCPBENPTY.BENPARTY_RSDLIABCCY as BENPARTY_RSDLIABCCY,	MTRCPBENPTY.BENPARTY_OVERRIDDEN as BENPARTY_OVERRIDDEN,	MTRCPBENPTY.BENPARTY_TAKERNDING as BENPARTY_TAKERNDING,	MTRCPBENPTY.BENPARTY_REL_P_CNTY as BENPARTY_REL_P_CNTY,	MTRCPBENPTY.BENPARTY_REL_CUSTYP as BENPARTY_REL_CUSTYP,	MTRCPBENPTY.BENPARTY_REL_A_CODE as BENPARTY_REL_A_CODE,	MTRCPBENPTY.BENPARTY_EMAIL as BENPARTY_EMAIL,	MTRCPBENPTY.BENPARTY_PTNSTARTDT as BENPARTY_PTNSTARTDT,	MTRCPBENPTY.BENPARTY_TRANSLIT as BENPARTY_TRANSLIT,	MTRCPBENPTY.BENPARTY_PREF_CCY as BENPARTY_PREF_CCY,	MTRCPBENPTY.BENPARTY_SUPPR_BILL as BENPARTY_SUPPR_BILL,	MTRCPBENPTY.BENPARTY_PRI_CCY as BENPARTY_PRI_CCY,	MTRCPBENPTY.BENPARTY_INT_CCY as BENPARTY_INT_CCY,	MTRCPBENPTY.BENPARTY_ACTION as BENPARTY_ACTION,	MTRCPBENPTY.BENPARTY_DATE_MAINT as BENPARTY_DATE_MAINT,	MTRCPBENPTY.BENPARTY_NOTES1 as BENPARTY_NOTES1,	MTRCPBENPTY.BENPARTY_NOTES2 as BENPARTY_NOTES2,	MTRCPBENPTY.BENPARTY_PTNRELEADT as BENPARTY_PTNRELEADT,CCY.C8CED as CCY_C8CED, gfpf.gfctp1 as gfpf_Cus_Type,
  traceinstr.KEY97 as traceinstr_KEY97,
  traceinstr.MASTER_KEY as traceinstr_MASTER_KEY,
  traceinstr.STATUS as traceinstr_STATUS,
  traceinstr.TRACED_EV  as traceinstr_TRACED_EV,
  payfxrate86.CODE53  as payfxrate86_CODE53,
  payfxrate86.CURREN49 as payfxrate86_CURREN49,
  payfxrate86.BUYEXC03 as payfxrate86_BUYEXC03,
  payfxrate86.SELLEX99 as payfxrate86_SELLEX99,
  mstrfxrate86.CODE53  as mstrfxrate86_CODE53,
  mstrfxrate86.CURREN49 as mstrfxrate86_CURREN49,
  mstrfxrate86.BUYEXC03 as mstrfxrate86_BUYEXC03,
  mstrfxrate86.SELLEX99 as mstrfxrate86_SELLEX99,
  rcvfxrate86.CODE53  as rcvfxrate86_CODE53,
  rcvfxrate86.CURREN49 as rcvfxrate86_CURREN49,
  rcvfxrate86.BUYEXC03 as rcvfxrate86_BUYEXC03,
  rcvfxrate86.BUYSPR07 as rcvfxrate86_BUYSPR07,
  rcvfxrate86.SELLEX99 as rcvfxrate86_SELLEX99,
  provnfxrate86.CODE53  as provnfxrate86_CODE53,
  provnfxrate86.BUYEXC03 as provnfxrate86_BUYEXC03,
  provnfxrate86.SELLEX99 as provnfxrate86_SELLEX99,
  cpaycreate.PAY_AMT as cpaycreate_PAY_AMT,
  cpaycreate.PAY_CCY as cpaycreate_PAY_CCY,
  cpaycreate.RCV_CCY as cpaycreate_RCV_CCY,
  cpaycreate.RATECODE as cpaycreate_RATECODE,
  cpaycreate.RCV_AMT as cpaycreate_RCV_AMT,
  cpaycreate.FXRATE as cpaycreate_FXRATE,
  provnpayCCY.C8CED as provnpayCCY_C8CED,
  extmaster.RATEDIR as  extmaster_RATEDIR,
  define.PROV_EVENT as define_PROV_EVENT,
  payaccount.ext_acctno as payaccount_ext_account,
  rcvaccount.ext_acctno as rcvaccount_ext_account,
  PAYSETTLE.NOSTRO as PAYSETTLE_NOSTRO,
  RCVSETTLE.NOSTRO as RCVSETTLE_NOSTRO,
  PAYSETTLE.OC_NM_ADD1 as PAYSETTLE_OC_NM_ADD1,
  RCVSETTLE.OC_NM_ADD1 as RCVSETTLE_OC_NM_ADD1,
  RCVSETTLE.IR_NM_ADD1 as RCVSETTLE_IR_NM_ADD1,
  RCVSETTLE.PYMT_DETLS as RCVSETTLE_PYMT_DETLS,
  PAYSETTLE.PYMT_DETLS as PAYSETTLE_PYMT_DETLS,
  PRODTYPE.NAME as PRODTYPE_NAME,
  PRODTYPE.DESCRIP as PRODTYPE_DESCRIP


from master
inner join exempl30 EXMMASTER on master.exemplar = EXMMASTER.key97
inner join cpaymaster on master.key97 = cpaymaster.key97
left outer join  extmaster on master.key97 = extmaster.master
left outer join extbalofpay on extmaster.bopay = extbalofpay.bid
inner join c8pf CCY on MASTER.CCY = CCY.c8ccy
inner join baseevent on master.key97 = baseevent.master_key
inner join exempl30 EXMEVENT on baseevent.exemplar = EXMEVENT.key97

inner join mstrsettle paysettle on cpaymaster.pay_si = paysettle.key97
inner join mstrsettle rcvsettle on cpaymaster.receive_si = rcvsettle.key97

left outer join account payaccount on paysettle.acct_no = payaccount.acct_key
left outer join account rcvaccount on rcvsettle.acct_no = rcvaccount.acct_key


inner join partydtls PCPPTY on master.PCP_PTY = PCPPTY.KEY97
inner join partydtls NPCPPTY on master.NPCP_PTY = NPCPPTY.KEY97

inner join partydtls REMITPTY on cpaymaster.REMIT_PTY = REMITPTY.KEY97
inner join partydtls SENDTOPTY on cpaymaster.SENDTO_PTY = SENDTOPTY.KEY97

inner join mtrcpbenpty on master.key97 = mtrcpbenpty.master_key97

inner join c8pf PAYCCY on cpaymaster.pay_ccy = PAYCCY.c8ccy
inner join c8pf RCVCCY on cpaymaster.RCV_CCY = RCVCCY.c8ccy

inner join spotrate payspot on master.REFNO_MBE = payspot.BRANCH and PAYCCY.c8ccy = payspot.currency
inner join spotrate rcvspot on master.REFNO_MBE = rcvspot.BRANCH and RCVCCY.c8ccy = rcvspot.currency
left outer join fxrate86 payfxrate86 on extmaster.ratecode = payfxrate86.code53  and  PAYCCY.c8ccy = payfxrate86.curren49
left outer join fxrate86 rcvfxrate86 on extmaster.ratecode = rcvfxrate86.code53  and  RCVCCY.c8ccy = rcvfxrate86.curren49
left outer join fxrate86 mstrfxrate86 on extmaster.ratecode = mstrfxrate86.code53  and  master.ccy = mstrfxrate86.curren49
left outer join cpaycreate on baseevent.key97 = cpaycreate.key97
left outer join fxrate86 provnfxrate86 on cpaycreate.ratecode = provnfxrate86.code53  and  cpaycreate.pay_ccy = provnfxrate86.curren49
left outer join c8pf provnpayCCY on cpaycreate.PAY_CCY = provnpayCCY.c8ccy
left outer join gfpf on SENDTOPTY.CUS_SBB  = gfpf.gfcus1_sbb and  sendtopty.cus_mnm = gfpf.gfcus1
left outer join traceinstr  on master.key97 = traceinstr.master_key
left outer join define on baseevent.key97 = define.key97
left outer join prodtype on master.prodtype =prodtype.key97
 )