ProPay Provisioning Transaction UML


Added On:  02/04/16 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ProPayProvisioningTransaction 
Entity that represents information about provisioning transaction as it is represented in ProPay certification.
Added On:  02/05/16
SQL Column:  ACCNT_NUM
Java Field:  accntNum
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier of the account assigned by a processor.
Added On:  04/02/16
SQL Column:  ACCOUNT_COUNTRY_CODE
Java Field:  accountCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code specified in ProPay account.
Added On:  02/04/16
SQL Column:  ACCOUNT_NAME
Java Field:  accountName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Name of the ProPay account.
Added On:  02/04/16
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Account number of the user. Required if adding bank account info as part of the signup
Added On:  04/01/16
SQL Column:  ACCOUNT_NUMBER_ENCODED
Java Field:  accountNumberEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded account number.
Added On:  02/04/16
SQL Column:  ACCOUNT_NUMBER_MASKED
Java Field:  accountNumberMasked
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Masked account number of the client.
Added On:  02/04/16
SQL Column:  ACCOUNT_OWNERSHIP_TYPE
Java Field:  accountOwnershipType
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Required if adding bank account info as part of the signup. Valid values are ‘Personal’ or ‘Business’ If accountType is G, then this value is always overwritten as ‘Business’.
Added On:  02/04/16
SQL Column:  ACCOUNT_TYPE
Java Field:  accountType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Type of account from which funds are being pulled. Valid values are “Savings” or “Checking”.
Added On:  02/04/16
SQL Column:  ADDR
Java Field:  addr
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Address of the user.
Added On:  02/04/16
SQL Column:  ADDR3
Java Field:  addr3
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Physical address of the user.
Added On:  02/04/16
SQL Column:  APT_NUM
Java Field:  aptNum
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Either aptNum or addr2. Do not supply both for this field. Refer to the cpecification of the processor for more information.
Added On:  02/04/16
SQL Column:  BANK_NAME
Java Field:  bankName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the issuing bank.
Added On:  02/04/16
SQL Column:  BUSINESS_ADDRESS
Java Field:  businessAddress
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Business address of the user.
Added On:  02/04/16
SQL Column:  BUSINESS_ADDRESS2
Java Field:  businessAddress2
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Address (line 2) of the business address.
Added On:  05/31/16
SQL Column:  BUSINESS_CITY
Java Field:  businessCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City of the associated business address.
Added On:  02/04/16
SQL Column:  BUSINESS_COUNTRY
Java Field:  businessCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the business address.
Added On:  02/04/16
SQL Column:  BUSINESS_STATE
Java Field:  businessState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the business address of the client.
Added On:  02/04/16
SQL Column:  BUSINESS_ZIP
Java Field:  businessZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the business address. If domestic signup this value MUST be either 5 or 9 characters with no dash. For Canada this value MUST be 6 characters.
Added On:  02/21/19
SQL Column:  CERT_STR
Java Field:  certStr
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  02/04/16
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City address of the user.
Added On:  02/04/16
SQL Column:  COUNTRY
Java Field:  country
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the business address.
Added On:  02/04/16
SQL Column:  CURRENCY_CODE
Java Field:  currencyCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Code of the currency used in the transaction.
Added On:  02/04/16
SQL Column:  DAY_PHONE
Java Field:  dayPhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Day phone used for iscussing any processing issues. If domestic or Canadian signup this value must be 10 characters with no dash.
Added On:  02/04/16
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Description of bank account. ‘Personal’ or ‘Business’.
Added On:  02/04/16
SQL Column:  DOB
Java Field:  dob
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The date of birth of the user.
mm-dd-yyyy. The person must be at least 18 years old to obtain an account.
Added On:  02/04/16
SQL Column:  DOING_BUSINESS_AS
Java Field:  doingBusinessAs
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Merchant's DBA ("Doing Business As") name.
Added On:  06/10/16
SQL Column:  
Java Field:  ein
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Employer identification number associated with transaction.
Added On:  04/01/16
SQL Column:  EIN_ENCODED
Java Field:  einEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded EIN (Employer Identification Number).

