FTP Gates Log UML

Added On:  02/13/12 

SQL Table:  FTP_GATES_LOG 

Module:  UniCharge 

Type:  Entity  Status:  Active 

Java Class:  FtpGatesLog 

Available Fields:

• Aggregated FTP Gates Log FK
• Aggregation Code
• Aggregation Level Cl
• Error Message
• File CL
• Id

• Is Compressed Request Content
• Is Locked
• Merchant Code
• Processed Date
• Request Date
• Request File Checksum

• Request File Content FK
• Request File Name
• Response File Content FK
• Response File Name
• Status CL
• Submission ID

• Validation File Content FK
• Validation File Name

Aggregated FTP Gates Log FK

Added On:  09/05/14

SQL Column:  AGGREGATED_FTP_GATES_LOG_FK

Java Field:  aggregatedFtpGatesLog

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References FTP Gates Log

Attributes:

Reference to the entity that represents aggregated FTP Gates log.

Aggregation Code

Added On:  09/05/14

SQL Column:  AGGREGATION_CODE

Java Field:  aggregationCode

Status:  Active

SQL Type:  varchar(15)

Java Type:  String

Attributes:

The aggregation code of the file.

Aggregation Level Cl

Added On:  10/06/17

SQL Column:  AGGREGATION_LEVEL_CL

Java Field:  aggregationLevelCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References Aggregation Level Classifier

Attributes:

Error Message

Added On:  02/13/12

SQL Column:  ERROR_MESSAGE

Java Field:  errorMessage

Status:  Active

SQL Type:  varchar(255)

Java Type:  String

Attributes:

The text message explaining the error.

File CL

Added On:  12/11/13

SQL Column:  FILE_CL

Java Field:  fileCl

Status:  Active

SQL Type:  varchar(1)

Java Type:  String

References File Classifier

Attributes:

Enumeration of possible types of files available in the system.

Id

Added On:  02/13/12

SQL Column:  ID

Java Field:  id

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Identifier / Primary Key

Attributes: Unique, Required

Identifier of the file record used for references; auto-incremented integer value.

Is Compressed Request Content

Added On:  02/13/12

SQL Column:  IS_COMPRESSED_REQUEST_CONTENT

Java Field:  isCompressedRequestContent

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Is Locked

Added On:  02/16/16

SQL Column:  IS_LOCKED

Java Field:  isLocked

Status:  Active

SQL Type:  tinyint(1)

Java Type:  Boolean

Attributes: Default:false

Merchant Code

Added On:  02/13/12

SQL Column:  MERCHANT_CODE

Java Field:  merchantCode

Status:  Active

SQL Type:  int(11)

Java Type:  Integer

Attributes:

Provided by gateway owner. Identifies the merchant.

Processed Date

Added On:  02/13/12

SQL Column:  PROCESSED_DATE

Java Field:  processedDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

The exact date and time when the file was processed.

Request Date

Added On:  02/13/12

SQL Column:  REQUEST_DATE

Java Field:  requestDate

Status:  Active

SQL Type:  datetime

Java Type:  Date

Attributes:

The exact date and time when the file was requested.

Request File Checksum

Added On:  09/12/14

SQL Column:  REQUEST_FILE_CHECKSUM

Java Field:  requestFileChecksum

Status:  Active

SQL Type:  varchar(50)

Java Type:  String

Attributes:

Request File Content FK

Added On:  02/13/12

SQL Column:  REQUEST_FILE_CONTENT_FK

Java Field:  requestFileContent

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References FTP Gates File Content

Attributes:

Reference to the entity that represents FTP Gates file content.

Request File Name

Added On:  02/13/12

SQL Column:  REQUEST_FILE_NAME

Java Field:  requestFileName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

The name of the file that was downloaded.

Response File Content FK

Added On:  02/13/12

SQL Column:  RESPONSE_FILE_CONTENT_FK

Java Field:  responseFileContent

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References FTP Gates File Content

Attributes:

Reference to the entity that represents FTP Gates file content.

Response File Name

Added On:  02/13/12

SQL Column:  RESPONSE_FILE_NAME

Java Field:  responseFileName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

The name of the file that was downloaded and processed in the gateway.

Status CL

Added On:  02/13/12

SQL Column:  STATUS_CL

Java Field:  statusCl

Status:  Active

SQL Type:  varchar(10)

Java Type:  String

References FTP Gates Log Status Classifier

Attributes:

Represents current status of FTP Gates log.

Submission ID

Added On:  02/13/12

SQL Column:  SUBMISSION_ID

Java Field:  submissionId

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

Attributes:

Identification number of the submission file in the system.

Validation File Content FK

Added On:  04/17/15

SQL Column:  VALIDATION_FILE_CONTENT_FK

Java Field:  validationFileContent

Status:  Active

SQL Type:  bigint(20)

Java Type:  Long

References FTP Gates File Content

Attributes:

Reference to the entity that represents FTP Gates file content.

Validation File Name

Added On:  04/22/15

SQL Column:  VALIDATION_FILE_NAME

Java Field:  validationFileName

Status:  Active

SQL Type:  varchar(100)

Java Type:  String

Attributes:

The name of the validation file.