Delivery Advices

Hi,

I am facing a problem with DE.MAPPING for 1705.LC.1, error: Repair #Missing Expiry.Date.

Now,
I have entered Expiry.Date in my version LC,IMPREADV
By default Model Bank setup Expiry.Date is mapped to Feild.Position 1.3
I have declared the variable in DE.MESSAGE.
My DE.O.HEADER doesnt get formulated , it is in repair state.

APPLICATION.HANDOFF internally triggers and mapps each feild in F.DE.O.HANDOFF , is their any way i can find how they have mapped F.DE.O.HANDOFF in core setup .

Any help is higly appriciated :)

Warm Regards,
Yasu.

a way to see how your specific handoff is mapped use enquiry DE.HANDOFF.DETS

Hi Lars,

Thanx for ur concern. I have checked that , but my expiry.date does not get any values and i think the 1.3 mapping position is wrong. So how do i find the correct position ....

I mean Handoff.Records has a array of 10 feilds , in every field several values are their seperated by VM , how to see the array.

Plz help.

Thanx
Yasu.

as I know you have to go with trial&error...
Put a good to identify value in your field expiry.daty
Then check the produced handoff to find the value
Use the position and map it in de.mapping in new field
use new field in de.format.
--> good luck, its a stupid work....

@Liars,

Hahhhahha... yess!! u r right, but i wish there was any application in t24 which could show me where actually is a feild being mapped.
To be more accurate i have completed doing this, succeeded in getting the advice , but all shuffled values. **Grrrrr**

Any waz thanx a lot for ur help.God Bless!!!

Hi,

Thanx for ur valueble replies. I got my advice finally and is left with one small problem.

Handoff.Dets has Available.with.cus= 123456(cus id)

Now in the DE.FORMAT.PRINT i have used Feid Text=Available.with.cus and Conversion=Cus*Full

it a multivalued feild and proper space is given.

The problem is only the Customer id is printed while i want the entire address of the Customer as it is stated in my Conversion field.

Your help is highly appriciated.

Regards,
yassar.

Yes... i am getting the values from DE.ADDRESS in other advices , only for one particular DFP id the conversion feild does not give the desired result.

DE.MESSAGE

---

