Fi Serv Batch Transaction UML

Added On: 01/22/14

SQL Table: FI_SERV_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: FiServBatchTransaction

Entity that represents a batch transaction as it is defined in FiServe's batch processing specification.

Available Fields:

Bank Account Number
Charge Transaction FK
Client Transaction Code
Customer Address
Customer City
Customer ID Number
Customer Name
Customer State

Customer ZIP
Effective Date
Exception Reason Code
Fi Serv Batch FK
Id
MC Visa Rate Name
Merchant Account Code
NOC Reason Code

Raw Response Code
Record Content
Response Type
Return Reason Code
Return Transaction Code
Routing Transit Check Digit
Routing Transit Number
Sequence Number

Transaction Amount
Transaction Code

Bank Account Number

Added On: 02/22/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/15/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.

Client Transaction Code

Added On: 07/30/18

SQL Column: CLIENT_TRANSACTION_CODE

Java Field: clientTransactionCode

Status: Active

SQL Type: varchar(19)

Java Type: String

Attributes:

Customer Address

Added On: 01/22/14

SQL Column: CUSTOMER_ADDRESS

Java Field: customerAddress

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

Street address of a customer.

Customer City

Added On: 01/22/14

SQL Column: CUSTOMER_CITY

Java Field: customerCity

Status: Active

SQL Type: varchar(24)

Java Type: String

Attributes:

City of a customer.

Customer ID Number

Added On: 01/22/14

SQL Column: CUSTOMER_ID_NUMBER

Java Field: customerIdNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Unique identifier associated with customer.

Customer Name

Added On: 01/22/14

SQL Column: CUSTOMER_NAME

Java Field: customerName

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

Full name of the customer.

Customer State

Added On: 01/22/14

SQL Column: CUSTOMER_STATE

Java Field: customerState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State code of a customer.

Customer ZIP

Added On: 01/22/14

SQL Column: CUSTOMER_ZIP

Java Field: customerZip

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP (or postal) code of a customer.

Effective Date

Added On: 01/22/14

SQL Column: EFFECTIVE_DATE

Java Field: effectiveDate

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Date of collection as provided by the financial institution may not always be the same as the original collection date.

Alpha/Numeric, YYMMDD.

Exception Reason Code

Added On: 01/22/14

SQL Column: EXCEPTION_REASON_CODE

Java Field: exceptionReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Type of file.

Fi Serv Batch FK

Added On: 01/22/14

SQL Column: FI_SERV_BATCH_FK

Java Field: fiServBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Fi Serv Batch

Attributes:

Reference to the entity that represents FiServe batch transaction information.

Added On: 01/22/14

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

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

MC Visa Rate Name

Added On: 01/22/14

SQL Column: MC_VISA_RATE_NAME

Java Field: mcVisaRateName

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

MC (MasterCard) or Visa rate name.

Merchant Account Code

Added On: 01/22/14

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: 07/01/14

SQL Column: NOC_REASON_CODE

Java Field: nocReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

NoC (Notice of Change) reason code.

Raw Response Code

Added On: 08/22/18

SQL Column: RAW_RESPONSE_CODE

Java Field: rawResponseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Record Content

Added On: 02/22/16

SQL Column:

Java Field: recordContent

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Content of the record.

Response Type

Added On: 07/01/14

SQL Column: RESPONSE_TYPE

Java Field: responseType

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Type of response.

Return Reason Code

Added On: 01/22/14

SQL Column: RETURN_REASON_CODE

Java Field: returnReasonCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Reason code for the return.

Return Transaction Code

Added On: 05/26/14

SQL Column: RETURN_TRANSACTION_CODE

Java Field: returnTransactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction code that specifies the code of returning.

Routing Transit Check Digit

Added On: 01/22/14

SQL Column: ROUTING_TRANSIT_CHECK_DIGIT

Java Field: routingTransitCheckDigit

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Routing transit number check digit required for banking transactions OR filler for credit card.

Routing Transit Number

Added On: 02/22/16

SQL Column:

Java Field: routingTransitNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Routing transit number.

Sequence Number

Added On: 04/27/15

SQL Column: SEQUENCE_NUMBER

Java Field: sequenceNumber

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Sequence number of a transaction.

Transaction Amount

Added On: 01/22/14

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Amount of the transaction.

Transaction Code

Added On: 01/22/14

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Transaction code submitted for processing will be returned with each item. Numeric.