Note: EIN can be added to a ProPay account. Including this value does not satisfy the SSN requirement for SSN.
Added On:  02/05/16
SQL Column:  ERROR_CODE
Java Field:  errorCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code of the error message generated by the procesor.
Added On:  02/05/16
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Error message generated by a processor.
Added On:  02/04/16
SQL Column:  EVEN_PHONE
Java Field:  evenPhone
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Evening phone number for discussing any processing issues. If domestic or Canadian signup this value must be 10 characters with no dash.
Added On:  02/04/16
SQL Column:  EXP_DATE
Java Field:  expDate
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Expiration date of the credit card used in the transaction.
Added On:  02/04/16
SQL Column:  EXTERNAL_ID
Java Field:  externalId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
External identification number of the account. One of the optional account identification values.
Added On:  02/04/16
SQL Column:  FIRST_NAME
Java Field:  firstName
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
First name of the ProPay account holder.
Added On:  02/04/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:  02/04/16
SQL Column:  INTL_ID
Java Field:  intlId
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Omit unless specially instructed by ProPay.
Added On:  06/10/16
SQL Column:  
Java Field:  isNextTransactionRequired
Status:  Active
SQL Type:  
Java Type:  Boolean
Attributes: Transient, Default:false
Transient field that indicates whether it is required to send additional data to the processor or not.
Added On:  02/04/16
SQL Column:  LAST_NAME
Java Field:  lastName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Last name of the ProPay account holder.
Added On:  02/04/16
SQL Column:  MAIL_ADDR
Java Field:  mailAddr
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Mailing address of the user.
Added On:  02/04/16
SQL Column:  MAIL_ADDR3
Java Field:  mailAddr3
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Mailing address values will override user address for shipping a debit card.
Added On:  02/04/16
SQL Column:  MAIL_CITY
Java Field:  mailCity
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
City mailing address of the user.
Added On:  04/02/16
SQL Column:  MAIL_COUNTRY
Java Field:  mailCountry
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Mailing address of the ProPay account.
Added On:  02/04/16
SQL Column:  MAIL_STATE
Java Field:  mailState
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State code of the mailing address of the user.
Added On:  02/04/16
SQL Column:  MAIL_ZIP
Java Field:  mailZip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code of the mailing address of the user. If domestic signup this value MUST be either 5 or 9 characters with no dash. For Canada this value MUST be 6 characters.
Added On:  02/04/16
SQL Column:  MCC_CODE
Java Field:  mccCode
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Merchant category code.
Added On:  02/04/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:  02/04/16
SQL Column:  MINITIAL
Java Field:  minitial
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Title of the customer.
Added On:  02/05/16
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Password associated with user ProPay account.
Added On:  02/04/16
SQL Column:  PAYMENT_METHOD_ID
Java Field:  paymentMethodId
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Used to pay for an account via a ProtectPay Payment Method ID. Valid value is a GUID.
Added On:  02/04/16
SQL Column:  PHONE_PIN
Java Field:  phonePin
Status:  Active
SQL Type:  varchar(4)
Java Type:  String
Attributes:
Numeric value which will give access to your user to ProPay’s IVR system. Also used to reset password if you forget your login.
Added On:  02/05/16
SQL Column:  PORTFOLIO_CODE
Java Field:  portfolioCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the portfolio associated with the record.
Added On:  02/05/16
SQL Column:  PROVISIONING_TRANSACTION_FK
Java Field:  provisioningTransaction
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity taht represents information about provisioning transaction.
Added On:  06/02/16
SQL Column:  RESELLER_CODE
Java Field:  resellerCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Code of the reseller assigned to the transaction.
Added On:  02/04/16
SQL Column:  RETAIL_TRANSACTION_CYCLE_FK
Java Field:  retailTransactionCycle
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
Reference to the entity that represents a group of real-time transactions which must be settled together.
Added On:  02/04/16
SQL Column:  
Java Field:  routingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Routing number of the bank account.
Added On:  04/01/16
SQL Column:  ROUTING_NUMBER_ENCODED
Java Field:  routingNumberEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded routing number of the bank account.
Added On:  02/04/16
SQL Column:  ROUTING_NUMBER_MASKED
Java Field:  routingNumberMasked
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Masked routing number of the bank account.
Added On:  02/24/16
SQL Column:  SECONDARY_ACCOUNT_COUNTRY_CODE
Java Field:  secondaryAccountCountryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Required if adding secondary bank account. Must be ISO standard 3 character code. This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  02/04/16
SQL Column:  SECONDARY_ACCOUNT_NAME
Java Field:  secondaryAccountName
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Required if adding secondary bank account info as part of the signup. This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  06/10/16
SQL Column:  
Java Field:  secondaryAccountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Secondary bank account number.
Added On:  04/01/16
SQL Column:  SECONDARY_ACCOUNT_NUMBER_ENCODED
Java Field:  secondaryAccountNumberEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded secondary account number.
Added On:  02/24/16
SQL Column:  SECONDARY_ACCOUNT_NUMBER_MASKED
Java Field:  secondaryAccountNumberMasked
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Required if adding secondary bank account info as part of the signup. This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  02/24/16
SQL Column:  SECONDARY_ACCOUNT_OWNERSHIP_TYPE
Java Field:  secondaryAccountOwnershipType
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Required if adding secondary account as part of the signup. Valid values are ‘Personal’ or ‘Business’ If accountType is G, then this value is always overwritten as ‘Business’ This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  02/04/16
SQL Column:  SECONDARY_ACCOUNT_TYPE
Java Field:  secondaryAccountType
Status:  Active
SQL Type:  varchar(8)
Java Type:  String
Attributes:
Required if adding secondary bank account info as part of the signup. Valid values are ‘Checking’, ‘Savings’, or simply ‘C’ or ‘S’. ‘G’ must be passed for GL accounts. This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  04/02/16
SQL Column:  SECONDARY_BANK_NAME
Java Field:  secondaryBankName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Secondary bank name. This field is needed for "Edit Account" request.
Added On:  06/10/16
SQL Column:  
Java Field:  secondaryRoutingNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Secondary routing number of the secondary bank account.
Added On:  04/01/16
SQL Column:  SECONDARY_ROUTING_NUMBER_ENCODED
Java Field:  secondaryRoutingNumberEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded secondary routing number.
Added On:  02/24/16
SQL Column:  SECONDARY_ROUTING_NUMBER_MASKED
Java Field:  secondaryRoutingNumberMasked
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
Required if adding secondary bank account info as part of the signup, must be a valid Fedwire ACH participant routing number. This will become the account to which proceeds of transactions are sent in split sweep functionality.
Added On:  02/04/16
SQL Column:  SOURCE_EMAIL
Java Field:  sourceEmail
Status:  Active
SQL Type:  varchar(55)
Java Type:  String
Attributes:
Omit unless specially instructed by ProPay.
Added On:  02/21/19
SQL Column:  SSL_CERTIFICATE_FILE_NAME
Java Field:  sslCertificateFileName
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  02/21/19
SQL Column:  SSL_PASSWORD
Java Field:  sslPassword
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Transient
Added On:  02/04/16
SQL Column:  
Java Field:  ssn
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Required for USA. Not for CAN or other country codes. Must be 9 characters with no dash if USA.
Added On:  04/01/16
SQL Column:  SSN_ENCODED
Java Field:  ssnEncoded
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Encoded SSN (Social Security Number).
Added On:  02/04/16
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State of the physical address of the user.
Added On:  02/05/16
SQL Column:  STATUS
Java Field:  status
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Status of the transaction.
Added On:  12/13/16
SQL Column:  TERM_ID
Java Field:  termId
Status:  Active
SQL Type:  varchar(31)
Java Type:  String
Attributes:
Identifier of the terminal assigned within the system.
Added On:  02/04/16
SQL Column:  TIER
Java Field:  tier
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
The type of ProPay account owned by this user. Your ProPay affiliation will have pre-defined tiers available to it.
Added On:  03/14/16
SQL Column:  TRANS_TYPE
Java Field:  transType
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Type of the transaction.
Added On:  06/10/16
SQL Column:  
Java Field:  transactionDescription
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Short description of the processed transaction (if required).
Added On:  02/04/16
SQL Column:  USER_ID
Java Field:  userId
Status:  Active
SQL Type:  varchar(55)
Java Type:  String
Attributes:
Unique identifier of the ProPay user.
Added On:  02/04/16
SQL Column:  ZIP
Java Field:  zip
Status:  Active
SQL Type:  varchar(9)
Java Type:  String
Attributes:
ZIP (or postal) code o the client's address.