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 MT910 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_TransactionReferenceNumber | Text | :20:16x (no characters limits) |
| Block4_RelatedReference | Text | :21:16x (no characters limits) |
| Block4_AccountId_Account | Text | :25P:35x OR :25:35x (no characters limits) |
| Block4_AccountId_IdCode | Text | 4!a2!a2!c[3!c] |
| Block4_Date | Date | :13D:6!n4!n1!x4!n |
| Block4_Time | Time | :13D:6!n4!n1!x4!n |
| Block4_Sign | Text | :13D:6!n4!n1!x4!n |
| Block4_Offset | Time | :13D:6!n4!n1!x4!n |
| Block4_ValueDate | Date | :32A:6!n3!a15d |
| Block4_Currency | Text | :32A:6!n3!a15d |
| Block4_Amount | Decimal | :32A:6!n3!a15d |
| Block4_OrderingCustomer_Account | Text | :50A:/34x OR :50F:/34x OR :50K:/34x |
| Block4_OrderingCustomer_Account_IdCode | Text | :50A:4!a2!a2!c[3!c] |
| Block4_OrderingCustomer_PartyId_Code | Text | |
| Block4_OrderingCustomer_PartyId_CountryCode | Text | |
| Block4_OrderingCustomer_PartyId_Id | Text | :50F:35x |
| Block4_OrderingCustomer_Name | Text | :50F:1/33x |
| Block4_OrderingCustomer_AddressLine | Text | :50F:2/33x |
| Block4_OrderingCustomer_CountryAndTown | Text | :50F:3/33x |
| Block4_OrderingCustomer_DateOfBirth | Text | :50F:4/33x |
| Block4_OrderingCustomer_PlaceOfBirth | Text | :50F:5/33x |
| Block4_OrderingCustomer_CustomerIdentificationNumber | Text | :50F:6/33x |
| Block4_OrderingCustomer_NationalIdentityNumber | Text | :50F:7/33x |
| Block4_OrderingCustomer_AdditionalInformation | Text | :50F:8/33x |
| Block4_OrderingCustomer_NameAndAddress | Text | :50K:4*35x |
| Block4_OrderingInstitution_PartyId | Text | :52A:[/1!a][/34x] or :52D:[/1!a][/34x] |
| Block4_OrderingInstitution_IdCode | Text | :52A:4!a2!a2!c[3!c] |
| Block4_OrderingInstitution_NameAndAddress | Text | :52D:4*35x |
| Block4_Intermediary_PartyId | Text | :56A:[/1!a][/34x] or :56D:[/1!a][/34x] |
| Block4_Intermediary_IdCode | Text | :56A:4!a2!a2!c[3!c] |
| Block4_Intermediary_NameAndAddress | Text | :56D:4*35x |
| Block4_SenderToReceiverInformation | Text | :72: 6*35x |