Developer Programs

Learn

Docs

ssdb_wire_cdc

Pipelined Data Sets > Symitar > ssdb_wire_cdc

Column nameDescriptionModeTypeLength
institutionidThis field stores the JH Platform institution identifierREQUIREDSTRING
sourceeventtimeThe timestamp of the change event from the source system (e.g., Debezium's ts_ms field).NULLABLEINTEGER
sourceeventdateThe UTC date of the change event, derived from sourceeventtime.NULLABLEDATE
operationThe type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field.NULLABLESTRING
wirekeyInternal use only; SSDB fieldNULLABLEINTEGER
deleteidThis field stores a soft delete flag where 0=not deleted, 1=deletedNULLABLEINTEGER
directiondateNULLABLEDATE
strippedglaccountNULLABLESTRING
omaduppercaseNULLABLESTRING
imaduppercaseNULLABLESTRING
sortdateNULLABLEINTEGER
nameuppercaseNULLABLESTRING
sequencenumberThis field contains a unique number that Symitar Quest assigns when you enter an outgoing wire or upload an incoming wireNULLABLEINTEGER
directionThis field indicates whether a wire is outgoing or incomingNULLABLEINTEGER
typeThis field is only used by corporate credit unions; it indicates the type of Wire recordNULLABLEINTEGER
statusThis field stores the current status of the wireNULLABLEINTEGER
ofacstatusThis field stores the status of the wire relative to its Office of Foreign Assets Control (OFAC) checkNULLABLEINTEGER
accountnumberThis field stores the member account number of a member's wireNULLABLESTRING
effectivedateThis field stores the effective date of the wire postingNULLABLEDATE
uploadeddateThis field is only used by corporate credit unions; it stores the date an incoming wire was uploadedNULLABLEDATE
uploadedtimeThis field is only used by corporate credit unions; it stores the time an incoming wire was uploadedNULLABLEINTEGER
entereddateThis field stores the date that an outgoing wire was enteredNULLABLEDATE
enteredtimeThis field stores the time that an outgoing wire was enteredNULLABLEINTEGER
enteredbymemberuserThis field stores the user number of the member user who entered the outgoing wireNULLABLEINTEGER
enteredbycorporateuserThis field stores the user number of the user who entered the wireNULLABLEINTEGER
enteredvalidationmethodThis field is only used by corporate credit unions; it stores the method used to authenticate the member user who requested the outgoing wire entryNULLABLESTRING
verificationmembercontactThis field is only used by corporate credit unions; it stores the user number of the member user who can be contacted regarding the outgoing wire entryNULLABLEINTEGER
verifieddateThis field stores the date that the outgoing wire was verifiedNULLABLEDATE
verifiedtimeThis field is only used by corporate credit unions; it stores the time the outgoing wire was verifiedNULLABLEINTEGER
verifiedbymemberuserThis field stores the user number of the member user who verified the outgoing wireNULLABLEINTEGER
verifiedbycorpuserNULLABLEINTEGER
verifiedvalidationmethodThis field is only used by corporate credit unions; it stores the method used to authenticate the member user who verified the outgoing wireNULLABLESTRING
verifiedvalidationreasonThis field stores the reason (other than OFAC failure) that this wire was rejected or the reason that any release option was selected for a wire that failed the OFAC checkNULLABLESTRING
releaseddateThis field stores the date the outgoing or incoming wire was released for postingNULLABLEDATE
releasedtimeThis field is only used by corporate credit unions; it stores the time that the outgoing or incoming wire was released for postingNULLABLEINTEGER
releasedbycorporateuserThis field stores the user number of the user who released this wire for postingNULLABLEINTEGER
releasedreasonThis field stores the reason a non-OFAC failed wire was rejected or the reason any release option was selected for a wire that failed the OFAC checkNULLABLESTRING
extracteddateThis field is only used by corporate credit unions; it stores the date this outgoing wire was extracted to the FedNULLABLEDATE
extractedtimeThis field is only used by corporate credit unions; it stores the time this outgoing wire was extracted to the FedNULLABLEINTEGER
extractedbycorporateuserThis field is only used by corporate credit unions; it stores the user number of the corporate user who extracted this outgoing wire to the FedNULLABLEINTEGER
batchnumberThis field stores the batch sequence number assigned for outgoing wire extraction to the FedNULLABLEINTEGER
uscaudittrailinfoSymitar Quest no longer uses this field, which stored a reference to a specific Wire USC Audit Info record (see Wire USC Audit Info Record Fields)NULLABLEINTEGER
returnrejectdateThis field stores the date an outgoing wire's Status field value was updated to (4) Returned or (9) Fed RejectNULLABLEDATE
returnrejecttimeThis field is only used by corporate credit unions; it stores the time an outgoing wire's Status field was updated to (4) Returned or (9) Fed RejectNULLABLEINTEGER
returnrejectbycorpuserThis field stores the user number of the user who updated an outgoing wire's Status field value to (4) Returned or (9) Fed RejectNULLABLEINTEGER
returnrejectreasonThis field stores the reason an outgoing wire's Status field value was updated to (4) Returned or (9) Fed RejectNULLABLESTRING
commentcodeThis field stores a comment code for billing and statement disclosureNULLABLEINTEGER
statementdescriptionThis field is only used by corporate credit unions; it stores a description for billing and statement disclosure (if this differs from the default comment code verbiage; otherwise, this field remains blank)NULLABLESTRING
transactionsequencenumberThis field stores the share (for a member wire) or general ledger transaction sequence number (for a corporate wire) from the wire postingNULLABLEINTEGER
shareidFor incoming wires, this field stores the ID of the share the wire amount was deposited to when the wire was posted; and for outgoing wires, it stores the ID of the share the wire amount was withdrawn fromNULLABLESTRING
glaccountFor incoming member wires, this field stores the number of the general ledger account that was credited during the posting of the wire; and for outgoing member wires, it stores the number of the general ledger account that was debitedNULLABLESTRING
gloffsetFor incoming wires, this field stores the number of the general ledger account that was debited during the posting of this wire; and for outgoing wires, it stores the number of the general ledger account that was creditedNULLABLESTRING
postingerrorThis field stores the error (if any) that occurred during the posting of this wireNULLABLESTRING
imadThis field stores the Input Message Accountability Data (IMAD) value for the sender assigned to uniquely identify the incoming wireNULLABLESTRING
amountThis field stores the amount of the wireNULLABLEINTEGER
adjustmentdateFedwire® discontinued this field on November 19, 2011. It stored the as-of adjustment dateNULLABLESTRING
adjustmentreasonFedwire® discontinued this field on November 19, 2011. It stored the reason for an as-of adjustment wireNULLABLESTRING
senderfiThis field stores the routing and transit (R&T) number of the sending institutionNULLABLESTRING
sendernameThis field stores the name of the sending institutionNULLABLESTRING
senderreferencenumberThis field stores the wire ID number that the sender generatesNULLABLESTRING
receiverfiThis field stores the routing and transit (R&T) number of the receiving institutionNULLABLESTRING
receivernameThis field stores the name of the receiving institutionNULLABLESTRING
previousmessageimadThis field stores the Input Message Accountability Data (IMAD) value the sender assigned to uniquely identify the previous message being referencedNULLABLESTRING
businessfunctioncodeThis field stores the business function code describing this wireNULLABLESTRING
typecodeThis field stores the type code that describes this wireNULLABLESTRING
intermediaryfinameThis field stores the name of the financial institution that the transfer must pass through, between the receiving institution and the beneficiary's institution, if specified by the sending institutionNULLABLESTRING
intermediaryfiidcodeThis field stores a code used to identify the intermediary financial institutionNULLABLESTRING
intermediaryfiidThis field stores the identification of the intermediary financial institutionNULLABLESTRING
intermediaryfiaddress_1This field stores the first line of the address of the intermediary financial institutionNULLABLESTRING
intermediaryfiaddress_2This field stores the first line of the address of the intermediary financial institutionNULLABLESTRING
intermediaryfiaddress_3This field stores the first line of the address of the intermediary financial institutionNULLABLESTRING
beneficiaryfinameThis field stores the name of the financial institution that will credit or pay the beneficiary if this institution is other than the receiver financial institutionNULLABLESTRING
beneficiaryfiidcodeThis field stores a code for the type of identification used to identify the beneficiary financial institutionNULLABLESTRING
beneficiaryfiidThis field stores an identifier for the beneficiary financial institutionNULLABLESTRING
beneficiaryfiaddress_1This field stores a code for the type of identification used to identify the beneficiary financial institutionNULLABLESTRING
beneficiaryfiaddress_2This field stores a code for the type of identification used to identify the beneficiary financial institutionNULLABLESTRING
beneficiaryfiaddress_3This field stores a code for the type of identification used to identify the beneficiary financial institutionNULLABLESTRING
beneficiarynameThis field stores the name of the person or institution credited or paid by the wireNULLABLESTRING
beneficiaryidcodeThis field stores a code for the type of identification used to identify the beneficiaryNULLABLESTRING
beneficiaryidThis field stores the beneficiary identificationNULLABLESTRING
beneficiaryaddress_1This field stores the first line of the address of the beneficiaryNULLABLESTRING
beneficiaryaddress_2This field stores the first line of the address of the beneficiaryNULLABLESTRING
beneficiaryaddress_3This field stores the first line of the address of the beneficiaryNULLABLESTRING
beneficiaryreferenceThis field stores reference information for use by the beneficiary to identify the transferNULLABLESTRING
drawdowndebitaccountnameThis field stores the financial institution's name for the drawdown debit accountNULLABLESTRING
drawdowndebitaccountidcodeThis field stores an identifier of the account debited in the drawdownNULLABLESTRING
drawdowndebitaccountidNULLABLESTRING
drawdowndebitaccountaddress_1This field stores the first line of the address of the drawdown debit account's financial institutionNULLABLESTRING
drawdowndebitaccountaddress_2This field stores the first line of the address of the drawdown debit account's financial institutionNULLABLESTRING
drawdowndebitaccountaddress_3This field stores the first line of the address of the drawdown debit account's financial institutionNULLABLESTRING
originatornameThis field stores the name of the person or institution originating the wireNULLABLESTRING
originatoridcodeThis field stores a code for the type of identification used to identify the originator of the wireNULLABLESTRING
originatoridThis field stores the originator's identificationNULLABLESTRING
originatoraddress_1This field stores the first line of the address of the wire originatorNULLABLESTRING
originatoraddress_2This field stores the first line of the address of the wire originatorNULLABLESTRING
originatoraddress_3This field stores the first line of the address of the wire originatorNULLABLESTRING
originatorfinameThis field stores the name of the financial institution originating this transferNULLABLESTRING
originatorfiidcodeThis field stores a code for the type of identification used to identify the originating financial institutionNULLABLESTRING
originatorfiidThis field stores an identifier for this wire's originating financial institutionNULLABLESTRING
originatorfiaddress_1This field stores the first through third lines of the wire originator's addressNULLABLESTRING
originatorfiaddress_2This field stores the first through third lines of the wire originator's addressNULLABLESTRING
originatorfiaddress_3This field stores the first through third lines of the wire originator's addressNULLABLESTRING
instructingfinameThis field stores the name of the instructing institution, between the sender and the originator's institutionsNULLABLESTRING
instructingfiidcodeThis field stores a code for the type of identification used to identify the instructing financial institutionNULLABLESTRING
instructingfiidThis field stores an identifier for the instructing financial institutionNULLABLESTRING
instructingfiaddress_1This field stores the first through fourth lines of the address of this wire's instructing financial institutionNULLABLESTRING
instructingfiaddress_2This field stores the first through fourth lines of the address of this wire's instructing financial institutionNULLABLESTRING
instructingfiaddress_3This field stores the first through fourth lines of the address of this wire's instructing financial institutionNULLABLESTRING
drawdowncreditaccountThis field stores the routing and transit (R&T) number used to identify the account to be credited in response to a drawdown requestNULLABLESTRING
originatortobeneficiaryinfo_1This field stores the first line of information conveyed from the originator to the beneficiary (for example, details of payment)NULLABLESTRING
originatortobeneficiaryinfo_2This field stores the first line of information conveyed from the originator to the beneficiary (for example, details of payment)NULLABLESTRING
originatortobeneficiaryinfo_3This field stores the first line of information conveyed from the originator to the beneficiary (for example, details of payment)NULLABLESTRING
originatortobeneficiaryinfo_4This field stores the first line of information conveyed from the originator to the beneficiary (for example, details of payment)NULLABLESTRING
receiverfiinfoThis field stores a reference to a specific Wire Receiver Information record (see Wire Receiver Financial Institution Information Record Fields)NULLABLEINTEGER
drawdowndebitacctadvicecodeThis field stores the method to be used for the debit account in a drawdown transferNULLABLESTRING
drawdowndebitacctadviceThis field stores a reference to a specific Wire Drawdown Debit Account Advice record (see Wire Drawdown Debit Account Advice Record Fields)NULLABLEINTEGER
intermediaryfiinfoThis field stores a reference to a specific Wire Intermediary Financial Institution Information record (see Wire Intermediary Financial Institution Information Record Fields for details)NULLABLEINTEGER
intermediaryfiadvicecodeThis field stores the method to be used to notify the intermediary financial institution of the receipt of fundsNULLABLESTRING
intermediaryfiadviceThis field stores a reference to a specific Wire Intermediary Financial Institution Advice record (see Wire Intermediary Financial Institution Advice Record Fields for details)NULLABLEINTEGER
beneficiaryfiinfoThis field stores a reference to a specific Wire Beneficiary Financial Institution Information record (see Wire Beneficiary Financial Institution Information Record Fields for details)NULLABLEINTEGER
beneficiaryfiadvicecodeThis field stores the method to be used to notify the beneficiary financial institution of the receipt of fundsNULLABLESTRING
beneficiaryfiadviceThis field stores a reference to a specific Wire Beneficiary Financial Institution Adv record (see Wire Beneficiary Financial Institution Advice Record Fields for details)NULLABLEINTEGER
beneficiaryinfoThis field stores a reference to a specific Wire Beneficiary Information record (see Wire Beneficiary Information Record Fields for details)NULLABLEINTEGER
beneficiaryadvicecodeThis field stores the method to use to notify the beneficiary of the receipt of fundsNULLABLESTRING
beneficiaryadviceThis field stores a reference to a specific Wire Beneficiary Advice record (see Wire Beneficiary Advice Record Fields for details)NULLABLEINTEGER
paymentmethodcodeThis field stores a code for the method of payment for this wireNULLABLESTRING
paymentmethodThis field stores additional payment information for the beneficiary of the transferNULLABLESTRING
fitofiinfoThis field stores a reference to a specific Wire Financial Institution to Financial Institution Information record (see Wire Financial Institution to Financial Institution Information Record Fields for details)NULLABLEINTEGER
servicemessageThis field stores a reference to a specific Wire Service Message record (see Wire Service Message Record Fields for details)NULLABLEINTEGER
formatversionThis field stores the Fed format version that the wire usesNULLABLESTRING
testproductioncodeThis field indicates the operational status of the Fed application that delivered the messageNULLABLESTRING
messageduplicationcodeThis field indicates whether the message delivered by the Fed application is originalNULLABLESTRING
messagestatusindicatorThis field stores the processing status of the incoming messageNULLABLESTRING
acceptancedateThis field uses the MMDD format to store the date the wire was acceptedNULLABLESTRING
acceptancetimeThis field uses the HHMM format to store the time the wire was acceptedNULLABLESTRING
applicationidThis field stores the Fed application IDNULLABLESTRING
omadThis field is not part of the ISO 20022 specification but has been retained as part of the Wire recordNULLABLESTRING
errorcategoryThis field stores a code indicating the type of errorNULLABLESTRING
errorcodeThis field stores a code for the errorNULLABLESTRING
errordescriptionThis field stores a description of the errorNULLABLESTRING
urcdataThis field stores an indication of a specific errorNULLABLESTRING
preauthtemplatenumberThis field is used by corporate credit unions only; it stores the wire template number for pre-authorized wiresNULLABLEINTEGER
preauthtemplatenameThis field stores the wire template name for pre-authorized wiresNULLABLESTRING
notificationstatusThis field is only used by corporate credit unions; it stores the notification status for this wireNULLABLEINTEGER
notificationmethodThis field is used by corporate credit unions only; it indicates the method of notification for this wireNULLABLEINTEGER
notificationdateThis field is used by corporate credit unions only; it stores the date the member was notified of the incoming wireNULLABLEDATE
notificationtimeThis field is used by corporate credit unions only; it stores the time the member was notified of the incoming wireNULLABLEINTEGER
notificationuserNULLABLESTRING
detailofchargesThis field indicates who is responsible for the wire chargesNULLABLESTRING
chargescurrencycode_1This field stores the first through fourth currency code for chargesNULLABLESTRING
chargescurrencycode_2This field stores the first through fourth currency code for chargesNULLABLESTRING
chargescurrencycode_3This field stores the first through fourth currency code for chargesNULLABLESTRING
chargescurrencycode_4This field stores the first through fourth currency code for chargesNULLABLESTRING
sendercharges_1This field stores the first through fourth sender chargesNULLABLESTRING
sendercharges_2This field stores the first through fourth sender chargesNULLABLESTRING
sendercharges_3This field stores the first through fourth sender chargesNULLABLESTRING
sendercharges_4This field stores the first through fourth sender chargesNULLABLESTRING
instructedamtcurrencycodeThis field stores currency code information on the instructed amount (the amount provided by the sending financial institution)NULLABLESTRING
instructedamountThis field stores information on the instructed amount (the amount provided by the sending financial institution)NULLABLESTRING
exchangerateThis field stores information on any exchange rate applicable to this wireNULLABLESTRING
paymentlimitationThis field is obsolete. Fedwire® discontinued this field on November 19, 2011. It stored the BONL (beneficiary only) codeNULLABLESTRING
extractdestinationThis field is for corporate credit unions only; it indicates the extract destinationNULLABLEINTEGER
ofacdetailsThis field stores the details of wires that fail the OFAC (Office of Foreign Assets Control) checkNULLABLEINTEGER
trantypecodeThis field stores information on the transaction type code for incoming wires onlyNULLABLESTRING
destinationThis field indicates the destination of the wireNULLABLEINTEGER
fmlastpurgedateThis field stores the system date when you perform a purge of file maintenance historyNULLABLEDATE
regetranThis field indicates whether a transaction should be counted under Reg ENULLABLEINTEGER
beneficiaryfiintrnatlidThis field is used for international wires; it identifies international bank accounts with an ID recognizable across national bordersNULLABLESTRING
lastfmdateThis field stores the date of the last file maintenance affecting this Wire recordNULLABLEDATE
originatornamefThis field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorpartyidfThis field indicates the type of identification used by the originatorNULLABLESTRING
originatoridfThe information after the slash (/) appears in the Originator ID F field (field # 073)NULLABLESTRING
originatorlinecodef_1This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorlinecodef_2This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorlinecodef_3This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorlinef_1This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorlinef_2This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
originatorlinef_3This field is not part of the FAIM or ISO 20022 specifications but has been retained as part of the Wire recordNULLABLESTRING
glcommentaddlinfoThis field stores miscellaneous information about a wire transactionNULLABLESTRING
otheraddlinfoThis field stores miscellaneous information or notes regarding the wire transfer transactionNULLABLESTRING
creationdatetimeNULLABLESTRING
transactionidNULLABLESTRING
uetrThe value calculated for this field conforms to the Universally Unique IDentifier (UUID) version 4 standard. For return wires, the user should enter the original wire's UETR value in this fieldNULLABLESTRING
messagetypeThis field denotes the type of wire transferNULLABLEINTEGER
chargebearerNULLABLEINTEGER
prevmsgnameidNULLABLESTRING
prevmsgcreationdatetimeNULLABLESTRING
returnreasoncodeNULLABLESTRING
creditoragentfibicNULLABLESTRING
creditoragentclrsysmemidcodeNULLABLESTRING
creditoragentclrsysmemidNULLABLESTRING
creditoragentfileiNULLABLESTRING
creditoragentfiname_1When the teller uses the Wire Transfer (WT) transaction to create a wire, the value they enter in the Beneficiary/Creditor Agent FI Information FI Name field populates the Creditor Agent FI Name 1-4 fields of the Wire recordNULLABLESTRING
creditoragentfiname_2When the teller uses the Wire Transfer (WT) transaction to create a wire, the value they enter in the Beneficiary/Creditor Agent FI Information FI Name field populates the Creditor Agent FI Name 1-4 fields of the Wire recordNULLABLESTRING
creditoragentfiname_3When the teller uses the Wire Transfer (WT) transaction to create a wire, the value they enter in the Beneficiary/Creditor Agent FI Information FI Name field populates the Creditor Agent FI Name 1-4 fields of the Wire recordNULLABLESTRING
creditoragentfiname_4When the teller uses the Wire Transfer (WT) transaction to create a wire, the value they enter in the Beneficiary/Creditor Agent FI Information FI Name field populates the Creditor Agent FI Name 1-4 fields of the Wire recordNULLABLESTRING
creditoragentdepartment_1NULLABLESTRING
creditoragentdepartment_2NULLABLESTRING
creditoragentsubdepartment_1NULLABLESTRING
creditoragentsubdepartment_2NULLABLESTRING
creditoragentstreetname_1NULLABLESTRING
creditoragentstreetname_2NULLABLESTRING
creditoragentbuildingnumNULLABLESTRING
creditoragentbuildingnameNULLABLESTRING
creditoragentfloor_1NULLABLESTRING
creditoragentfloor_2NULLABLESTRING
creditoragentpostboxNULLABLESTRING
creditoragentroom_1NULLABLESTRING
creditoragentroom_2NULLABLESTRING
creditoragentpostcodeNULLABLESTRING
creditoragenttownnameNULLABLESTRING
creditoragenttownlocationnameNULLABLESTRING
creditoragentdistrictnameNULLABLESTRING
creditoragentcountrysubdivNULLABLESTRING
creditoragentcountryNULLABLESTRING
debtorname_1This field stores the name of the person or institution originating the wireNULLABLESTRING
debtorname_2This field stores the name of the person or institution originating the wireNULLABLESTRING
debtorname_3This field stores the name of the person or institution originating the wireNULLABLESTRING
debtorname_4This field stores the name of the person or institution originating the wireNULLABLESTRING
debtorbicNULLABLESTRING
debtoridNULLABLESTRING
debtorissuerNULLABLESTRING
debtoridschemecodeNULLABLESTRING
debtoridschemenameNULLABLESTRING
debtorleiNULLABLESTRING
debtordepartment_1NULLABLESTRING
debtordepartment_2NULLABLESTRING
debtorsubdepartment_1NULLABLESTRING
debtorsubdepartment_2NULLABLESTRING
debtorstreetname_1NULLABLESTRING
debtorstreetname_2NULLABLESTRING
debtorbuildingnumNULLABLESTRING
debtorbuildingnameNULLABLESTRING
debtorfloor_1NULLABLESTRING
debtorfloor_2NULLABLESTRING
debtorpostboxNULLABLESTRING
debtorroom_1NULLABLESTRING
debtorroom_2NULLABLESTRING
debtorpostcodeNULLABLESTRING
debtortownnameNULLABLESTRING
debtortownlocationnameNULLABLESTRING
debtordistrictnameNULLABLESTRING
debtorcountrysubdivNULLABLESTRING
debtorcountryNULLABLESTRING
debtoragentname_1NULLABLESTRING
debtoragentname_2NULLABLESTRING
debtoragentname_3NULLABLESTRING
debtoragentname_4NULLABLESTRING
debtoragentbicNULLABLESTRING
debtoragentclrsysmemidcodeNULLABLESTRING
debtoragentclrsysmemidNULLABLESTRING
debtoragentleiNULLABLESTRING
debtoragentdepartment_1NULLABLESTRING
debtoragentdepartment_2NULLABLESTRING
debtoragentsubdepartment_1NULLABLESTRING
debtoragentsubdepartment_2NULLABLESTRING
debtoragentstreetname_1NULLABLESTRING
debtoragentstreetname_2NULLABLESTRING
debtoragentbuildingnumNULLABLESTRING
debtoragentbuildingnameNULLABLESTRING
debtoragentfloor_1NULLABLESTRING
debtoragentfloor_2NULLABLESTRING
debtoragentpostboxNULLABLESTRING
debtoragentroom_1NULLABLESTRING
debtoragentroom_2NULLABLESTRING
debtoragentpostcodeNULLABLESTRING
debtoragenttownnameNULLABLESTRING
debtoragenttownlocationnameNULLABLESTRING
debtoragentdistrictnameNULLABLESTRING
debtoragentcountrysubdivNULLABLESTRING
debtoragentcountryNULLABLESTRING
creditorname_1NULLABLESTRING
creditorname_2NULLABLESTRING
creditorname_3NULLABLESTRING
creditorname_4NULLABLESTRING
creditorbicNULLABLESTRING
creditoridNULLABLESTRING
creditorissuerNULLABLESTRING
creditoridschemecodeNULLABLESTRING
creditoridschemenameNULLABLESTRING
creditorleiNULLABLESTRING
creditordepartment_1NULLABLESTRING
creditordepartment_2NULLABLESTRING
creditorsubdepartment_1NULLABLESTRING
creditorsubdepartment_2NULLABLESTRING
creditorstreetname_1NULLABLESTRING
creditorstreetname_2NULLABLESTRING
creditorbuildingnumNULLABLESTRING
creditorbuildingnameNULLABLESTRING
creditorfloor_1NULLABLESTRING
creditorfloor_2NULLABLESTRING
creditorpostboxNULLABLESTRING
creditorroom_1NULLABLESTRING
creditorroom_2NULLABLESTRING
creditorpostcodeNULLABLESTRING
creditortownnameNULLABLESTRING
creditortownlocationnameNULLABLESTRING
creditordistrictnameNULLABLESTRING
creditorcountrysubdivNULLABLESTRING
creditorcountryNULLABLESTRING
chargeagent1name_1NULLABLESTRING
chargeagent1name_2NULLABLESTRING
chargeagent1name_3NULLABLESTRING
chargeagent1name_4NULLABLESTRING
chargeagent1bicNULLABLESTRING
chargeagent1clrsysmemidcodeNULLABLESTRING
chargeagent1clrsysmemidNULLABLESTRING
chargeagent1leiNULLABLESTRING
chargeagent1department_1NULLABLESTRING
chargeagent1department_2NULLABLESTRING
chargeagent1subdepartment_1NULLABLESTRING
chargeagent1subdepartment_2NULLABLESTRING
chargeagent1streetname_1NULLABLESTRING
chargeagent1streetname_2NULLABLESTRING
chargeagent1buildingnumNULLABLESTRING
chargeagent1buildingnameNULLABLESTRING
chargeagent1floor_1NULLABLESTRING
chargeagent1floor_2NULLABLESTRING
chargeagent1postboxNULLABLESTRING
chargeagent1room_1NULLABLESTRING
chargeagent1room_2NULLABLESTRING
chargeagent1postcodeNULLABLESTRING
chargeagent1townnameNULLABLESTRING
chargeagent1townlocationnameNULLABLESTRING
chargeagent1districtnameNULLABLESTRING
chargeagent1countrysubdivNULLABLESTRING
chargeagent1countryNULLABLESTRING
chargeagent2name_1NULLABLESTRING
chargeagent2name_2NULLABLESTRING
chargeagent2name_3NULLABLESTRING
chargeagent2name_4NULLABLESTRING
chargeagent2bicNULLABLESTRING
chargeagent2clrsysmemidcodeNULLABLESTRING
chargeagent2clrsysmemidNULLABLESTRING
chargeagent2leiNULLABLESTRING
chargeagent2department_1NULLABLESTRING
chargeagent2department_2NULLABLESTRING
chargeagent2subdepartment_1NULLABLESTRING
chargeagent2subdepartment_2NULLABLESTRING
chargeagent2streetname_1NULLABLESTRING
chargeagent2streetname_2NULLABLESTRING
chargeagent2buildingnumNULLABLESTRING
chargeagent2buildingnameNULLABLESTRING
chargeagent2floor_1NULLABLESTRING
chargeagent2floor_2NULLABLESTRING
chargeagent2postboxNULLABLESTRING
chargeagent2room_1NULLABLESTRING
chargeagent2room_2NULLABLESTRING
chargeagent2postcodeNULLABLESTRING
chargeagent2townnameNULLABLESTRING
chargeagent2townlocationnameNULLABLESTRING
chargeagent2districtnameNULLABLESTRING
chargeagent2countrysubdivNULLABLESTRING
chargeagent2countryNULLABLESTRING
chargeagent3name_1NULLABLESTRING
chargeagent3name_2NULLABLESTRING
chargeagent3name_3NULLABLESTRING
chargeagent3name_4NULLABLESTRING
chargeagent3bicNULLABLESTRING
chargeagent3clrsysmemidcodeNULLABLESTRING
chargeagent3clrsysmemidNULLABLESTRING
chargeagent3leiNULLABLESTRING
chargeagent3department_1NULLABLESTRING
chargeagent3department_2NULLABLESTRING
chargeagent3subdepartment_1NULLABLESTRING
chargeagent3subdepartment_2NULLABLESTRING
chargeagent3streetname_1NULLABLESTRING
chargeagent3streetname_2NULLABLESTRING
chargeagent3buildingnumNULLABLESTRING
chargeagent3buildingnameNULLABLESTRING
chargeagent3floor_1NULLABLESTRING
chargeagent3floor_2NULLABLESTRING
chargeagent3postboxNULLABLESTRING
chargeagent3room_1NULLABLESTRING
chargeagent3room_2NULLABLESTRING
chargeagent3postcodeNULLABLESTRING
chargeagent3townnameNULLABLESTRING
chargeagent3townlocationnameNULLABLESTRING
chargeagent3districtnameNULLABLESTRING
chargeagent3countrysubdivNULLABLESTRING
chargeagent3countryNULLABLESTRING
chargeagent4name_1NULLABLESTRING
chargeagent4name_2NULLABLESTRING
chargeagent4name_3NULLABLESTRING
chargeagent4name_4NULLABLESTRING
chargeagent4bicNULLABLESTRING
chargeagent4clrsysmemidcodeNULLABLESTRING
chargeagent4clrsysmemidNULLABLESTRING
chargeagent4leiNULLABLESTRING
chargeagent4department_1NULLABLESTRING
chargeagent4department_2NULLABLESTRING
chargeagent4subdepartment_1NULLABLESTRING
chargeagent4subdepartment_2NULLABLESTRING
chargeagent4streetname_1NULLABLESTRING
chargeagent4streetname_2NULLABLESTRING
chargeagent4buildingnumNULLABLESTRING
chargeagent4buildingnameNULLABLESTRING
chargeagent4floor_1NULLABLESTRING
chargeagent4floor_2NULLABLESTRING
chargeagent4postboxNULLABLESTRING
chargeagent4room_1NULLABLESTRING
chargeagent4room_2NULLABLESTRING
chargeagent4postcodeNULLABLESTRING
chargeagent4townnameNULLABLESTRING
chargeagent4townlocationnameNULLABLESTRING
chargeagent4districtnameNULLABLESTRING
chargeagent4countrysubdivNULLABLESTRING
chargeagent4countryNULLABLESTRING
previnstructagentbicNULLABLESTRING
previnstructagentclrsysmemidcodeNULLABLESTRING
previnstructagentleiNULLABLESTRING
previnstragentdepartment_1NULLABLESTRING
previnstragentdepartment_2NULLABLESTRING
previnstragentsubdepartment_1NULLABLESTRING
previnstragentsubdepartment_2NULLABLESTRING
previnstragentstreetname_1NULLABLESTRING
previnstragentstreetname_2NULLABLESTRING
previnstragentbuildingnumNULLABLESTRING
previnstragentbuildingnameNULLABLESTRING
previnstragentfloor_1NULLABLESTRING
previnstragentfloor_2NULLABLESTRING
previnstragentpostboxNULLABLESTRING
previnstragentroom_1NULLABLESTRING
previnstragentroom_2NULLABLESTRING
previnstragentpostcodeNULLABLESTRING
previnstragenttownnameNULLABLESTRING
previnstragttownlocationnameNULLABLESTRING
previnstragentdistrictnameNULLABLESTRING
previnstragentcountrysubdivNULLABLESTRING
previnstragentcountryNULLABLESTRING
previnstragentacctibanNULLABLESTRING
previnstragentacctidNULLABLESTRING
previnstragentacctidcodeNULLABLESTRING
previnstragentacctidproprietaryNULLABLESTRING
previnstragentacctidissuerNULLABLESTRING
previnstragentaccttypecodeNULLABLESTRING
previnstragentaccttypeprtryNULLABLESTRING
previnstragentacctcurrencyNULLABLESTRING
previnstragentacctname_1NULLABLESTRING
previnstragentacctname_2NULLABLESTRING
previnstragentacctproxycodeNULLABLESTRING
previnstragentacctproxyprtryNULLABLESTRING
previnstragentacctproxyid_1NULLABLESTRING
previnstragentacctproxyid_2NULLABLESTRING
intermedfibicNULLABLESTRING
intermedficlrsysmemidcodeNULLABLESTRING
intermedfileiNULLABLESTRING
intermedfidepartment_1NULLABLESTRING
intermedfidepartment_2NULLABLESTRING
intermedfisubdepartment_1NULLABLESTRING
intermedfisubdepartment_2NULLABLESTRING
intermedfistreetname_1NULLABLESTRING
intermedfistreetname_2NULLABLESTRING
intermedfibuildingnumNULLABLESTRING
intermedfibuildingnameNULLABLESTRING
intermedfifloor_1NULLABLESTRING
intermedfifloor_2NULLABLESTRING
intermedfipostboxNULLABLESTRING
intermedfiroom_1NULLABLESTRING
intermedfiroom_2NULLABLESTRING
intermedfipostcodeNULLABLESTRING
intermedfitownnameNULLABLESTRING
intermedfitownlocationnameNULLABLESTRING
intermedfidistrictnameNULLABLESTRING
intermedficountrysubdivNULLABLESTRING
intermedficountryNULLABLESTRING
intrmyagt1acctibanNULLABLESTRING
intrmyagt1acctidNULLABLESTRING
intrmyagt1acctidcodeNULLABLESTRING
intrmyagt1acctidproprietaryNULLABLESTRING
intrmyagt1acctidissuerNULLABLESTRING
intrmyagt1accttypecodeNULLABLESTRING
intrmyagt1accttypeproprietaryNULLABLESTRING
intrmyagt1acctcurrencyNULLABLESTRING
intrmyagt1acctname_1NULLABLESTRING
intrmyagt1acctname_2NULLABLESTRING
intrmyagt1acctproxycodeNULLABLESTRING
intrmyagt1acctproxyproprietaryNULLABLESTRING
intrmyagt1acctproxyid_1NULLABLESTRING
intrmyagt1acctproxyid_2NULLABLESTRING
ultmtdbtrname_1NULLABLESTRING
ultmtdbtrname_2NULLABLESTRING
ultmtdbtrname_3NULLABLESTRING
ultmtdbtrname_4NULLABLESTRING
ultmtdbtrdepartment_1NULLABLESTRING
ultmtdbtrdepartment_2NULLABLESTRING
ultmtdbtrsubdepartment_1NULLABLESTRING
ultmtdbtrsubdepartment_2NULLABLESTRING
ultmtdbtrstreetname_1NULLABLESTRING
ultmtdbtrstreetname_2NULLABLESTRING
ultmtdbtrbuildingnumNULLABLESTRING
ultmtdbtrbuildingnameNULLABLESTRING
ultmtdbtrfloor_1NULLABLESTRING
ultmtdbtrfloor_2NULLABLESTRING
ultmtdbtrpostboxNULLABLESTRING
ultmtdbtrroom_1NULLABLESTRING
ultmtdbtrroom_2NULLABLESTRING
ultmtdbtrpostcodeNULLABLESTRING
ultmtdbtrtownnameNULLABLESTRING
ultmtdbtrtownlocationnameNULLABLESTRING
ultmtdbtrdistrictnameNULLABLESTRING
ultmtdbtrcountrysubdivNULLABLESTRING
ultmtdbtrcountryNULLABLESTRING
ultmtdbtrorgidbicNULLABLESTRING
ultmtdbtrorgidleiNULLABLESTRING
ultmtdbtrorgidNULLABLESTRING
ultmtdbtrorgidschemecodeNULLABLESTRING
ultmtdbtrorgidschemeprtryNULLABLESTRING
ultmtdbtrorgidissuerNULLABLESTRING
ultmtdbtrprvtidbirthdtNULLABLESTRING
ultmtdbtrprvtidprvcofbirthNULLABLESTRING
ultmtdbtrprvtidcityofbirthNULLABLESTRING
ultmtdbtrprvtidctryofbirthNULLABLESTRING
ultmtdbtrprvtididNULLABLESTRING
ultmtdbtrprvtididschemecodeNULLABLESTRING
ultmtdbtrprvtididschemeprtryNULLABLESTRING
ultmtdbtrprvtididissuerNULLABLESTRING
ultmtdbtrctryofresNULLABLESTRING
initgptyname_1NULLABLESTRING
initgptyname_2NULLABLESTRING
initgptyname_3NULLABLESTRING
initgptyname_4NULLABLESTRING
initgptydepartment_1NULLABLESTRING
initgptydepartment_2NULLABLESTRING
initgptysubdepartment_1NULLABLESTRING
initgptysubdepartment_2NULLABLESTRING
initgptystreetname_1NULLABLESTRING
initgptystreetname_2NULLABLESTRING
initgptybuildingnumNULLABLESTRING
initgptybuildingnameNULLABLESTRING
initgptyfloor_1NULLABLESTRING
initgptyfloor_2NULLABLESTRING
initgptypostboxNULLABLESTRING
initgptyroom_1NULLABLESTRING
initgptyroom_2NULLABLESTRING
initgptypostcodeNULLABLESTRING
initgptytownnameNULLABLESTRING
initgptytownlocationnameNULLABLESTRING
initgptydistrictnameNULLABLESTRING
initgptycountrysubdivNULLABLESTRING
initgptycountryNULLABLESTRING
initgptyorgidbicNULLABLESTRING
initgptyorgidleiNULLABLESTRING
initgptyorgidNULLABLESTRING
initgptyorgidschemecodeNULLABLESTRING
initgptyorgidschemeprtryNULLABLESTRING
initgptyorgidissuerNULLABLESTRING
initgptyprvtidbirthdtNULLABLESTRING
initgptyprvtidprvcofbirthNULLABLESTRING
initgptyprvtidcityofbirthNULLABLESTRING
initgptyprvtidctryofbirthNULLABLESTRING
initgptyprvtididNULLABLESTRING
initgptyprvtididschemecodeNULLABLESTRING
initgptyprvtididschemeprtryNULLABLESTRING
initgptyprvtididissuerNULLABLESTRING
initgptyctryofresNULLABLESTRING
debtoracctibanNULLABLESTRING
debtoracctidNULLABLESTRING
debtoracctidcodeNULLABLESTRING
debtoracctidproprietaryNULLABLESTRING
debtoracctidissuerNULLABLESTRING
debtoraccttypecodeNULLABLESTRING
debtoraccttypeproprietaryNULLABLESTRING
debtoracctcurrencyNULLABLESTRING
debtoracctname_1NULLABLESTRING
debtoracctname_2NULLABLESTRING
debtoracctproxycodeNULLABLESTRING
debtoracctproxyproprietaryNULLABLESTRING
debtoracctproxyid_1NULLABLESTRING
debtoracctproxyid_2NULLABLESTRING
dbtragtacctibanNULLABLESTRING
dbtragtacctidNULLABLESTRING
dbtragtacctidcodeNULLABLESTRING
dbtragtacctidproprietaryNULLABLESTRING
dbtragtacctidissuerNULLABLESTRING
dbtragtaccttypecodeNULLABLESTRING
dbtragtaccttypeproprietaryNULLABLESTRING
dbtragtacctcurrencyNULLABLESTRING
dbtragtacctname_1NULLABLESTRING
dbtragtacctname_2NULLABLESTRING
dbtragtacctproxycodeNULLABLESTRING
dbtragtacctproxyproprietaryNULLABLESTRING
dbtragtacctproxyid_1NULLABLESTRING
dbtragtacctproxyid_2NULLABLESTRING
cdtragtacctibanNULLABLESTRING
cdtragtacctidNULLABLESTRING
cdtragtacctidcodeNULLABLESTRING
cdtragtacctidproprietaryNULLABLESTRING
cdtragtacctidissuerNULLABLESTRING
cdtragtaccttypecodeNULLABLESTRING
cdtragtaccttypeproprietaryNULLABLESTRING
cdtragtacctcurrencyNULLABLESTRING
cdtragtacctname_1NULLABLESTRING
cdtragtacctname_2NULLABLESTRING
cdtragtacctproxycodeNULLABLESTRING
cdtragtacctproxyproprietaryNULLABLESTRING
cdtragtacctproxyid_1NULLABLESTRING
cdtragtacctproxyid_2NULLABLESTRING
cdtracctibanNULLABLESTRING
cdtracctidNULLABLESTRING
cdtracctidcodeNULLABLESTRING
cdtracctidproprietaryNULLABLESTRING
cdtracctidissuerNULLABLESTRING
cdtraccttypecodeNULLABLESTRING
cdtraccttypeproprietaryNULLABLESTRING
cdtracctcurrencyNULLABLESTRING
cdtracctname_1NULLABLESTRING
cdtracctname_2NULLABLESTRING
cdtracctproxycodeNULLABLESTRING
cdtracctproxyproprietaryNULLABLESTRING
cdtracctproxyid_1NULLABLESTRING
cdtracctproxyid_2NULLABLESTRING
ultmtcdtrname_1NULLABLESTRING
ultmtcdtrname_2NULLABLESTRING
ultmtcdtrname_3NULLABLESTRING
ultmtcdtrname_4NULLABLESTRING
ultmtcdtrdepartment_1NULLABLESTRING
ultmtcdtrdepartment_2NULLABLESTRING
ultmtcdtrsubdepartment_1NULLABLESTRING
ultmtcdtrsubdepartment_2NULLABLESTRING
ultmtcdtrstreetname_1NULLABLESTRING
ultmtcdtrstreetname_2NULLABLESTRING
ultmtcdtrbuildingnumNULLABLESTRING
ultmtcdtrbuildingnameNULLABLESTRING
ultmtcdtrfloor_1NULLABLESTRING
ultmtcdtrfloor_2NULLABLESTRING
ultmtcdtrpostboxNULLABLESTRING
ultmtcdtrroom_1NULLABLESTRING
ultmtcdtrroom_2NULLABLESTRING
ultmtcdtrpostcodeNULLABLESTRING
ultmtcdtrtownnameNULLABLESTRING
ultmtcdtrtownlocationnameNULLABLESTRING
ultmtcdtrdistrictnameNULLABLESTRING
ultmtcdtrcountrysubdivNULLABLESTRING
ultmtcdtrcountryNULLABLESTRING
ultmtcdtrorgidbicNULLABLESTRING
ultmtcdtrorgidleiNULLABLESTRING
ultmtcdtrorgidNULLABLESTRING
ultmtcdtrorgidschemecodeNULLABLESTRING
ultmtcdtrorgidschemeprtryNULLABLESTRING
ultmtcdtrorgidissuerNULLABLESTRING
ultmtcdtrprvtidbirthdtNULLABLESTRING
ultmtcdtrprvtidprvcofbirthNULLABLESTRING
ultmtcdtrprvtidcityofbirthNULLABLESTRING
ultmtcdtrprvtidctryofbirthNULLABLESTRING
ultmtcdtrprvtididNULLABLESTRING
ultmtcdtrprvtididschemecodeNULLABLESTRING
ultmtcdtrprvtididschemeprtryNULLABLESTRING
ultmtcdtrprvtididissuerNULLABLESTRING
ultmtcdtrctryofresNULLABLESTRING
instr1forcdtragtcodeNULLABLEINTEGER
instr1forcdtragtinfo_1NULLABLESTRING
instr1forcdtragtinfo_2NULLABLESTRING
instr1forcdtragtinfo_3NULLABLESTRING
instr1forcdtragtinfo_4NULLABLESTRING
instr2forcdtragtcodeNULLABLEINTEGER
instr2forcdtragtinfo_1NULLABLESTRING
instr2forcdtragtinfo_2NULLABLESTRING
instr2forcdtragtinfo_3NULLABLESTRING
instr2forcdtragtinfo_4NULLABLESTRING
intermediaryfiname2This field stores the name of the financial institution that the transfer must pass through, between the receiving institution and the beneficiary institution, if specified by the sending institutionNULLABLESTRING
intermediaryfiname3This field stores the name of the financial institution that the transfer must pass through, between the receiving institution and the beneficiary' institution, if specified by the sending institutionNULLABLESTRING
intermediaryfiname4This field stores the name of the financial institution that the transfer must pass through, between the receiving institution and the beneficiary institution, if specified by the sending institutionNULLABLESTRING
instructingfiname2This field stores the name of the instructing institution, between the sender's and originator's institutionsNULLABLESTRING
instructingfiname3This field stores the name of the instructing institution, between the sender's and originator's institutionsNULLABLESTRING
instructingfiname4This field stores the name of the instructing institution, between the sender's and originator's institutionsNULLABLESTRING


Have a Question?
  • Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
  • Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.

Did this page help you?

Last updated Tue Sep 15 2026