Get Started

Table 2

Fields Available for Retrieval in Completed Payment File V 4.0


Field Name Description Data Type (LEN)
BeneficiaryName Beneficiary Legal Name Char (35)
BeneficiaryID Client-assigned, unique ID for a payee Char (35)
BeneficiaryStreetAddress Beneficiary street address Char (35)
BeneficiaryCity Beneficiary city Char (35)
BeneficiaryStateProvince Beneficiary state or province Char (35)
BeneficiaryPostalCode Beneficiary postal code Char(20)
BeneficiaryCountry Beneficiary ISO country code Char (2)
BeneficiaryEmailAddress Beneficiary e-mail address Char(255)
BankName Beneficiary bank name Char(35)
BankCountry Beneficiary bank country ISO code Char(2)
BankAccount Beneficiary bank account numbers Char(34)
BankSwiftAddress Beneficiary Bank Swift Address Char(11)
BankRoutingCode Beneficiary bank local routing code Char(29)
BankStreetAddress Beneficiary bank street address Char (35)
BankCity Beneficiary city Char (35)
BankStateProvince Beneficiary bank state or province Char(35)
BankPostalCode Beneficiary bank postal code Char(20)
SwiftBranchDetails Beneficiary bank Swift details Char(45)
IBankName Intermediary bank name Char (35)
IBankCountry Intermediary bank ISO country code Char(2)
IBankAccount Intermediary bank account number Char(34)
IBankSwiftAddr Intermediary bank Swift address Char(11)
IBankRoutingCode Intermediary bank local routing code Char(35)
IBankStreetAddress Intermediary bank street address Char(35)
IBankCity Intermediary bank city Char(35)
IBankStateProvince Intermediary bank address state or province Char(35)
IBankPostalCode Intermediary bank postal code Char(20)
PaymentID Client-assigned, unique payment ID Char(35)
Currency Payment ISO currency code Char(3)
Amount Payment amount Float
PayBy “ach”, “draft”, "eft", or "Draft2Bene" Char(8)
ReleaseDate Payment release date Date(mm/dd/yyyy)
Ref1 Client reference sent with payment Char(53)
Ref2 Client reference sent with payment Char(53)
AmountExpression “target” or “settlement” Char(10)
FundedBy “holding” or “fxtrade” Char(7)
FileID  Client generated file ID Char(35)
ItemRate Rate charged to the client for the item Float
Extension Amount in the settlement currency owed by client to WUBS Float
ServiceCharge Service charge to client for the item Float
Subtotal Total amount owed for item (extension plus service charge) Float
ConfirmationNo Confirmation number of the order on which the item was committed Char(16)
ItemNo Item number on the order on which item was committed Integer
ValueDate Date on which EFT or ACH was valued based on receipt of settlement from client Datetime
TrackingNumber Tracking number of the outgoing EFT or ACH, where available Char(50)
ActualSettlementMethod The method by which the item was actually settled Char(10)
ActualSettlementAccount The account from which the item was actually settled Char(35)
PaymentType    
RemitterAccountNumber  Remitter’s account number or unique identifier Char(50)
RemitterName  Remitter’s full name (business or first and last of person) Char(50)
RemitterAddressLine1  Remitter’s street address line 1 Char(52)
RemitterAddressLine2  Remitter’s street address line 1 Char(52)
RemitterCity  Remitter’s city Char(36)
RemitterState  Remitter’s State Char(30)
RemitterProvince Remitter’s Province  Char(30)
RemitterPostalCode  Remitter’s Postal Code Char(20)
RemitterCountry  Remitter’s ISO country code Char(2)
RemitterFIAccountNumber  Remitter’s financial institution’s account number or unique identifier Char(50)
RemitterFISwift  Remitter’s financial institution’s SWIFT number  
RemitterFIFullName  Remitter’s financial institution’s full name (business or first and last of person) Char(50)
RemitterFIAddressLine1  Remitter’s financial institution’s street address line 1 Char(52)
RemitterFIAddressLine2  Remitter’s financial institution’s street address line 2 Char(52)
RemitterFICity  Remitter’s financial institution’s city Char(36)
RemitterFIStateProvince  Remitter’s financial institution’s state or province Char(30)
RemitterFIPostalCode Remitter’s financial institution’s postal code Char(20)
RemitterFICountry  Remitter’s financial institution’s country Char(2)
ClientRate  Reference rate provided from Client Float
SettlementMethod  Code for the method by which the client intends to settle with WESTERN UNION BUSINESS SOLUTIONS.Value may be “BACS”, “CertChk”, “CHAPS”, “Check”, “Cheque”, “DirCred”, “DrawDown”, “Edebit”, “Holding”, “QuickCHK” or “Wire” Char(10)
SettlementCurrency ISO currency code for the currency in which the client will settle with WUBS Char(3)
SettlementCurrencySettlementAccount Account number of the account from which WUBS will initiate settlement from the client Char(35)
ClientFileID WUBS generated File ID Char(35)
BankAccountType    
ExtendedField1  Internal reference for the client; not sent with the payment Char(255)
ExtendedField2 Internal reference for the client; not sent with the payment Char(255)
ExtendedField3 Internal reference for the client; not sent with the payment Char(255)
ExtendedField4  Internal reference for the client; not sent with the payment Char(255)
ExtendedField5 Internal reference for the client; not sent with the payment Char(255)
ExtendedField6 Internal reference for the client; not sent with the payment Char(255)
ExtendedField7 Internal reference for the client; not sent with the payment Char(255)
ExtendedField8 Internal reference for the client; not sent with the payment Char(255)
ExtendedField9 Internal reference for the client; not sent with the payment Char(255)
ExtendedField10 Internal reference for the client; not sent with the payment  Char(255)
StatementBankID    
StatementDate    
BeneficiaryDataChanged References if the beneficiary data was changed as part of the payment. Values include "TRUE" or "FALSE" Char
WUMTCN Unique Payment number for cash payments. Varchar (16)
WUReceiverFirstName Mobile Phone Number for Beneficiary Char (20)
WUReceiverLastName Beneficiary First Name Char (35)
WUMobilePhoneNumber Beneficiary Last Name Char (35)
WUReceiverCity City of Payment Receipt Char(40)
WUReceiverState State of Payment Receipt Char (5)
WUReceiverCountry Country of Payment Receipt Char (2)
WUSecretAnswer Test Answer Char (20)
SwiftUETR Unique SWIFT payment reference. Only use if passing a file generated from SWIFT, any other values will be removed. Char(255)
BeneficiaryRegistrationNumber    
FamiliarName Unique name amount your beneficiaires. Will store in the Familiar Name field in WUBS. Char(255)
YourID Can be used as an internal reference number for the user booking payments. Will travel with the payment. Char(255)
NotestoVerifier Can be used to pass instructions to a payment approval. Will travel with the payment and be visible to approvers and Western Union. Char(255)