COMPANY create procedure.

Kindly refer the LEAD COMPANY document <<LEAD COMPANY>>before starting up with this

Example:
GB0010001 is a lead company with local currency USD.
Now we are creating a lead company GB0010400 with local currency GBP

The format of the Company Code is:

CC GGG LLLL

Where:

CC Is the Country Code

GGG Is the Company Group Code
LLLL Is Local Code

Note:
Local code must be different for each location/ branch within one country even if the processing is run in
different environments.

Step 1:

Run the application COMPANY.CREATE.

Verify the new company id in this application.

create new company VERIFY

COMPANY........... GB0010400
------------------------------------------------------------------------------
1. 1 GB COMPANY.NAME LEAD 2
2. 1 NAME.ADDRESS... NEW
3 MNEMONIC.......... BR8
4 FINANCIAL.COM..... GB0010400
5 FINANCIAL.MNE..... BR8
6 SUB.DIVISION.CODE. 31
7 CREATION.DATE.....
8 DEFAULT.COMPANY... GB0010001
9 RESERVED.8........
10 RESERVED.7........
Step 2:

After committing the above record, the system will prompt you

The new company record in INPUT mode.

COMPANY SEE

COMPANY.CODE...... GB-001-0400 Great Britain COMPANY GROUP 1

------------------------------------------------------------------------------
1. 1 GB COMPANY.NAME LEAD 2
2. 1 NAME.ADDRESS... NEW
3 MNEMONIC.......... BR8
4 LANGUAGE.CODE..... 1 English
11 CONSOLIDATION.MARK N
12 DEFAULT.NO.OF.AUTH 1
13. 1 PGM.AUTOM.ID... ACCOUNT

13. 2 PGM.AUTOM.ID... DX.CO.EXT.XFER.MANUAL

13. 3 PGM.AUTOM.ID... DX.CO.XFER.MANUAL
13. 4 PGM.AUTOM.ID... ST.GROUP.FIX
13. 5 PGM.AUTOM.ID... FUNDS.TRANSFER
13. 6 PGM.AUTOM.ID... FOREX
13. 7 PGM.AUTOM.ID... MM.MONEY.MARKET
13. 8 PGM.AUTOM.ID... FD.FID.ORDER
13. 9 PGM.AUTOM.ID... FD.FIDUCIARY
13.10 PGM.AUTOM.ID... FRA.DEAL
13.11 PGM.AUTOM.ID... MG.MORTGAGE
13.12 PGM.AUTOM.ID... TELLER
13.13 PGM.AUTOM.ID... SEC.TRADE
13.14 PGM.AUTOM.ID... ND.DEAL
13.15 PGM.AUTOM.ID... DX.DIARY
13.16 PGM.AUTOM.ID... LETTER.OF.CREDIT
13.17 PGM.AUTOM.ID... LD.LOANS.AND.DEPOSITS
13.18 PGM.AUTOM.ID... MD.DEAL
13.19 PGM.AUTOM.ID... IM.DOCUMENT.IMAGE
13.20 PGM.AUTOM.ID... SWAP
13.21 PGM.AUTOM.ID... SEC.OPEN.ORDER
13.22 PGM.AUTOM.ID... SECURITY.TRANSFER
13.23 PGM.AUTOM.ID... DX.CLOSEOUT
13.24 PGM.AUTOM.ID... DX.ORDER
 13.25 PGM.AUTOM.ID... DX.REVALUE
