Terminal UML


Added On:  01/19/15 
SQL Table:  TERMINAL 
Module:  UniCharge 
Type:  Entity  Status:  Active 
Java Class:  Terminal 
Entity that represents a notion of physical or virtual terminal and shows internal and advanced settings.
Added On:  01/19/15
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:  01/19/15
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created.
Added On:  01/19/15
SQL Column:  CODE
Java Field:  code
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Unique, Required
System identifier of the terminal.
Added On:  01/19/15
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Secondary identifier of the terminal which can be used to cross-reference records between UniPay and integrated systems.
Added On:  01/19/15
SQL Column:  TERMINAL_MODEL_CODE
Java Field:  terminalModelCode
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Code of the terminal model.
Added On:  01/19/15
SQL Column:  IP_ADDRESS
Java Field:  ipAddress
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
IP location of the terminal.
Added On:  01/19/15
SQL Column:  PROCESSOR_TERMINAL_ID
Java Field:  processorTerminalId
Status:  Active
SQL Type:  varchar(16)
Java Type:  String
Attributes:
Terminal ID that is used within a service provider's system.
Added On:  01/19/15
SQL Column:  PROCESSOR_CUSTOM_FIELD1
Java Field:  processorCustomField1
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Field that provides specific values that can override respective fields in a provider profile. This field is used when provider assigns more than just Terminal ID for tracking of terminal.
Added On:  01/19/15
SQL Column:  PROCESSOR_CUSTOM_FIELD2
Java Field:  processorCustomField2
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
Field that provides specific values that can override respective fields in a provider profile. This field is used when provider assigns more than just Terminal ID for tracking of terminal.
Added On:  03/12/15
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible terminal activity statuses.
Added On:  05/12/15
SQL Column:  TERMINAL_CL
Java Field:  terminalCl
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
References Terminal Classifier
Attributes:
Reference to the entity that represents enumeration of possible types of terminal.
Added On:  06/07/15
SQL Column:  ACTIVATION_DATE
Java Field:  activationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the terminal was activated.
Added On:  06/07/15
SQL Column:  ACTIVATION_CODE
Java Field:  activationCode
Status:  Active
SQL Type:  varchar(6)
Java Type:  String
Attributes:
Code used for activation of the terminal.
Added On:  08/04/15
SQL Column:  LAST_CREDENTIALS_GENERATION_DATE
Java Field:  lastCredentialsGenerationDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when terminal password was generated the last time.
Added On:  08/04/15
SQL Column:  LAST_CREDENTIALS_CHANGE_DATE
Java Field:  lastCredentialsChangeDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
The date when terminal parrword was changed the last time.
Added On:  08/04/15
SQL Column:  PASSWORD
Java Field:  password
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Password used by the terminal within the system to process transactions.
Added On:  08/04/15
SQL Column:  NEW_PASSWORD
Java Field:  newPassword
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Updated password used by the terminal within the system to process transactions.
Added On:  09/01/15
SQL Column:  LAST_UPDATE_DATE
Java Field:  lastUpdateDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the last update of the terminal.
Added On:  11/27/15
SQL Column:  NEW_MERCHANT_ACCOUNT_CODE
Java Field:  newMerchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
New merchant account code the terminal is assigned to after the migration process.
Added On:  11/27/15
SQL Column:  NEW_TERMINAL_CODE
Java Field:  newTerminalCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Attributes:
New code of the terminal assigned after the migration process.
Added On:  12/16/15
SQL Column:  UPDATE_MODE_CL
Java Field:  updateModeCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of possible update modes of a terminal.
Added On:  12/16/15
SQL Column:  TERMINAL_LEVEL_CL
Java Field:  terminalLevelCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Reference to the entity that represents enumeration of update levels for terminals.
Added On:  09/09/16
SQL Column:  LAST_TRANSACTION_DATE
Java Field:  lastTransactionDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the last transaction was processed by the terminal.
Added On:  12/06/16
SQL Column:  KEY_ROTATION_REQUEST_DATE_P2PE
Java Field:  keyRotationRequestDateP2pe
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when request for P2PE keys rotation is sent by a processor.
Added On:  11/22/18
SQL Column:  LAST_ACTIVITY_DATE
Java Field:  lastActivityDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Added On:  11/22/18
SQL Column:  LAST_ACTIVITY_NAME
Java Field:  lastActivityName
Status:  Active
SQL Type:  varchar(25)
Java Type:  String
Attributes:
Added On:  03/12/19
SQL Column:  IS_PROCESSOR_ACTIVATED
Java Field:  isProcessorActivated
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:false
Added On:  11/28/18
SQL Column:  ONBOARDING_TERMINAL_FK
Java Field:  onboardingTerminal
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Onboarding Terminal
Attributes:
Added On:  05/23/18
SQL Column:  IS_PROVIDER_CONFIGURATION_REQUIRED
Java Field:  isProviderConfigurationRequired
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:True