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) |