EFT NACHA Profile

Parent:    EFT Profile

Added On:  02/13/12 

SQL Table:  EFT_NACHA_PROFILE 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  EftNachaProfile 

Configuration settings for processing of ACH transactions using NACHA format.

Available Fields:

• Application ID
• City
• Company Name
• Company Prefix
• Contact Name
• Contact Phone Number
• Country Code
• Currency Code
• Customer Account Location Cl
• Description

• Descriptor
• Eft Nacha Profile CL
• Filename
• Immediate Origin
• Immediate Origin Name
• Merchant Account Number
• Merchant Id
• Merchant Routing Number
• Originating Dfi Identification
• Point Name

• Refund Company Id
• Request Profile Id
• Response PGP Action CL
• Response Profile Id
• Sale Company ID
• State
• Street
• User Id
• Verification Profile Id
• ZIP Code

Application ID

Added On:  11/20/12

SQL Column:  APPLICATION_ID

Java Field:  applicationId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

This value is a unique string used to identify the application within the EFT NACHA system. This field contains the Service Access ID (SAID) assigned by NACHA.

City

Added On:  07/09/13

SQL Column:  CITY

Java Field:  city

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

This field contains the merchant location/city name provided by the signing member or 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 company that originates transactions.

Company Prefix

Added On:  08/08/13

SQL Column:  COMPANY_PREFIX

Java Field:  companyPrefix

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

The prefix of the company that is used to identify this company as the component of EFT NACHA.

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 person to contact with processing issues.

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:

Phone number of the person to contact with processing issues.

Country Code

Added On:  07/09/13

SQL Column:  COUNTRY_CODE

Java Field:  countryCode

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

Attributes: Default:US

Country code of the merchant

Currency Code

Added On:  07/09/13

SQL Column:  CURRENCY_CODE

Java Field:  currencyCode

Status:  Active

SQL Type:  varchar(3)

Java Type:  String

Attributes: Default:USD

This code used to further identify the currency that is used.

Customer Account Location Cl

Added On:  09/25/20

SQL Column:  CUSTOMER_ACCOUNT_LOCATION_CL

Java Field:  customerAccountLocationCl

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

References Customer Account Location Classifier

Attributes: Default:DR

Description

Added On:  02/13/12

SQL Column:  DESCRIPTION

Java Field:  description

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Descriptor that will appear on the cardholder’s statement. If this field is blank the descriptor is reset to the default at the division level.

Descriptor

Added On:  08/13/13

SQL Column:  DESCRIPTOR

Java Field:  descriptor

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Indicates the descriptor which is set up for transactions processing.

Eft Nacha Profile CL

Added On:  02/13/12

SQL Column:  EFT_NACHA_PROFILE_CL

Java Field:  eftNachaProfileCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References EFT NACHA Profile Classifier

Attributes:

Represents the type of the provider that is used.

Filename

Added On:  02/13/12

SQL Column:  FILENAME

Java Field:  filename

Status:  Active

SQL Type:  varchar(40)

Java Type:  String

Attributes:

Name of the file to use for EFT transfer.

Immediate Origin

Added On:  02/13/12

SQL Column:  IMMEDIATE_ORIGIN

Java Field:  immediateOrigin

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

Assigned by provider (it seems this field is linked to routing number)

Immediate Origin Name

Added On:  07/11/17

SQL Column:  IMMEDIATE_ORIGIN_NAME

Java Field:  immediateOriginName

Status:  Active

SQL Type:  varchar(23)

Java Type:  String

Attributes:

Name of the Originating Company

Merchant Account Number

Added On:  07/27/20

SQL Column:  MERCHANT_ACCOUNT_NUMBER

Java Field:  merchantAccountNumber

Status:  Active

SQL Type:  varchar(17)

Java Type:  String

Attributes:

Merchant Id

Added On:  07/27/20

SQL Column:  MERCHANT_ID

Java Field:  merchantId

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

Merchant Routing Number

Added On:  07/27/20

SQL Column:  MERCHANT_ROUTING_NUMBER

Java Field:  merchantRoutingNumber

Status:  Active

SQL Type:  varchar(9)

Java Type:  String

Attributes:

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:

This field Contains the 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:

This field is only for Comerica. It is given by provider

Refund Company Id

Added On:  02/13/12

SQL Column:  REFUND_COMPANY_ID

Java Field:  refundCompanyId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ID of the company (originator of the transaction) assigned by the bank to process credits.

Request Profile Id

Added On:  02/13/12

SQL Column:  REQUEST_PROFILE_ID

Java Field:  requestProfileId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

This field is only for Comerica. It is given by provider

Response PGP Action CL

Added On:  04/24/17

SQL Column:  RESPONSE_PGP_ACTION_CL

Java Field:  responsePgpActionCl

Status:  Active

SQL Type:  varchar(2)

Java Type:  String

References PGP Action Classifier

Attributes:

Reference to the enumeration of possible types of the response files encryption that are received from the processor.

Response Profile Id

Added On:  02/13/12

SQL Column:  RESPONSE_PROFILE_ID

Java Field:  responseProfileId

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

This field is only for Comerica. It is given by provider

Sale Company ID

Added On:  02/13/12

SQL Column:  SALE_COMPANY_ID

Java Field:  saleCompanyId

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

Attributes:

ID of the company (originator of the transaction) assigned by the bank to process sales.

State

Added On:  07/09/13

SQL Column:  STATE

Java Field:  state

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

This field contains the merchant State/Province Code provided by the signing member or processor.

Street

Added On:  07/09/13

SQL Column:  STREET

Java Field:  street

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

Street address of the Merchant's postal address.

User Id

Added On:  11/20/12

SQL Column:  USER_ID

Java Field:  userId

Status:  Active

SQL Type:  varchar(8)

Java Type:  String

Attributes:

This value is a unique string used to identify the user within the EFT Nacha system.

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:

This field is only for Comerica. It is given by provider

ZIP Code

Added On:  07/09/13

SQL Column:  ZIP_CODE

Java Field:  zipCode

Status:  Active

SQL Type:  varchar(35)

Java Type:  String

Attributes:

ZIP or postal code of the merchant's mailing address.