Provider Account


Added On:  02/13/12 
SQL Table:  PROVIDER_ACCOUNT 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  ProviderAccount 
Encapsulates communication settings necessary to establish connection with a server of a Provider.

The connection can be established to the servers of different types and communication can occur over different protocols.

Provider Account also stores information about security keys used for secure communication.

Common connection types are HTTPs for real-time processing and sFTP for batch processing.

Added On:  02/13/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required, CreateOnly
Identifier of the object used for references; auto-incremented integer value.
Added On:  02/13/12
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/13/12
SQL Column:  NAME
Java Field:  name
Status:  Active
SQL Type:  varchar(80)
Java Type:  String
Attributes:
Name of the provider account.

Generated automatically by default. Comprised of a merchant account code followed by the type of provider profile for which it is defined.
Added On:  02/13/12
SQL Column:  USERNAME
Java Field:  username
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Username used for connection with provider through various connection protocols (e.g. for FTP/sFTP based connectivity).
Added On:  02/13/12
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Password used for connection with provider through various connection protocols (e.g. for FTP/sFTP based connectivity.).
Added On:  02/13/12
SQL Column:  OLD_PASSWORD
Java Field:  oldPassword
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Previous password used for connection with provider. The value is used to support password changes mandated by some of the providers.
Added On:  02/13/12
SQL Column:  FTP_HOST
Java Field:  ftpHost
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Host used for FTP/sFTP based connectivity.
Added On:  02/13/12
SQL Column:  FTP_PORT
Java Field:  ftpPort
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Port used for FTP/sFTP based connectivity.
Added On:  02/13/12
SQL Column:  INBOX
Java Field:  inbox
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Location where files are uploaded for processing.
Added On:  02/13/12
SQL Column:  OUTBOX
Java Field:  outbox
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Location from which response files are downloaded for processing. If value is not defined, the responses are downloaded from the upload location.
Added On:  02/13/12
SQL Column:  HTTP_HOST
Java Field:  httpHost
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Host used for HTTP/HTTPs based connectivity.
Added On:  02/13/12
SQL Column:  HTTP_PORT
Java Field:  httpPort
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Port used for HTTP/HTTPs based connectivity.
Added On:  02/13/12
SQL Column:  PRIMARY_CONNECTION_TYPE
Java Field:  primaryConnectionType
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Primary type of connectivity used to exchange messages/files with a processor.
Added On:  02/13/12
SQL Column:  SECONDARY_CONNECTION_TYPE
Java Field:  secondaryConnectionType
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Secondary/additional type of connectivity used to exchange messages/files with a provider. The value is used when more than one protocol is involved in communication process (for example, real time authorization and batch settlement).
Added On:  02/13/12
SQL Column:  PASSWORD_EXPIRATION_PERIOD
Java Field:  passwordExpirationPeriod
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Time period during which FTP/sFTP connectivity password will expire.
Added On:  02/13/12
SQL Column:  PASSWORD_EXPIRATION_DATE
Java Field:  passwordExpirationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date on which the FTP/sFTP password expires.
Added On:  02/13/12
SQL Column:  PASSWORD_CHANGE_DATE
Java Field:  passwordChangeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the FTP/sFTP password was changed for the last time. The value is used to support password changes mandated by some of the providers.
Added On:  02/13/12
SQL Column:  IS_CHANGED
Java Field:  isChanged
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Indicates whether the password was changed.
Added On:  02/13/12
SQL Column:  ENCRYPTION_PUBLIC_KEY_FILE_NAME
Java Field:  encryptionPublicKeyFileName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the public PGP key of a processor that should be used for FTP/sFTP based connectivity. The key is used to decrypt processor's response files.
Added On:  02/13/12
SQL Column:  ENCRYPTION_PRIVATE_KEY_FILE_NAME
Java Field:  encryptionPrivateKeyFileName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the private PGP key to be used for FTP/sFTP based connectivity. The key is used to encrypt outgoing files.
Added On:  02/13/12
SQL Column:  ENCRYPTION_PASS_PHRASE
Java Field:  encryptionPassPhrase
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Passphrase of the private PGP key used for FTP/sFTP based connectivity. The key is used to encrypt outgoing files.
Added On:  02/13/12
SQL Column:  ENCRYPTION_EXPIRATION_DATE
Java Field:  encryptionExpirationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Expiration date of the private PGP key used for FTP/sFTP based connectivity.
Added On:  02/13/12
SQL Column:  SSH_PRIVATE_KEY_FILE_NAME
Java Field:  sshPrivateKeyFileName
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Name of the private SSH key to be used for FTP/sFTP based connectivity (for sFTP communication)
Added On:  02/13/12
SQL Column:  SSH_PASS_PHRASE
Java Field:  sshPassPhrase
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Passphrase of the private SSH key used for FTP/sFTP based connectivity.
Added On:  02/13/12
SQL Column:  ARCHIVE_PASSWORD
Java Field:  archivePassword
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Password on .zip-archive which contains request file. The value is used to support communication with providers that require response files to be delivered as a password protected .zip-archive.
Added On:  02/13/12
SQL Column:  SMTP_HOST
Java Field:  smtpHost
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Host used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_PORT
Java Field:  smtpPort
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Port used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_ENCRYPTION_CL
Java Field:  smtpEncryptionCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible encryption modes used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_USERNAME
Java Field:  smtpUsername
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Username used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_PASSWORD
Java Field:  smtpPassword
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Password used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_FROM
Java Field:  smtpFrom
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
List of From address used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SMTP_TO
Java Field:  smtpTo
Status:  Active
SQL Type:  varchar(200)
Java Type:  String
Attributes:
List of To addresses used for SMTP based connectivity.
Added On:  02/13/12
SQL Column:  SSL_CERTIFICATE_FILE_NAME
Java Field:  sslCertificateFileName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of SSL certificate used for HTTP/HTTPs based communication.
Added On:  02/13/12
SQL Column:  SSL_PASSWORD
Java Field:  sslPassword
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Password on the SSL certificate used for HTTP/HTTPs based communication.
Added On:  06/05/14
SQL Column:  ALTERNATIVE_CONNECTION_TYPE
Java Field:  alternativeConnectionType
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Represents the type of backup connection used if primary connection is unavailable.
Added On:  06/05/14
SQL Column:  ALTERNATIVE_HTTP_HOST
Java Field:  alternativeHttpHost
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Backup HTTP/HTTPs host which is used if primary connection is unavailable.
Added On:  06/05/14
SQL Column:  ALTERNATIVE_HTTP_PORT
Java Field:  alternativeHttpPort
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Backup HTTP/HTTPs port which is used if primary connection is unavailable.
Added On:  06/16/16
SQL Column:  HTTP_HOST_BACKUP
Java Field:  httpHostBackup
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  06/16/16
SQL Column:  HTTP_PORT_BACKUP
Java Field:  httpPortBackup
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  06/16/16
SQL Column:  ALTERNATIVE_HTTP_HOST_BACKUP
Java Field:  alternativeHttpHostBackup
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Added On:  06/16/16
SQL Column:  ALTERNATIVE_HTTP_PORT_BACKUP
Java Field:  alternativeHttpPortBackup
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: