Signature


Added On:  06/08/12 
SQL Table:  SIGNATURE 
Module:  UniRun 
Type:  Entity  Status:  Active 
Java Class:  Signature 
Stores digital signatures associated with the digital documents.
Added On:  06/08/12
SQL Column:  CONTENT
Java Field:  content
Status:  Active
SQL Type:  longtext
Java Type:  String
Attributes:
Binary content (base64) of the signature object.
Added On:  06/08/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:  06/08/12
SQL Column:  DOCUMENT_FK
Java Field:  document
Status:  Active
SQL Type:  bigint(20)
Java Type:  
References Document
Attributes: Required
Reference to the document that this signature is associated with.
Added On:  06/08/12
SQL Column:  EMPLOYEE_FK
Java Field:  employee
Status:  Active
SQL Type:  bigint(20)
Java Type:  
References Employee
Attributes: Required
Reference to the employee that this signature is associated with. Note: the signature may not necessarily belong to the employee (e.g. supervisor's signature).
Added On:  06/08/12
SQL Column:  EMPLOYEE_RECORD_FK
Java Field:  employeeRecord
Status:  Active
SQL Type:  bigint(20)
Java Type:  
References Employee Record
Attributes: Required
Reference to the employee record that was active at the moment when the signature was token for the employee associated with this signature.
Added On:  06/08/12
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:  06/08/12
SQL Column:  IMAGE
Java Field:  image
Status:  Active
SQL Type:  longblob
Java Type:  byte[]
Attributes:
Binary content of the graphical (jpeg) representation of the signature (signature's picture)
Added On:  06/08/12
SQL Column:  MARKER
Java Field:  marker
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Internal identifier of the signature within the associated document.
Added On:  06/08/12
SQL Column:  MERCHANT_ACCOUNT_CODE
Java Field:  merchantAccountCode
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: Required, CreateOnly
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:  06/08/12
SQL Column:  REF_CODE
Java Field:  refCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
See Reference Code definition for additional information.
Added On:  06/08/12
SQL Column:  TERMS
Java Field:  terms
Status:  Active
SQL Type:  longtext
Java Type:  String
Attributes:
Terms accepted/acknowledge with the signature.