EFT NACHA Batch Transaction UML

Added On: 02/13/12

SQL Table: EFT_NACHA_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: EftNachaBatchTransaction

Represents EFT NACHA batch transaction.

Available Fields:

Amount
Bank Account Number
Charge Transaction FK
Custom Field
Date Of Death
Discretionary Data
EFT Nacha Batch FK
Foreign Receiver Accoun Number
Id
Individual Id Number
Individual Name
Merchant Account Code

NOC Reason Code
Number Of Addenda Records
Originator City State
Originator Country Postal Code
Originator Name
Originator Street Address
Payment Relaited Information
Receiver City State
Receiver Country Postal Code
Receiver Id
Receiver Street Address
Receiving Company Name

Receiving DFI Branch Country Code
Receiving DFI ID
Receiving DFI Name
Record Content
Return Description
Return Reason Code
Return Transaction Code
Return Type
Routing Check
Trace Number
Transaction Code
Transaction Type Code

Amount

Added On: 02/13/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Total amount of the transactions including discount and tax.

Bank Account Number

Added On: 06/13/16

SQL Column:

Java Field: bankAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Number of the bank account.

Charge Transaction FK

Added On: 06/13/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.

Custom Field

Added On: 12/02/12

SQL Column: CUSTOM_FIELD

Java Field: customField

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Date Of Death

Added On: 02/13/12

SQL Column: DATE_OF_DEATH

Java Field: dateOfDeath

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

This field will contain the Date of Death for Reclaim return transactions. If not a Reclaim return transaction this field should be blank

Discretionary Data

Added On: 10/31/18

SQL Column: DISCRETIONARY_DATA

Java Field: discretionaryData

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

EFT Nacha Batch FK

Added On: 02/13/12

SQL Column: EFT_NACHA_BATCH_FK

Java Field: eftNachaBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References EFT NACHA Batch

Attributes:

Reference to the entity that reprents EFT NACHA batch information.

Foreign Receiver Accoun Number

Added On: 06/13/16

SQL Column:

Java Field: foreignReceiverAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Added On: 02/13/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

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

Individual Id Number

Added On: 02/13/12

SQL Column: INDIVIDUAL_ID_NUMBER

Java Field: individualIdNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

This field will contain the original transaction's Individual Identification Number

Individual Name

Added On: 02/13/12

SQL Column: INDIVIDUAL_NAME

Java Field: individualName

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

This field will contain the original transaction's Individual Name

Merchant Account Code

Added On: 02/13/12

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.

NOC Reason Code

Added On: 04/04/13

SQL Column: NOC_REASON_CODE

Java Field: nocReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Number Of Addenda Records

Added On: 07/09/13

SQL Column: NUMBER_OF_ADDENDA_RECORDS

Java Field: numberOfAddendaRecords

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Originator City State

Added On: 07/09/13

SQL Column: ORIGINATOR_CITY_STATE

Java Field: originatorCityState

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

City and state of the originator's mailing address.

Originator Country Postal Code

Added On: 07/09/13

SQL Column: ORIGINATOR_COUNTRY_POSTAL_CODE

Java Field: originatorCountryPostalCode

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

ZIP code and country code of the oroginator's mailing address.

Originator Name

Added On: 07/10/13

SQL Column: ORIGINATOR_NAME

Java Field: originatorName

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Name assosiated with the originator.

Originator Street Address

Added On: 07/09/13

SQL Column: ORIGINATOR_STREET_ADDRESS

Java Field: originatorStreetAddress

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Street of the originator's mailing address.

Payment Relaited Information

Added On: 09/25/20

SQL Column: PAYMENT_RELAITED_INFORMATION

Java Field: paymentRelaitedInformation

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Receiver City State

Added On: 07/09/13

SQL Column: RECEIVER_CITY_STATE

Java Field: receiverCityState

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

City and state of the receiver's mailing address.

Receiver Country Postal Code

Added On: 07/09/13

SQL Column: RECEIVER_COUNTRY_POSTAL_CODE

Java Field: receiverCountryPostalCode

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

ZIP code and country code of the receiver's mailing address.

Receiver Id

Added On: 07/09/13

SQL Column: RECEIVER_ID

Java Field: receiverId

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

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

Receiver Street Address

Added On: 07/09/13

SQL Column: RECEIVER_STREET_ADDRESS

Java Field: receiverStreetAddress

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Street of the receiver's mailing address.

Receiving Company Name

Added On: 07/09/13

SQL Column: RECEIVING_COMPANY_NAME

Java Field: receivingCompanyName

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

Name of the receiving company.

Receiving DFI Branch Country Code

Added On: 07/09/13

SQL Column: RECEIVING_DFI_BRANCH_COUNTRY_CODE

Java Field: receivingDfiBranchCountryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

This field contains the Branch Country Code of the Originating DFI (Depository Financial Institution).

Receiving DFI ID

Added On: 06/13/16

SQL Column:

Java Field: receivingDfiId

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Receiving DFI Name

Added On: 07/09/13

SQL Column: RECEIVING_DFI_NAME

Java Field: receivingDfiName

Status: Active

SQL Type: varchar(35)

Java Type: String

Attributes:

This field contains the receiver's name in the originating DFI (Depository Financial Institution).

Record Content

Added On: 06/13/16

SQL Column:

Java Field: recordContent

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Return Description

Added On: 02/13/12

SQL Column: RETURN_DESCRIPTION

Java Field: returnDescription

Status: Active

SQL Type: varchar(44)

Java Type: String

Attributes:

This field represents the content of field Date of Death. This field will contain the description of the return based on the value in field Return Reason Code.

Return Reason Code

Added On: 02/13/12

SQL Column: RETURN_REASON_CODE

Java Field: returnReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

This field will contain one of the standard codes used to describe the reason for returning the entry

Return Transaction Code

Added On: 02/13/12

SQL Column: RETURN_TRANSACTION_CODE

Java Field: returnTransactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

This field contains transaction code, which specifies the code of returning: 99

Return Type

Added On: 02/13/12

SQL Column: RETURN_TYPE

Java Field: returnType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

For returned records value R is used

Routing Check

Added On: 02/13/12

SQL Column: ROUTING_CHECK

Java Field: routingCheck

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

The last number in routing number

Trace Number

Added On: 02/13/12

SQL Column: TRACE_NUMBER

Java Field: traceNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Reference number on the transaction in merchant's system

Transaction Code

Added On: 02/13/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of transaction. We use values:
22 - for Checking, Credits
32 - for Savings, Credits
27 - for Checking
37 - for Savings

Transaction Type Code

Added On: 07/09/13

SQL Column: TRANSACTION_TYPE_CODE

Java Field: transactionTypeCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes: