EFT ISO20022 Profile

Parent:    EFT Profile

Added On:  03/07/16 

SQL Table:  EFT_ISO20022_PROFILE 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EftIso20022Profile 

Configuration settings for processing of ACH transactions through EFT ISO20022.

Available Fields:

• Acknowledgement File Name Prefix
• Creditor Account IBAN
• Creditor Account Identification
• Creditor Account Proprietary
• Creditor Address Line

• Creditor Country
• Creditor Country Sub Division
• Creditor Name
• Creditor Post Code
• Creditor Street Name

• Creditor Town Name
• Descriptor Prefix
• Initiating Party Bic Or Bei
• Initiating Party Identification
• Initiating Party Name

• Request File Name Prefix

Acknowledgement File Name Prefix

Added On:  03/23/16

SQL Column:  ACKNOWLEDGEMENT_FILE_NAME_PREFIX

Java Field:  acknowledgementFileNamePrefix

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Prefix of the acknowledgement file name.

Creditor Account IBAN

Added On:  03/07/16

SQL Column:  CREDITOR_ACCOUNT_IBAN

Java Field:  creditorAccountIban

Status:  Active

SQL Type:  varchar(34)

Java Type:  String

Attributes:

Creditor account IBAN (International Bank Account Number).

Creditor Account Identification

Added On:  03/07/16

SQL Column:  CREDITOR_ACCOUNT_IDENTIFICATION

Java Field:  creditorAccountIdentification

Status:  Active

SQL Type:  varchar(34)

Java Type:  String

Attributes:

Contain the creditor account in IBAN format where it is available.

Creditor Account Proprietary

Added On:  03/07/16

SQL Column:  CREDITOR_ACCOUNT_PROPRIETARY

Java Field:  creditorAccountProprietary

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

JPMC Company ID used for client identification and returns distribution/routing.

Creditor Address Line

Added On:  03/07/16

SQL Column:  CREDITOR_ADDRESS_LINE

Java Field:  creditorAddressLine

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

Address line (free-form address) of the creditor's address.

Creditor Country

Added On:  03/07/16

SQL Column:  CREDITOR_COUNTRY

Java Field:  creditorCountry

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Country code of the creditor's address.

Creditor Country Sub Division

Added On:  03/07/16

SQL Column:  CREDITOR_COUNTRY_SUB_DIVISION

Java Field:  creditorCountrySubDivision

Status:  Active

SQL Type:  varchar(25)

Java Type:  String

Attributes:

Country sub-division of the creditor's address.

Creditor Name

Added On:  03/07/16

SQL Column:  CREDITOR_NAME

Java Field:  creditorName

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

Name of the creditor. Name of the holder of the account to be credited.

Creditor Post Code

Added On:  03/07/16

SQL Column:  CREDITOR_POST_CODE

Java Field:  creditorPostCode

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

ZIP (or postal) code of the creditor's address.

Creditor Street Name

Added On:  03/07/16

SQL Column:  CREDITOR_STREET_NAME

Java Field:  creditorStreetName

Status:  Active

SQL Type:  varchar(70)

Java Type:  String

Attributes:

Street name of the creditor's address.

Creditor Town Name

Added On:  03/07/16

SQL Column:  CREDITOR_TOWN_NAME

Java Field:  creditorTownName

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Name of the creditor town (or city).

Descriptor Prefix

Added On:  03/14/17

SQL Column:  DESCRIPTOR_PREFIX

Java Field:  descriptorPrefix

Status:  Active

SQL Type:  varchar(7)

Java Type:  String

Attributes:

Prefix that is used with subscription ID to compose a mandate identifier.

Initiating Party Bic Or Bei

Added On:  03/07/16

SQL Column:  INITIATING_PARTY_BIC_OR_BEI

Java Field:  initiatingPartyBicOrBei

Status:  Active

SQL Type:  varchar(11)

Java Type:  String

Attributes:

Type of initiating party.

Initiating Party Identification

Added On:  03/07/16

SQL Column:  INITIATING_PARTY_IDENTIFICATION

Java Field:  initiatingPartyIdentification

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Identification of the initiating party.

Initiating Party Name

Added On:  03/07/16

SQL Column:  INITIATING_PARTY_NAME

Java Field:  initiatingPartyName

Status:  Active

SQL Type:  varchar(140)

Java Type:  String

Attributes:

Name of the initiating party.

Request File Name Prefix

Added On:  03/23/16

SQL Column:  REQUEST_FILE_NAME_PREFIX

Java Field:  requestFileNamePrefix

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Prefix of the request file name.