MT536 Statement of transactions
Data within an MT536 message is transformed and flattened to a row of data with the following fields in Duco.
| Duco field name | Duco field type | SWIFT message tag |
|---|---|---|
| Sender reference | Text | 20C |
| Preparation Date/Time | Date / Time | 98A/C/E |
| Statement Period Start | Date / Time | 69A and 69B |
| Statement Period End | Date / Time | 69A and 69B |
| Complete/Updates Indicator | Text | 22F/[Qualifier=CODE] |
| Statement Basis | Text | 22F/[Qualifier=STBA] |
| Account Owner LEI | 95L[Qualified=ALTE] | |
| Account Owner BIC | Text | 95P[Qualified=ACOW] |
| Account Owner ID | Text | 95R[Qualified=ACOW] |
| Account Number | Text | 97A/Account Number |
| 97B/Account Number | ||
| Account Type Code | Text | 97B/Account Type Code |
| Sub Account Number | Text | 97A/Account Number |
| 97B/Account Number | ||
| Sub Account Type Code | Text | 97B/Account Type Code |
| Sub Safekeeping Place | Text | 94B/Place |
| 94C/Country | ||
| 94F/Place | ||
| Sub Safekeeping BIC | Text | 94F/BICorBEI |
| ISIN | Text | 35B/ISIN |
| CUSIP | Text | 35B/Description |
| SEDOL | Text | 35B/Description |
| Ticker | Text | 35B/Description |
| Instrument Id | Text | 35B/Description |
| Instrument Description | Text | 35B/Description |
| Indicative Price Percentage | Decimal | F90A[Qualifier=INDC]/Price |
| Indicative Price Percentage Type | Text | F90A[Qualifier=INDC]/Percentage Type Code |
| Indicative Price | Decimal | F90B[Qualifier=INDC]/Price |
| Indicative Price Currency | Text | F90B[Qualifier=INDC]/Currency code |
| Indicative Price Type | Text | F90B[Qualifier=INDC]/Amount type code |
| Market Price Percentage | Decimal | F90A[Qualifier=MRKT]/Price |
| Market Price Percentage Type | Text | F90A[Qualifier=MRKT]/Percentage Type Code |
| Market Price | Decimal | F90B[Qualifier=MRKT]/Price |
| Market Price Currency | Text | F90B[Qualifier=MRKT]/Currency code |
| Market Price Type | Text | F90B[Qualifier=MRKT]/Amount type code |
| Source of Price | Text | 94B/Place code |
| Price Quotation Date/Time | Date / Time | 98a[Qualifier=PRIC] |
| Previous message reference | Text | 20C[Qualifier=PREV] |
| Related message reference | Text | 20C[Qualifier=RELA] |
| Account Servicer Reference | Text | LINK/20C[Qualifier=ASRF] |
| Common Reference | Text | LINK/20C[Qualifier=COMM] |
| Market Infrastructure txn id | Text | LINK/20C[Qualifier=MITI] |
| Deal Reference | Text | LINK/20C[Qualifier=TRRF] |
| Posting Quantity Amount | Decimal | 36B[Qualifier=PSTA][QuantityType=FAMT] |
| Posting Quantity Units | Decimal | 36B[Qualifier=PSTA][QuantityType=UNIT] |
| Posting Quantity Amortised | Decimal | 36B[Qualifier=PSTA][QuantityType=AMOR] |
| Posting Amount | Decimal | 19A[Qualifier=PSTA] |
| Posting Amount Currency | Text | 19A[Qualifier=PSTA] |
| Accrued Interest Amount | Decimal | 19A[Qualifier=ACRU] |
| Accrued Interest Currency | Text | 19A[Qualifier=ACRU] |
| Transaction Indicator | Text | 22F[Qualifier=TRAN] |
| Receive/Deliver Indicator | Text | 22H[Qualifier=REDE] |
| Payment Indicator | Text | 22H[Qualifier=PAYM] |
| Corporate Action Event Indicator | Text | 22F[Qualifier=CAEV] |
| Type of Settlement Txn Indicator | Text | 22F[Qualifier=SETR] |
| Acknowledged Status Timestamp | Date / Time | 98C[Qualifier=ASTS] |
| Effective Settlement Date/Time | Date / Time | 98A/98C[Qualifier=ESET] |
| Matched Status Timestamp | Date / Time | 98C[Qualifier=MTCH] |
| Settlement Date/Time | Date / Time | 98A/98C[Qualifier=SETT] |
| Settlement Date/Time Code | Text | 98B[Qualifier=SETT] |
| Trade Date/Time | Date / Time | 98A/98C[Qualifier=TRAD] |
| Trade Date/Time Code | Text | 98B[Qualifier=TRAD] |
| Value Date/Time | Date / Time | 98A/98C[Qualifier=VALU] |