Entity InterfaceCodeTable

Description of Entity InterfaceCodeTable

An interface code table mainly for changing the codes.


List of all Dependencies of the Entity InterfaceCodeTable

Name

Code

Class Name

Relation_7881

Relation_7881

Reference

Relation_12200

Relation_12200

Reference


List of Attributes of the Entity InterfaceCodeTable

Name

Code

Code Table ID

CodeTableID

Code SQL Statement

CodeSQLStatement

To skip mapping process

CodeSkipMapping

Code Use External

CodeUseExternal

Code External SQL

CodeExternalSQL


Entity Attribute Code Table ID of the Entity InterfaceCodeTable

Card of Attribute Code Table ID of the Entity InterfaceCodeTable

Name

Code Table ID

Code

CodeTableID

Data Type

char(20)

Mandatory

Yes


Description of Attribute Code Table ID of the Entity InterfaceCodeTable

Shows the identity of the code table. It is also the primary key of the InterfaceCodeTable entity.


Entity Attribute Code SQL Statement of the Entity InterfaceCodeTable

Card of Attribute Code SQL Statement of the Entity InterfaceCodeTable

Name

Code SQL Statement

Code

CodeSQLStatement

Data Type

char(200)

Mandatory

No


Description of Attribute Code SQL Statement of the Entity InterfaceCodeTable

Shows the SQL (Structured Query Language) statement for the code table.


Entity Attribute To skip mapping process of the Entity InterfaceCodeTable

Card of Attribute To skip mapping process of the Entity InterfaceCodeTable

Name

To skip mapping process

Code

CodeSkipMapping

Data Type

smallint

Mandatory

No


Description of Attribute To skip mapping process of the Entity InterfaceCodeTable

Indicates if the user wants to skip the mapping process, in a form of a checkbox.


Entity Attribute Code Use External of the Entity InterfaceCodeTable

Card of Attribute Code Use External of the Entity InterfaceCodeTable

Name

Code Use External

Code

CodeUseExternal

Data Type

smallint

Mandatory

No


Description of Attribute Code Use External of the Entity InterfaceCodeTable

Shows if the code uses and external connection.


Entity Attribute Code External SQL of the Entity InterfaceCodeTable

Card of Attribute Code External SQL of the Entity InterfaceCodeTable

Name

Code External SQL

Code

CodeExternalSQL

Data Type

char(200)

Mandatory

No


Description of Attribute Code External SQL of the Entity InterfaceCodeTable

Shows if the code uses an external SQL (Structured Query Language).