Trust Commerce Batch Transaction UML

Added On: 11/18/16

SQL Table: TRUST_COMMERCE_BATCH_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TrustCommerceBatchTransaction

Entity that represents a batch transaction as it is defined in batch processing specification of TrustCommerce.

Available Fields:

Action
Address1
Amount
AVS
Billing ID
Blacklist Field
Blacklist Value
CC
Charge Transaction FK
City
Country
Customer Account Internal Code
Email
Exp
Fraud Score
Id
Merchant Account Code
Name

Operator
Payment Number
Phone
PINless Debit
PINless Lookup
Purchase Level
Purchase Order Num
Response Auth Code
Response AVS
Response Bad Data Type
Response Code
Response Code Descriptor
Response Commercial Card
Response CVV
Response Decline Type
Response Error Type
Response Offenders
Response Receipt Status

Response Status Type
Ship Date
Ship To Address1
Ship To City
Ship To Country
Ship To Name
Ship To State
Ship To ZIP
State
Tax
Tax Identifier
Ticket
Total Payments
Trans ID
Trust Commerce Batch
Velocity Type
Velocity Value
ZIP

Action

Added On: 11/18/16

SQL Column: ACTION

Java Field: action

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Address1

Added On: 11/18/16

SQL Column: ADDRESS1

Java Field: address1

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Address (line 1) of the merchant.

Amount

Added On: 11/18/16

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Amount included in the batch file.

AVS

Added On: 11/18/16

SQL Column: AVS

Java Field: avs

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Billing ID

Added On: 11/21/16

SQL Column: BILLING_ID

Java Field: billingId

Status: Active

SQL Type: varchar(16)

Java Type: String

Attributes:

Identifier of the billing plan assigned to the transaction.

Blacklist Field

Added On: 11/19/16

SQL Column: BLACKLIST_FIELD

Java Field: blacklistField

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Blacklist Value

Added On: 11/19/16

SQL Column: BLACKLIST_VALUE

Java Field: blacklistValue

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Contents of the blacklist field.

Added On: 11/18/16

SQL Column:

Java Field: cc

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Charge Transaction FK

Added On: 11/19/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 information about a batch transaction in processor’s format.

City

Added On: 11/18/16

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

City of the merchant's billing address.

Country

Added On: 11/18/16

SQL Column: COUNTRY

Java Field: country

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Country code of the merchant's billing address.

Customer Account Internal Code

Added On: 01/27/20

SQL Column: CUSTOMER_ACCOUNT_INTERNAL_CODE

Java Field: customerAccountInternalCode

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Added On: 11/18/16

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Email address of the merchant.

Exp

Added On: 11/18/16

SQL Column:

Java Field: exp

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Fraud Score

Added On: 11/19/16

SQL Column: FRAUD_SCORE

Java Field: fraudScore

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Added On: 11/18/16

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.

Merchant Account Code

Added On: 11/18/16

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.

Name

Added On: 11/18/16

SQL Column: NAME

Java Field: name

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Name of the merchant.

Operator

Added On: 11/18/16

SQL Column: OPERATOR

Java Field: operator

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Payment Number

Added On: 11/18/16

SQL Column: PAYMENT_NUMBER

Java Field: paymentNumber

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Phone

Added On: 11/18/16

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Telephone number of the merchant.

PINless Debit

Added On: 11/21/16

SQL Column: PINLESS_DEBIT

Java Field: pinlessDebit

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

PINless Lookup

Added On: 11/21/16

SQL Column: PINLESS_LOOKUP

Java Field: pinlessLookup

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Purchase Level

Added On: 11/18/16

SQL Column: PURCHASE_LEVEL

Java Field: purchaseLevel

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Purchase Order Num

Added On: 11/18/16

SQL Column: PURCHASE_ORDER_NUM

Java Field: purchaseOrderNum

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Response Auth Code

Added On: 11/19/16

SQL Column: RESPONSE_AUTH_CODE

Java Field: responseAuthCode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Code of the authorization response message generated by the system.

Response AVS

Added On: 11/19/16

SQL Column: RESPONSE_AVS

Java Field: responseAvs

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the AVS response message generated by the system.

Response Bad Data Type

Added On: 11/19/16

