LSI Batch Transaction UML

Added On: 02/13/12

SQL Table: LSI_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: LsiBatchTransaction

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

Available Fields:

Account Name
Account Number
Account Type
Address Street1
Amount
Charge Transaction FK
City
Collection Status
Date Returned
Debitor ID

Email Address
Home Phone
Id
Individual First Name
Individual Last Name
LSI Batch FK
Merchant Account Code
Merchant Account ID
Merchant Number
Payee Name

Reference Number
Return Addenda
Return Code
Return Count
Routing Number
State
Transaction Date
Transaction Method
Transaction Type
ZIP

Account Name

Added On: 02/13/12

SQL Column: ACCOUNT_NAME

Java Field: accountName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Name associated with the account in the system.

Account Number

Added On: 07/14/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: 02/13/12

SQL Column: ACCOUNT_TYPE

Java Field: accountType

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Type of the account within the system.

Address Street1

Added On: 02/13/12

SQL Column: ADDRESS_STREET1

Java Field: addressStreet1

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Street address (line 1) of the accountholder.

Amount

Added On: 02/13/12

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

The amount element defines the amount of the transaction. Supply the value in cents without a decimal point.

Charge Transaction FK

Added On: 02/13/12

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.

City

Added On: 02/13/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

City of the mailing address.

Collection Status

Added On: 02/13/12

SQL Column: COLLECTION_STATUS

Java Field: collectionStatus

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Date Returned

Added On: 02/13/12

SQL Column: DATE_RETURNED

Java Field: dateReturned

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Debitor ID

Added On: 02/13/12

SQL Column: DEBITOR_ID

Java Field: debitorId

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Email Address

Added On: 02/13/12

SQL Column: EMAIL_ADDRESS

Java Field: emailAddress

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Home Phone

Added On: 02/13/12

SQL Column: HOME_PHONE

Java Field: homePhone

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 02/13/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required

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

Individual First Name

Added On: 02/13/12

SQL Column: INDIVIDUAL_FIRST_NAME

Java Field: individualFirstName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Individual Last Name

Added On: 02/13/12

SQL Column: INDIVIDUAL_LAST_NAME

Java Field: individualLastName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

LSI Batch FK

Added On: 02/13/12

SQL Column: LSI_BATCH_FK

Java Field: lsiBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References LSI Batch

Attributes:

Reference to the entity that represnets LSI batch configuration information.

Merchant Account Code

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

Merchant Account ID

Added On: 02/13/12

SQL Column: MERCHANT_ACCOUNT_ID

Java Field: merchantAccountId

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Merchant Number

Added On: 02/13/12

SQL Column: MERCHANT_NUMBER

Java Field: merchantNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Payee Name

Added On: 02/13/12

SQL Column: PAYEE_NAME

Java Field: payeeName

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Reference Number

Added On: 02/13/12

SQL Column: REFERENCE_NUMBER

Java Field: referenceNumber

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Return Addenda

Added On: 02/13/12

SQL Column: RETURN_ADDENDA

Java Field: returnAddenda

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Return Code

Added On: 02/13/12

SQL Column: RETURN_CODE

Java Field: returnCode

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Return Count

Added On: 02/13/12

SQL Column: RETURN_COUNT

Java Field: returnCount

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Routing Number

Added On: 07/14/16

SQL Column:

Java Field: routingNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

State

Added On: 02/13/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Transaction Date

Added On: 02/13/12

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Date when the transaction was placed.

Transaction Method

Added On: 02/13/12

SQL Column: TRANSACTION_METHOD

Java Field: transactionMethod

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Transaction Type

Added On: 02/13/12

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP

Added On: 02/13/12

SQL Column: ZIP

Java Field: zip

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

ZIP or postal code of the mailing address.