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.
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.
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.
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).
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.
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.
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.
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.
Added On:  07/05/16
SQL Column:  CREDITOR_COUNTRY_SUB_DIVISION
Java Field:  creditorCountrySubDivision
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
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.
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.
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.
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).
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.
Added On:  03/07/16
SQL Column:  
Java Field:  initiatingPartyIdentification
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Identification of the initiating party.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.