1. 1 GB DESCRIPTION. PRE-ADVICE OF A DOCUMENTARY CREDIT
2 COPIES............ NO
3 TRANSLATION....... NO
4 DELETE............ Y
5 TEST.KEY.REQ...... NO
6 APPLICATION.QUEUE. LC Letters of Credit
7. 1 FIELD.NAME..... TYPE.OF.CREDIT
8. 1 LENGTH......... 24
9. 1 PRINT.TYPE..... A
10. 1 SINGLE.MULTI... S
11. 1 MANDATORY...... Y
7. 2 FIELD.NAME..... LC.REF
8. 2 LENGTH......... 16
9. 2 PRINT.TYPE..... A
10. 2 SINGLE.MULTI... S
11. 2 MANDATORY...... NO
7. 3 FIELD.NAME..... ISSUING.BANK.REF
8. 3 LENGTH......... 25
9. 3 PRINT.TYPE..... A
10. 3 SINGLE.MULTI... S
11. 3 MANDATORY...... NO
7. 4 FIELD.NAME..... ISSUE.DATE
8. 4 LENGTH......... 16
9. 4 PRINT.TYPE..... A
10. 4 SINGLE.MULTI... S
11. 4 MANDATORY...... NO
7. 5 FIELD.NAME..... EXPIRY.DATE
8. 5 LENGTH......... 6
9. 5 PRINT.TYPE..... N
10. 5 SINGLE.MULTI... S
11. 5 MANDATORY...... Y
7. 6 FIELD.NAME..... EXPIRY.PLACE
8. 6 LENGTH......... 29
9. 6 PRINT.TYPE..... A
10. 6 SINGLE.MULTI... S
11. 6 MANDATORY...... Y
7. 7 FIELD.NAME..... APPLICANT
8. 7 LENGTH......... 35
9. 7 PRINT.TYPE..... A
10. 7 SINGLE.MULTI... M
11. 7 MANDATORY...... Y
7. 8 FIELD.NAME..... BENE
8. 8 LENGTH......... 35
9. 8 PRINT.TYPE..... A
10. 8 SINGLE.MULTI... M
11. 8 MANDATORY...... Y
7. 9 FIELD.NAME..... CURRENCY.CODE
8. 9 LENGTH......... 3
9. 9 PRINT.TYPE..... A
10. 4 SINGLE.MULTI... S
11. 4 MANDATORY...... NO
7. 5 FIELD.NAME..... EXPIRY.DATE
8. 5 LENGTH......... 6
9. 5 PRINT.TYPE..... N
10. 5 SINGLE.MULTI... S
11. 5 MANDATORY...... Y
7. 6 FIELD.NAME..... EXPIRY.PLACE
8. 6 LENGTH......... 29
9. 6 PRINT.TYPE..... A
10. 6 SINGLE.MULTI... S
11. 6 MANDATORY...... Y
7. 7 FIELD.NAME..... APPLICANT
8. 7 LENGTH......... 35
9. 7 PRINT.TYPE..... A
10. 7 SINGLE.MULTI... M
11. 7 MANDATORY...... Y
7. 8 FIELD.NAME..... BENE
8. 8 LENGTH......... 35
9. 8 PRINT.TYPE..... A
10. 8 SINGLE.MULTI... M
11. 8 MANDATORY...... Y
7. 9 FIELD.NAME..... CURRENCY.CODE
8. 9 LENGTH......... 3
9. 9 PRINT.TYPE..... A
10. 9 SINGLE.MULTI... S
11. 9 MANDATORY...... Y
7.10 FIELD.NAME..... CURRENCY.AMT
8.10 LENGTH......... 15
9.10 PRINT.TYPE..... N
10.10 SINGLE.MULTI... S
11.10 MANDATORY...... Y
7.11 FIELD.NAME..... PERCENT
8.11 LENGTH......... 5
9.11 PRINT.TYPE..... A
10.11 SINGLE.MULTI... S
11.11 MANDATORY...... NO
7.12 FIELD.NAME..... MAX.CR.AMT
8.12 LENGTH......... 13
9.12 PRINT.TYPE..... A
10.12 SINGLE.MULTI... S
11.12 MANDATORY...... NO
7.13 FIELD.NAME..... ADD.AMT.COVERED
8.13 LENGTH......... 35
9.13 PRINT.TYPE..... A
10.13 SINGLE.MULTI... M
11.13 MANDATORY...... NO
7.14 FIELD.NAME..... AVAIL.CUST.ADD
8.14 LENGTH......... 35
9.14 PRINT.TYPE..... A
10.14 SINGLE.MULTI... M
11.14 MANDATORY...... NO
7.15 FIELD.NAME..... AVAIL.CUST
8.15 LENGTH......... 35
9.15 PRINT.TYPE..... A
10.15 SINGLE.MULTI... M
11.15 MANDATORY...... NO
7.16 FIELD.NAME..... AVAIL.BY
8.16 LENGTH......... 35
9.16 PRINT.TYPE..... A
10.16 SINGLE.MULTI... S
11.16 MANDATORY...... NO
7.17 FIELD.NAME..... DISPATCH
8.17 LENGTH......... 65
9.17 PRINT.TYPE..... A
10.17 SINGLE.MULTI... S
11.17 MANDATORY...... NO
7.18 FIELD.NAME..... TRANSPORT
8.18 LENGTH......... 65
9.18 PRINT.TYPE..... A
10.18 SINGLE.MULTI... S
11.18 MANDATORY...... NO
7.19 FIELD.NAME..... LATEST.SHIP.DATE
8.19 LENGTH......... 6
9.19 PRINT.TYPE..... N
10.19 SINGLE.MULTI... S
11.19 MANDATORY...... NO
7.20 FIELD.NAME..... SHIP.PERIOD
8.20 LENGTH......... 65
9.20 PRINT.TYPE..... A
10.20 SINGLE.MULTI... M
11.20 MANDATORY...... NO
7.21 FIELD.NAME..... DESC.GOODS
8.21 LENGTH......... 65
9.21 PRINT.TYPE..... A
10.21 SINGLE.MULTI... M
11.21 MANDATORY...... NO
7.22 FIELD.NAME..... DOC.REQ
8.22 LENGTH......... 65
9.22 PRINT.TYPE..... A
10.22 SINGLE.MULTI... M
11.22 MANDATORY...... NO
7.23 FIELD.NAME..... ADD.COND
8.23 LENGTH......... 65
9.23 PRINT.TYPE..... A
10.23 SINGLE.MULTI... M
11.23 MANDATORY...... NO
7.24 FIELD.NAME..... CHARGES.DET
8.24 LENGTH......... 35
9.24 PRINT.TYPE..... A
10.24 SINGLE.MULTI... M
11.24 MANDATORY...... NO
7.25 FIELD.NAME..... PERIOD.PRES
8.25 LENGTH......... 35
9.25 PRINT.TYPE..... A
10.25 SINGLE.MULTI... M
11.25 MANDATORY...... NO
7.26 FIELD.NAME..... CONFIRM.INS
8.26 LENGTH......... 7
9.26 PRINT.TYPE..... A
10.26 SINGLE.MULTI... S
11.26 MANDATORY...... Y
7.27 FIELD.NAME..... REIMB.BANK
8.27 LENGTH......... 35
9.27 PRINT.TYPE..... A
10.27 SINGLE.MULTI... M
11.27 MANDATORY...... NO
7.28 FIELD.NAME..... ADV.THRU.BANK
8.28 LENGTH......... 35
9.28 PRINT.TYPE..... A
10.28 SINGLE.MULTI... M
11.28 MANDATORY...... NO
7.29 FIELD.NAME..... INFORMATION
8.29 LENGTH......... 35
9.29 PRINT.TYPE..... A
10.29 SINGLE.MULTI... M
11.29 MANDATORY...... NO
7.30 FIELD.NAME..... CUSTOMER
9.30 PRINT.TYPE..... A
10.30 SINGLE.MULTI... S
10.31 SINGLE.MULTI... S
11.31 MANDATORY...... Y
7.32 FIELD.NAME..... DEPARTMENT
9.32 PRINT.TYPE..... A
10.32 SINGLE.MULTI... S
11.32 MANDATORY...... Y
7.33 FIELD.NAME..... CUS.COMPANY
9.33 PRINT.TYPE..... A
10.33 SINGLE.MULTI... S
11.33 MANDATORY...... Y
7.34 FIELD.NAME..... LANGUAGE
9.34 PRINT.TYPE..... A
10.34 SINGLE.MULTI... S
11.34 MANDATORY...... Y
7.35 FIELD.NAME..... APP.FORMAT
9.35 PRINT.TYPE..... A
10.35 SINGLE.MULTI... S
11.35 MANDATORY...... Y
7.36 FIELD.NAME..... ISSUE.BANK
9.36 PRINT.TYPE..... A
10.36 SINGLE.MULTI... M
11.36 MANDATORY...... NO
7.37 FIELD.NAME..... AVAIL.WITH
9.37 PRINT.TYPE..... A
10.37 SINGLE.MULTI... M
11.37 MANDATORY...... NO
7.38 FIELD.NAME..... ADVISING.BANK
9.38 PRINT.TYPE..... A
10.38 SINGLE.MULTI... S
11.38 MANDATORY...... NO
7.39 FIELD.NAME..... TRANSACTION.REF
8.39 LENGTH......... 16
9.39 PRINT.TYPE..... A
10.39 SINGLE.MULTI... S
11.39 MANDATORY...... NO
7.40 FIELD.NAME..... BEN.INFO
8.40 LENGTH......... 35
9.40 PRINT.TYPE..... A
10.40 SINGLE.MULTI... M
11.40 MANDATORY...... NO
27 CURR.NO........... 20
28. 1 INPUTTER....... 3956_YASSER
29. 1 DATE.TIME...... 09 MAY 11 08:21
30 AUTHORISER........ 4452_VALIDATE_4465_INPUTTER
31 CO.CODE........... IT-001-0001 UBAE Roma Head Office
32 DEPT.CODE......... 1 Implementation

