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 MT900 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_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_SenderToReceiverInformation | Text | :72: 6*35x |