Mt 940 Setup Procedure _v2_abl
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Mt 940 Setup Procedure _v2_abl as PDF for free.
More details
- Words: 1,200
- Pages: 8
Loading documents preview...
SETUP DOCUMENT TO GENERATE MT940 MESSAGE
Information in this document is subject to change without notice. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of TEMENOS Holdings NV. Copyright 2002-2003 TEMENOS Holdings NV. All rights reserved.
INTRODUCTION: This document contains the setup to meet the client requirement. REQUIREMENT: Need to generate MT940 message Steps to be followed: 1. 2. 3. 4.
Set up the ACCOUNT.STATEMENT record Check the records in DE.PRODUCT and DE.ADDRESSS Setup the DE.PARM record Run the COB
1. Set up the ACCOUNT.STATEMENT record In ACCOUNT.STATEMENT, for the customer, set the STMT.FREQUENCY as date and the SWIFT.STMT.TYPE as MT940. R8 MODEL BANK
Account Statement, SEE
ACCOUNT.NUMBER.... 11193 -----------------------------------------------------------------------------1. 1 STMT.FQU.1..... 07 MAY 2008 BSNSS 07 MAY 2008 Every working day 3 IF.NO.MOVEMENT.... NO 4 DESCRIPT.STATEMENT NO 5 INT.CLOSING.ADVICE Y 6 INTEREST.SCALE.... Y 7 TAX.ADVICE........ Y 8 CURRENCY.......... USD US Dollar 12. 1 SWIFT.STMT.TYPE 940 CUSTOMER STATEMENT 47. 1 OVERRIDE....... OVER 12 MONTHS SINCE LAST STATEMENT 49 CURR.NO........... 2 50. 1 INPUTTER....... 104_KARTHIK1_I_INAU 50. 2 INPUTTER....... 53_INPUTTER___OFS_OFS.LOAD 51. 1 DATE.TIME...... 25 OCT 10 11:19 51. 2 DATE.TIME...... 25 OCT 10 11:19 51. 3 DATE.TIME...... 05 DEC 07 18:47 52 AUTHORISER........ 104_KARTHIK1 2. Setup the DE.PARM record
TEMENOS
Page 2 of 8
September 2010
Check the DE.PARM record, make value in the field PRINT.BYPASS as NULL and the value should not be MT940. (The field is to bypass the printing of account statements during EOD process) DE.PARM INPUT ID................ SYSTEM.STATUS -----------------------------------------------------------------------------7. 6 OUTWARD CARRIER RECS 8. 6 SHUT OUT CARR.. C 7. 7 OUTWARD CARRIER STKREC 8. 7 SHUT OUT CARR.. C 9 READ PRIORITY..... 10 10 READ NORMAL....... 10 11 DISP CONTROL...... Y 12 INWARD ROUTING.... Y 13 MAINTAIN HISTORY.. Y 14. 1 PRINT.BYPASS... 15 MACHINE.ID........ ST400 16 SWIFT MF SEQUENCE. 1 17 SWIFT SF SEQUENCE. 1 18 SWIFT.HARDWARE.... ST400 19 SWIFT.PROTOCOL.... 3270 20 SWIFT.NETWORK..... 2 3. Check the records in DE.PRODUCT and DE.ADDRESS In DE.PRODUCT an account specific record has to be created, for RECS message. Since MT940 and 950 messages delivered as RECS messages. In DE.ADDRESS table, create a RECS delivery address for that customer. R8 MODEL BANK
DE.PRODUCT, SEE
ID................ GB0010001.C-100343.940.ALL CUSTOMER STATEMENT -----------------------------------------------------------------------------3. 1 CARRIER.ADDR NO SWIFT.1 4. 1 LANGUAGE....... GB 5. 1 FORMAT......... 1 6. 1 COPIES......... 1 15 CURR.NO........... 1 16. 1 INPUTTER....... 104_KARTHIK1_I_INAU 17. 1 DATE.TIME...... 25 OCT 10 11:23 17. 2 DATE.TIME...... 25 OCT 10 11:23 18 AUTHORISER........ 104_KARTHIK1 19 CO.CODE........... GB-001-0001 R8 MODEL BANK TEMENOS
Page 3 of 8
September 2010
20 DEPT.CODE......... 1 ------------------------------------------------------------------------------
R8 MODEL BANK
DE.ADDRESS SEE
ID................ GB0010001.C-100343.SWIFT.1 -----------------------------------------------------------------------------1 DELIVERY ADDRESS.. AEIBSGSG 6. 1 GB SHORT NAME.. TESTING 20. 1 OVERRIDE....... ADDRESS ALREADY USED BY ANOTHER CUSTOMER (&)}{GB0010001. 22 CURR.NO........... 1 23. 1 INPUTTER....... 104_KARTHIK1_I_INAU 24. 1 DATE.TIME...... 25 OCT 10 11:22 24. 2 DATE.TIME...... 25 OCT 10 11:22 25 AUTHORISER........ 104_KARTHIK1 26 CO.CODE........... GB-001-0001 R8 MODEL BANK 27 DEPT.CODE......... 1 DELIVERY.CARRIER R8 MODEL BANK
DELIVERY CARRIER PARAMETERS SEE
CARRIER........... SWIFT -----------------------------------------------------------------------------1. 1 GB DESCRIPTION. Standard SWIFT carrier definition 2 ADDRESS........... SWIFT 3 FORMAT.MODULE..... SWIFT 4 CARRIER.MODULE.... GENERIC 5 INTERFACE......... MODEL MODEL INTERFACE 6 IN.FORMAT.MODULE.. SWIFT 19 CURR.NO........... 3 20. 1 INPUTTER....... 32_AUTHORISER___OFS_MB.OFS.AUTH 21. 1 DATE.TIME...... 08 AUG 07 18:02 22 AUTHORISER........ 32_AUTHORISER_OFS_MB.OFS.AUTH 23 CO.CODE........... GB-001-0001 R8 MODEL BANK 24 DEPT.CODE......... 1
4. Run the COB After the COB, the corresponding ACCOUNT.STATEMENT would contain the delivery reference id for the MT940 message TEMENOS
Page 4 of 8
September 2010
Note: The MT940 messages (CUSTOMER STATEMENT) generated only during COB. The job that generate the 940 message during COB is PRINT.ACCOUNT.STMT i.
After COB process the ACCOUNT.STATEMENT Record
R8 MODEL BANK
Account Statement, SEE
ACCOUNT.NUMBER.... 11193 -----------------------------------------------------------------------------1. 1 STMT.FQU.1..... 08 MAY 2008 BSNSS 08 MAY 2008 Every working day 3 IF.NO.MOVEMENT.... NO 4 DESCRIPT.STATEMENT NO 5 INT.CLOSING.ADVICE Y 6 INTEREST.SCALE.... Y 7 TAX.ADVICE........ Y 8 CURRENCY.......... USD US Dollar 9 FQU1.LAST.DATE.... 07 MAY 2008 10 FQU1.LAST.BALANCE. -100.00 11 LAST.STATEMENT.NO. 1 12. 1 SWIFT.STMT.TYPE 940 CUSTOMER STATEMENT 22. 1 STATEMENT.DATE. 07 MAY 2008 23. 1. 1 DELIVERY.REF D20101025001024172006 47. 1 OVERRIDE....... OVER 12 MONTHS SINCE LAST STATEMENT 49 CURR.NO........... 2 50. 1 INPUTTER....... 104_KARTHIK1_I_INAU ii.
View of the DE.O.HEADER record
R8 MODEL BANK
OUTWARD DELIVERY HEADER SEE
DATE.TIME.STAMP... D20101025-00102-41720-06 -----------------------------------------------------------------------------1 MESSAGE TYPE...... 940 2 APPLICATION FORMAT 1 3 APPLICATION....... ACC1 4 DISPOSITION....... UNFORMATTED 6 PRIORITY.......... N 10 ACCOUNT NUMBER.... 11193 11. 1 CUSTOMER NUMBER 100343 12 CUS. COMPANY...... GB0010001 13 COMPANY CODE...... GB0010001 16 LANGUAGE.......... GB 18 CURRENCY.......... USD TEMENOS
Page 5 of 8
September 2010
20 DEPARTMENT........ 1 21 TRANSACTION REF... 20080507-1 23 TEST KEY REQ...... NO 25. 1 CARRIER ADDR NO SWIFT.1 26. 1 COPY NUMBER.... 1-100343 27. 1 FRAME NUMBER... 1 28. 1 FORMAT......... 1 29. 1 MSG LANGUAGE... GB 30. 1 MSG PRIORITY... N 34. 1 SHORT NAME..... TESTING 36. 1. 1 TO ADDRESS.. AEIBSGSG 47 BANK DATE......... 20080507 49 CURR.NO........... 1 50. 1 INPUTTER....... 1_SYSTEM 51. 1 DATE.TIME...... 25 OCT 10 11:35 52 AUTHORISER........ 1_SYSTEM 53 CO.CODE........... GB-001-0001 R8 MODEL BANK III. View of the DE.O.HEADER record after run the service 36. 1. 1 TO ADDRESS.. AEIBSGSG R8 MODEL BANK
OUTWARD DELIVERY HEADER SEE
DATE.TIME.STAMP... D20101025-00102-41720-06 -----------------------------------------------------------------------------1 MESSAGE TYPE...... 940 2 APPLICATION FORMAT 1 3 APPLICATION....... ACC1 4 DISPOSITION....... FORMATTED 6 PRIORITY.......... N 10 ACCOUNT NUMBER.... 11193 11. 1 CUSTOMER NUMBER 100343 12 CUS. COMPANY...... GB0010001 13 COMPANY CODE...... GB0010001 16 LANGUAGE.......... GB 18 CURRENCY.......... USD 20 DEPARTMENT........ 1
TEMENOS
Page 6 of 8
September 2010
21 TRANSACTION REF... 20080507-1 23 TEST KEY REQ...... NO 25. 1 CARRIER ADDR NO SWIFT.1 26. 1 COPY NUMBER.... 1-100343 27. 1 FRAME NUMBER... 1 28. 1 FORMAT......... 1 29. 1 MSG LANGUAGE... GB 30. 1 MSG PRIORITY... N 32. 1 MSG DISPOSITION WACK 34. 1 SHORT NAME..... TESTING 36. 1. 1 TO ADDRESS.. AEIBSGSG 38. 1 FROM ADDRESS... DEMOGBPXAXXX 39. 1 SENT STAMP..... 20101025 11:42:16 40. 1 CARRIER SEQ NO. 1563942136.00 47 BANK DATE......... 20080507 49 CURR.NO........... 1 50. 1 INPUTTER....... 1_SYSTEM 51. 1 DATE.TIME...... 25 OCT 10 11:35 52 AUTHORISER........ 1_SYSTEM 53 CO.CODE........... GB-001-0001
TEMENOS
R8 MODEL BANK
Page 7 of 8
September 2010
Updated troubleshooting information Added by Syed Ali Ahmad Dated 12-Nov-10
1. Make sure you have the record in DE.ADDRESS PK0010001.C-<custno>.SWIFT.1. This record must be in lead company to get a closest match 2. Make sure that you have the record in DE.PRODUCT PK001brcd.A-.940.ALL. This record must be at branch level to get a closest match (This point is not well covered in the above manual) 3. Add record in DE.ADDRESS (DE.ADDRESS>PK0010141.SWIFT.1) with delivery address as ABPAPKKAA940 (New Point) 4. It is not absolutely mandatory to run COB. You can create a BATCH and TSA.SERVICE records for the service BNK/PRINT.ACCOUNT.STMT and run this service separately 5. If you encounter an error like “missing transaction record txnl/nnn” then please do the following: a. Note the number and look for this number in TRANSACTION table b. Note the GB NARRATATIVE field and copy the value in it c. Create a record of ID TXNL/nnn in DE.TRANSLATION paste the value in the only field of the record and commit it. d. Make sure the records are authorized
TEMENOS
Page 8 of 8
September 2010
Information in this document is subject to change without notice. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of TEMENOS Holdings NV. Copyright 2002-2003 TEMENOS Holdings NV. All rights reserved.
INTRODUCTION: This document contains the setup to meet the client requirement. REQUIREMENT: Need to generate MT940 message Steps to be followed: 1. 2. 3. 4.
Set up the ACCOUNT.STATEMENT record Check the records in DE.PRODUCT and DE.ADDRESSS Setup the DE.PARM record Run the COB
1. Set up the ACCOUNT.STATEMENT record In ACCOUNT.STATEMENT, for the customer, set the STMT.FREQUENCY as date and the SWIFT.STMT.TYPE as MT940. R8 MODEL BANK
Account Statement, SEE
ACCOUNT.NUMBER.... 11193 -----------------------------------------------------------------------------1. 1 STMT.FQU.1..... 07 MAY 2008 BSNSS 07 MAY 2008 Every working day 3 IF.NO.MOVEMENT.... NO 4 DESCRIPT.STATEMENT NO 5 INT.CLOSING.ADVICE Y 6 INTEREST.SCALE.... Y 7 TAX.ADVICE........ Y 8 CURRENCY.......... USD US Dollar 12. 1 SWIFT.STMT.TYPE 940 CUSTOMER STATEMENT 47. 1 OVERRIDE....... OVER 12 MONTHS SINCE LAST STATEMENT 49 CURR.NO........... 2 50. 1 INPUTTER....... 104_KARTHIK1_I_INAU 50. 2 INPUTTER....... 53_INPUTTER___OFS_OFS.LOAD 51. 1 DATE.TIME...... 25 OCT 10 11:19 51. 2 DATE.TIME...... 25 OCT 10 11:19 51. 3 DATE.TIME...... 05 DEC 07 18:47 52 AUTHORISER........ 104_KARTHIK1 2. Setup the DE.PARM record
TEMENOS
Page 2 of 8
September 2010
Check the DE.PARM record, make value in the field PRINT.BYPASS as NULL and the value should not be MT940. (The field is to bypass the printing of account statements during EOD process) DE.PARM INPUT ID................ SYSTEM.STATUS -----------------------------------------------------------------------------7. 6 OUTWARD CARRIER RECS 8. 6 SHUT OUT CARR.. C 7. 7 OUTWARD CARRIER STKREC 8. 7 SHUT OUT CARR.. C 9 READ PRIORITY..... 10 10 READ NORMAL....... 10 11 DISP CONTROL...... Y 12 INWARD ROUTING.... Y 13 MAINTAIN HISTORY.. Y 14. 1 PRINT.BYPASS... 15 MACHINE.ID........ ST400 16 SWIFT MF SEQUENCE. 1 17 SWIFT SF SEQUENCE. 1 18 SWIFT.HARDWARE.... ST400 19 SWIFT.PROTOCOL.... 3270 20 SWIFT.NETWORK..... 2 3. Check the records in DE.PRODUCT and DE.ADDRESS In DE.PRODUCT an account specific record has to be created, for RECS message. Since MT940 and 950 messages delivered as RECS messages. In DE.ADDRESS table, create a RECS delivery address for that customer. R8 MODEL BANK
DE.PRODUCT, SEE
ID................ GB0010001.C-100343.940.ALL CUSTOMER STATEMENT -----------------------------------------------------------------------------3. 1 CARRIER.ADDR NO SWIFT.1 4. 1 LANGUAGE....... GB 5. 1 FORMAT......... 1 6. 1 COPIES......... 1 15 CURR.NO........... 1 16. 1 INPUTTER....... 104_KARTHIK1_I_INAU 17. 1 DATE.TIME...... 25 OCT 10 11:23 17. 2 DATE.TIME...... 25 OCT 10 11:23 18 AUTHORISER........ 104_KARTHIK1 19 CO.CODE........... GB-001-0001 R8 MODEL BANK TEMENOS
Page 3 of 8
September 2010
20 DEPT.CODE......... 1 ------------------------------------------------------------------------------
R8 MODEL BANK
DE.ADDRESS SEE
ID................ GB0010001.C-100343.SWIFT.1 -----------------------------------------------------------------------------1 DELIVERY ADDRESS.. AEIBSGSG 6. 1 GB SHORT NAME.. TESTING 20. 1 OVERRIDE....... ADDRESS ALREADY USED BY ANOTHER CUSTOMER (&)}{GB0010001. 22 CURR.NO........... 1 23. 1 INPUTTER....... 104_KARTHIK1_I_INAU 24. 1 DATE.TIME...... 25 OCT 10 11:22 24. 2 DATE.TIME...... 25 OCT 10 11:22 25 AUTHORISER........ 104_KARTHIK1 26 CO.CODE........... GB-001-0001 R8 MODEL BANK 27 DEPT.CODE......... 1 DELIVERY.CARRIER R8 MODEL BANK
DELIVERY CARRIER PARAMETERS SEE
CARRIER........... SWIFT -----------------------------------------------------------------------------1. 1 GB DESCRIPTION. Standard SWIFT carrier definition 2 ADDRESS........... SWIFT 3 FORMAT.MODULE..... SWIFT 4 CARRIER.MODULE.... GENERIC 5 INTERFACE......... MODEL MODEL INTERFACE 6 IN.FORMAT.MODULE.. SWIFT 19 CURR.NO........... 3 20. 1 INPUTTER....... 32_AUTHORISER___OFS_MB.OFS.AUTH 21. 1 DATE.TIME...... 08 AUG 07 18:02 22 AUTHORISER........ 32_AUTHORISER_OFS_MB.OFS.AUTH 23 CO.CODE........... GB-001-0001 R8 MODEL BANK 24 DEPT.CODE......... 1
4. Run the COB After the COB, the corresponding ACCOUNT.STATEMENT would contain the delivery reference id for the MT940 message TEMENOS
Page 4 of 8
September 2010
Note: The MT940 messages (CUSTOMER STATEMENT) generated only during COB. The job that generate the 940 message during COB is PRINT.ACCOUNT.STMT i.
After COB process the ACCOUNT.STATEMENT Record
R8 MODEL BANK
Account Statement, SEE
ACCOUNT.NUMBER.... 11193 -----------------------------------------------------------------------------1. 1 STMT.FQU.1..... 08 MAY 2008 BSNSS 08 MAY 2008 Every working day 3 IF.NO.MOVEMENT.... NO 4 DESCRIPT.STATEMENT NO 5 INT.CLOSING.ADVICE Y 6 INTEREST.SCALE.... Y 7 TAX.ADVICE........ Y 8 CURRENCY.......... USD US Dollar 9 FQU1.LAST.DATE.... 07 MAY 2008 10 FQU1.LAST.BALANCE. -100.00 11 LAST.STATEMENT.NO. 1 12. 1 SWIFT.STMT.TYPE 940 CUSTOMER STATEMENT 22. 1 STATEMENT.DATE. 07 MAY 2008 23. 1. 1 DELIVERY.REF D20101025001024172006 47. 1 OVERRIDE....... OVER 12 MONTHS SINCE LAST STATEMENT 49 CURR.NO........... 2 50. 1 INPUTTER....... 104_KARTHIK1_I_INAU ii.
View of the DE.O.HEADER record
R8 MODEL BANK
OUTWARD DELIVERY HEADER SEE
DATE.TIME.STAMP... D20101025-00102-41720-06 -----------------------------------------------------------------------------1 MESSAGE TYPE...... 940 2 APPLICATION FORMAT 1 3 APPLICATION....... ACC1 4 DISPOSITION....... UNFORMATTED 6 PRIORITY.......... N 10 ACCOUNT NUMBER.... 11193 11. 1 CUSTOMER NUMBER 100343 12 CUS. COMPANY...... GB0010001 13 COMPANY CODE...... GB0010001 16 LANGUAGE.......... GB 18 CURRENCY.......... USD TEMENOS
Page 5 of 8
September 2010
20 DEPARTMENT........ 1 21 TRANSACTION REF... 20080507-1 23 TEST KEY REQ...... NO 25. 1 CARRIER ADDR NO SWIFT.1 26. 1 COPY NUMBER.... 1-100343 27. 1 FRAME NUMBER... 1 28. 1 FORMAT......... 1 29. 1 MSG LANGUAGE... GB 30. 1 MSG PRIORITY... N 34. 1 SHORT NAME..... TESTING 36. 1. 1 TO ADDRESS.. AEIBSGSG 47 BANK DATE......... 20080507 49 CURR.NO........... 1 50. 1 INPUTTER....... 1_SYSTEM 51. 1 DATE.TIME...... 25 OCT 10 11:35 52 AUTHORISER........ 1_SYSTEM 53 CO.CODE........... GB-001-0001 R8 MODEL BANK III. View of the DE.O.HEADER record after run the service 36. 1. 1 TO ADDRESS.. AEIBSGSG R8 MODEL BANK
OUTWARD DELIVERY HEADER SEE
DATE.TIME.STAMP... D20101025-00102-41720-06 -----------------------------------------------------------------------------1 MESSAGE TYPE...... 940 2 APPLICATION FORMAT 1 3 APPLICATION....... ACC1 4 DISPOSITION....... FORMATTED 6 PRIORITY.......... N 10 ACCOUNT NUMBER.... 11193 11. 1 CUSTOMER NUMBER 100343 12 CUS. COMPANY...... GB0010001 13 COMPANY CODE...... GB0010001 16 LANGUAGE.......... GB 18 CURRENCY.......... USD 20 DEPARTMENT........ 1
TEMENOS
Page 6 of 8
September 2010
21 TRANSACTION REF... 20080507-1 23 TEST KEY REQ...... NO 25. 1 CARRIER ADDR NO SWIFT.1 26. 1 COPY NUMBER.... 1-100343 27. 1 FRAME NUMBER... 1 28. 1 FORMAT......... 1 29. 1 MSG LANGUAGE... GB 30. 1 MSG PRIORITY... N 32. 1 MSG DISPOSITION WACK 34. 1 SHORT NAME..... TESTING 36. 1. 1 TO ADDRESS.. AEIBSGSG 38. 1 FROM ADDRESS... DEMOGBPXAXXX 39. 1 SENT STAMP..... 20101025 11:42:16 40. 1 CARRIER SEQ NO. 1563942136.00 47 BANK DATE......... 20080507 49 CURR.NO........... 1 50. 1 INPUTTER....... 1_SYSTEM 51. 1 DATE.TIME...... 25 OCT 10 11:35 52 AUTHORISER........ 1_SYSTEM 53 CO.CODE........... GB-001-0001
TEMENOS
R8 MODEL BANK
Page 7 of 8
September 2010
Updated troubleshooting information Added by Syed Ali Ahmad Dated 12-Nov-10
1. Make sure you have the record in DE.ADDRESS PK0010001.C-<custno>.SWIFT.1. This record must be in lead company to get a closest match 2. Make sure that you have the record in DE.PRODUCT PK001brcd.A-
TEMENOS
Page 8 of 8
September 2010
Related Documents
Mt 940 Setup Procedure _v2_abl
January 2021 0
Din 940
January 2021 2
Mt-2
January 2021 4
Lab Setup
January 2021 2
Mt-1
January 2021 3
Palex -setup-joe-dinapoli.pdf
February 2021 0More Documents from "xucro.ponto6747"
T24 Directory Structure And Core Parameter Files In T24
January 2021 0
Jed Command Syntax: Option Description
January 2021 0
Mt 940 Setup Procedure _v2_abl
January 2021 0
Using The Jed Editor And Navigation In Classic
January 2021 0