DE.MAPPING

---

1. 1 GB DESCRIPTION. PRE-ADVICE OF A DOC CREDIT
5. 1 INPUT.POSITION. 1.1
8. 1 FIELD.NAME..... TYPE.OF.CREDIT
5. 2 INPUT.POSITION. 1.7
8. 2 FIELD.NAME..... ISSUE.BANK
5. 3 INPUT.POSITION. 1.214
8. 3 FIELD.NAME..... ISSUING.BANK.REF
5. 4 INPUT.POSITION. 8.7
8. 4 FIELD.NAME..... LC.REF
5. 5 INPUT.POSITION. 1.28
8. 5 FIELD.NAME..... EXPIRY.DATE
5. 6 INPUT.POSITION. 1.29
8. 6 FIELD.NAME..... EXPIRY.PLACE
5. 7 INPUT.POSITION. 1.10
8. 7 FIELD.NAME..... APPLICANT
5. 8 INPUT.POSITION. 1.13
8. 8 FIELD.NAME..... BENE
5. 9 INPUT.POSITION. 1.20
8. 9 FIELD.NAME..... CURRENCY.CODE
5.10 INPUT.POSITION. 1.21
8.10 FIELD.NAME..... CURRENCY.AMT
5.11 INPUT.POSITION. 1.52
8.11 FIELD.NAME..... PERCENT
5.12 INPUT.POSITION. 1.53
8.12 FIELD.NAME..... MAX.CR.AMT
5.13 INPUT.POSITION. 1.54
8.13 FIELD.NAME..... ADD.AMT.COVERED
5.14 INPUT.POSITION. 1.55
8.14 FIELD.NAME..... AVAIL.CUST.ADD
5.15 INPUT.POSITION. 1.56
8.15 FIELD.NAME..... AVAIL.CUST
5.16 INPUT.POSITION. 7.61
8.16 FIELD.NAME..... AVAIL.BY
5.17 INPUT.POSITION. 1.12
8.17 FIELD.NAME..... DISPATCH
5.18 INPUT.POSITION. 1.9
8.18 FIELD.NAME..... TRANSPORT
5.19 INPUT.POSITION. 1.27
8.19 FIELD.NAME..... LATEST.SHIP.DATE
5.20 INPUT.POSITION. 7.220
8.20 FIELD.NAME..... SHIP.PERIOD
5.21 INPUT.POSITION. 7.5
8.21 FIELD.NAME..... DESC.GOODS
5.22 INPUT.POSITION. 1.7
8.22 FIELD.NAME..... ADV.THRU.BANK
5.23 INPUT.POSITION. 7.16
8.23 FIELD.NAME..... INFORMATION
5.24 INPUT.POSITION. 1.13
8.24 FIELD.NAME..... CUSTOMER
8.25 FIELD.NAME..... COMPANY
9.25 HEADER.NAME.... COMPANY
5.26 INPUT.POSITION. 1.20
8.26 FIELD.NAME..... DEPARTMENT
9.26 HEADER.NAME.... DEPARTMENT
5.27 INPUT.POSITION. 8.11
8.27 FIELD.NAME..... CUS.COMPANY
9.27 HEADER.NAME.... CUS.COMPANY
5.28 INPUT.POSITION. 7.42
8.28 FIELD.NAME..... LANGUAGE
9.28 HEADER.NAME.... LANGUAGE
5.29 INPUT.POSITION. 8.7
8.29 FIELD.NAME..... DOC.REQ
5.30 INPUT.POSITION. 1.26
8.30 FIELD.NAME..... ADD.COND
5.31 INPUT.POSITION. 1.103.1
8.31 FIELD.NAME..... CHARGES.DET
5.32 INPUT.POSITION. 1.28
8.32 FIELD.NAME..... PERIOD.PRES
5.33 INPUT.POSITION. 1.29
8.33 FIELD.NAME..... CONFIRM.INS
5.34 INPUT.POSITION. 1.30
8.34 FIELD.NAME..... REIMB.BANK
5.35 INPUT.POSITION. 8.3
8.35 FIELD.NAME..... APP.FORMAT
9.35 HEADER.NAME.... APP.FORMAT
5.36 INPUT.POSITION. 9.2
8.36 FIELD.NAME..... BEN.INFO
5.37 INPUT.POSITION. 8.7
9.37 HEADER.NAME.... TRANS.REF
15.24 HEADER.POSITION 11
15.25 HEADER.POSITION 13
15.26 HEADER.POSITION 20
15.27 HEADER.POSITION 12
15.28 HEADER.POSITION 16
15.35 HEADER.POSITION 2
15.37 HEADER.POSITION 21
16 ROUTINE........... @UBAE.DFP.BENEFICIARY.INFO
30 CURR.NO........... 61
31. 1 INPUTTER....... 8493_YASSER
32. 1 DATE.TIME...... 13 MAY 11 05:49
33 AUTHORISER........ 321_VALIDATE
34 CO.CODE........... IT-001-0001 UBAE Roma Head Office
35 DEPT.CODE......... 1 Implementation


