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.

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.

All Logos and Trademarks used or mentioned on this page are copyrighted property of their respective owners and are used for display purposes only.