Collections Transaction

Added On: 02/13/12

SQL Table: COLLECTIONS_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: CollectionsTransaction

Available Fields:

City
Collections Profile CL
Country
Create Date
Custom Field1
Custom Field2
Custom Field3
Custom Field4
Custom Field5
Customer Account Balance
Customer Account Code
Email
External Reference Code
First Billing Date

First Name
Id
Is Statement
Last Name
Late Fee Amount
Merchant Account Code
Merchant Account Name
Merchant Name
Next Billing Date
Note
Payment Option Holder Name
Payment Option Number
Payment Option Type
Payment Plan Amount

Phone
Response Code
Return Fee Amount
Return Reason
State
Street1
Street2
Template Code
Transaction Amount
Transaction Balance
Transaction Code
Transaction Date
Transaction Due Date
Transaction Type

ZIP Code

City

Added On: 02/13/12

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

City of Merchant's postal address.

Collections Profile CL

Added On: 02/13/12

SQL Column: COLLECTIONS_PROFILE_CL

Java Field: collectionsProfileCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Collections Profile Classifier

Attributes:

Represents the type of collections profile.

Country

Added On: 02/13/12

SQL Column: COUNTRY

Java Field: country

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Country of Merchant's postal address.

Create Date

Added On: 02/13/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Custom Field1

Added On: 02/13/12

SQL Column: CUSTOM_FIELD1

Java Field: customField1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field2

Added On: 02/13/12

SQL Column: CUSTOM_FIELD2

Java Field: customField2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field3

Added On: 02/13/12

SQL Column: CUSTOM_FIELD3

Java Field: customField3

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field4

Added On: 02/13/12

SQL Column: CUSTOM_FIELD4

Java Field: customField4

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Custom Field5

Added On: 02/13/12

SQL Column: CUSTOM_FIELD5

Java Field: customField5

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Customer Account Balance

Added On: 02/13/12

SQL Column: CUSTOMER_ACCOUNT_BALANCE

Java Field: customerAccountBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Customer Account Code

Added On: 02/13/12

SQL Column: CUSTOMER_ACCOUNT_CODE

Java Field: customerAccountCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Value, identifying customer in submitter’s system.

Added On: 02/13/12

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Merchant's email.

External Reference Code

Added On: 02/13/12

SQL Column: EXTERNAL_REFERENCE_CODE

Java Field: externalReferenceCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

First Billing Date

Added On: 02/13/12

SQL Column: FIRST_BILLING_DATE

Java Field: firstBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

First Name

Added On: 02/13/12

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Merchant's first name.

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.

Is Statement

Added On: 02/13/12

SQL Column: IS_STATEMENT

Java Field: isStatement

Status: Active

SQL Type: tinyint(1)

Java Type: Boolean

Attributes: Default:false

Last Name

Added On: 02/13/12

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Merchant's last name.

Late Fee Amount

Added On: 02/13/12

SQL Column: LATE_FEE_AMOUNT

Java Field: lateFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

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 Name

Added On: 02/13/12

SQL Column: MERCHANT_ACCOUNT_NAME

Java Field: merchantAccountName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

The name assosiated with this merchant account.

Merchant Name

Added On: 02/13/12

SQL Column: MERCHANT_NAME

Java Field: merchantName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

The name assosiated with this merchant.

Next Billing Date

Added On: 02/13/12

SQL Column: NEXT_BILLING_DATE

Java Field: nextBillingDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Note

Added On: 02/13/12

SQL Column: NOTE

Java Field: note

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Any additional information for the merchant about the transaction.

Payment Option Holder Name

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_HOLDER_NAME

Java Field: paymentOptionHolderName

Status: Active

SQL Type: varchar(75)

Java Type: String

Attributes:

Payment Option Number

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_NUMBER

Java Field: paymentOptionNumber

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Payment Option Type

Added On: 02/13/12

SQL Column: PAYMENT_OPTION_TYPE

Java Field: paymentOptionType

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Payment Plan Amount

Added On: 02/13/12

SQL Column: PAYMENT_PLAN_AMOUNT

Java Field: paymentPlanAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Phone

Added On: 02/13/12

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant's phone number.

Response Code

Added On: 02/13/12

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Gateway generated response code.

Return Fee Amount

Added On: 02/13/12

SQL Column: RETURN_FEE_AMOUNT

Java Field: returnFeeAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Amount of return fee included in amount field.

Return Reason

Added On: 02/13/12

SQL Column: RETURN_REASON

Java Field: returnReason

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Reason for the returning of transaction.

State

Added On: 02/13/12

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State of Merchant's postal address.

Street1

Added On: 02/13/12

SQL Column: STREET1

Java Field: street1

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street1 of the merchant's mailing address.

Street2

Added On: 02/13/12

SQL Column: STREET2

Java Field: street2

Status: Active

SQL Type: varchar(128)

Java Type: String

Attributes:

Street2 of the merchant's mailing address.

Template Code

Added On: 02/13/12

SQL Column: TEMPLATE_CODE

Java Field: templateCode

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Transaction Amount

Added On: 02/13/12

SQL Column: TRANSACTION_AMOUNT

Java Field: transactionAmount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Total amount of the transaction. Usually shown in cents.

Transaction Balance

Added On: 02/13/12

SQL Column: TRANSACTION_BALANCE

Java Field: transactionBalance

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Transaction Code

Added On: 02/13/12

SQL Column: TRANSACTION_CODE

Java Field: transactionCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Value identifying this transaction in submitter’s system

Transaction Date

Added On: 02/13/12

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Actual date of the transaction.

Transaction Due Date

Added On: 02/13/12

SQL Column: TRANSACTION_DUE_DATE

Java Field: transactionDueDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Time within which payment for the transaction must be made.

Transaction Type

Added On: 02/13/12

SQL Column: TRANSACTION_TYPE

Java Field: transactionType

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Type of actual transaction.

ZIP Code

Added On: 02/13/12

SQL Column: ZIP_CODE

Java Field: zipCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP code of Merchant's postal address.