EFT ISO20022 Batch Transaction UML

Added On: 03/07/16

SQL Table: EFT_ISO20022_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: EftIso20022BatchTransaction

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

Available Fields:

Acceptance Datetime
Account Servicer Reference
Charge Transaction FK
Debtor Account IBAN
Debtor Account Identification
Debtor Account Type Code
Debtor Account Type Proprietary
Debtor Address Line
Debtor Agent Country
Debtor Agent Member Identification
Debtor Country

Debtor Country Sub Division
Debtor Name
Debtor Post Code
Debtor Town Name
EFT ISO2022 Batch FK
End To End Identification
Gach Reason Additional Information
Gach Reason Code
Id
Instructed Amount
Mandate Identification

Merchant Account Code
Nordic Mand Reason Additional Information
Reason Code
Return Amount
Return Instructed Amount
Subscription Transaction FK
Transaction Status
Type Reason Additional Information
UK Addacs Reason Additional Information
UK IT Reason Additional Information
US Reason Additional Information

US Reason Code

Acceptance Datetime

Added On: 04/06/16

SQL Column: ACCEPTANCE_DATETIME

Java Field: acceptanceDatetime

Status: Active

SQL Type: varchar(23)

Java Type: String

Attributes:

Date and time of the acceptance.

Account Servicer Reference

Added On: 03/23/16

SQL Column: ACCOUNT_SERVICER_REFERENCE

Java Field: accountServicerReference

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Unique reference, as assigned by the account servicing institution, to unambiguously identify the instruction.

Charge Transaction FK

Added On: 03/07/16

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Reference to the entity that represents real-time financial transaction.

Debtor Account IBAN

Added On: 03/07/16

SQL Column:

Java Field: debtorAccountIban

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Debtor account IBAN (Identification Bank Account Number).

Debtor Account Identification

Added On: 03/07/16

SQL Column:

Java Field: debtorAccountIdentification

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

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

Debtor Account Type Code

Added On: 03/07/16

SQL Column: DEBTOR_ACCOUNT_TYPE_CODE

Java Field: debtorAccountTypeCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Type of debtor account (checking or savings).

Debtor Account Type Proprietary

Added On: 03/07/16

SQL Column: DEBTOR_ACCOUNT_TYPE_PROPRIETARY

Java Field: debtorAccountTypeProprietary

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

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

Debtor Address Line

Added On: 03/07/16

SQL Column: DEBTOR_ADDRESS_LINE

Java Field: debtorAddressLine

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Address line of the debtor's address.

Debtor Agent Country

Added On: 03/07/16

SQL Column: DEBTOR_AGENT_COUNTRY

Java Field: debtorAgentCountry

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country code of the debtor agent address.

Debtor Agent Member Identification

Added On: 03/07/16

SQL Column:

Java Field: debtorAgentMemberIdentification

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Local, in-country banking association code associated to the Bank/Branch holding the debtor's account.

Debtor Country

Added On: 03/07/16

SQL Column: DEBTOR_COUNTRY

Java Field: debtorCountry

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Country code of the debtor's address.

Debtor Country Sub Division

Added On: 03/07/16

SQL Column: DEBTOR_COUNTRY_SUB_DIVISION

Java Field: debtorCountrySubDivision

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Country sub-devision of the debtor's address.

Debtor Name

Added On: 03/07/16

SQL Column: DEBTOR_NAME

Java Field: debtorName

Status: Active

SQL Type: varchar(70)

Java Type: String

Attributes:

Debtor party name.

Debtor Post Code

Added On: 03/07/16

SQL Column: DEBTOR_POST_CODE

Java Field: debtorPostCode

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

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

Debtor Town Name

Added On: 03/07/16

SQL Column: DEBTOR_TOWN_NAME

Java Field: debtorTownName

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Town (or city) name of the debtor's address.

EFT ISO2022 Batch FK

Added On: 03/07/16

SQL Column: EFT_ISO20022_BATCH_FK

Java Field: eftIso2022Batch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References EFT ISO20022 Batch

Attributes:

Reference to the entity that represents EFT ISO20022 batch information.

End To End Identification

Added On: 03/07/16

SQL Column: END_TO_END_IDENTIFICATION

Java Field: endToEndIdentification

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Gach Reason Additional Information

Added On: 03/23/16

SQL Column: GACH_REASON_ADDITIONAL_INFORMATION

Java Field: gachReasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the status reason.

Gach Reason Code

Added On: 03/23/16

SQL Column: GACH_REASON_CODE

Java Field: gachReasonCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

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

Added On: 03/07/16

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Instructed Amount

Added On: 03/07/16

SQL Column: INSTRUCTED_AMOUNT

Java Field: instructedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Instructed amount and payment currency of the collection.

Note: Currency code is an attribute of the XML tag name.

Mandate Identification

Added On: 03/07/16

SQL Column: MANDATE_IDENTIFICATION

Java Field: mandateIdentification

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

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.

Nordic Mand Reason Additional Information

Added On: 03/23/16

SQL Column: NORDIC_MAND_REASON_ADDITIONAL_INFORMATION

Java Field: nordicMandReasonAdditionalInformation

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, as published in an external reason code list.

Return Amount

Added On: 04/06/16

SQL Column: RETURN_AMOUNT

Java Field: returnAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of the return transaction.

Return Instructed Amount

Added On: 04/06/16

SQL Column: RETURN_INSTRUCTED_AMOUNT

Java Field: returnInstructedAmount

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Instructed amount of the return transaction.

Subscription Transaction FK

Added On: 03/07/16

SQL Column: SUBSCRIPTION_TRANSACTION_FK

Java Field: subscriptionTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Subscription Transaction

Attributes:

Reference to the entity that represents subscription transaction information.

Transaction Status

Added On: 03/23/16

SQL Column: TRANSACTION_STATUS

Java Field: transactionStatus

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Current status of the transaction.

Type Reason Additional Information

Added On: 03/23/16

SQL Column: TYPE_REASON_ADDITIONAL_INFORMATION

Java Field: typeReasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the reason type.

UK Addacs Reason Additional Information

Added On: 03/23/16

SQL Column: UK_ADDACS_REASON_ADDITIONAL_INFORMATION

Java Field: ukAddacsReasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the status reason.

UK IT Reason Additional Information

Added On: 03/23/16

SQL Column: UK_IT_REASON_ADDITIONAL_INFORMATION

Java Field: ukItReasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the status reason.

US Reason Additional Information

Added On: 03/23/16

SQL Column: US_REASON_ADDITIONAL_INFORMATION

Java Field: usReasonAdditionalInformation

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Further details on the status reason.

US Reason Code

Added On: 03/23/16

SQL Column: US_REASON_CODE

Java Field: usReasonCode

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

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