DE.FORMAT.PRINT

---

1. 1 GB DESCRIPTION. ACKNOWLEDGE TO APPLICANT (ISSUE)
2 FORM TYPE......... LETTER LETTER OF CREDIT FORMATS
3. 1 LINE(S)........ 02
4. 1 INDENT......... 75
7. 1 COMPLETE....... NO
8. 1 FIELD/"TEXT"... "Date"
15. 1 PAGE OVERFLOW.. NO
3. 2 LINE(S)........ +00
4. 2 INDENT......... 80
7. 2 COMPLETE....... NO
8. 2 FIELD/"TEXT"... EXPIRY.DATE
9. 2 CONVERSION..... DATE/F
15. 2 PAGE OVERFLOW.. NO
3. 3 LINE(S)........ +01
4. 3 INDENT......... 01
7. 3 COMPLETE....... NO
8. 3 FIELD/"TEXT"... "MAIL TO"
15. 3 PAGE OVERFLOW.. NO
3. 4 LINE(S)........ +00
4. 4 INDENT......... 50
7. 4 COMPLETE....... NO
8. 4 FIELD/"TEXT"... "ISSUING BANK"
15. 4 PAGE OVERFLOW.. NO
3. 5 LINE(S)........ +01-+06
4. 5 INDENT......... 01
6. 5 MULTI.......... M
7. 5 COMPLETE....... NO
8. 5 FIELD/"TEXT"... CUSTOMER
9. 5 CONVERSION..... CUS*FULL
15. 5 PAGE OVERFLOW.. NO
3. 6 LINE(S)........ +00-+06
4. 6 INDENT......... 50
6. 6 MULTI.......... M
7. 6 COMPLETE....... NO
8. 6 FIELD/"TEXT"... ISSUE.BANK
9. 6 CONVERSION..... CUS*FULL
15. 6 PAGE OVERFLOW.. NO
3. 7 LINE(S)........ +02
4. 7 INDENT......... 1
7. 7 COMPLETE....... NO
8. 7 FIELD/"TEXT"... "BENEFICIARY"
15. 7 PAGE OVERFLOW.. NO
3. 8 LINE(S)........ +00
4. 8 INDENT......... 50
7. 8 COMPLETE....... NO
8. 8 FIELD/"TEXT"... "AVAILABLE WITH"
15. 8 PAGE OVERFLOW.. NO
3. 9 LINE(S)........ +01-+06
4. 9 INDENT......... 1
6. 9 MULTI.......... M
7. 9 COMPLETE....... NO
8. 9 FIELD/"TEXT"... BENE
9. 9 CONVERSION..... CUS*FULL 3.19 LINE(S)........ +01
4.19 INDENT......... 1
7.19 COMPLETE....... NO
8.19 FIELD/"TEXT"... "Documentary Credit Number"
15.19 PAGE OVERFLOW.. NO
3.20 LINE(S)........ +00
4.20 INDENT......... 50
7.20 COMPLETE....... NO
8.20 FIELD/"TEXT"... ISSUING.BANK.REF
15.20 PAGE OVERFLOW.. NO
3.21 LINE(S)........ +01
4.21 INDENT......... 1
7.21 COMPLETE....... NO
8.21 FIELD/"TEXT"... "Amount"
15.21 PAGE OVERFLOW.. NO
3.22 LINE(S)........ +00
4.22 INDENT......... 50
7.22 COMPLETE....... NO
8.22 FIELD/"TEXT"... CURRENCY.CODE
15.22 PAGE OVERFLOW.. NO
3.23 LINE(S)........ +00
4.23 INDENT......... 54
7.23 COMPLETE....... NO
8.23 FIELD/"TEXT"... CURRENCY.AMT
10.23 MASK........... ,
15.23 PAGE OVERFLOW.. NO
3.24 LINE(S)........ +01
4.24 INDENT......... 1
7.24 COMPLETE....... NO
8.24 FIELD/"TEXT"... "Expiry Date / Place"
15.24 PAGE OVERFLOW.. NO
3.25 LINE(S)........ +00
4.25 INDENT......... 50
7.25 COMPLETE....... NO
8.25 FIELD/"TEXT"... EXPIRY.DATE
9.25 CONVERSION..... DATE/F
15.25 PAGE OVERFLOW.. NO
3.26 LINE(S)........ +00
4.26 INDENT......... 72
7.26 COMPLETE....... NO
8.26 FIELD/"TEXT"... EXPIRY.PLACE
15.26 PAGE OVERFLOW.. NO
3.27 LINE(S)........ +01
4.27 INDENT......... 1
7.27 COMPLETE....... NO
8.27 FIELD/"TEXT"... "

