Added On:  02/13/12 
        
        
        
            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:  06/05/14
                SQL Column:  ALTERNATIVE_CONNECTION_TYPE
                Java Field:  alternativeConnectionType
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        Backup HTTP/HTTPs host which is used if primary connection is unavailable.
                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  ALTERNATIVE_HTTP_HOST_BACKUP
                Java Field:  alternativeHttpHostBackup
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  06/05/14
                SQL Column:  ALTERNATIVE_HTTP_PORT
                Java Field:  alternativeHttpPort
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Backup HTTP/HTTPs port which is used if primary connection is unavailable.
                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  ALTERNATIVE_HTTP_PORT_BACKUP
                Java Field:  alternativeHttpPortBackup
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  ARCHIVE_PASSWORD
                Java Field:  archivePassword
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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:  ENCRYPTION_EXPIRATION_DATE
                Java Field:  encryptionExpirationDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Expiration date of the private PGP key used for FTP/sFTP based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  ENCRYPTION_PASS_PHRASE
                Java Field:  encryptionPassPhrase
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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_PRIVATE_KEY_FILE_NAME
                Java Field:  encryptionPrivateKeyFileName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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_PUBLIC_KEY_FILE_NAME
                Java Field:  encryptionPublicKeyFileName
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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:  FTP_HOST
                Java Field:  ftpHost
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        Port used for FTP/sFTP based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  HTTP_HOST
                Java Field:  httpHost
             
            
                Status:  Active
                SQL Type:  varchar(160)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Host to be used for HTTPs based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  HTTP_HOST_BACKUP
                Java Field:  httpHostBackup
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  HTTP_PORT
                Java Field:  httpPort
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Port to be used for HTTPs based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  06/16/16
                SQL Column:  HTTP_PORT_BACKUP
                Java Field:  httpPortBackup
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  ID
                Java Field:  id
             
            
                Status:  Active
                SQL Type:  bigint(20)
                Java Type:  Long
             
            
            
                
                    Attributes:
                    Unique, Required                
                             
            
                
                    
                        
                        Identifier of the object used for references; auto-incremented integer value.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  INBOX
                Java Field:  inbox
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Location where files are uploaded for processing.
                        
                     
                 
             
                    
                        
                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:  MERCHANT_ACCOUNT_CODE
                Java Field:  merchantAccountCode
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        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:  OLD_PASSWORD
                Java Field:  oldPassword
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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:  OUTBOX
                Java Field:  outbox
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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:  PASSWORD
                Java Field:  password
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Password used for HTTPs based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PASSWORD_CHANGE_DATE
                Java Field:  passwordChangeDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        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:  PASSWORD_EXPIRATION_DATE
                Java Field:  passwordExpirationDate
             
            
                Status:  Active
                SQL Type:  datetime
                Java Type:  Date
             
            
            
            
                
                    
                        
                        Date on which the FTP/sFTP password expires.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PASSWORD_EXPIRATION_PERIOD
                Java Field:  passwordExpirationPeriod
             
            
                Status:  Active
                SQL Type:  int(11)
                Java Type:  Integer
             
            
            
            
                
                    
                        
                        Time period during which FTP/sFTP connectivity password will expire.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  PRIMARY_CONNECTION_TYPE
                Java Field:  primaryConnectionType
             
            
                Status:  Active
                SQL Type:  varchar(30)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Type of connectivity to use 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
             
            
            
            
                
                    
                        
                        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:  09/04/18
                SQL Column:  SECONDARY_SSL_ALIAS
                Java Field:  secondarySslAlias
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/04/18
                SQL Column:  SECONDARY_SSL_CERTIFICATE_FILE_NAME
                Java Field:  secondarySslCertificateFileName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  09/04/18
                SQL Column:  SECONDARY_SSL_PASSWORD
                Java Field:  secondarySslPassword
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  SMTP_ENCRYPTION_CL
                Java Field:  smtpEncryptionCl
             
            
                Status:  Active
                SQL Type:  varchar(1)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Enumeration of possible encryption modes 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
             
            
            
            
                
                    
                        
                        List of From address used for SMTP based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SMTP_HOST
                Java Field:  smtpHost
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Host 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
             
            
            
            
                
                    
                        
                        Password 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
             
            
            
            
                
                    
                        
                        Port 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
             
            
            
            
                
                    
                        
                        List of To addresses 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
             
            
            
            
                
                    
                        
                        Username used for SMTP based connectivity.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  SSH_PASS_PHRASE
                Java Field:  sshPassPhrase
             
            
                Status:  Active
                SQL Type:  varchar(100)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Passphrase of the private SSH 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
             
            
            
            
                
                    
                        
                        Name of the private SSH key to be used for FTP/sFTP based connectivity (for sFTP communication)
                        
                     
                 
             
                    
                        
                Added On:  09/04/18
                SQL Column:  SSL_ALIAS
                Java Field:  sslAlias
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                    
                        
                Added On:  02/13/12
                SQL Column:  SSL_CERTIFICATE_FILE_NAME
                Java Field:  sslCertificateFileName
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        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
             
            
            
            
                
                    
                        
                        Password on the SSL certificate used for HTTP/HTTPs based communication.
                        
                     
                 
             
                    
                        
                Added On:  02/13/12
                SQL Column:  USERNAME
                Java Field:  username
             
            
                Status:  Active
                SQL Type:  varchar(50)
                Java Type:  String
             
            
            
            
                
                    
                        
                        Username used for HTTPs based connectivity.