Note: This format is supported via the Data Prep capability. If it is not available in your environment, please contact your Client Success Manager.
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 Tag |
| Block1_AppID | Text | 1a |
| Block1_ServiceID | Text | 2n |
| Block1_LTAddress_IdCode | Text | 8c |
| Block1_LTAddress_LT | Text | 1c |
| Block1_LTAddress_Branch | Text | 3c |
| Block1_SessionNumber | Text | 4n |
| Block1_SequenceNumber | Text | 6n |
| Block2_InputOutput | Text | 1a |
| Block2_MessageType | Text | 3n |
| Block2_DestinationAddress_IdCode | Text | 8c |
| Block2_DestinationAddress_LT | Text | 1c |
| Block2_DestinationAddress_Branch | Text | 3c |
| Block2_Priority | Text | 1a |
| Block2_DeliveryMonitoring | Text | 1x |
| Block2_ObsolescencePeriod | Text | 3n |
| Block2_InputTime | Text | 4n |
| Block2_MIR | Text | 28c |
| Block2_OutputDate | Date | 6n |
| Block2_OutputTime | Time | 4n |
| Block3_ServiceIdentifier | Text | {103:3!a} |
| Block3_BankingPriority | Text | {113:4!x} |
| Block3_MUR | Text | {108:16!x} |
| Block3_ValidationFlag | Text | {119:8c} |
| Block3_BalanceCheckpoint_Date | Date | {423:YYMMDDHHMMSS[ss]} |
| Block3_BalanceCheckpoint_Time | Time | {423:YYMMDDHHMMSS[ss]} |
| Block3_BalanceCheckpoint_DecimalFractions | Text | {423:YYMMDDHHMMSS[ss]} |
| Block3_MIR_Date | Date | {106:} 6n |
| Block3_MIR_LTIdentifier | Text | {106:} 4a2a2c1c |
| Block3_MIR_BranchCode | Text | {106:} 3c |
| Block3_MIR_SessionNumber | Text | {106:} 4n |
| Block3_MIR_SequenceNumber | Text | {106:} 6n |
| Block3_RelatedReference | Text | {424:16x} |
| Block3_ServiceTypeIdentifier | Text | {111:3!n} |
| Block3_UniqueEndToEndTransactionReference | Text | {121:xxxxxxxx-xxxx-4xxx-yxxxxxxxxxxxxxxx} |
| Block3_AddresseeInformation | Text | {115:32x} |
| Block3_PaymentRelease_ServiceTypeIdentifier | Text | {165:/3!c/34x} |
| Block3_PaymentRelease_UniqueEndToEndTransactionReference | Text | {165:/3!c/34x} |
| Block3_SanctionsSceening_Codeword | Text | {433:/3!a/[20x]} |
| Block3_SanctionsSceening_AddInfo | Text | {433:/3!a/[20x]} |
| Block3_PaymentControls_Codeword | Text | {434:/3!a/[20x] |
| Block3_PaymentControls_AddInfo | Text | {434:/3!a/[20x]} |
| Block4_GenInfo_PageNumber | Integer | Tag: 28E Format Specification: 5n/ |
| Block4_GenInfo_ContinuationInd | Text | Tag: 28E Format Specification: 4!c |
| Block4_GenInfo_StatementNumber | Text | Tag: 13a Qualifier: STAT FormatOption: A (3!c) or J (5!c) |
| Block4_GenInfo_SendersReference | Text | Tag: 20C Qualifier: SEME Format Specification: 16x |
| Block4_GenInfo_Function | Text | Tag: 23G Format Specification: 4!c |
| Block4_GenInfo_Subfunction | Text | Tag: 23G Format Specification: /4!c |
| Block4_GenInfo_PrepDate | Date | Tag: 98a Qualifier: PREP FormatOption: A (8!n) or C (8!n) |
| Block4_GenInfo_PrepTime | Time | Tag: 98a Qualifier: PREP FormatOption: C (8!n) |
| Block4_GenInfo_StatementPeriod_StartDate | Date | Tag: 69A or 69B Qualifier: STAT Format Specification: 8!n/ |
| Block4_GenInfo_StatementPeriod_EndDate | Date | Tag: 69A or 69B Qualifier: STAT Format Specification: 8!n |
| Block4_GenInfo_StatementPeriod_StartTime | Time | Tag: 69B Qualifier: STAT Format Specification: 6!n/ |
| Block4_GenInfo_StatementPeriod_EndTime | Time | Tag: 69B Qualifier: STAT Format Specification: 6!n |
| Block4_GenInfo_StatementFreqInd | Text | Tag: 22F Qualifier: SFRE Format Specification: 4!c |
| Block4_GenInfo_CompleteOrUpdatesInd | Text | Tag: 22F Qualifier: CODE Format Specification: 4!c |
| Block4_GenInfo_StatementBasis | Text | Tag: 22F Qualifier: STBA Format Specification: 4!c |
| Block4_GenInfo_AccountOwner_BIC | Text | Tag: 95P Qualifier: ACOW Format Specification: 4!a2!a2!c[3!c] |
| Block4_GenInfo_AccountOwner_ID_DataSourceScheme | Text | Tag: 95R Qualifier: ACOW Format Specification: 8c |
| Block4_GenInfo_AccountOwner_ID_ProprietaryCode | Text | Tag: 95R Qualifier: ACOW Format Specification: 34x |
| Block4_GenInfo_AccountOwner_LEI | Text | Tag: 95L Qualifier: ALTE Format Specification: 18!c2!n |
| Block4_GenInfo_AccountTypeCode | Text | Tag: 97B Qualifier: SAFE Format Specification: 4!c/ |
| Block4_GenInfo_AccountNumber | Text | Tag: 97A or 97B Qualifier: SAFE Format Specification: 35x |
| Block4_GenInfo_Flags_ActivityFlag | Text | Tag: 17B Qualifier: ACTI Format Specification: 1!a |
| Block4_GenInfo_Flags_SubsafekeepingStatement | Text | Tag: 17B Qualifier: CONS Format Specification: 1!a |
| Block4_SubSafeAcc_AccountTypeCode | Text | Tag: 97B Qualifier: SAFE Format Specification: 4!c/ |
| Block4_SubSafeAcc_AccountNumber | Text | Tag: 97A or 97B Qualifier: SAFE Format Specification: 35x |
| Block4_SubSafeAcc_Safekeeping_Place | Text | Tag: 94B or 94C or 94F Qualifier: SAFE Format Specification: 4!c |
| Block4_SubSafeAcc_Safekeeping_BIC | Text | Tag: 94F or 94L Format Specification: 4!a2!a2!c[3!c] |
| Block4_SubSafeAcc_ActivityFlag | Text | Tag: 17B Qualifier: ACTI Format Specification: 1!a |
| Block4_SubSafeAcc_FinInstr_IdOfSecurity | Text | Tag: 35B Format Specification: ISIN1!e12!c |
| Block4_SubSafeAcc_FinInstr_DescOfSecurity | Text | Tag: 35B Format Specification: 4x35x |
| Block4_SubSafeAcc_FinInstr_Price_IndicativePrice_PercentageTypeCode | Text | Tag: 90A Qualifier: INDC Format Specification: 4!c/ |
| Block4_SubSafeAcc_FinInstr_Price_IndicativePrice_Percentage | Decimal | Tag: 90A Qualifier: INDC Format Specification: [N]15d |
| Block4_SubSafeAcc_FinInstr_Price_IndicativePrice_AmountTypeCode | Text | Tag: 90B Qualifier: INDC Format Specification: 4!c/ |
| Block4_SubSafeAcc_FinInstr_Price_IndicativePrice_AmountCcyCode | Text | Tag: 90B Qualifier: INDC Format Specification: 3!a |
| Block4_SubSafeAcc_FinInstr_Price_IndicativePrice_Amount | Decimal | Tag: 90B Qualifier: INDC Format Specification: 15d |
| Block4_SubSafeAcc_FinInstr_Price_MarketPrice_PercentageTypeCode | Text | Tag: 90A Qualifier: MRKT Format Specification: 4!c/ |
| Block4_SubSafeAcc_FinInstr_Price_MarketPrice_Percentage | Decimal | Tag: 90A Qualifier: MRKT Format Specification: [N]15d |
| Block4_SubSafeAcc_FinInstr_Price_MarketPrice_AmountTypeCode | Text | Tag: 90B Qualifier: MRKT Format Specification: 4!c/ |
| Block4_SubSafeAcc_FinInstr_Price_MarketPrice_AmountCcyCode | Text | Tag: 90B Qualifier: MRKT Format Specification: 3!a |
| Block4_SubSafeAcc_FinInstr_Price_MarketPrice_Amount | Decimal | Tag: 90B Qualifier: MRKT Format Specification: 15d |
| Block4_SubSafeAcc_FinInstr_SourceOfPrice_PlaceCode | Text | Tag: 94B Qualifier: PRIC Format Specification: 8c |
| Block4_SubSafeAcc_FinInstr_PriceQuoteDate | Date | Tag: 98A or 98C Qualifier: PRIC Format Specification: 8c |
| Block4_SubSafeAcc_FinInstr_PriceQuoteTime | Time | Tag: 98C Qualifier: PRIC Format Specification: 6!n |
| Block4_SubSafeAcc_Txn_Link_CounterptyMktInfrastructureTransctnId | Text | Tag: 20C Qualifier: CMIT Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_PoolReference | Text | Tag: 20C Qualifier: POOL Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_PreviousReference | Text | Tag: 20C Qualifier: PREV Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_RelatedReference | Text | Tag: 20C Qualifier: RELA Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_DealReference | Text | Tag: 20C Qualifier: TRRF Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_CommonReference | Text | Tag: 20C Qualifier: COMM Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_AcctServicerReference | Text | Tag: 20C Qualifier: ASRF Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_CorporateActionReference | Text | Tag: 20C Qualifier: CORP Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_TripartyAgentCollatTransReference | Text | Tag: 20C Qualifier: TCTR Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_ClientTriPrtyCollatTransReference | Text | Tag: 20C Qualifier: CLTR Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_ClientsCollatInstrucReference | Text | Tag: 20C Qualifier: CLCI Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_TripartysCollatInstructReference | Text | Tag: 20C Qualifier: TRCI Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_MktInfrastructureTransactionId | Text | Tag: 20C Qualifier: MITI Format Specification: 16x |
| Block4_SubSafeAcc_Txn_Link_ProcessorTransactionIdentification | Text | Tag: 20C Qualifier: PCTI Format Specification: 16x |
| Block4_SubSafeAcc_TxnDetails_PlaceOfClearing_Id | Text | Tag: 94H of 94L Qualifier: CLEA |
| Block4_SubSafeAcc_TxnDetails_PlaceOfTrade_Place | Text | Tag: 94B Qualifier: TRAD |
| Block4_SubSafeAcc_TxnDetails_PlaceOfTrade_Id | Text | Tag: 94B or 94L Qualifier: TRAD |
| Block4_SubSafeAcc_TxnDetails_PlaceOfSafeKeeping_Place | Text | Tag: 94B or 94C or 94F Qualifier: SAFE |
| Block4_SubSafeAcc_TxnDetails_PlaceOfSafeKeeping_Id | Text | Tag: 94B or 94F or 94L Qualifier: SAFE |
| Block4_SubSafeAcc_TxnDetails_PostingQuantity_Amortised | Decimal | Tag: 36B Qualifier: PSTA//AMOR Format Specification: 15d |
| Block4_SubSafeAcc_TxnDetails_PostingQuantity_FaceAmount | Decimal | Tag: 36B Qualifier: PSTA//FAMT Format Specification: 15d |
| Block4_SubSafeAcc_TxnDetails_PostingQuantity_Unit | Decimal | Tag: 36B Qualifier: PSTA//UNIT Format Specification: 15d |
| Block4_SubSafeAcc_TxnDetails_PostingAmount_Ccy | Text | Tag: 19A Qualifier: PSTA Format Specification: [N>]3!a |
| Block4_SubSafeAcc_TxnDetails_PostingAmount | Decimal | Tag: 19A Qualifier: PSTA Format Specification: [<N]15d |
| Block4_SubSafeAcc_TxnDetails_AccruedInterestAmount_Ccy | Text | Tag: 19A Qualifier: ACRU Format Specification: [N>]3!a |
| Block4_SubSafeAcc_TxnDetails_AccruedInterestAmount | Decimal | Tag: 19A Qualifier: ACRU Format Specification: [<N]15d |
| Block4_SubSafeAcc_TxnDetails_Transaction_Indicator | Text | Tag: 22F Qualifier: TRAN Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_ReceiveOrDeliverInd | Text | Tag: 22H Qualifier: REDE Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_PaymentIndicator | Text | Tag: 22H Qualifier: PAYM Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_CAEventInd | Text | Tag: 22F Qualifier: CAEV Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_TypeOfSettTxn | Text | Tag: 22F Qualifier: SETR Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_AcknwlgdStatusDate | Date | Tag: 98C Qualifier: ASTS Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_AcknwlgdStatusTime | Time | Tag: 98C Qualifier: ASTS Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_EffSettDate | Date | Tag: 98A or 98C Qualifier: ESET Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_EffSettTime | Time | Tag: 98C Qualifier: ESET Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_MatchedStatusDate | Date | Tag: 98C Qualifier: MTCH Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_MatchedStatusTime | Time | Tag: 98C Qualifier: MTCH Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_SettlementDate | Date | Tag: 98A or 98C Qualifier: SETT Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_SettlementTime | Time | Tag: 98C Qualifier: SETT Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_SettlementDateTime_Code | Text | Tag: 98B Qualifier: SETT Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_TradeDate | Date | Tag: 98A or 98C Qualifier: TRAD Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_TradeTime | Time | Tag: 98C Qualifier: TRAD Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_TradeDateTime_Code | Text | Tag: 98B Qualifier: TRAD Format Specification: 4!c |
| Block4_SubSafeAcc_TxnDetails_ValueDate | Date | Tag: 98A or 98C Qualifier: VALU Format Specification: 8c |
| Block4_SubSafeAcc_TxnDetails_ValueTime | Time | Tag: 98C Qualifier: VALU Format Specification: 6!n |
| Block4_SubSafeAcc_TxnDetails_TransactionDetailsNarrative | Text | Tag: 70E Qualifier: TRDE Format Specification: 10*35x |
| Block4_SubSafeAcc_TxnDetails_SetParties_PlaceSettlement | Text | Tag: 95P Qualifier: PSET Format Specification: 4!a2!a2!c[3!c] |