Import Log UML


Added On:  05/03/12 
SQL Table:  IMPORT_LOG 
Module:  UniBill 
Type:  Entity  Status:  Active 
Java Class:  ImportLog 
Represents a registry of import files processed by the system.

The import files contain customer account data.
Added On:  05/03/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:  05/03/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:  05/03/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:  05/03/12
SQL Column:  FILE_NAME
Java Field:  fileName
Status:  Active
SQL Type:  varchar(50)
Java Type:  String
Attributes:
Name of the physical file that was loaded for import.
Added On:  05/03/12
SQL Column:  STATUS_CL
Java Field:  statusCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
Attributes:
Enumeration of possible statuses of the file within import process queue.
Added On:  05/03/12
SQL Column:  IMPORT_FORMAT_CODE
Java Field:  importFormatCode
Status:  Active
SQL Type:  varchar(10)
Java Type:  String
Attributes:
Identifier of the import file's format. Each format has corresponding import logic.
Added On:  05/03/12
SQL Column:  ERROR_MESSAGE
Java Field:  errorMessage
Status:  Active
SQL Type:  varchar(255)
Java Type:  String
Attributes:
If error occurred during the import process, this field contains error message explaining the nature of the problem.
Added On:  05/03/12
SQL Column:  IMPORT_CONTENT_FK
Java Field:  importContent
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Import Log Content
Attributes:
Reference to the import file's raw content (as stream).
Added On:  05/03/12
SQL Column:  ERROR_CONTENT_FK
Java Field:  errorContent
Status:  Active
SQL Type:  bigint(20)
Java Type:  Long
References Import Log Content
Attributes:
Reference to the reject file's raw content (as stream). Reject file is generated when import file contains errors and records that cannot be processed.
Added On:  05/14/12
SQL Column:  REVIEW_CL
Java Field:  reviewCl
Status:  Active
SQL Type:  varchar(1)
Java Type:  String
References Review Classifier
Attributes:
Enumeration of possible file statuses after the review.
Added On:  05/14/12
SQL Column:  IMPORT_COUNT
Java Field:  importCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes:
Added On:  05/14/12
SQL Column:  ERROR_COUNT
Java Field:  errorCount
Status:  Active
SQL Type:  int(11)
Java Type:  Integer
Attributes: