ProPay Return Transaction UML

Added On: 04/25/16

SQL Table: PRO_PAY_RETURN_TRANSACTION

Module: UniCharge

Type: Entity Status: Active

Java Class: ProPayReturnTransaction

Available Fields:

Account Num1
Affiliate ID
Affiliate Name1
Att Num1
Auth Amount1
Auth Code
AVS Code
AVS Code Description
Bank Address1
Bank Address2
Bank City
Bank Name
Bank Postal Code
Bank State Province
Bank Telephone
Batch ID
Billing Address1
Billing Address2
Billing Address3
Billing City
Billing Country
Billing Postal Code
Billing State
Business Legal Name
Card Present
Charge Transaction FK
Comment11

Comment21
Consumer ID
Credit
CVV2 Resp
Disc Fee
Doing Business As
Email
Exp Date
External ID
First Name
Fund Date
Gross Amount
Has CVV2
Id
Inv Num1
Last Name
Merchant Account Code
Net Amount
New Account Number
New Routing Number
Old Account Number
Old Routing Number
Owner Address1
Owner Address2
Owner Address3
Owner City
Owner Country Code

Owner First Name
Owner Last Name
Owner Postal Code
Owner State
Per Trans Fee
Receiving Account Num
Receiving Payer Email
Receiving Payer Name
Record Content
Response Code
Response Code Description
Sending Account Num
Sending Payer Email
Sending Payer Name
Shipping Address1
Shipping Address2
Shipping City
Shipping Name
Shipping Postal Code
Shipping State
Sweep ID
Trans Description1
Transaction Date
Transaction Detail Account
Transaction Detail Email
Transaction Detail Name
Transaction Detail Type

Transaction Info ID
User Name

Account Num1

Added On: 04/25/16

SQL Column: ACCOUNT_NUM1

Java Field: accountNum1

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Required if adding bank account info as part of the signup.

Affiliate ID

Added On: 04/25/16

SQL Column: AFFILIATE_ID

Java Field: affiliateId

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

ID of the affiliate.

Affiliate Name1

Added On: 04/25/16

SQL Column: AFFILIATE_NAME1

Java Field: affiliateName1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Affiliate name in ProPay system.

Att Num1

Added On: 04/25/16

SQL Column: ATT_NUM1

Java Field: attNum1

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Number of the attempt.

Auth Amount1

Added On: 04/25/16

SQL Column: AUTH_AMOUNT1

Java Field: authAmount1

Status: Active

SQL Type: varchar(21)

Java Type: String

Attributes:

Returned if multi-currency processing is enabled. Amount expressed in foreign currency.

Auth Code

Added On: 04/25/16

SQL Column: AUTH_CODE

Java Field: authCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Issuer authorization code.

AVS Code

Added On: 04/25/16

SQL Column: AVS_CODE

Java Field: avsCode

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

AVS code of the customer.

AVS Code Description

Added On: 04/25/16

SQL Column: AVS_CODE_DESCRIPTION

Java Field: avsCodeDescription

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Short description of the AVS code.

Bank Address1

Added On: 04/25/16

SQL Column: BANK_ADDRESS1

Java Field: bankAddress1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bank location street address.

Bank Address2

Added On: 04/25/16

SQL Column: BANK_ADDRESS2

Java Field: bankAddress2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Bank location address (line 2).

Bank City

Added On: 04/25/16

SQL Column: BANK_CITY

Java Field: bankCity

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

City where the bank is located.

Bank Name

Added On: 04/25/16

SQL Column: BANK_NAME

Java Field: bankName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Bank account name.

Bank Postal Code

Added On: 04/25/16

SQL Column: BANK_POSTAL_CODE

Java Field: bankPostalCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP (or postal) code of the bank location address.

Bank State Province

Added On: 04/25/16

SQL Column: BANK_STATE_PROVINCE

Java Field: bankStateProvince

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State/Province of the bank location address.

Bank Telephone

Added On: 04/25/16

SQL Column: BANK_TELEPHONE

Java Field: bankTelephone

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Telephone number of the bank.

Batch ID

Added On: 04/25/16

SQL Column: BATCH_ID

Java Field: batchId

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

ID of the batch file of the transaction.

Billing Address1

Added On: 04/25/16

SQL Column: BILLING_ADDRESS1

Java Field: billingAddress1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Billing address of the merchant.

Billing Address2

Added On: 04/25/16

SQL Column: BILLING_ADDRESS2

Java Field: billingAddress2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Billing address of the merchant.

Billing Address3

Added On: 04/25/16

SQL Column: BILLING_ADDRESS3

Java Field: billingAddress3

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Billing address of the merchant.

Billing City

Added On: 04/25/16

SQL Column: BILLING_CITY

Java Field: billingCity

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

City of the billing address of the merchant.

Billing Country

Added On: 04/25/16

SQL Column: BILLING_COUNTRY

Java Field: billingCountry

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Country code of the billing address of the merchant.

Billing Postal Code

Added On: 04/25/16

SQL Column: BILLING_POSTAL_CODE

Java Field: billingPostalCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP (or postal) code of the billing address of the merchant.

Billing State

Added On: 04/25/16

SQL Column: BILLING_STATE

Java Field: billingState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State of the billing address of the merchant.

Business Legal Name

Added On: 04/25/16

SQL Column: BUSINESS_LEGAL_NAME

Java Field: businessLegalName

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Legal business name for merchant of record.

Card Present

Added On: 04/25/16

SQL Column: CARD_PRESENT

Java Field: cardPresent

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Indicates that transaction is card present.

Charge Transaction FK

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

Comment11

Added On: 04/25/16

SQL Column: COMMENT11

Java Field: comment11

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Comment as provided by the processor (open field in request).

Comment21

Added On: 04/25/16

SQL Column: COMMENT21

Java Field: comment21

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Comment as provided by you (open field in request).

Consumer ID

Added On: 05/05/16

SQL Column: CONSUMER_ID

Java Field: consumerId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Identification number of the consumer.

Credit

Added On: 04/25/16

SQL Column: CREDIT

Java Field: credit

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Processing credit used, if any.

CVV2 Resp

Added On: 04/25/16

SQL Column: CVV2_RESP

Java Field: cvv2Resp

Status: Active

SQL Type: varchar(1)

Java Type: String

Attributes:

CVV2 verification response.

Disc Fee

Added On: 04/25/16

SQL Column: DISC_FEE

Java Field: discFee

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

ProPay fee deducted at time of transaction (represented as %).

Doing Business As

Added On: 04/25/16

SQL Column: DOING_BUSINESS_AS

Java Field: doingBusinessAs

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

'Doing Business As' (DBA) name of the merchant.

Added On: 04/25/16

SQL Column: EMAIL

Java Field: email

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Email address of the customer.

Exp Date

Added On: 04/25/16

SQL Column: EXP_DATE

Java Field: expDate

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Expiration date of the credit card.

External ID

Added On: 05/05/16

SQL Column: EXTERNAL_ID

Java Field: externalId

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Distributor ID record.

Note: Lacking a distributor ID will prevent users from restoring a lost password, and will prevent an affiliate from ‘pinging’ using that information.

First Name

Added On: 04/25/16

SQL Column: FIRST_NAME

Java Field: firstName

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

First name of the customer.

Fund Date

Added On: 04/25/16

SQL Column: FUND_DATE

Java Field: fundDate

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Timestamp of funds becoming available to merchant.

Gross Amount

Added On: 04/25/16

SQL Column: GROSS_AMOUNT

Java Field: grossAmount

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Transaction gross amount.

Has CVV2

Added On: 04/25/16

SQL Column: HAS_CVV2

Java Field: hasCvv2

Status: Active

SQL Type: varchar(5)

Java Type: String

Attributes:

Indicates whether the credit card used in the transaction has CVV2 information.

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

Inv Num1

Added On: 04/25/16

SQL Column: INV_NUM1

Java Field: invNum1

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

Invoice number of the transaction.

Note: Transactions are rejected as duplicate when the same card is charged for the same amount with the same invoice number (including blank invoices) in a 1 minute period.

Last Name

Added On: 04/25/16

SQL Column: LAST_NAME

Java Field: lastName

Status: Active

SQL Type: varchar(25)

Java Type: String

Attributes:

Last name of the customer.

Merchant Account Code

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

Net Amount

Added On: 05/05/16

SQL Column: NET_AMOUNT

Java Field: netAmount

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Net amount of transaction.

New Account Number

Added On: 05/05/16

SQL Column:

Java Field: newAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

The ProPay account identifier for the account that is to be renewed.

New Routing Number

Added On: 05/05/16

SQL Column:

Java Field: newRoutingNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

New routing number of the bank account.

Old Account Number

Added On: 05/05/16

SQL Column:

Java Field: oldAccountNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Old account identifier assigned by ProPay.

Old Routing Number

Added On: 05/05/16

SQL Column:

Java Field: oldRoutingNumber

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Old routing number of the bank account.

Owner Address1

Added On: 04/25/16

SQL Column: OWNER_ADDRESS1

Java Field: ownerAddress1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Mailing address of the account owner.

Owner Address2

Added On: 04/25/16

SQL Column: OWNER_ADDRESS2

Java Field: ownerAddress2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Mailing address of the account owner.

Owner Address3

Added On: 04/25/16

SQL Column: OWNER_ADDRESS3

Java Field: ownerAddress3

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Address of the account owner.

Owner City

Added On: 04/25/16

SQL Column: OWNER_CITY

Java Field: ownerCity

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

City address of the account owner.

Owner Country Code

Added On: 04/25/16

SQL Column: OWNER_COUNTRY_CODE

Java Field: ownerCountryCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Country code of the account owner address.

Owner First Name

Added On: 04/25/16

SQL Column: OWNER_FIRST_NAME

Java Field: ownerFirstName

Status: Active

SQL Type: varchar(50)

Java Type: String

Attributes:

First name of the account owner.

Owner Last Name

Added On: 04/25/16

SQL Column: OWNER_LAST_NAME

Java Field: ownerLastName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Last name of the account owner.

Owner Postal Code

Added On: 04/25/16

SQL Column: OWNER_POSTAL_CODE

Java Field: ownerPostalCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP (or postal) code of the account owner address.

Owner State

Added On: 04/25/16

SQL Column: OWNER_STATE

Java Field: ownerState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State address of the account owner.

Per Trans Fee

Added On: 04/25/16

SQL Column: PER_TRANS_FEE

Java Field: perTransFee

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

The ‘flat’ per transaction portion of the ProPay fee applied to this transaction.

Receiving Account Num

Added On: 04/25/16

SQL Column: RECEIVING_ACCOUNT_NUM

Java Field: receivingAccountNum

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Account number of the receiving order side.
Assigned by ProPay.

Receiving Payer Email

Added On: 04/25/16

SQL Column: RECEIVING_PAYER_EMAIL

Java Field: receivingPayerEmail

Status: Active

SQL Type: varchar(55)

Java Type: String

Attributes:

ProPay account email for receiving funds in ProPay to ProPay transactions.

Receiving Payer Name

Added On: 04/25/16

SQL Column: RECEIVING_PAYER_NAME

Java Field: receivingPayerName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

ProPay account name for receiving funds in ProPay to ProPay transactions.

Record Content

Added On: 06/01/16

SQL Column:

Java Field: recordContent

Status: Active

SQL Type:

Java Type: String

Attributes: Transient

Content of the record.

Response Code

Added On: 04/25/16

SQL Column: RESPONSE_CODE

Java Field: responseCode

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

Gateway generated response code of the transaction.