13.26 PGM.AUTOM.ID... DX.TRADE
....
14 LOCAL.COUNTRY..... GB Great Britain
16 LOCAL.CURRENCY.... GBP
17 RATE.SYSTEM....... BUY.SELL.RATE
18 CUSTOMER.COMPANY.. GB-001-0001
19 CUSTOMER.MNEMONIC. BNK
20 DEFAULT.CUST.COM.. GB-001-0001
21 DEFAULT.CUST.MNE.. BNK
25 DEFAULT.FINAN.COM. GB-001-0001
26 DEFAULT.FINAN.MNE. BNK
30 CURRENCY.COMPANY.. GB-001-0400
31 CURRENCY.MNEMONIC. BR8 Currency Company should be the same company
32 FINAN.FINAN.COM... GB-001-0001
33 FINAN.FINAN.MNE... BNK
34 NOSTRO.COMPANY.... GB-001-0001
35 NOSTRO.MNEMONIC... BNK
38. 1 APPLICATIONS... AA ARRANGEMENT ARCHITECTURE
38. 2 APPLICATIONS... AC ACCOUNT
38. 3 APPLICATIONS... AI ARC INTERNET BANKING
38. 4 APPLICATIONS... AM ASSET MANAGEMENT
38. 5 APPLICATIONS... AL AA LENDING
38. 6 APPLICATIONS... AP ARC PROXY SERVICES
38. 7 APPLICATIONS... AZ ALL IN ONE ACCOUNT
38. 8 APPLICATIONS... BL BILLS
38. 9 APPLICATIONS... CM CONFIRMATION MATCHING
38.10 APPLICATIONS... CO COLLATERAL
38.11 APPLICATIONS... CR CUSTOMER RELATIONSHIP MANAGEMENT
38.12 APPLICATIONS... DC DATA CAPTURE
38.13 APPLICATIONS... DD DIRECT DEBITS
38.14 APPLICATIONS... DE DELIVERY
38.15 APPLICATIONS... DM DOCUMENT MANAGEMENT
38.16 APPLICATIONS... DX DERIVATIVES
38.17 APPLICATIONS... EB CORE
38.18 APPLICATIONS... EU THE EURO
38.19 APPLICATIONS... FD FIDUCIARY
38.20 APPLICATIONS... FR FORWARD RATE AGREEMENTS
38.21 APPLICATIONS... FT FUNDS TRANSFER
38.22 APPLICATIONS... FX FOREIGN EXCHANGE
38.23 APPLICATIONS... GP GLOBAL PROCESSING
38.24 APPLICATIONS... IA INTERNATIONAL ACCOUNTING STANDARDS
38.25 APPLICATIONS... IB INTERNET BANKING
38.26 APPLICATIONS... IC INTEREST AND CHARGES
....
41 DEFAULT.RATE.ALLOW 5.00
42 FCY.CONV.TOLER.MIN 1.00
 43 FCY.CONV.TOLER.MAX 10.00
44 CHARGE.CALCULATION Q
45 FINANCIAL.YEAR.END 20081231M1231
46 INACTIVITY.MONTHS. 12
47 SUB.DIVISION.CODE. 0031
48 SWIFT.ADD.COM.REF. DEMOPX
49 LAST.YEAR.END..... 31 DEC 2007
50 DC.TOLERANCE.RATE. 1.00
51 DC.MAX.ROUND.AMT.. 1.00
54 ACCOUNT.MASK...... ##########
59 COMPANY.GROUP..... 1 COMPANY GROUP 1
60 OFFICIAL.HOLIDAY.. GB00
61 BRANCH.HOLIDAY.... GB00
62 BATCH.HOLIDAY..... GB00
64 FINANCIAL.COM..... GB-001-0400
65 FINANCIAL.MNE..... BR8
78 CURR.NO........... 1
79. 1 INPUTTER....... 3_DEEPAK2
80. 1 DATE.TIME...... 16 MAR 11 16:07
81 AUTHORISER........ 3_DEEPAK2
82 CO.CODE........... GB-001-0001 R08.003 MODEL BANK
83 DEPT.CODE......... 1
------------------------------------------------------------------------------

12 OCT 2007 11:16:01 USER (04 DEC) BANSAL1 [0,18] PAGE 1 >>11>>>

ACTION

4090 Records selected

Creating file FPS1.CONS.ASST.LIAB.GBP

No Records selected

4090 Records selected

Creating file FPS1.CONS.ASST.LIAB.GBP

No Records selected
[ 417 ] File ../mbdemo.data/re/FPS1.CONS000 created , type = J4

Creating file FPS1.CONS.PRFT.LOSS.GBP

1 Records selected

[ 417 ] File ../mbdemo.data/re/FPS1.CONS001 created , type = J4

..

[ 417 ] File ../mbdemo.data/sc/FPS1.VAUL005 created , type = J4

Creating file FPS1.VAULT.EXPECT$HIS

6 Records selected

[ 417 ] File ../mbdemo.data/sc/FPS1.VAUL006 created , type = J4

Creating file FPS1.VAULT.TODAY

7 Records selected
[ 417 ] File ../mbdemo.data/sc/FPS1.VAUL007 created , type = J4

Creating file FPS1.WORK.CASH.FLOW

No Records selected

[ 417 ] File ../mbdemo.data/am/FPS1.WORK000 created , type = J4