SQL Column: RESPONSE_BAD_DATA_TYPE

Java Field: responseBadDataType

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Response Code

Added On: 11/19/16

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Response code generated by the system.

Response Code Descriptor

Added On: 11/19/16

SQL Column: RESPONSE_CODE_DESCRIPTOR

Java Field: responseCodeDescriptor

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Dynamic description of the response message generated by the system.

Response Commercial Card

Added On: 11/19/16

SQL Column: RESPONSE_COMMERCIAL_CARD

Java Field: responseCommercialCard

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the card transaction response message generated by the system.

Response CVV

Added On: 11/19/16

SQL Column: RESPONSE_CVV

Java Field: responseCvv

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Code of the CVV response message generated by the system.

Response Decline Type

Added On: 11/19/16

SQL Column: RESPONSE_DECLINE_TYPE

Java Field: responseDeclineType

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Type of the decline response message generated by the system.

Response Error Type

Added On: 11/19/16

SQL Column: RESPONSE_ERROR_TYPE

Java Field: responseErrorType

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Type of the error response message generated by the system.

Response Offenders

Added On: 11/19/16

SQL Column: RESPONSE_OFFENDERS

Java Field: responseOffenders

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Response Receipt Status

Added On: 08/11/17

SQL Column: RESPONSE_RECEIPT_STATUS

Java Field: responseReceiptStatus

Status: Active

SQL Type: varchar(22)

Java Type: String

Attributes:

If the value of emailreceipt is Y, TC Link API returns a status value indicating the result of the email receipt attempt. The Email Receipt status field is in the Batch Results file.
Possible Values: emailmissing, malformattedemail, actionnotsupported, noteligibleforemailing

Response Status Type

Added On: 11/19/16

SQL Column: RESPONSE_STATUS_TYPE

Java Field: responseStatusType

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Ship Date

Added On: 11/21/16

SQL Column: SHIP_DATE

Java Field: shipDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Date of the shipping.

Ship To Address1

Added On: 11/18/16

SQL Column: SHIP_TO_ADDRESS1

Java Field: shipToAddress1

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Address (line 1) of the shipping destination.

Ship To City

Added On: 11/18/16

SQL Column: SHIP_TO_CITY

Java Field: shipToCity

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

City of the shipping address.

Ship To Country

Added On: 11/18/16

SQL Column: SHIP_TO_COUNTRY

Java Field: shipToCountry

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Country code of the shipping address.

Ship To Name

Added On: 11/18/16

SQL Column: SHIP_TO_NAME

Java Field: shipToName

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Name that is assigned to the shipping address.

Ship To State

Added On: 11/18/16

SQL Column: SHIP_TO_STATE

Java Field: shipToState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

State code of the shipping address.

Ship To ZIP

Added On: 11/18/16

SQL Column: SHIP_TO_ZIP

Java Field: shipToZip

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

ZIP code of the shipping address.

State

Added On: 11/18/16

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

State code of the merchant's billing address.

Tax

Added On: 11/18/16

SQL Column: TAX

Java Field: tax

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Tax Identifier

Added On: 11/19/16

SQL Column: TAX_IDENTIFIER

Java Field: taxIdentifier

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Ticket

Added On: 11/18/16

SQL Column: TICKET

Java Field: ticket

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Total Payments

Added On: 11/18/16

SQL Column: TOTAL_PAYMENTS

Java Field: totalPayments

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Trans ID

Added On: 11/18/16

SQL Column: TRANS_ID

Java Field: transId

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Identifier of the transaction.

Trust Commerce Batch

Added On: 11/19/16

SQL Column: TRUST_COMMERCE_BATCH_FK

Java Field: trustCommerceBatch

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Trust Commerce Batch

Attributes:

Reference to the entity that represents information about a batch transaction in processor’s format.

Velocity Type

Added On: 11/19/16

SQL Column: VELOCITY_TYPE

Java Field: velocityType

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Velocity Value

Added On: 11/19/16

SQL Column: VELOCITY_VALUE

Java Field: velocityValue

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Contents of the velocity field.

ZIP

Added On: 11/18/16

SQL Column: ZIP

Java Field: zip

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

ZIP code of the merchant's billing address.