EFT ISO20022 Batch UML

Parent: File Batch

Added On: 03/07/16

SQL Table: EFT_ISO20022_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: EftIso20022Batch

Represents a batch of transactions as it is defined in ISO20022 batch processing specification.

Available Fields:

Control Sum
Creation Date Time
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
Initiating Party Bic Or Bei
Initiating Party Identification
Initiating Party Name
Local Instrument Code

Merchant Account Code
Message Identification
Number Of Transactions
Payment Information Identification
Reason Additional Information
Reason Code
Requested Collection Date
Response Status

Control Sum

Added On: 03/07/16

SQL Column: CONTROL_SUM

Java Field: controlSum

Status: Active

SQL Type: varchar(36)

Java Type: String

Attributes:

Hash total of all instructed amounts in thie message. Observes decimals, but ignores currencies.

Creation Date Time

Added On: 03/07/16

SQL Column: CREATION_DATE_TIME

Java Field: creationDateTime

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Date and time when the file was created.

Creditor Account IBAN

Added On: 03/07/16

SQL Column:

Java Field: creditorAccountIban

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Creditor account IBAN (International Bank Account Number).

Creditor Account Identification

Added On: 03/07/16

SQL Column:

Java Field: creditorAccountIdentification

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

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

Creditor Account Proprietary

Added On: 03/07/16

SQL Column:

Java Field: creditorAccountProprietary

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

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: 07/05/16

SQL Column: CREDITOR_COUNTRY_SUB_DIVISION

Java Field: creditorCountrySubDivision

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

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).

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:

Java Field: initiatingPartyIdentification

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

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.

Local Instrument Code

Added On: 03/07/16

SQL Column: LOCAL_INSTRUMENT_CODE

Java Field: localInstrumentCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Specifies the local instrument, as published in an external local instrument code list. A sub-level indicator for type of instrument - transaction level.

Merchant Account Code

Added On: 03/07/16

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required

Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Message Identification

Added On: 03/07/16

SQL Column: MESSAGE_IDENTIFICATION

Java Field: messageIdentification

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Control number for the message.

Number Of Transactions

Added On: 03/07/16

SQL Column: NUMBER_OF_TRANSACTIONS

Java Field: numberOfTransactions

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Number of transactions in the file.

Payment Information Identification

Added On: 03/07/16

SQL Column: PAYMENT_INFORMATION_IDENTIFICATION

Java Field: paymentInformationIdentification

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Payment identification information. Batch reference.

Reason Additional Information

Added On: 03/23/16

SQL Column: REASON_ADDITIONAL_INFORMATION

Java Field: reasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the status reason.

Reason Code

Added On: 03/23/16

SQL Column: REASON_CODE

Java Field: reasonCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Reason for the status reported, as published in an external reason code list.

Requested Collection Date

Added On: 03/07/16

SQL Column: REQUESTED_COLLECTION_DATE

Java Field: requestedCollectionDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Value date for the collection.

Response Status

Added On: 03/23/16

SQL Column: RESPONSE_STATUS

Java Field: responseStatus

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Current status of the response.