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 MT381 message is transformed and flattened to a row of data with the following fields in Duco.
| Data Prep field name | Data Type | Content / Options |
| Record_ID | Text | Record tracking |
| 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 | Integer | 4n |
| Block1_SequenceNumber | Integer | 6n |
| Block2_Input/Output | Text | 1a |
| Block2_MessageType | Integer | 3n |
| Block2_DestinationAddress_IdCode | Text | 8c |
| Block2_DestinationAddress_LT | Text | 1c |
| Block2_DestinationAddress_Branch | Text | 3c |
| Block2_Priority | Text | 1a |
| Block2_DeliveryMonitoring | Integer | 1x |
| Block2_ObsolescencePeriod | Integer | 3n |
| Block2_InputTime | Integer | 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 | Integer | {423:YYMMDDHHMMSS[ss]} |
| Block3_MIR_Date | Date | {106:} 6n |
| Block3_MIR_LTIdentifier | Text | {106:} 4a2a2c1c |
| Block3_MIR_BranchCode | Text | {106:} 3c |
| Block3_MIR_SessionNumber | Integer | {106:} 4n |
| Block3_MIR_SequenceNumber | Integer | {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_AdditionalInformation | Text | {433:/3!a/[20x]} |
| Block3_PaymentControls_Codeword | Text | {434:/3!a/[20x] |
| Block3_PaymentControls_AdditionalInformation | Text | {434:/3!a/[20x]} |
| Block4_SendersReference | Text | Tag: 20C Qualifier: SEME Format Specification: 16x |
| Block4_FunctionOfMessage_Function | Text | Tag: 23G Format Specification: 4!c |
| Block4_FunctionOfMessage_SubFunction | Text | Tag: 23G Format Specification: /4!c |
| Block4_FXOrderTxnTypeInd | Text | Tag: 22H Qualifier: FXTR Format Specification: 4!c |
| Block4_Linkages_LinkedTxn | Text | Tag: 13A Qualifier: LINK Format Specification: 3!c |
| Block4_Linkages_LinkedTxnWithDSS_DataSourceScheme | Text | Tag: 13B Qualifier: LINK Format Specification: 8c |
| Block4_Linkages_LinkedTxnWithDSS_Number | Text | Tag: 13B Qualifier: LINK Format Specification: /30x |
| Block4_Linkages_RelatedReference | Text | Tag: 20C Qualifier: RELA Format Specification: 16x |
| Block4_Linkages_PreviousRef | Text | Tag: 20C Qualifier: PREV Format Specification: 16x |
| Block4_DateOfOrder | Date | Tag: 98A or 98C Qualifier: ORDR Format Specification: 8!n |
| Block4_TimeOfOrder | Time | Tag: 98C Qualifier: ORDR Format Specification: 6!n |
| Block4_TradeDate | Date | Tag: 98A Qualifier: TRAD Format Specification: 8!n |
| Block4_ValueDate | Date | Tag: 98A Qualifier: VALU Format Specification: 8!n |
| Block4_BuyCcy | Text | Tag: 19B Qualifier: BUYE Format Specification: 3!a |
| Block4_BuyAmount | Decimal | Tag: 19B Qualifier: BUYE Format Specification: 15d |
| Block4_SellCcy | Text | Tag: 19B Qualifier: SELL Format Specification: 3!a |
| Block4_SellAmount | Decimal | Tag: 19B Qualifier: SELL Format Specification: 15d |
| Block4_ExchangeRate_FirstCcyCode | Text | Tag: 92B Qualifier: EXCH Format Specification: 3!a |
| Block4_ExchangeRate_SecondCcyCode | Text | Tag: 92B Qualifier: EXCH Format Specification: 3!a |
| Block4_ExchangeRate_Rate | Decimal | Tag: 92B Qualifier: EXCH Format Specification: 15d |
| Block4_PaymentClearingCentreCountry | Text | Tag: 94C Qualifier: COUN Format Specification: 2!a |
| Block4_Investor_DataSourceScheme | Text | Tag: 95R Qualifier: INVE Format Specification: 8c |
| Block4_Investor_Code | Text | Tag: 95P or 95Q or 95R Qualifier: INVE Format Specification: 34x |
| Block4_SafekeepingAcct | Text | Tag: 97A Qualifier: SAFE Format Specification: 35x |
| Block4_TransactionReasonCode_DataSourceScheme | Text | Tag: 24B Qualifier: REAS Format Specification: 8c |
| Block4_TransactionReasonCode | Text | Tag: 24B Qualifier: REAS Format Specification: 4!c |
| Block4_ReasonNarrative | Text | Tag: 70D Qualifier: REAS Format Specification: 6*35x |
| Block4_IdOfSecurity | Text | Tag: 35B Format Specification: ISIN1!e12!c |
| Block4_DescOfSecurity | Text | Tag: 35B Format Specification: 4*35x |
| Block4_QtyofFinancialInstrumentSettled_Amortised | Decimal | Tag: 36B Qualifier: ESTT//AMOR Format Specification: 15d |
| Block4_QtyofFinancialInstrumentSettled_Face | Decimal | Tag: 36B Qualifier: ESTT//FAMT Format Specification: 15d |
| Block4_QtyofFinancialInstrumentSettled_Unit | Decimal | Tag: 36B Qualifier: ESTT//UNIT Format Specification: 15d |
| Block4_Agreement_DataSourceScheme | Text | Tag: 22F Qualifier: AGRE Format Specification: 8c |
| Block4_Agreement_Indicator | Text | Tag: 22F Qualifier: AGRE Format Specification: 4!c |
| Block4_TransactionDetailsNarrative | Text | Tag: 70E Qualifier: TRDE Format Specification: 10*35x |