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 |