pacs_004_messages_fct_cdd (ISO)

Pipelined Data Sets > JH Wires > pacs_004_messages_fct_cdd (ISO)

Column name	Description	Mode	Type
MessageId	ID of the wire message	REQUIRED	STRING
InstructionId	Unique identifier for the instruction	REQUIRED	STRING
InstitutionId	Unique Id for the Institution	REQUIRED	STRING
CreditorAgentRouting	Routing information for the creditor's agent	NULLABLE	STRING
Amount	Amount of the wire	REQUIRED	NUMERIC
CurrencyType	Type of currency. Example: USD	NULLABLE	STRING
PaymentProprietaryCode	Proprietary code for the payment	REQUIRED	STRING
SettlementCode	Code for the settlement	REQUIRED	STRING
InstructionIdentification	Identification for the instruction	REQUIRED	STRING
EndToEndIdentification	End-to-end identification	REQUIRED	STRING
InstructedAgentRouting	Routing information for the instructed agent	REQUIRED	STRING
MarketPracticeIdentification	Market practice identification	NULLABLE	STRING
SettlementMethod	Method of settlement	REQUIRED	STRING
InstructedAgentClearingCode	Clearing code for the instructed agent	REQUIRED	STRING
InstructingAgentClearingCode	Clearing code for the instructing agent	REQUIRED	STRING
UnstructuredRemittanceInformation	Unstructured remittance information	NULLABLE	STRING
IntermediaryAgentRouting	Routing information for the intermediary agent	NULLABLE	STRING
InstructingAgentRouting	Routing information for the instructing agent	REQUIRED	STRING
DebtorAgentRouting	Routing information for the debtor's agent	NULLABLE	STRING
DebtorAgentClearingCode	Clearing code for the debtor's agent	NULLABLE	STRING
CreditorAgentClearingCode	Clearing code for the creditor's agent	NULLABLE	STRING
IntermediaryAgentClearingCode	Clearing code for the intermediary agent	NULLABLE	STRING
WireDescription	Description of the wire transaction	NULLABLE	STRING
CreatedOn	Created On ISO date format.	REQUIRED	TIMESTAMP
CreditorFI	Creditor Financial Institution details in JSON format	NULLABLE	JSON
IntermediaryFI	Intermediary Financial Institution details in JSON format	NULLABLE	JSON
DebtorFI	Debtor Financial Institution details in JSON format	NULLABLE	JSON
OriginalMessageIdentifier	Original Message Identifier	NULLABLE	STRING
OriginalWireDefinition	Original message's ISO 20022 identifier (pacs.008.001.08, pacs.009.001.08, pacs.004.001.10)	NULLABLE	STRING
OriginalSentOn	Original message sent on ISO date format	NULLABLE	TIMESTAMP
ReturnReasonCode	Code for the return reason	NULLABLE	STRING
ApprovalId	Unique Identifier of the wire approval	NULLABLE	STRING
ReturnReasonAdditionalInfo	Unique Identifier of the wire approval	REQUIRED	ARRAY<STRING>
MessageIdentifier	Message Identifier	NULLABLE	STRING
BusinessMessageIdentifier	Business Message Identifier	NULLABLE	STRING

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed Mar 4 2026