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 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_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] |