Response Code Description

Added On: 04/25/16

SQL Column: RESPONSE_CODE_DESCRIPTION

Java Field: responseCodeDescription

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Short explaining description of the response code received for the transaction.

Sending Account Num

Added On: 04/25/16

SQL Column: SENDING_ACCOUNT_NUM

Java Field: sendingAccountNum

Status: Active

SQL Type: varchar(20)

Java Type: String

Attributes:

Assigned by ProPay.

Sending Payer Email

Added On: 04/25/16

SQL Column: SENDING_PAYER_EMAIL

Java Field: sendingPayerEmail

Status: Active

SQL Type: varchar(55)

Java Type: String

Attributes:

Sending payer email address.

Sending Payer Name

Added On: 04/25/16

SQL Column: SENDING_PAYER_NAME

Java Field: sendingPayerName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Sending payer first and last name.

Shipping Address1

Added On: 04/25/16

SQL Column: SHIPPING_ADDRESS1

Java Field: shippingAddress1

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Shipping address of the customer (line1).

Shipping Address2

Added On: 04/25/16

SQL Column: SHIPPING_ADDRESS2

Java Field: shippingAddress2

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Street (line 2) of the shipping address.

Shipping City

Added On: 04/25/16

SQL Column: SHIPPING_CITY

Java Field: shippingCity

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

City of the shipping address.

Shipping Name

Added On: 04/25/16

SQL Column: SHIPPING_NAME

Java Field: shippingName

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Name of the person that will receive the order.

Shipping Postal Code

Added On: 04/25/16

SQL Column: SHIPPING_POSTAL_CODE

Java Field: shippingPostalCode

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

ZIP (or postal) code of the shipping address.

Shipping State

Added On: 04/25/16

SQL Column: SHIPPING_STATE

Java Field: shippingState

Status: Active

SQL Type: varchar(3)

Java Type: String

Attributes:

State code of the shipping address.

Sweep ID

Added On: 04/25/16

SQL Column: SWEEP_ID

Java Field: sweepId

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Sweep ID.

Use this service to push money from a ProPay account to an on-file checking or savings account. Before this transaction can be performed, the ProPay account holder must already have logged to establish an on-file bank account.

Trans Description1

Added On: 04/25/16

SQL Column: TRANS_DESCRIPTION1

Java Field: transDescription1

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Short description of a transaction.

Transaction Date

Added On: 04/25/16

SQL Column: TRANSACTION_DATE

Java Field: transactionDate

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Date of the transaction processing.

Transaction Detail Account

Added On: 04/25/16

SQL Column: TRANSACTION_DETAIL_ACCOUNT

Java Field: transactionDetailAccount

Status: Active

SQL Type: varchar(120)

Java Type: String

Attributes:

Merchant account information.
Transaction detail fields.

Transaction Detail Email

Added On: 04/25/16

SQL Column: TRANSACTION_DETAIL_EMAIL

Java Field: transactionDetailEmail

Status: Active

SQL Type: varchar(55)

Java Type: String

Attributes:

Omit unless specially instructed by ProPay.

Transaction Detail Name

Added On: 04/25/16

SQL Column: TRANSACTION_DETAIL_NAME

Java Field: transactionDetailName

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Name of the credit card (or bank account) holder.
Transaction detail fields.

Transaction Detail Type

Added On: 04/25/16

SQL Column: TRANSACTION_DETAIL_TYPE

Java Field: transactionDetailType

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Type of transaction.
Transaction detail fields.

Transaction Info ID

Added On: 04/25/16

SQL Column: TRANSACTION_INFO_ID

Java Field: transactionInfoId

Status: Active

SQL Type: varchar(17)

Java Type: String

Attributes:

Unique ProPay transaction identifier.

User Name

Added On: 04/25/16

SQL Column: USER_NAME

Java Field: userName

Status: Active

SQL Type: varchar(150)

Java Type: String

Attributes:

Username assigned to the merchant account.