EFT Actum Batch Transaction UML

Added On: 09/25/12

SQL Table: EFT_ACTUM_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: EftActumBatchTransaction

Represents EFT Actum batch transaction.

Available Fields:

ABA Number
Account Number
Account Type
Authorization Code
Charge Transaction FK
Cust Address1
Cust City
Cust Email
Cust Name
Cust Phone

Cust State
Cust ZIP
EFT Actum Batch FK
History Key ID
Id
Initial Amount
Mer Order Number
Merchant Account Code
New ABA Number
New Account Number

Order Number
Prev History ID
Reference Key ID
Response Transaction Type
Ship Address1
Ship City
Ship State
Ship ZIP
Sub Id
Transaction Result

Transaction Type

ABA Number

Added On: 06/10/16

SQL Column:

Java Field: abaNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Account Number

Added On: 06/10/16

SQL Column:

Java Field: accountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Contains the credit card account number which identifies the customer. The account number is left justified with trailing spaces.

Account Type

Added On: 09/25/12

SQL Column: ACCOUNT_TYPE

Java Field: accountType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Type of the account.

Authorization Code

Added On: 09/26/12

SQL Column: AUTHORIZATION_CODE

Java Field: authorizationCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Alphanumeric value assigned by the bank to a merchant sale or cash advance that has received specific approval. The code is used as proof that the transaction has been properly approved.

Charge Transaction FK

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

Cust Address1

Added On: 09/25/12

SQL Column: CUST_ADDRESS1

Java Field: custAddress1

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Street of the customer mailing address.

Cust City

Added On: 09/25/12

SQL Column: CUST_CITY

Java Field: custCity

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

City of the customer mailing address.

Cust Email

Added On: 09/25/12

SQL Column: CUST_EMAIL

Java Field: custEmail

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Email address of the customer for discussing any processing issues or sending notifications.

Cust Name

Added On: 09/25/12

SQL Column: CUST_NAME

Java Field: custName

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Name of the customer.

Cust Phone

Added On: 09/25/12

SQL Column: CUST_PHONE

Java Field: custPhone

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Phone number of the customer for discussing any processing issues.

Cust State

Added On: 09/25/12

SQL Column: CUST_STATE

Java Field: custState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State code of the customer mailing address.

Cust ZIP

Added On: 09/25/12

SQL Column: CUST_ZIP

Java Field: custZip

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP (or postal) code of the customer mailing address.

EFT Actum Batch FK

Added On: 09/26/12

SQL Column: EFT_ACTUM_BATCH_FK

Java Field: eftActumBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References EFT Actum Batch

Attributes:

Reference to a batch that this transaction belongs to.

History Key ID

Added On: 09/26/12

SQL Column: HISTORY_KEY_ID

Java Field: historyKeyId

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Unique ID for the history of the transaction.

Added On: 09/25/12

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.

Initial Amount

Added On: 09/25/12

SQL Column: INITIAL_AMOUNT

Java Field: initialAmount

Status: Active

SQL Type: varchar(13)

Java Type: String

Attributes:

Indicates the amount of the transaction to be processed, it must be entered as a decimal amount. The decimal format amount MUST be given in hundredths of a cent, with a trailing zero of an even dime - for example, "29.90" and NOT "29.9". A value of "29.9" in this field will fail to be imported.

Mer Order Number

Added On: 09/25/12

SQL Column: MER_ORDER_NUMBER

Java Field: merOrderNumber

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Usually left blank for batch transaction imports, but it may be used for any extra information regarding the transaction that the merchant may wish to keep track of

Merchant Account Code

Added On: 09/25/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.

New ABA Number

Added On: 06/05/15

SQL Column: NEW_ABA_NUMBER

Java Field: newAbaNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

New ABA number used by bank to identify specific financial institution.

New Account Number

Added On: 06/05/15

SQL Column: NEW_ACCOUNT_NUMBER

Java Field: newAccountNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

New account number of the customer.

Order Number

Added On: 09/26/12

SQL Column: ORDER_NUMBER

Java Field: orderNumber

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Identifier of the transaction to be used for cross referencing with the provider's system.

Prev History ID

Added On: 06/10/16

SQL Column: PREV_HISTORY_ID

Java Field: prevHistoryId

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Reference Key ID

Added On: 09/26/12

SQL Column: REFERENCE_KEY_ID

Java Field: referenceKeyId

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Unique ID of the reference key.

Response Transaction Type

Added On: 09/25/12

SQL Column: RESPONSE_TRANSACTION_TYPE

Java Field: responseTransactionType

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

Type of the response transaction.

Ship Address1

Added On: 09/25/12

SQL Column: SHIP_ADDRESS1

Java Field: shipAddress1

Status: Active

SQL Type: varchar(64)

Java Type: String

Attributes:

Shipping address of the customer if it is different from the billing address.

Ship City

Added On: 09/25/12

SQL Column: SHIP_CITY

Java Field: shipCity

Status: Active

SQL Type: varchar(32)

Java Type: String

Attributes:

City of the customer's shipping address if it is different from the billing address.

Ship State

Added On: 09/25/12

SQL Column: SHIP_STATE

Java Field: shipState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State code of the customer's shipping address if it is different from the billing address.

Ship ZIP

Added On: 09/25/12

SQL Column: SHIP_ZIP

Java Field: shipZip

Status: Active

SQL Type: varchar(9)

Java Type: String

Attributes:

ZIP (or postal) code of the customer's shipping address if it is different from the billing address.

Sub Id

Added On: 11/20/19

SQL Column: SUB_ID

Java Field: subId

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Transaction Result

Added On: 09/30/14

SQL Column: TRANSACTION_RESULT

Java Field: transactionResult

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Result of the transaction processing.

Transaction Type

Added On: 09/25/12

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Type of the transaction.