Creating file FPS1.WORK.PERF.DETAIL

1 Records selected

[ 417 ] File ../mbdemo.data/am/FPS1.WORK001 created , type = J4

Creating file FPS1.WRITE.AM.INST.VEH.YYYYMM.LIST

No Records selected

[ 417 ] File ../mbdemo.data/am/FPS1.WRIT000 created , type = J4

Creating file FPS1.WRITE.SC.VAL.EXTRACT.LIST

No Records selected

[ 417 ] File ../mbdemo.data/sc/FPS1.WRIT000 created , type = J4

Creating file FPS1.YCON.KEY.WORK

No Records selected
[ 417 ] File ../mbdemo.data/ac/FPS1.YCON000 created , type = J4

Creating file FPS1.YCUST.LINES.WORK

No Records selected

[ 417 ] File ../mbdemo.data/li/FPS1.YCUS000 created , type = J4

Creating file FPS1.YFWD.ENT.WORK

No Records selected

[ 417 ] File ../mbdemo.data/ac/FPS1.YFWD000 created , type = J4

Creating file FPS1.YPOSITIONS.WRK

No Records selected

[ 417 ] File ../mbdemo.data/ic/FPS1.YPOS000 created , type = J4

STEP 3:

//INTERCO.PARAMETER setup
Input the newly created company in the INTERCO.PARAEMTER

INTERCOMPANY PARAMETERS SEE

INTERCO.PARAMETER. SYSTEM
------------------------------------------------------------------------------
 1 BALANCE.INTERCOMP. YES
2 BALANCE.INTERDEPT. YES
3 BRANCH.CODE.START. 1
4 BRANCH.CODE.LENGTH 1
5 DR.TXN.CODE....... 182 INTERCOMPANY DEBIT
6 CR.TXN.CODE....... 183 INTERCOMPANY CREDIT
7. 1 COMPANY........ GB0010001 R08.003 MODEL BANK
8. 1 FIN.MNEMONIC... BNK
9. 1. 1 BRANCH.CODE. 1
...
7. 4 COMPANY........ GB0010400 LEAD 2
8. 4 FIN.MNEMONIC... BR8
9. 4. 1 BRANCH.CODE. 7
7. 5 COMPANY........ GB0010300 BP LEAD 1
8. 5 FIN.MNEMONIC... BR7
9. 5. 1 BRANCH.CODE. 6
7. 6 COMPANY........ SG0010001 R8 LEAD CO SINGAPORE
8. 6 FIN.MNEMONIC... SG1
9. 6. 1 BRANCH.CODE. 3
10 ACCOUNT.NO.LENGTH. 10
16 CURR.NO........... 6
17. 1 INPUTTER....... 3_DEEPAK1
18. 1 DATE.TIME...... 16 MAR 11 16:11
19 AUTHORISER........ 3_DEEPAK1
20 CO.CODE........... GB-001-0001 R08.003 MODEL BANK
21 DEPT.CODE......... 1

The above is done before signing onto the New Company. It will be necessary to sign off and on again to
obtain use of the modified details to the USER and INTERCO.PARAMETER file records

STEP 4:

After this kindly authorize the DATES Record for the newly created LEAD COMPANY

T24MOCK5 DATES - Default Exceptions

-------------------------------------------------------------------------------

------------------------------------------------------------------------------
27 APR 2011 14:52:45 USER (02 FEB) AUTHORISER [8255,IN]
ACTION DATES E
AWAITING APPLICATION

T24MOCK5 DATES - Default Exceptions

ID STATUS DATE.TIME INPUTTER FUNCT.
------------------------------------------------------------------------------
1 GB0010400 IHLD 18 FEB 11 15:35 144_SYSADMIN.2

------------------------------------------------------------------------------
19 FEB 2011 12:16:53 USER (17 JAN) SYSADMIN.1 [128,28]PAGE 1 >>>1>>>
ACTION
AWAITING PAGE INSTRUCTIONS

This will be in HOLD status so kindly input and authorize the record

STEP 5:

Create a record in the REVALUATION.PARAMETER file with parameters set up for the following: ‘AL’ –
Asset and Liability revaluation, ‘FX’ – Forex, ‘FX.SP’ – Forex spot revaluation, and ‘FX.RB’ – Forex rebate
revaluation

STEP 6:

Run the ENQUIRY EXCEPTION to view the list of files in IHLD status for the newly created LEAD company