---

"

......
........

DE.O.HEADER

---

1 MESSAGE TYPE...... 1705
2 APPLICATION FORMAT 1
3 APPLICATION....... LC
4 DISPOSITION....... FORMATTED
6 PRIORITY.......... N
11. 1 CUSTOMER NUMBER CUST
11. 2 CUSTOMER NUMBER TEST
11. 3 CUSTOMER NUMBER NEWYORK CROSS ROAD
12 CUS. COMPANY...... 20110602
13 COMPANY CODE...... IT0010001
16 LANGUAGE.......... GB
20 DEPARTMENT........ USD
21 TRANSACTION REF... TF1115311138
23 TEST KEY REQ...... NO
25. 1 CARRIER ADDR NO PRINT.1
26. 1 COPY NUMBER.... 1-CUST
27. 1 FRAME NUMBER... 1
28. 1 FORMAT......... 1
29. 1 MSG LANGUAGE... GB
30. 1 MSG PRIORITY... N
32. 1 MSG DISPOSITION FORMATTED
36. 1. 1 TO ADDRESS.. CUST
36. 1. 2 TO ADDRESS.. TEST
36. 1. 3 TO ADDRESS.. NEWYORK CROSS ROAD
44. 1 FORM TYPE...... LETTER
53 BANK DATE......... 02 JUN 2011
60 CURR.NO........... 1
61. 1 INPUTTER....... 1_SYSTEM
62. 1 DATE.TIME...... 12 MAY 11 12:42
63 AUTHORISER........ 1_SYSTEM
64 CO.CODE........... IT-001-0001 UBAE Roma Head Office
65 DEPT.CODE......... 1 Implementation

