Queries:
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1001 WITH WORKING.BALANCE GT 1000 ONLY
LIST FBNK.AA.ACCOUNT.DETAILS WITH ARR.AGE.STATUS EQ 'EXPIRED' ARRANGEMENT.ID
ARR.AGE.STATUS
LIST FBNK.AA.ARRANGEMENT.ACTIVITY
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1001 CUSTOMER.NO CATEGORY JOINT.HOLDER
POSTING.RESTRICT
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 590 ONLY - MMA
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 590 AND INCM.VERIFIED EQ Y
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 902 ONLY - SJP
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 902 AND INCM.VERIFIED EQ Y
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 705 AND BADGE.COLOUR EQ BLUE ONLY - US
Embassy
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 705 AND INCM.VERIFIED EQ Y
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 2001 ONLY - Retail
LIST FBNK.CUSTOMER WITH ACCOUNT.OFFICER EQ 1 AND INCM.VERIFIED EQ Y
LIST FBNK.AA.ACCOUNT.DETAILS ARR.AGE.STATUS
LIST FBNK.CUSTOMER WITH L.CORP.TYPE EQ SME
LIST FBNK.CUSTOMER WITH L.CORP.TYPE EQ COR
LIST FBNK.ACCOUNT WITH CATERGORY EQ _____ CUSTOMER.NO WORKING.BALANCE
LIST FBNK.ACCOUNT WITH CATERGORY EQ 6226 CUSTOMER.NO
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1001 AND CURRENCY EQ GBP WITH WORKING BALANCE GT
200000000 ONLY
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1015 AND CURRENCY EQ AED WITH WORKING BALANCE GT
1000 ONLY
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1015 AND CURRENCY EQ USD WITH WORKING.BALANCE GT
1000 ONLY
LIST FBNK.ACCOUNT WITH CATEGORY EQ 1015 AND CURRENCY EQ EUR WITH WORKING BALANCE GT
1000 ONLY
LIST FBNK.ACCOUNT '62845864' CUSTOMER CATEGORY JOINT.HOLDER LIMIT.REF
WORKING.BALANCE LOPS.MAX.LMT POSTING.RESTRICT
LIST FBNK.METRO.CARD.MANAGE '12345678' CARD.HOLDER STATUS
LIST F.METRO.CHANGED.PRIM.CUS ACTION.REQ OLD.PRIM.CUSTOMER NEW.PRIM.CUSTOMER
ACTION.TAKEN INPUTTER DATE.TIME
LIST FBNK.STANDING.ORDER$HIS LIKE 12345678... ORDERING.CUST INPUTTER DATE.TIME
LIST FBNK.STANDING.ORDER LIKE 62889314... ORDERING.CUST INPUTTER DATE.TIME
LIST FBNK.DD.DDI LIKE 12345678... CUSTOMER.NO INPUTTER
LIST FBNK.ACCT.ENT.FWD '62845864'
LIST F.METRO.CHANGED.PRIM.CUS '12345678' ACTION.REQ OLD.PRIM.CUSTOMER
NEW.PRIM.CUSTOMER ACTION.TAKEN INPUTTER AUTHORISER DATE.TIME
RETAIL - 1001/6001
CORPORATE - 1020/1030
To check list of users
LIST F.USER
to check the charges configured
VERSION -> FT.COMMISSION.TYPE
For SWIFT -> FTOT03
For SEPA -> METRSEPACHG
To find US Embassy User profile
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...C022-
LENDINGSERVICINGSPECIALISTEXP...
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...LOAN...
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...LENDING...
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...CASHIER...
LIST F.USER USER.TYPES WITH USER.TYPES EQ ASSETANDINVOICEFINANCE-CLIENTSERVREP
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...MGMTACCOUNTA&IF...
LIST F.BROWSER.PREFERENCES MAIN.SCREEN WITH MAIN.SCREEN LIKE ...US...
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...CUSTOMER...
LIST F.BROWSER.PREFERENCES MAIN.SCREEN WITH MAIN.SCREEN LIKE ...CSR...
LIST F.BROWSER.PREFERENCES MAIN.SCREEN WITH MAIN.SCREEN LIKE ...MMA...
LIST F.USER USER.TYPES WITH USER.TYPES EQ LENDINGOPERATIONS-COLLECTIONSSPEC ONLY
LENDINGOPERATIONS-COLLECTIONSSPEC
LIST F.USER USER.NAME LIKE ...PRASH...
Below are the base users:
METRO.JBIRING
A.AZAD1-US Embassy - USPRASH
A.PACE AND T.BOWDEN - MMA Customer - MMAPRASH
LIST F.USER USER.TYPES WITH CLASS.OVERRIDE NE 'STPA'
LIST F.USER USER.TYPES WITH USER.TYPES LIKE ...Cashier...
Cards Env
PRASHMMA1,PRASHMMA2
PRASHUS1
TELLER,NCP.CUS.TL - Cash deposit
TELLER,NCP.TL.CUS - Cash withdraw
--------------------------------------------
Local Beneficiary A/C no and Sort Code
12345676
404127
---------------------------------------------
To restart the env
jsh temenos ~ -->cd /opt/TCServer/tcserver/bin/
jsh temenos /opt/TCServer/tcserver/bin -->sh
sh-4.1$ ./Stop.TCServer.sh
nohup: ignoring input and appending output to `nohup.out'
sh-4.1$ ./TCServer.sh
sh-4.1$ nohup: appending output to `nohup.out'
sh-4.1$
--------------------------------------
To check the T24 updates in the system goto version -> SPF S
--------------------------------------------
SMS OTP checking linking
http://10.248.87.112:8080/CLXSendSMSStub/sendsms
SVN Packs
http://svn.service.metrobank.plc.uk/releases/t24/packs/
LIST,COUNT AND SELECT CAN BE USED IN QUERIES
EG: To count avaialble SDB in BAU1
jsh temenos ~ -->COUNT F.MB.SDB.STATUS WITH STATUS EQ AVAILABLE
AA.INTEREST.ACCRUALS - to view int accrual in AA arichitecture
153 :
SANSUP2 - SUPERUSER
LOPSUSER1 - Loan User
--------------------------------------------
When IB ID is not fetched in 4 Stress
EB.EXTERNAL.USER,
-------------------------------------------------
Whenever customer doesnt exist error comes in Fortress, navigate to
EB.EXTERNAL.USER, version and enter status reasion and commit
Intl Beneficiary:
IBAN/Acc 12345676
BIC Code CITIUS33
--------------------------
COUNT FBNK.ACCOUNT WITH CATEGORY EQ 1001
SELECT FBNK.ACCOUNT WITH CATEGORY EQ 1001 EVAL
"CUSTOMER.NO:',':@ID:',':CATEGORY:',':JOINT.HOLDER:',':POSTING.RESTRICT:',':WORKING
.BALANCE"
SAVE-LIST FileName.csv
/opt/Metro_T24/bnk/bnk.run/T24Share/bnk.shared/&SAVEDLISTS&
-------------------------------
To view outward msg status
Jsh temenos> SEARCH F.SWIFT.NONSOP.FILE
String: FTXXXXX
String:
Record: *
after records are displayed
LIST.ITEM F.SWIFT.NONSOP.FILE
-----------------------------------
Winscp Path to check FICO log : /opt/Metro_T24/bnk
xml formatter - http://xmltoolbox.appspot.com/
to list all the loan products
LIST FBNK.AA.PRODUCT.CATALOG ONLY
----------------------------------------------------------
TSM RESTART
1)VOC
2)TS, I
3)TSM
4)6 AND ENTER
5)CHANGE IT TO STOP + enter mmmmm
6)ctrl+v and enter
7)ctrl + u
8) come bak to jsh temenos
9) TSA1
10) Wait till all the services ar stopped
11)follow from 1 to 4
12)Chnage it to START + enter
13)ctrl + v enter
14) come back to jsh temenos
15)START.TSM
TO CLEAR TSM : CLEAR.FILE F.TSA.STATUS
-----------------------------------------------------
To find allowed SWIFT characters in the payment reference field
ASCII.VAL.TABLE
--------------------------------------------
Sample Profiles �������
������� PROFILE�USERNAME������� �������
������� Super User����� ERSEN1� �������
������� CSR���� D.NGAN� �������
������� Manager L.MOYSES������� �������
������� Commercial����� J.HUXLEY������� �������
������� Cashier E.IBEKE �������
������� Ops���� M.DEY�� �������
������� Lops��� K.LANFEAR������ �������
������� Head Teller���� H.ROUEN������� �������
������� DAP���� D.PHILLIPS
Leada cashier : H.ROUEN
2 H.SOKHI
3 R.STAUNTON
*************************************************************
PNP Service
1. Run BNK/METRO.FT.START.OF.DAY.MANUAL , in case the batch is not attached to
COB�
2.������Run DD and CHQ files - Optional�
3.������Run programs P.METR.CHQ.SUSP.ENTRIES and P.METR.DDCHQ.ALLENTRIES.�
4.������Once the service BNK/B.METR.PNP.PROCESS.REC is stopped�
5.������Do the tests/ deposits�
6.������Run BNK/B.METR.PNP.RETRY.REC�
7.������Check that BNK/B.METR.PNP.MASK is in AUTO status
********************************************************************
Fortess username :PPTESTING�
Password: Metro123
***************************************************
ITCR-3254 take aways
jsh temenos /opt/Metro_T24/bnk/bnk.run -->SELECT FBNK.AA.ARR.ACCOUNT EQ
AA14171VC370... ONLY
2 Records selected
>JED FBNK.AA.ARR.ACCOUNT
------
LIST FBNK.AA.ACCOUNT.DETAILS WITH MATURITY.DATE GT 20180516 AND LT 20180516 AND
WITH EVAL '@ID; EQ '6231' ONLY MATURITY.DATE
To list the accounts a customer have
LIST-ITEM FBNK.CUSTOMER.ACCOUNT WITH @ID EQ 10137667 CUSTOMER.NO ACCOUNT.NO
_______________________________________
E-Signature
http://10.248.87.35:80
earlscourt
Password
_______________________
New Mobile port
40.114.255.33
4321
LIST F.POSTING.RESTRICT BY-DSND @ID
***********************************************************************************
*****
To check what all versions a routine has been attached
jsh temenos ~ -->SELECT F.VERSION
6286 Records selected
>SEARCH F.VERSION
String :METRO.FICO.AUT.ACLOAN.CLOSE
String :
7 Records selected
>LIST F.VERSION ONLY
LIST F.VERSION ONLY
PAGE 1 07:24:56 14 JUN 2018
@ID...................................................
AA.ARRANGEMENT.ACTIVITY,AA
AA.ARRANGEMENT.ACTIVITY,METR.CTA.AUTH
ACCOUNT.CLOSURE,INPUT
ACCOUNT.CLOSURE,METRO.AUTH
ACCOUNT.CLOSURE,TELLER.AC.CLOSURE
FUNDS.TRANSFER,AUTH.B
FUNDS.TRANSFER,METR.CTA.DISB.AUTH
7 Records Listed
***********************************************************************************
***********************