T24MOCK5 ENQUIRY INPUT

SELECT NAME....... EXCEPTION

------------------------------------------------------------------------------
1. 1 SELECTION.TYPE. <d>
2. 1 SELECTION.FIELD FILE.NAME
3. 1 OPERAND........ LK
4. 1. 1 LIST........ ... BR8...
5 ENQUIRY........... EXCEPTION
6 PRE.SET.SELECTION.
7 BACKGROUND........
8 NOTIFY............
9. 1 SORT.FIELD.....
10. 1 FIXED.SELECTION USER.REC EQ 1
11. 1 FIXED.SORT..... SORT.FLD
12 PRINT.............
13 RECORD.STATUS.....
14 CURR.NO........... 1
15. 1 INPUTTER....... 128_SYSADMIN.1
16. 1 DATE.TIME...... 19 FEB 11 14:19
------------------------------------------------------------------------------
19 FEB 2011 14:25:05 USER (17 JAN) SYSADMIN.1 [128,28] VALIDATED
ACTION
T24MOCK5
List of Unauthorised Files
File Name Total Nau Na2 Nao Hld Err Undefined
------------------------------------------------------------------------------
1 FBR8.CURRENCY 25 0 0 0 25 0 0
2 FBR8.CUSTOMER.STATUS 14 0 0 0 14 0 0
3 FBR8.FD.PARAMETER 1 0 0 0 1 0 0
4 FBR8.FX.TEXT 2 0 0 0 2 0 0
5 FBR8.LC.ENRICHMENT 42 0 0 0 42 0 0
6 FBR8.LIMIT.PARAMETER 1 0 0 0 1 0 0
7 FBR8.SECTOR 41 0 0 0 41 0 0
8 FBR8.SWAP.PARAMETER 1 0 0 0 1 0 0
9 FBR8.TRANSACTION 815 0 0 0 815 0 0

------------------------------------------------------------------------------
19 FEB 2011 14:26:48 USER (17 JAN) SYSADMIN.1 [128,28]PAGE 1 >>>1>>>
ACTION
AWAITING PAGE INSTRUCTIONS

We can see that there the 8 files and around 1000 records in IHLD status .so we need to input and
authorize all these .This can be done with the help of EBS.AUTO.FUNCTION. Document regarding
EBS.AUTO.FUNCTION is attached kindly refer the document << EBS.AUTO.FUNCTION>>>

STEP 7:

Input and Authorise Data on the following files (this list assumes shared Customer and Nostro Files) if
files have been created for a New Lead Company. For these files, data must be entered
Input and Authorise Data on the following files (this list assumes shared Customer and
Nostro Files) if files have been created for a New Lead Company. - For these files, data must
be entered
File Name Classification and Notes
PERIODIC.INTEREST CCY - Only when New Local Currency
FORWARD.RATES CCY - Only when New Local Currency
GROUP.CAPITALISATION
GROUP.DEBIT.INT
GROUP.CREDIT.INT
Other Interest and Charges tables.
ACCOUNT Default accounts in the Local currency for the
suspense accounts, etc.
DE.ADDRESS Create record for new company.
DE.PRODUCT Create record for new company.
MG.PARAMETER Create new record for new company.
HOLIDAY Set up this for the currency in PERIODIC.INTEREST
PERIODIC.INTEREST Set up PERIODIC.INTEREST for the currency/rate in
FRA.PARAMETER
FRA.PARAMETER Create new record for new company.
LC.PARAMETERS Set up internal accounts, then a system record for this
parameter.
MD.PARAMETER Input and authorise this held record.
SC.PARAMETER Input and authorise this held record.
SC.STD.SEC.TRADE Input and authorise this held record.
PD.AMOUNT.TYPE Set up various types then set up the PD.PARAMETER
file below.
PD.PARAMETER Create new record for new company
CONDITION.PRIORITY Set up an ' Account ' record in this file.
RE.BASE.CCY.PARAM Set up the base currency record.
SC.STD.COUPON Create new company record ensuring fields 24-26 are
populated.
SC.STD.BOND.RED Create new company record ensuring fields 24-26 are
populated.
FD.PARAMETER Create new record for new company

STEP 8:
Input and authorize the records on the BATCH file that have been created above.
STEP 9:.
Run INSTALL.SYS.RECS for new company from j shell prompt.
STEP 10:
Check printed output to ensure that there are no missing records.