Elavon EISOP Retail File Batch UML

Parent: File Batch

Added On: 04/06/15

SQL Table: ELAVON_EISOP_RETAIL_FILE_BATCH

Module: UniCharge

Type: Entity Status: Active

Java Class: ElavonEisopRetailFileBatch

Elavon EISOP specific File Batch representation for the settlement process. It represents a group of Elavon EISOP Capture Retail Transaction objects that are settled together as a group within a single file.
During Generation Process, Elavon EISOP Retail File Batch is converted into a settlement file, which is then registered into File Store for further processing.

Available Fields:

Auxiliary Record Count
Building Number
City
Country
Credit Transactions Count
Currency Of TDR Records
Debit Transactions Count
Digital Wallet Merchant Enabled Flag
Dynamic Merchant Indicator

Email Address
File Creation Date
File Number
Merchant Group Identifier
Merchant Name
Net Value Of Transactions
Phone Number
Processor ID
Processor Name

SE Number
Settlement Currency
SOC Merchant Reference
SOC Number
Street Name
TDR Record Count
Total Record Count
Value Of Credit Transactions
Value Of Debit Transactions

ZIP Code

Auxiliary Record Count

Added On: 04/27/15

SQL Column: AUXILIARY_RECORD_COUNT

Java Field: auxiliaryRecordCount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Number of various auxiliary records in batch (TAR, AAR, CCR, HAR, AAR, PAR, PIR, EXD).

Building Number

Added On: 04/27/15

SQL Column: BUILDING_NUMBER

Java Field: buildingNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Building number of processing centre.

City

Added On: 04/27/15

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

City or town name of processing centre.

Country

Added On: 04/27/15

SQL Column: COUNTRY

Java Field: country

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Country of processing centre.

Credit Transactions Count

Added On: 04/27/15

SQL Column: CREDIT_TRANSACTIONS_COUNT

Java Field: creditTransactionsCount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Number of credit /refund transactions in batch.

Currency Of TDR Records

Added On: 04/27/15

SQL Column: CURRENCY_OF_TDR_RECORDS

Java Field: currencyOfTdrRecords

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Transaction currency code for TDR records contained in the batch (ISO 4217).

Debit Transactions Count

Added On: 04/27/15

SQL Column: DEBIT_TRANSACTIONS_COUNT

Java Field: debitTransactionsCount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Number of debit (sale) transactions in batch.

Digital Wallet Merchant Enabled Flag

Added On: 04/06/15

SQL Column: DIGITAL_WALLET_MERCHANT_ENABLED_FLAG

Java Field: digitalWalletMerchantEnabledFlag

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Flag to indicate that the digital wallet is enabled on merchant's side. Must be sent regardless if the transaction had been processed using digital wallet. For MasterCard only.

Dynamic Merchant Indicator

Added On: 04/06/15

SQL Column: DYNAMIC_MERCHANT_INDICATOR

Java Field: dynamicMerchantIndicator

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Allows for the merchant ID to be dynamically changed on each transaction submitted to the host for authorization and settlement.

The use of the dynamic merchant ID field is restricted by Elavon and requires prior approval to participate in the program. Values that are sent in this field by merchants that are not approved for use of this field will be ignored by the host prior to authorization and the value currently “on file” with Elavon will be used.

Email Address

Added On: 04/27/15

SQL Column: EMAIL_ADDRESS

Java Field: emailAddress

Status: Active

SQL Type: varchar(160)

Java Type: String

Attributes:

For batch authorisation use. Multiple addresses should be separated using ‘,’.

File Creation Date

Added On: 04/06/15

SQL Column: FILE_CREATION_DATE

Java Field: fileCreationDate

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

The actual date when the file was created (YYYYMMDD).

File Number

Added On: 08/03/15

SQL Column: FILE_NUMBER

Java Field: fileNumber

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Number of the batch file in the system.

Merchant Group Identifier

Added On: 04/27/15

SQL Column: MERCHANT_GROUP_IDENTIFIER

Java Field: merchantGroupIdentifier

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Only valid if a merchant is processing in Spain and other countries allocated and provided by Elavon.

If data is not present, spaces must be entered.

Merchant Name

Added On: 04/27/15

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

The name associated with merchant account.

Net Value Of Transactions

Added On: 04/27/15

SQL Column: NET_VALUE_OF_TRANSACTIONS

Java Field: netValueOfTransactions

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Net value of batch (debits minus credits). Should be an absolute value.

Phone Number

Added On: 04/27/15

SQL Column: PHONE_NUMBER

Java Field: phoneNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Contact phone number of processing centre.

Processor ID

Added On: 04/27/15

SQL Column: PROCESSOR_ID

Java Field: processorId

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

The unique processor identifier assigned for Elavon processing.

Processor Name

Added On: 04/27/15

SQL Column: PROCESSOR_NAME

Java Field: processorName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Identifies the name of the processor.

SE Number

Added On: 04/27/15

SQL Column: SE_NUMBER

Java Field: seNumber

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Service Establishment (SE) number (allocated by ELAVON).

Settlement Currency

Added On: 04/27/15

SQL Column: SETTLEMENT_CURRENCY

Java Field: settlementCurrency

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Merchant settlement currency code (ISO 4217).

SOC Merchant Reference

Added On: 04/27/15

SQL Column: SOC_MERCHANT_REFERENCE

Java Field: socMerchantReference

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Merchant Summary of Charge (SOC) reference field.

SOC Number

Added On: 04/27/15

SQL Column: SOC_NUMBER

Java Field: socNumber

Status: Active

SQL Type: varchar(8)

Java Type: String

Attributes:

Summary of Charge (SOC) number is a batch identifier that is created by the merchant/processor.

Street Name

Added On: 04/27/15

SQL Column: STREET_NAME

Java Field: streetName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Street name of processing centre.

TDR Record Count

Added On: 04/27/15

SQL Column: TDR_RECORD_COUNT

Java Field: tdrRecordCount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Number of TDR records in batch.

Total Record Count

Added On: 04/27/15

SQL Column: TOTAL_RECORD_COUNT

Java Field: totalRecordCount

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

Total number of records in batch (only TDR records and AUX records).

Value Of Credit Transactions

Added On: 04/27/15

SQL Column: VALUE_OF_CREDIT_TRANSACTIONS

Java Field: valueOfCreditTransactions

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Accumulated value for credit transactions in batch.

Value Of Debit Transactions

Added On: 04/27/15

SQL Column: VALUE_OF_DEBIT_TRANSACTIONS

Java Field: valueOfDebitTransactions

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Accumulated value for debit transactions in batch.

ZIP Code

Added On: 04/27/15

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP or postal code of processing centre.