Document


Added On:  06/04/12 
SQL Table:  DOCUMENT 
Module:  UniRun 
Type:  Entity  Status:  Active 
Java Class:  Document 
Digital document associated with an employee account.
Added On:  06/04/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/04/12
SQL Column:  CREATOR_CODE
Java Field:  creatorCode
Status:  Active
SQL Type:  varchar(60)
Java Type:  String
Attributes:
Added On:  06/04/12
SQL Column:  DESCRIPTION
Java Field:  description
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
Brief description of the document's content
Added On:  06/04/12
SQL Column:  DOCUMENT_CODE_FK
Java Field:  documentCode
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Document Code
Attributes:
Reference to a document code definition type of this document.
Added On:  06/04/12
SQL Column:  EMPLOYEE_ACCOUNT_FK
Java Field:  employeeAccount
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Employee Record
Attributes:
Reference to employee account that this document is associated with.
Added On:  06/04/12
SQL Column:  FILE_STORE_CONTENT_FK
Java Field:  fileStoreContent
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References File Store Content
Attributes:
Reference to the file store content record that contains binary content of this document.
Added On:  06/04/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:  06/04/12
SQL Column:  IS_VISIBLE_EXTERNALLY
Java Field:  isVisibleExternally
Status:  Active
SQL Type:  tinyint(1)
Java Type:  Boolean
Attributes: Default:1
Indicates whether this record is visible to users who are not company's employees.
Added On:  06/04/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:  06/04/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.