× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Data fields mapping for swift messages

Start
Prev
1
Next
End

sailen
Topic Author
Offline
Premium Member

11 years 8 months ago #14808 by sailen

Data fields mapping for swift messages was created by sailen

Hi,

Can anyone please suggest me how can I check the actual mapping between the data fields and the fields defined for swift messages?
Actually I had checked in DE.MAPPING, it seems that the mapping is done through INPUT.POSITION field.

But I want to know the exact field name and the table name to which the swift message's fields are mapped so that I can tell the users to input the data in the correct field to get the data displayed for the correct tag of swift message.

Quick response is highly appreciated.

Thanks & Regards,
Sailendra

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

11 years 8 months ago #14810 by jpb

Replied by jpb on topic Data fields mapping for swift messages

It depends on the message.
There is no standard which records is placed where in the handoff.
Common might be that record 1 is the application record (R.NEW) but the rest is changing from application to application.

A chance to near down is using enquiry DE.HANDOFF.DETS which at least shows contents of all 9 handoff records and the used names for each field. This might enable you to find out if any record represents an application (might be R.OLD as well).

For some the mapping can be found in DE.MAPPING itself (INPUT.REC.NO INPUT.REC.DESC).

Please Log in or Create an account to join the conversation.

sailen
Topic Author
Offline
Premium Member

11 years 8 months ago #14816 by sailen

Replied by sailen on topic Data fields mapping for swift messages

Hi,

I guess in DE.HANDOFF.DETS enquiry, only those field names used for swift are displayed but no field names from the table are shown. Actually I just want to know to which field tag 86 of MT 940 is mapped. When I viewed this in DE.MAPPING, I could find the record as below:
Input Position.58 - 1.60
Field Name.58 - SWIFT ENTRY INFO

Also when I checked in DE.FORMAT.SWIFT, I could find the data as below:
Field Tag.18 - 86
Field Name.18 - SWIFT ENTRY INFO

Since the data for this field is not showing in MT940 message, I want to know in which field the user should input the value to get it displayed in that message.

I hope you understand my issue.

Thanks,
Sailendra

Please Log in or Create an account to join the conversation.

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

11 years 8 months ago #14818 by jpb

Replied by jpb on topic Data fields mapping for swift messages

Here you touched a very special case. The first handoff for statements is total generic and field 1.60 for TAG 86 in it is a high complex construct.

So complex that TMNS created an own "How TO" for this : How To

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.036 seconds