EFT NACHA Batch UML

Parent:    File Batch

Added On:  02/13/12 

SQL Table:  EFT_NACHA_BATCH 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EftNachaBatch 

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

Available Fields:

• Application ID
• Block Count
• Company Descriptive Date
• Company ID
• Company Name
• Contact Name
• Contact Phone Number
• Credit Amount
• Credit Count
• Date Verification Totals Provided
• Debit Amount
• Debit Count
• Description

• Destination Country Code
• Destination Currency Code
• Effective Entry Date
• Entry Count
• Entry Hash
• File Creation Date
• File Creation Time
• File ID Modifier
• File Process Date
• Immediate Origin
• Main File Batch Id
• Merchant Code
• Merchant Name

• Merchant Phone Number
• Origin
• Originating Currency Code
• Originating DFI Identification
• Point Name
• Profile ID
• Refund Company ID
• Sale Company ID
• Standard Entry Class
• Total Credit Entry Dollar Amount
• Total Debit Entry Dollar Amount
• User ID
• Verification Profile ID

Application ID

Added On:  11/19/12

SQL Column:  APPLICATION_ID

Java Field:  applicationId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

ID of the application used within EFT NACHA system. Contains the Service Access ID (SAID) assigned by EFT NACHA.

Block Count

Added On:  02/13/12

SQL Column:  BLOCK_COUNT

Java Field:  blockCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Number of the blocks within the file.

Company Descriptive Date

Added On:  02/13/12

SQL Column:  COMPANY_DESCRIPTIVE_DATE

Java Field:  companyDescriptiveDate

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Descriptive date of the company.

Company ID

Added On:  02/13/12

SQL Column:  COMPANY_ID

Java Field:  companyId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Unique ID of the merchant's company assigned by a processor.

Company Name

Added On:  02/13/12

SQL Column:  COMPANY_NAME

Java Field:  companyName

Status:  Active

SQL Type:  varchar(16)

Java Type:  String

Attributes:

Name of the merchant's company.

Contact Name

Added On:  02/13/12

SQL Column:  CONTACT_NAME

Java Field:  contactName

Status:  Active

SQL Type:  varchar(80)

Java Type:  String

Attributes:

Name of the contact person.

Contact Phone Number

Added On:  02/13/12

SQL Column:  CONTACT_PHONE_NUMBER

Java Field:  contactPhoneNumber

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Contact phone number.

Credit Amount

Added On:  02/13/12

SQL Column:  CREDIT_AMOUNT

Java Field:  creditAmount

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Amount of the credit transactions in the file.

Credit Count

Added On:  02/13/12

SQL Column:  CREDIT_COUNT

Java Field:  creditCount

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Amount of the credit transactions in the file.

Date Verification Totals Provided

Added On:  08/16/16

SQL Column:  DATE_VERIFICATION_TOTALS_PROVIDED

Java Field:  dateVerificationTotalsProvided

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Time and date when a processor received a file with control totals.
This field can be empty if at the moment of generation of acknowledgement file control totals file was not yet generated.

Debit Amount

Added On:  02/13/12

SQL Column:  DEBIT_AMOUNT

Java Field:  debitAmount

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Amount of the debit transactions in the file.

Debit Count

Added On:  02/13/12

SQL Column:  DEBIT_COUNT

Java Field:  debitCount

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Amount of the debit transactions in the file.

Description

Added On:  02/13/12

SQL Column:  DESCRIPTION

Java Field:  description

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Description of the file.

Destination Country Code

Added On:  07/09/13

SQL Column:  DESTINATION_COUNTRY_CODE

Java Field:  destinationCountryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes:

Country code of the merchant's mailing address.

Destination Currency Code

Added On:  07/09/13

SQL Column:  DESTINATION_CURRENCY_CODE

Java Field:  destinationCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Code used to identify the currency that is used in the destination country.

Effective Entry Date

Added On:  02/13/12

SQL Column:  EFFECTIVE_ENTRY_DATE

Java Field:  effectiveEntryDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Date when the batch file was applied to processing.

Entry Count

Added On:  02/13/12

SQL Column:  ENTRY_COUNT

Java Field:  entryCount

Status:  Active

SQL Type:  varchar(6)

Java Type:  String

Attributes:

Number of the records within the batch.

Entry Hash

Added On:  02/13/12

SQL Column:  ENTRY_HASH

Java Field:  entryHash

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Transit Routing Number of the merchant.

File Creation Date

