MT535 Statement of holdings
Data within an MT535 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 | SWIFT message sequence |
| Sender | Text | The Logical Terminal (LT) Address | Message block 1 |
| Statement Type | Text | 22F (STTY) | Sequence A (General Information) |
| Statement Basis | Text | 22F (STBA) | Sequence A (General Information) |
| Account Number | Text | 97A / 97B | Sequence A (General Information) |
| Account Type Code | Text | 97B | Sequence A (General Information) |
| Statement Date | Date | 98A / 98C (STAT) | Sequence A (General Information) |
| Preparation Date Time | Date | 98A / 98C (PREP) | Sequence A (General Information) |
| Sub Account Number | Text | 97A / 97B | Sequence B (Sub-safekeeping Account) |
| Sub Account Type Code | Text | 97B | Sequence B (Sub-safekeeping Account) |
| Sub Safekeeping Place | Text | 94B, 94C | Sequence B (Sub-safekeeping Account) |
| Sub Safekeeping BIC | Text | 94F | Sequence B (Sub-safekeeping Account) |
| Activity Flag | Text | 17B (ACTI) | Sequence B (Sub-safekeeping Account) |
| Coupon Date | Date | 98A (COUP) | Sequence B1 (Financial Instrument) |
| Expiry Date | Date | 98A (EXPI) | Sequence B1 (Financial Instrument) |
| Floating Rate Note Reset Date | Date | 98A (FRNR) | Sequence B1 (Financial Instrument) |
| Maturity Date | Date | 98A (MATU) | Sequence B1 (Financial Instrument) |
| Issue Date | Date | 98A (ISSU) | Sequence B1 (Financial Instrument) |
| Call Date | Date | 98A (CALD) | Sequence B1 (Financial Instrument) |
| Put Date | Date | 98A (PUTT) | Sequence B1 (Financial Instrument) |
| Dated Date | Date | 98A (DDTE) | Sequence B1 (Financial Instrument) |
| First Coupon Date | Date | 98A (FCOU) | Sequence B1 (Financial Instrument) |
| Interest rate | Decimal | 92A (INTR) | Sequence B1 (Financial Instrument) |
| FIA narrative | Text | 70E (FIAN) | Sequence B1 (Financial Instrument) |
| ISIN | Text | 35B | Sequence B1 (Financial Instrument) |
| CUSIP | Text | 35B | Sequence B1 (Financial Instrument) |
| SEDOL | Text | 35B | Sequence B1 (Financial Instrument) |
| Ticker | Text | 35B | Sequence B1 (Financial Instrument) |
| Instrument Id | Text | 35B | Sequence B1 (Financial Instrument) |
| Instrument Description | Text | 35B | Sequence B1 (Financial Instrument) |
| Book Value | Decimal | 19A (BOOK) | Sequence B1b (Sub-balance) |
| Book Currency | Text | 19A (BOOK) | Sequence B1b (Sub-balance) |
| Holding Value | Decimal | 19A (HOLD) | Sequence B1b (Sub-balance) |
| Holding Currency | Text | 19A (HOLD) | Sequence B1b (Sub-balance) |
| FIN narrative | Text | 70E (HOLD) | Sequence B1b (Sub-balance) |
| Indicative Price Percentage | Decimal | 90A (INDC) | Sequence B1b (Sub-balance) |
| Indicative Price Percentage Type | Text | 90A (INDC) | Sequence B1b (Sub-balance) |
| Indicative Price | Decimal | 90B (INDC) | Sequence B1b (Sub-balance) |
| Indicative Price Currency | Text | 90B (INDC) | Sequence B1b (Sub-balance) |
| Indicative Price Type | Text | 90E (INDC) | Sequence B1b (Sub-balance) |
| Market Price Percentage | Decimal | 90A (MRKT) | Sequence B1b (Sub-balance) |
| Market Price Percentage Type | Text | 90A (MRKT) | Sequence B1b (Sub-balance) |
| Market Price | Decimal | 90B (MRKT) | Sequence B1b (Sub-balance) |
| Market Price Currency | Text | 90B (MRKT) | Sequence B1b (Sub-balance) |
| Market Price Type | Text | 90A (MRKT) | Sequence B1b (Sub-balance) |
| Exchange Currency 1 | Text | 92B (EXCH) | Sequence B1b (Sub-balance) |
| Exchange Currency 2 | Text | 92B (EXCH) | Sequence B1b (Sub-balance) |
| Exchange Rate | Decimal | 92B (EXCH) | Sequence B1b (Sub-balance) |
| Aggregate Balance Amount | Decimal | 93B (AGGR) | Sequence B1b (Sub-balance) |
| Aggregate Balance Units | Decimal | 93B (AGGR) | Sequence B1b (Sub-balance) |
| Aggregate Balance Amortised | Decimal | 93B (AGGR) | Sequence B1b (Sub-balance) |
| Available Balance Amount | Decimal | 93B (AVAI) | Sequence B1b (Sub-balance) |
| Available Balance Units | Decimal | 93B (AVAI) | Sequence B1b (Sub-balance) |
| Available Balance Amortised | Decimal | 93B (AVAI) | Sequence B1b (Sub-balance) |
| Pend borrow del amount | Decimal | 93B (BODE//FAMT) | Sequence B1b (Sub-balance) |
| Pend borrow del units | Decimal | 93B (BODE//UNIT) | Sequence B1b (Sub-balance) |
| Pend borrow del amortised | Decimal | 93B (BODE//AMOR) | Sequence B1b (Sub-balance) |
| AVAI pend borrow del amount | Decimal | 93C (BODE//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend borrow del units | Decimal | 93C (BODE//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend borrow del amortised | Decimal | 93C (BODE//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL pend borrow del amount | Decimal | 93C (BODE//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend borrow del units | Decimal | 93C (BODE//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend borrow del amortised | Decimal | 93C (BODE//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Pend borrow rec amount | Decimal | 93B (BORE//FAMT) | Sequence B1b (Sub-balance) |
| Pend borrow rec units | Decimal | 93B (BORE//UNIT) | Sequence B1b (Sub-balance) |
| Pend borrow rec amortised | Decimal | 93B (BORE//AMOR) | Sequence B1b (Sub-balance) |
| AVAI pend borrow rec amount | Decimal | 93C (BORE//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend borrow rec units | Decimal | 93C (BORE//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend borrow rec amortised | Decimal | 93C (BORE//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL pend borrow rec amount | Decimal | 93C (BORE//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend borrow rec units | Decimal | 93C (BORE//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend borrow rec amortised | Decimal | 93C (BORE//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Borrow amount | Decimal | 93B (BORR//FAMT) | Sequence B1b (Sub-balance) |
| Borrow units | Decimal | 93B (BORR//UNIT) | Sequence B1b (Sub-balance) |
| Borrow amortised | Decimal | 93B (BORR//AMOR) | Sequence B1b (Sub-balance) |
| AVAI borrow amount | Decimal | 93C (BORR//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI borrow units | Decimal | 93C (BORR//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI borrow amortised | Decimal | 93C (BORR//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL borrow amount | Decimal | 93C (BORR//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL borrow units | Decimal | 93C (BORR//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL borrow amortised | Decimal | 93C (BORR//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Collateral in amount | Decimal | 93B (COLI//FAMT) | Sequence B1b (Sub-balance) |
| Collateral in units | Decimal | 93B (COLI//UNIT) | Sequence B1b (Sub-balance) |
| Collateral in amortised | Decimal | 93B (COLI//AMOR) | Sequence B1b (Sub-balance) |
| AVAI collateral in amount | Decimal | 93C (COLI//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI collateral in units | Decimal | 93C (COLI//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI collateral in amortised | Decimal | 93C (COLI//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL collateral in amount | Decimal | 93C (COLI//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL collateral in units | Decimal | 93C (COLI//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL collateral in amortised | Decimal | 93C (COLI//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Collateral out amount | Decimal | 93B (COLO//FAMT) | Sequence B1b (Sub-balance) |
| Collateral out units | Decimal | 93B (COLO//UNIT) | Sequence B1b (Sub-balance) |
| Collateral out amortised | Decimal | 93B (COLO//AMOR) | Sequence B1b (Sub-balance) |
| AVAI collateral out amount | Decimal | 93C (COLO//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI collateral out units | Decimal | 93C (COLO//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI collateral out amortised | Decimal | 93C (COLO//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL collateral out amount | Decimal | 93C (COLO//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL collateral out units | Decimal | 93C (COLO//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL collateral out amortised | Decimal | 93C (COLO//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| On loan amount | Decimal | 93B (LOAN//FAMT) | Sequence B1b (Sub-balance) |
| On loan units | Decimal | 93B (LOAN//UNIT) | Sequence B1b (Sub-balance) |
| On loan amortised | Decimal | 93B (LOAN//AMOR) | Sequence B1b (Sub-balance) |
| AVAI on loan amount | Decimal | 93C (LOAN//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI on loan units | Decimal | 93C (LOAN//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI on loan amortised | Decimal | 93C (LOAN//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL on loan amount | Decimal | 93C (LOAN//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL on loan units | Decimal | 93C (LOAN//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL on loan amortised | Decimal | 93C (LOAN//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Pend on loan del amount | Decimal | 93B (LODE//FAMT) | Sequence B1b (Sub-balance) |
| Pend on loan del units | Decimal | 93B (LODE//UNIT) | Sequence B1b (Sub-balance) |
| Pend on loan del amortised | Decimal | 93B (LODE//AMOR) | Sequence B1b (Sub-balance) |
| AVAI pend on loan del amount | Decimal | 93C (LODE//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend on loan del units | Decimal | 93C (LODE//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend on loan del amortised | Decimal | 93C (LODE//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL pend on loan del amount | Decimal | 93C (LODE//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend on loan del units | Decimal | 93C (LODE//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend on loan del amortised | Decimal | 93C (LODE//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Pend on loan rec amount | Decimal | 93B (LORE//FAMT) | Sequence B1b (Sub-balance) |
| Pend on loan rec units | Decimal | 93B (LORE//UNIT) | Sequence B1b (Sub-balance) |
| Pend on loan rec amortised | Decimal | 93B (LORE//AMOR) | Sequence B1b (Sub-balance) |
| AVAI pend on loan rec amount | Decimal | 93C (LORE//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend on loan rec units | Decimal | 93C (LORE//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pend on loan rec amortised | Decimal | 93C (LORE//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL pend on loan rec amount | Decimal | 93C (LORE//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend on loan rec units | Decimal | 93C (LORE//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pend on loan rec amortised | Decimal | 93C (LORE//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Pledged amount | Decimal | 93B (PLED//FAMT) | Sequence B1b (Sub-balance) |
| Pledged units | Decimal | 93B (PLED//UNIT) | Sequence B1b (Sub-balance) |
| Pledged amortised | Decimal | 93B (PLED//AMOR) | Sequence B1b (Sub-balance) |
| AVAI pledged amount | Decimal | 93C (PLED//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pledged units | Decimal | 93C (PLED//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI pledged amortised | Decimal | 93C (PLED//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL pledged amount | Decimal | 93C (PLED//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pledged units | Decimal | 93C (PLED//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL pledged amortised | Decimal | 93C (PLED//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Restricted amount | Decimal | 93B (RSTR//FAMT) | Sequence B1b (Sub-balance) |
| Restricted units | Decimal | 93B (RSTR//UNIT) | Sequence B1b (Sub-balance) |
| Restricted amortised | Decimal | 93B (RSTR//AMOR) | Sequence B1b (Sub-balance) |
| AVAI restricted amount | Decimal | 93C (RSTR//FAMT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI restricted units | Decimal | 93C (RSTR//UNIT/AVAI) | Sequence B1b (Sub-balance) |
| AVAI restricted amortised | Decimal | 93C (RSTR//AMOR/AVAI) | Sequence B1b (Sub-balance) |
| NAVL restricted amount | Decimal | 93C (RSTR//FAMT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL restricted units | Decimal | 93C (RSTR//UNIT/NAVL) | Sequence B1b (Sub-balance) |
| NAVL restricted amortised | Decimal | 93C (RSTR//AMOR/NAVL) | Sequence B1b (Sub-balance) |
| Not Available Balance Amount | Decimal | 93B (NAVL) | Sequence B1b (Sub-balance) |
| Not Available Balance Units | Decimal | 93B (NAVL) | Sequence B1b (Sub-balance) |
| Not Available Balance Amortised | Decimal | 93B (NAVL) | Sequence B1b (Sub-balance) |