Trust Commerce Chargeback Transaction UML

Added On: 05/16/18

SQL Table: TRUST_COMMERCE_CHARGEBACK_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: TrustCommerceChargebackTransaction

Available Fields:

Action Name
Address 1
Address 2
Amount
Auth Amount
Authcode
Avs
Bank Amount
Batchid
Batchnum
Billingid
Billingid 2
Cc
Chain
Chain Head
Charge Transaction
Chargeback Amount
City
Closed
Country Code

Credit Amount
Cust Id
Customfield 9
Description
Email
Emailreceiptstatus
Entry Mode
Exp
Expired
Fail Name
Healthcare
Id
Media Name
Merchant Account Code
Name
Operator
Phone
Prescription
Purchaseordernum
Reauth

Record Content
Ref Transid
Responsecode
Server
Shipto Address 1
Shipto Address 2
Shipto City
Shipto Name
Shipto State
Shipto Zip
Shiptosame
State
Status Name
Tax
Ticket
Trans Date
Transid
Transid 2
Trust Commerce Chargeback
Zip

Action Name

Added On: 10/24/17

SQL Column: ACTION_NAME

Java Field: actionName

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Address 1

Added On: 10/24/17

SQL Column: ADDRESS1

Java Field: address1

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Address 2

Added On: 10/24/17

SQL Column: ADDRESS2

Java Field: address2

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Amount

Added On: 10/24/17

SQL Column: AMOUNT

Java Field: amount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Auth Amount

Added On: 10/24/17

SQL Column: AUTH_AMOUNT

Java Field: authAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Authcode

Added On: 10/24/17

SQL Column: AUTHCODE

Java Field: authcode

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Avs

Added On: 10/24/17

SQL Column: AVS

Java Field: avs

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Bank Amount

Added On: 10/24/17

SQL Column: BANK_AMOUNT

Java Field: bankAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Batchid

Added On: 10/24/17

SQL Column: BATCHID

Java Field: batchid

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Batchnum

Added On: 10/24/17

SQL Column: BATCHNUM

Java Field: batchnum

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Billingid

Added On: 10/24/17

SQL Column: BILLINGID

Java Field: billingid

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Billingid 2

Added On: 10/24/17

SQL Column: BILLINGID2

Java Field: billingid2

Status: Active

SQL Type: varchar(6)

Java Type: String

Attributes:

Added On: 10/24/17

SQL Column: CC

Java Field: cc

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Chain

Added On: 10/24/17

SQL Column: CHAIN

Java Field: chain

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Chain Head

Added On: 10/24/17

SQL Column: CHAIN_HEAD

Java Field: chainHead

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Charge Transaction

Added On: 10/24/17

SQL Column: CHARGE_TRANSACTION_FK

Java Field: chargeTransaction

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Charge Transaction

Attributes:

Chargeback Amount

Added On: 10/24/17

SQL Column: CHARGEBACK_AMOUNT

Java Field: chargebackAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

City

Added On: 10/24/17

SQL Column: CITY

Java Field: city

Status: Active

SQL Type: varchar(40)

Java Type: String

Attributes:

Closed

Added On: 10/24/17

SQL Column: CLOSED

Java Field: closed

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Country Code

Added On: 10/24/17

SQL Column: COUNTRY_CODE

Java Field: countryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Credit Amount

Added On: 10/24/17

SQL Column: CREDIT_AMOUNT

Java Field: creditAmount

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Cust Id

Added On: 10/24/17

SQL Column: CUST_ID

Java Field: custId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Customfield 9

Added On: 10/24/17

SQL Column: CUSTOMFIELD9

Java Field: customfield9

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Description

Added On: 10/24/17

SQL Column: DESCRIPTION

Java Field: description

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Added On: 10/24/17

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Emailreceiptstatus

Added On: 10/24/17

SQL Column: EMAILRECEIPTSTATUS

Java Field: emailreceiptstatus

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Entry Mode

Added On: 10/24/17

SQL Column: ENTRY_MODE

