Signature UML

Added On: 03/16/12

SQL Table: SIGNATURE

Module: UniBill

Type: Entity Status: Active

Java Class: Signature

Available Fields:

Content
Create Date
Customer Account FK

Document FK
Id
Image

Marker
Merchant Account Code
Ref ID

Reference Code
Terms

Content

Added On: 03/16/12

SQL Column: CONTENT

Java Field: content

Status: Active

SQL Type: longtext

Java Type: String

Attributes:

Binary content of the signature object.

Create Date

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.

Customer Account FK

Added On: 03/16/12

SQL Column: CUSTOMER_ACCOUNT_FK

Java Field: customerAccount

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Customer Account

Attributes:

Reference to entity that represents customer account this signature is associated to. Note: the signature may not necessarily belong to the person represented by the account (e.g. sales person's signature).

Document FK

Added On: 03/16/12

SQL Column: DOCUMENT_FK

Java Field: document

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Document

Attributes:

Reference to the entity that represents a document that this signature is associated to.

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.

Image

Added On: 03/16/12

SQL Column: IMAGE

Java Field: image

Status: Active

SQL Type: longblob

Java Type: byte[]

Attributes:

Graphical representation of the signature in jpeg format.

Marker

Added On: 03/16/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.

Merchant Account Code

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.

Ref ID

Added On: 09/21/16

SQL Column:

Java Field: refId

Status: Active

SQL Type:

Java Type: Long

Attributes: Transient

Identifier that can be used to cross-reference records between UniPay and integrated systems.

Reference Code

Added On: 03/16/12

SQL Column: REF_CODE

Java Field: refCode

Status: Active

SQL Type: varchar(60)

Java Type: String

Attributes:

Secondary identifier used to cross-reference records between UniPay and integrated systems.

Terms

Added On: 03/16/12

SQL Column: TERMS

Java Field: terms

Status: Active

SQL Type: longtext

Java Type: String

Attributes:

Terms that are acknowledged with this signature.