Capture Info UML


Added On:  03/16/12 
SQL Table:  CAPTURE_INFO 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  CaptureInfo 
Added On:  08/30/15
SQL Column:  
Java Field:  accessory
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Expiration date of the card or bank routing number.
Added On:  08/30/15
SQL Column:  
Java Field:  accountNumber
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Encoded credit card number or bank account number.
Added On:  09/20/18
SQL Column:  ADDRESS
Java Field:  address
Status:  Active
SQL Type:  varchar
Java Type:  String
Attributes: Calculated
Added On:  03/16/12
SQL Column:  APPROVAL_CODE
Java Field:  approvalCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Authorization code returned by Provider that approved this transaction. In some instances might also be used to store response code returned by Provider when transaction declines.
Added On:  03/16/12
SQL Column:  BANK_INFO_FK
Java Field:  bankInfo
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
References Bank Info
Attributes:
Reference to the entity that represents bank information.
Added On:  03/16/12
SQL Column:  BILLING_HISTORY_FK
Java Field:  billingHistory
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Billing History
Attributes:
Reference to the entity that represents billing history of the account.
Added On:  03/16/12
SQL Column:  CITY
Java Field:  city
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
City mailing address of the cardholder.
Added On:  03/16/12
SQL Column:  COLLECTOR_ACCOUNT_CODE
Java Field:  collectorAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Account code of the collector's agent.
Added On:  02/27/14
SQL Column:  COUNTRY_CODE
Java Field:  countryCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Country code of the mailing address of the cardholder.
Added On:  03/16/12
SQL Column:  CREATE_DATE
Java Field:  createDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date when the record was created
Added On:  08/30/15
SQL Column:  
Java Field:  cvv2
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
CVV2 security code of the credit card.
Added On:  03/16/12
SQL Column:  EMAIL
Java Field:  email
Status:  Active
SQL Type:  varchar(100)
Java Type:  String
Attributes:
Email address associated with the cardholder.
Added On:  03/16/12
SQL Column:  ENCODED_BIN
Java Field:  encodedBin
Status:  Active
SQL Type:  varchar(32)
Java Type:  String
Attributes:
Encoded BIN (bank identification number).
Added On:  03/16/12
SQL Column:  HOLDER_NAME
Java Field:  holderName
Status:  Active
SQL Type:  varchar(150)
Java Type:  String
Attributes:
Name of bank account or credit card holder.
Added On:  03/16/12
SQL Column:  ID
Java Field:  id
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
Identifier / Primary Key
Attributes: Required
Identifier of the object used for references; auto-incremented integer value.
Added On:  03/16/12
SQL Column:  IS_BIN_UNAVAILABLE
Java Field:  isBinUnavailable
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes:
Indicates whether BIN is unavailable.
Added On:  08/30/15
SQL Column:  
Java Field:  isProxynizationEnabled
Status:  Active
SQL Type:  
Java Type:  Boolean
Attributes: Transient, Default:false
Indicates whether the proxynization is enabled for this transaction.
Added On:  03/16/12
SQL Column:  ISSUER_BANK_NAME
Java Field:  issuerBankName
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Bank name of the issuer.
Added On:  03/16/12
SQL Column:  ISSUER_BANK_PHONE
Java Field:  issuerBankPhone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Service phone of the issuer bank.
Added On:  12/22/21
SQL Column:  MASKED_ACCOUNT_NUMBER
Java Field:  maskedAccountNumber
Status:  Active
SQL Type:  varchar(19)
Java Type:  String
Attributes: Transient
Added On:  03/16/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:  01/24/18
SQL Column:  NETWORK_TRANSACTION_ID
Java Field:  networkTransactionId
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  01/24/18
SQL Column:  ORIGINAL_NETWORK_TRANSACTION_ID
Java Field:  originalNetworkTransactionId
Status:  Active
SQL Type:  varchar(30)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  PAYMENT_OPTION_FK
Java Field:  paymentOption
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Payment Option
Attributes:
Reference to the entity that represents payment options associated with the account.
Added On:  03/16/12
SQL Column:  PHONE
Java Field:  phone
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Phone number associated with mailing address of the cardholder.
Added On:  03/16/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Secondary identifier, which can be used to cross-reference records between UniPay and integrated systems.

See Reference Code for additional information.
Added On:  03/16/12
SQL Column:  REFERENCE_NUMBER
Java Field:  referenceNumber
Status:  Active
SQL Type:  varchar(20)
Java Type:  String
Attributes:
Transaction identification in gateway.
Added On:  03/16/12
SQL Column:  REQUEST_DATE
Java Field:  requestDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the request.
Added On:  03/16/12
SQL Column:  RESPONSE_CODE
Java Field:  responseCode
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
Gateway generated response code.
Added On:  03/16/12
SQL Column:  RESPONSE_DATE
Java Field:  responseDate
Status:  Active
SQL Type:  datetime
Java Type:  Date
Attributes:
Date of the response.
Added On:  07/18/18
SQL Column:  RESPONSE_MESSAGE
Java Field:  responseMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  RISK_EXPLANATION
Java Field:  riskExplanation
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  RISK_SCOPE
Java Field:  riskScope
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/09/18
SQL Column:  SEQUENCE_COUNT
Java Field:  sequenceCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  02/09/18
SQL Column:  SEQUENCE_NUMBER
Java Field:  sequenceNumber
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  03/16/12
SQL Column:  STATE
Java Field:  state
Status:  Active
SQL Type:  varchar(3)
Java Type:  String
Attributes:
State mailing address of the cardholder.
Added On:  03/16/12
SQL Column:  STREET
Java Field:  street
Status:  Active
SQL Type:  varchar(128)
Java Type:  String
Attributes:
Street mailing address of the cardholder.
Added On:  03/16/12
SQL Column:  SYS_MESSAGE
Java Field:  sysMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Added On:  03/16/12
SQL Column:  TAX_AMOUNT
Java Field:  taxAmount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Amount of tax in cents included in the amount field.
Added On:  03/16/12
SQL Column:  TOKEN_CODE
Java Field:  tokenCode
Status:  Active
SQL Type:  varchar(512)
Java Type:  String
Attributes:
Token generated for the provided payment information.
Added On:  08/30/15
SQL Column:  
Java Field:  trackData
Status:  Active
SQL Type:  
Java Type:  String
Attributes: Transient
Added On:  03/16/12
SQL Column:  TRANSACTION_CL
Java Field:  transactionCl
Status:  Active
SQL Type:  varchar(2)
Java Type:  String
Attributes:
Enumeration of possible asset transaction processing modes available in the system.
Added On:  03/16/12
SQL Column:  ZIP_CODE
Java Field:  zipCode
Status:  Active
SQL Type:  varchar(15)
Java Type:  String
Attributes:
ZIP/postal code of mailing address of the cardholder.