Java Field: entryMode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Exp

Added On: 10/24/17

SQL Column: EXP

Java Field: exp

Status: Active

SQL Type: varchar(4)

Java Type: String

Attributes:

Expired

Added On: 10/24/17

SQL Column: EXPIRED

Java Field: expired

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

Fail Name

Added On: 10/24/17

SQL Column: FAIL_NAME

Java Field: failName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Healthcare

Added On: 10/24/17

SQL Column: HEALTHCARE

Java Field: healthcare

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Added On: 10/24/17

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.

Media Name

Added On: 10/24/17

SQL Column: MEDIA_NAME

Java Field: mediaName

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Merchant Account Code

Added On: 10/24/17

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.\n\nDepending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.\n\nThe 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: 10/24/17

SQL Column: NAME

Java Field: name

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Operator

Added On: 10/24/17

SQL Column: OPERATOR

Java Field: operator

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Phone

Added On: 10/24/17

SQL Column: PHONE

Java Field: phone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Prescription

Added On: 10/24/17

SQL Column: PRESCRIPTION

Java Field: prescription

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Purchaseordernum

Added On: 10/24/17

SQL Column: PURCHASEORDERNUM

Java Field: purchaseordernum

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Reauth

Added On: 10/24/17

SQL Column: REAUTH

Java Field: reauth

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Record Content

Added On: 10/24/17

SQL Column: RECORD_CONTENT

Java Field: recordContent

Status: Active

SQL Type: varchar(512)

Java Type: String

Attributes: Transient

Ref Transid

Added On: 10/24/17

SQL Column: REF_TRANSID

Java Field: refTransid

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Responsecode

Added On: 10/24/17

SQL Column: RESPONSECODE

Java Field: responsecode

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Server

Added On: 10/24/17

SQL Column: SERVER

Java Field: server

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Shipto Address 1

Added On: 10/24/17

SQL Column: SHIPTO_ADDRESS1

Java Field: shiptoAddress1

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Shipto Address 2

Added On: 10/24/17

SQL Column: SHIPTO_ADDRESS2

Java Field: shiptoAddress2

Status: Active

SQL Type: varchar(80)

Java Type: String

Attributes:

Shipto City

Added On: 10/24/17

SQL Column: SHIPTO_CITY

Java Field: shiptoCity

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Shipto Name

Added On: 10/24/17

SQL Column: SHIPTO_NAME

Java Field: shiptoName

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Shipto State

Added On: 10/24/17

SQL Column: SHIPTO_STATE

Java Field: shiptoState

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Shipto Zip

Added On: 10/24/17

SQL Column: SHIPTO_ZIP

Java Field: shiptoZip

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Shiptosame

Added On: 10/24/17

SQL Column: SHIPTOSAME

Java Field: shiptosame

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

State

Added On: 10/24/17

SQL Column: STATE

Java Field: state

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Status Name

Added On: 10/24/17

SQL Column: STATUS_NAME

Java Field: statusName

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Tax

Added On: 10/24/17

SQL Column: TAX

Java Field: tax

Status: Active

SQL Type: varchar(12)

Java Type: String

Attributes:

Ticket

Added On: 10/24/17

SQL Column: TICKET

Java Field: ticket

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Trans Date

Added On: 10/24/17

SQL Column: TRANS_DATE

Java Field: transDate

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Transid

Added On: 10/24/17

SQL Column: TRANSID

Java Field: transid

Status: Active

SQL Type: varchar(15)

Java Type: String

Attributes:

Transid 2

Added On: 10/24/17

SQL Column: TRANSID2

Java Field: transid2

Status: Active

SQL Type: varchar(14)

Java Type: String

Attributes:

Trust Commerce Chargeback

Added On: 10/24/17

SQL Column: TRUST_COMMERCE_CHARGEBACK_BATCH_FK

Java Field: trustCommerceChargeback

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Trust Commerce Chargeback Batch

Attributes:

Zip

Added On: 10/24/17

SQL Column: ZIP

Java Field: zip

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes: