Import Log UML

Added On: 05/03/12

SQL Table: IMPORT_LOG

Module: UniBill

Type: Entity Status: Deleted

Java Class: ImportLog

Represents a registry of import files processed by the system.

The import files contain customer account data.

Available Fields:

Create Date
Error Content FK
Error Count
Error Message

File Name
Id
Import Content FK
Import Count

Import Format Code
Merchant Account Code
Review CL
Status CL

Create Date

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

Error Content FK

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.

Error Count

Added On: 05/14/12

SQL Column: ERROR_COUNT

Java Field: errorCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Error Message

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.

File Name

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: 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.

Import Content FK

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).

Import Count

Added On: 05/14/12

SQL Column: IMPORT_COUNT

Java Field: importCount

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Import Format Code

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.

Merchant Account Code

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.

Review CL

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.

Status CL

Added On: 05/03/12

SQL Column: STATUS_CL

Java Field: statusCl

Status: Active

SQL Type: varchar(1)

Java Type: String

References Import Log Status Classifier

Attributes:

Enumeration of possible statuses of the file within import process queue.