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 MT608 message is transformed and flattened to a row of data with the following fields in Duco.
| Duco field name | Duco field type | SWIFT Tag |
| DataType | Duco_Text | "Statements"/"Balances" |
| Block1_AppID | Duco_Text | 1a |
| Block1_ServiceID | Duco_Text | 2n |
| Block1_LTAddress_IdCode | Duco_Text | 8c |
| Block1_LTAddress_LT | Duco_Text | 1c |
| Block1_LTAddress_Branch | Duco_Text | 3c |
| Block1_SessionNumber | Duco_Integer | 4n |
| Block1_SequenceNumber | Duco_Integer | 6n |
| Block2_InputOutput | Duco_Text | 1a |
| Block2_MessageType | Duco_Integer | 3n |
| Block2_DestinationAddress_IdCode | Duco_Text | 8c |
| Block2_DestinationAddress_LT | Duco_Text | 1c |
| Block2_DestinationAddress_Branch | Duco_Text | 3c |
| Block2_Priority | Duco_Text | 1a |
| Block2_DeliveryMonitoring | Duco_Integer | 1x |
| Block2_ObsolescencePeriod | Duco_Integer | 3n |
| Block2_InputTime | Duco_Integer | 4n |
| Block2_MIR | Duco_Text | 28c |
| Block2_OutputDate | Duco_Date | 6n |
| Block2_OutputTime | Duco_Time | 4n |
| Block3_ServiceIdentifier | Duco_Text | {103:3!a} |
| Block3_BankingPriority | Duco_Text | {113:4!x} |
| Block3_MUR | Duco_Text | {108:16!x} |
| Block3_ValidationFlag | Duco_Text | {119:8c} |
| Block3_BalanceCheckpoint_Date | Duco_Date | {423:YYMMDDHHMMSS[ss]} |
| Block3_BalanceCheckpoint_Time | Duco_Time | {423:YYMMDDHHMMSS[ss]} |
| Block3_BalanceCheckpoint_DecimalFractions | Duco_Integer | {423:YYMMDDHHMMSS[ss]} |
| Block3_MIR_Date | Duco_Date | {106:} 6n |
| Block3_MIR_LTIdentifier | Duco_Text | {106:} 4a2a2c1c |
| Block3_MIR_BranchCode | Duco_Text | {106:} 3c |
| Block3_MIR_SessionNumber | Duco_Integer | {106:} 4n |
| Block3_MIR_SequenceNumber | Duco_Integer | {106:} 6n |
| Block3_RelatedReference | Duco_Text | {424:16x} |
| Block3_ServiceTypeIdentifier | Duco_Text | {111:3!n} |
| Block3_UniqueEndToEndTransactionReference | Duco_Text | {121:xxxxxxxx-xxxx-4xxx-yxxxxxxxxxxxxxxx} |
| Block3_AddresseeInformation | Duco_Text | {115:32x} |
| Block3_PaymentRelease_ServiceTypeIdentifier | Duco_Text | {165:/3!c/34x} |
| Block3_PaymentRelease_UniqueEndToEndTransactionReference | Duco_Text | {165:/3!c/34x} |
| Block3_SanctionsSceening_Codeword | Duco_Text | {433:/3!a/[20x]} |
| Block3_SanctionsSceening_AdditionalInformation | Duco_Text | {433:/3!a/[20x]} |
| Block3_PaymentControls_Codeword | Duco_Text | {434:/3!a/[20x] |
| Block3_PaymentControls_AdditionalInformation | Duco_Text | {434:/3!a/[20x]} |
| Block4_TransactionReferenceNumber | Duco_Text | Tag: 20 Format Specification: 16x |
| Block4_IdOfCommodityCommodityAcct_DeliveryDetails | Duco_Text | Tag: 26C Format Specification: 3!a |
| Block4_IdOfCommodityCommodityAcct_DeliveryLocation | Duco_Text | Tag: 26C Format Specification: /15x/ |
| Block4_IdOfCommodityCommodityAcct_Allocation | Duco_Text | Tag: 26C Format Specification: 5!a |
| Block4_IdOfCommodityCommodityAcct_Type | Duco_Integer | Tag: 26C Format Specification: 4!a |
| Block4_IdOfCommodityCommodityAcct_Denomination | Duco_Integer | Tag: 26C Format Specification: 4x |
| Block4_IdOfCommodityCommodityAcct_Form | Duco_Text | Tag: 26C Format Specification: //8x |
| Block4_FurtherAccountId | Duco_Text | Tag: 25 Format Specification: 35x |
| Block4_StatementNumSeqNum_StatementNumber | Duco_Integer | Tag: 28 Format Specification: 5n |
| Block4_StatementNumSeqNum_SequenceNumber | Duco_Integer | Tag: 28 Format Specification: /2n |
| Block4_OpeningBalance_FinalBalance_DebitOrCreditMark | Duco_Text | Tag: 60F Format Specification: 1!a |
| Block4_OpeningBalance_FinalBalanceDtedQuantityOfMetal_Date | Duco_Date | Tag: 60F Format Specification: 6!n |
| Block4_OpeningBalance_FinalBalanceDtedQuantityOfMetal_Unit | Duco_Text | Tag: 60F Format Specification: 3!a |
| Block4_OpeningBalance_FinalBalanceDtedQuantityOfMetal_Amount | Duco_Decimal | Tag: 60F Format Specification: 15d |
| Block4_OpeningBalance_IntermediateBalance_DebitOrCreditMark | Duco_Text | Tag: 60M Format Specification: 1!a |
| Block4_OpeningBalance_IntermediateBalance_DatedQuantityOfMetal_Date | Duco_Date | Tag: 60M Format Specification: 6!n |
| Block4_OpeningBalance_IntermediateBalance_DatedQuantityOfMetal_Unit | Duco_Text | Tag: 60M Format Specification: 3!a |
| Block4_OpeningBalance_IntermediateBalance_DatedQuantityOfMetal_Amount | Duco_Decimal | Tag: 60M Format Specification: 15d |
| Block4_StatementLine_Date | Duco_Date | Tag: 61 Format Specification: 6!n |
| Block4_StatementLine_EntryDate | Duco_Text | Tag: 61 Format Specification: 4!n |
| Block4_StatementLine_DebitOrCreditMark | Duco_Text | Tag: 61 Format Specification: 2a |
| Block4_StatementLine_FundsCode | Duco_Text | Tag: 61 Format Specification: 1!a |
| Block4_StatementLine_Amount | Duco_Decimal | Tag: 61 Format Specification: 15d |
| Block4_StatementLine_TxnTypeIdCode | Duco_Text | Tag: 61 Format Specification: 1!a3!c |
| Block4_StatementLine_ReferenceForTheAccountOwner | Duco_Text | Tag: 61 Format Specification: 16x |
| Block4_StatementLine_AccountServicingReference | Duco_Text | Tag: 61 Format Specification: //16x |
| Block4_StatementLine_SupplementaryDetails | Duco_Text | Tag: 61 Format Specification: 34x |
| Block4_FinalClosingBalance_DebitOrCreditMark | Duco_Text | Tag: 62F Format Specification: 1!a |
| Block4_FinalClosingBalance_Date | Duco_Date | Tag: 62F Format Specification: 6!n |
| Block4_FinalClosingBalance_Currency | Duco_Text | Tag: 62F Format Specification: 3!a |
| Block4_FinalClosingBalance_Amount | Duco_Decimal | Tag: 62F Format Specification: 15d |
| Block4_IntermediateClosingBalance_DebitOrCreditMark | Duco_Text | Tag: 62M Format Specification: 1!a |
| Block4_IntermediateClosingBalance_Date | Duco_Date | Tag: 62M Format Specification: 6!n |
| Block4_IntermediateClosingBalance_Currency | Duco_Text | Tag: 62M Format Specification: 3!a |
| Block4_IntermediateClosingBalance_Amount | Duco_Decimal | Tag: 62M Format Specification: 15d |
| Block4_ClosingAvailableBalance_DebitOrCreditMark | Duco_Text | Tag: 64 Format Specification: 1!a |
| Block4_ClosingAvailableBalance_Date | Duco_Date | Tag: 64 Format Specification: 6!n |
| Block4_ClosingAvailableBalance_Currency | Duco_Text | Tag: 64 Format Specification: 3!a |
| Block4_ClosingAvailableBalance_Amount | Duco_Decimal | Tag: 64 Format Specification: 15d |
| Block4_ForwardAvailableBalance_DebitOrCreditMark | Duco_Text | Tag: 65 Format Specification: 1!a |
| Block4_ForwardAvailableBalance_Date | Duco_Date | Tag: 65 Format Specification: 6!n |
| Block4_ForwardAvailableBalance_Currency | Duco_Text | Tag: 65 Format Specification: 3!a |
| Block4_ForwardAvailableBalance_Amount | Duco_Decimal | Tag: 65 Format Specification: 15d |