MT940 Customer statement
When used in a generic process in Duco, data within an MT940 message is transformed and flattened to a row of data with the following fields. When used in a cash reconciliation process, data is transformed into a cash statement containing balance and transaction data, where each transaction contains the same set of fields.
| Duco field name | Duco field type | SWIFT message tag |
|---|---|---|
| Value date | Date | 61 (sub field 1) |
| Entry date | Date | 61 (sub field 2) |
| Debit/credit mark | Text | 61 (sub field 3) |
| Funds code | Text | 61 (sub field 4) |
| Amount | Decimal | 61 (sub field 5) |
| Transaction type | Text | 61 (sub field 6) |
| Identification code | Text | 61 (sub field 6) |
| Reference for the account owner | Text | 61 (sub field 7) |
| Account servicing inst reference | Text | 61 (sub field 8) |
| Supplementary details | Text | 61 (sub field 9) |
| Account identifier | Text | 25 |
| Information to account owner | Text | 86 |
| Currency | Text | 60a (sub field 3) |
| Initial opening balance | Decimal | 60a (option F) |
| Final closing balance | Decimal | 62a (option F) |
| Intermediate opening balance | Decimal | 60a (option M) |
| Intermediate closing balance | Decimal | 62a (option M) |
| Statement number | Integer | 28c (sub field 1) |
| Sequence number | Integer | 28c (sub field 2) |