ProPay Return Transaction UML


Added On:  04/25/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ProPayReturnTransaction 
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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).
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).
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.
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.
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.
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 %).
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Added On:  06/01/16
SQL Column:  
Java Field:  recordContent
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Content of the record.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.