Added On:  02/13/12

SQL Column:  FILE_CREATION_DATE

Java Field:  fileCreationDate

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Date when the file was created.

File Creation Time

Added On:  02/13/12

SQL Column:  FILE_CREATION_TIME

Java Field:  fileCreationTime

Status:  Active

SQL Type:  varchar(4)

Java Type:  String

Attributes:

Time when the file was created.

File ID Modifier

Added On:  02/13/12

SQL Column:  FILE_ID_MODIFIER

Java Field:  fileIdModifier

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

Attributes:

Indicates whether identifier of the file is allowed to be modified.

File Process Date

Added On:  08/16/16

SQL Column:  FILE_PROCESS_DATE

Java Field:  fileProcessDate

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Date when the file is processed.

Immediate Origin

Added On:  02/13/12

SQL Column:  IMMEDIATE_ORIGIN

Java Field:  immediateOrigin

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Identifier of the merchant from which the payment is applied, used for short period of time.

Main File Batch Id

Added On:  07/18/18

SQL Column:  MAIN_FILE_BATCH_ID

Java Field:  mainFileBatchId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes: Transient

Merchant Code

Added On:  09/22/15

SQL Column:  MERCHANT_CODE

Java Field:  merchantCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Code of the merchant within the system.

Merchant Name

Added On:  02/13/12

SQL Column:  MERCHANT_NAME

Java Field:  merchantName

Status:  Active

SQL Type:  varchar(22)

Java Type:  String

Attributes:

Name of the merchant.

Merchant Phone Number

Added On:  02/13/12

SQL Column:  MERCHANT_PHONE_NUMBER

Java Field:  merchantPhoneNumber

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Phone number of the merchant.

Origin

Added On:  02/13/12

SQL Column:  ORIGIN

Java Field:  origin

Status:  Active

SQL Type:  varchar(23)

Java Type:  String

Attributes:

Identifier of the merchant from which the payment is applied, that is assigned and provided to a merchant by the processor.

Originating Currency Code

Added On:  07/09/13

SQL Column:  ORIGINATING_CURRENCY_CODE

Java Field:  originatingCurrencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Code used to identify the originating currency that is used.

Originating DFI Identification

Added On:  02/13/12

SQL Column:  ORIGINATING_DFI_IDENTIFICATION

Java Field:  originatingDfiIdentification

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

National Clearing System Number of the Originating DFI (Depository Financial Institution).

Point Name

Added On:  02/13/12

SQL Column:  POINT_NAME

Java Field:  pointName

Status:  Active

SQL Type:  varchar(20)

Java Type:  String

Attributes:

Specific name of the merchant.

Profile ID

Added On:  02/13/12

SQL Column:  PROFILE_ID

Java Field:  profileId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Unique ID assigned by Comerica to identify merchant's profile.

Refund Company ID

Added On:  06/21/13

SQL Column:  REFUND_COMPANY_ID

Java Field:  refundCompanyId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ID of the company that processes credits assigned by the bank.

Sale Company ID

Added On:  06/21/13

SQL Column:  SALE_COMPANY_ID

Java Field:  saleCompanyId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ID of the company that processes sale transactions assigned by the bank.

Standard Entry Class

Added On:  02/13/12

SQL Column:  STANDARD_ENTRY_CLASS

Java Field:  standardEntryClass

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes:

Field that indicates if the record is assigned to a company or a person.
The values can be the following:
'CCD' - Indicates a company
'PPD' - Indicates a person

Total Credit Entry Dollar Amount

Added On:  02/13/12

SQL Column:  TOTAL_CREDIT_ENTRY_DOLLAR_AMOUNT

Java Field:  totalCreditEntryDollarAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Total credit amount in dollars present within the batch file.

Total Debit Entry Dollar Amount

Added On:  02/13/12

SQL Column:  TOTAL_DEBIT_ENTRY_DOLLAR_AMOUNT

Java Field:  totalDebitEntryDollarAmount

Status:  Active

SQL Type:  varchar(12)

Java Type:  String

Attributes:

Total debit amount in dollars present within the batch file.

User ID

Added On:  11/19/12

SQL Column:  USER_ID

Java Field:  userId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

Unique ID assigned by EFT Nacha to identify a merchant.

Verification Profile ID

Added On:  02/13/12

SQL Column:  VERIFICATION_PROFILE_ID

Java Field:  verificationProfileId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Unique ID assigned by Comerica to identify merchant's profile that is used for verification purposes.