DE.HANDOFF.DETS

---

0.0 DELIVERY KEY D20110512097544576500
0.1 MAPPING.KEY 1705.LC.1
0.2 BANK.DATE 20110602
1.1 TYPE.OF.CREDIT P
1.2 EP
1.3
1.4 NO
1.5
1.6 999999
1.7.1 ISSUE.BANK UBAE
1.7.2 ISSUE.BANK SEC Servizi
1.7.3 ISSUE.BANK Via Gauslino Transalgardo,
1.8
1.9 TRANSPORT 1000004
1.10.1 APPLICANT Sycamore Networks
1.10.2 APPLICANT Sycamore Networks
1.10.3 APPLICANT 220 Mill Road
1.10.4 APPLICANT Chelmsford
1.11
1.12 DISPATCH 232232
1.13.1 BENE CUST
1.13.2 BENE TEST
1.13.3 BENE NEWYORK CROSS ROAD
1.14
1.15
1.16
1.17
1.18 999999
1.19
1.20 CURRENCY.CODE USD
1.21 CURRENCY.AMT 11.00
1.22 B
1.23
1.24 1
1.25 TR
1.26 ADD.COND 9700.01
1.27 LATEST.SHIP.DATE 20110602
1.28 EXPIRY.DATE 20110604
1.29 EXPIRY.PLACE US
1.30 REIMB.BANK 20120529
1.31
1.32
1.33
1.34
1.35
1.36
1.37
1.38
1.52 PERCENT
1.53 MAX.CR.AMT
1.54 ADD.AMT.COVERED
1.55 AVAIL.CUST.ADD 777777
1.56 AVAIL.CUST
1.57
1.58
1.59
1.60
1.61
1.62 WITHOUT
1.63 MX
1.64 100
1.65 11.00
1.66 20110604
1.67
1.68 1
1.69
1.70 0
1.89
1.90 O
1.91 O
1.92 23101
1.93 1
1.94
1.95
1.96 NO
1.97
1.98
1.99
1.100
1.101
1.102
1.119
1.120
1.121
1.122
1.123
1.124
1.125
1.126
1.127
1.128 20110602
1.129
1.130
1.131
1.132
1.133
1.134
1.181
1.182
1.183
1.184
1.185
1.186
1.187
1.188
1.189
1.190
1.191
1.192
1.193
1.194 999999
1.195
1.196
1.197
1.198
1.199
1.200
1.201
1.202
1.203
1.204
1.205 YES
1.206
1.207 NO
1.208
1.209
1.210
1.211
1.212
1.213
1.214 ISSUING.BANK.REF
1.215
1.216
1.217
1.218
1.219
1.220
1.221
1.222
1.223
1.224
1.225
1.226
1.227 1100.000000000
1.228
1.229
1.230
1.231
1.232
1.233
1.234
1.235
1.236
1.237
1.238
1.239
1.240
1.241 INA2
1.242 1
1.243 2727_YASSER
1.244 1105121242
1.245 7826_VALIDATE
1.246 IT0010001
1.247 1
2.1
3.1
4.1
5.1
6.1
6.2
6.3 QQQ
7.1
7.2
7.3
7.4 1
7.5 DESC.GOODS CRED
7.6 USD

7.7
7.8
7.9 20110604
7.10
7.11 11
7.12
7.13
7.14 11.00
7.15
7.16 INFORMATION IRREVOCABLE
7.17 IRREVOCABLE
7.18 BY NEGOTIATION
7.19
7.20
7.21
7.22
7.23 SHA
7.24
7.25 B
7.26
7.27
7.28 TF1115311138
7.29
7.30 NONREF
7.31 999999
7.32 GB
7.33
7.34
7.35
7.36
7.37
7.38
7.39
7.40
7.41 1000004
7.42 LANGUAGE GB
7.43
7.44
7.45
7.46 232232
7.47 GB
7.48
7.49
7.50
7.51
7.52
7.53
7.54
7.55
7.56
7.57
7.58
7.59
7.60
7.61 AVAIL.BY 777777
7.62 GB
7.63
7.64
7.65
7.66
7.67
7.68
7.69
7.70
7.215
7.216
7.217
7.218
7.219
7.220 SHIP.PERIOD 1/1
7.221
7.222
7.223
7.224
7.225
7.226
7.227
7.228
7.229
7.230 B
7.231
7.232
7.233
7.234 999999
7.235
8.1 IT0010001
8.2 COMPANY IT0010001
8.3 APP.FORMAT 1
8.4
8.5 USD
8.6 1
8.7 LC.REF TF1115311138
8.8
8.9 GB
8.10
8.11 CUS.COMPANY 20110602
8.12
8.13
8.14
8.15
8.16
8.17
8.18
8.19
8.20 SOFT-DELIVERY HEADER
9.1
9.2 BEN.INFO QQQ
10.1

---

NOW DE.ADDRESS for the 777777 record where the conversion is not working is shown below

ID................ IT0010001.C-777777.PRINT.1

---

6. 1 GB SHORT NAME.. UBAE BANK
7. 1 GB NAME 1...... BANK
8. 1 GB NAME 2...... UBAE
9. 1 GB STREET ADDR. HIGHWAY ITALY
31 CURR.NO........... 1
32. 1 INPUTTER....... 1715_YASSER
33. 1 DATE.TIME...... 19 APR 11 06:54
34 AUTHORISER........ 1715_YASSER
35 CO.CODE........... IT-001-0001 UBAE Roma Head Office
36 DEPT.CODE......... 1 Implementation

---

I know its hard to digest :) , butt trust me i didnt have any other option .

God bless.

Regards
Yaser

BOSSSSS!!! u r soooooooo brilliant , and i must say u r a GEEEKKK !!!!
Thanx thanx thanx a MILLION :D it worked

I appriciate ur help from the bottom of my heart

Regards
Yasu.

Hi, jpb
I have a table from where I want to generate a MT299 swift message. So, I created a routine to extract data from my table and pass them to the APPLICATION.HANDOFF routine. I want to use the default records for 299 in DE.MESSAGE, DE.MAPPING, DE.FORMAT.SWIFT.

After I run my routine I can see, using DE.HANDOFF.DETS, how the data is filling the DE.O.HANDOFF table. But, I facing two problems here:
1) I'm getting the same DELIVERY key for each delivery created inside a loop calling the APPLICATION.HANDOFF routine
2) In DE.O.HEADER I'm getting the message is in REPAIR with error "ERROR - Mapping key error 299.EB.1"

Any suggestions will be appreciated.

Best regards.

Hi, jpb
I haven't tried, but I will.

Thanks and best regards.

It works fine. I created an entry in EB.FREE.MESSAGE application and everything went smoothly.

In this process, the data from my table record populates DE.O.HANDOFF array perfectly. Now I need to have that data to be part of tag 79 of MT299 swift message. Do I have to create my own DE.MAPPING record? or I need to create a routine for this?

Thanks in advance.

Does that routine need to be attached to 299 EB.ADVICE entry?