System Table List

This section contains the names of system tables, upgrade actions, and a brief description of the tables. The upgrade actions are explained below.

Keep (KP): The data of the table in the customer's database is kept untouched. No insert or delete is performed to this table by the upgrade process. The initial installation will add necessary data for the system

Merge (MG): The non-base product data of the table in the database is kept untouched. If the data belongs to the base product, any changes pertaining to the new version of the software are performed.

Refresh (RF): The existing data in the table is replaced with the data from the base product table.

New product data is also inserted into tables marked as 'Merge'. If implementers add rows for a customer specific enhancement, it can cause duplication when the system data gets upgraded to the next version. We strongly recommend following the guidelines on how to use designated range of values or prefixes to segregate the implementation data from the base product data.

Table Name

Upgrade Action

Description

CI_​ALG

MG

Algorithm

CI_​ALG_​L

MG

Algorithm Language

CI_​ALG_​PARM

MG

Algorithm Parameters

CI_​ALG_​TYPE

MG

Algorithm Type

CI_​ALG_​TYPE_​L

MG

Algorithm Type Language

CI_​ALG_​TYPE_​PRM

MG

Algorithm Type Parameter

CI_​ALG_​TYPE_​PRM_​L

MG

Algorithm Type Parameter Language

CI_​ALG_​VER

MG

Algorithm Version

CI_​APP_​SVC_​ACC

MG

Application Service Access Mode

CI_​BATCH_​CTRL

MG

Batch Control

CI_​BATCH_​CTRL_​L

MG

Batch Control Language

CI_​BATCH_​CTRL_​P

MG

Batch Control Parameters

CI_​BATCH_​CTRL_​P_​L

MG

Batch Control Parameters Language

CI_​CHAR_​ENTITY

MG

Characteristic Type Entity

CI_​CHAR_​TYPE

MG

Characteristic Type

CI_​CHAR_​TYPE_​L

MG

Characteristic Type Language

CI_​CHAR_​VAL

MG

Characteristic Type Value

CI_​CHAR_​VAL_​L

MG

Characteristic Type Value Language

CI_​DISP_​ICON

MG

Display Icon

CI_​DISP_​ICON_​L

MG

Display Icon Language

CI_​FK_​REF

MG

Foreign Key Reference

CI_​FK_​REF_​L

MG

Foreign Key Reference Language

CI_​LANGUAGE

MG

Language Code

CI_​LOOKUP_​FIELD

MG

Lookup Field

CI_​LOOKUP_​VAL

MG

Lookup Field Value

CI_​LOOKUP_​VAL_​L

MG

Lookup Field Value Language

CI_​MD_​ATT_​TY

RF

MD Element Attribute Type

CI_​MD_​AT_​DTL

RF

MD Element Attribute Type Detail

CI_​MD_​AT_​DTL_​L

RF

MD Element Attribute Type Detail Language

CI_​MD_​CONST

MG

Constraints

CI_​MD_​CONST_​FLD

MG

Constraint Fields

CI_​MD_​CTL

RF

Generator Control

CI_​MD_​CTL_​L

RF

Generator Control Language

CI_​MD_​CTL_​TMPL

RF

Generator Control Template

CI_​MD_​ELTY

RF

MD Element Type

CI_​MD_​ELTY_​AT

RF

Element Type Attributes

CI_​MD_​ELTY_​L

RF

Element Type Language

CI_​MD_​FLD

MG

Field

CI_​MD_​FLD_​L

MG

Field Language

CI_​MD_​LOOKUP

RF

MD Lookup Field Value

CI_​MD_​LOOKUP_​F

RF

MD Lookup Field

CI_​MD_​MENU

MG

Menu Information

CI_​MD_​MENU_​IMOD

MG

Menu Item Module Maint

CI_​MD_​MENU_​ITEM

MG

Menu Item

CI_​MD_​MENU_​ITEM_​L

MG

Menu Item Language

CI_​MD_​MENU_​L

MG

Menu Language

CI_​MD_​MENU_​LINE

MG

Menu Line

CI_​MD_​MENU_​LINE_​L

MG

Menu Line Language

CI_​MD_​MENU_​MOD

MG

Menu Product Components

CI_​MD_​MO

MG

Maintenance Object

CI_​MD_​MO_​ALG

MG

Maintenance Object Algorithm

CI_​MD_​MO_​L

MG

Maintenance Object Language

CI_​MD_​MO_​OPT

MG

Maintenance Object Option

CI_​MD_​MO_​TBL

MG

Maintenance Object Table

CI_​MD_​MO_​WRK

MG

Maintenance Object Work Tables

CI_​MD_​MSG

RF

MD Message

CI_​MD_​MSG_​L

RF

MD Message Language

CI_​MD_​NAV

MG

Navigation Key

CI_​MD_​PDF

RF

Predefined Fields

CI_​MD_​PDF_​VAL

RF

Predefined Values

CI_​MD_​PRG_​COM

MG

Program Components

CI_​MD_​PRG_​ELEM

MG

UI Page Elements

CI_​MD_​PRG_​EL_​AT

MG

UI Page Element Attributes

CI_​MD_​PRG_​LOC

MG

Program Location

CI_​MD_​PRG_​MOD

MG

Program Module

CI_​MD_​PRG_​SEC

MG

UI Page Sections

CI_​MD_​PRG_​SQL

MG

MD SQL Meta Data

CI_​MD_​PRG_​TAB

MG

UI Tab Meta Data

CI_​MD_​PRG_​VAR

MG

Program Variable

CI_​MD_​SO

MG

Search Object

CI_​MD_​SOCG

MG

Search Object Criteria Group

CI_​MD_​SOCG_​FLD

MG

Search Object Criteria Group Field

CI_​MD_​SOCG_​FLDAT

MG

Search Object Criteria Group Field Attribute

CI_​MD_​SOCG_​L

MG

Search Object Criteria Group Language

CI_​MD_​SOCG_​SORT

MG

Search Object Criteria Group Result Sort Order

CI_​MD_​SO_​L

MG

Search Object Language

CI_​MD_​SO_​RSFLD

MG

Search Object Result Field

CI_​MD_​SO_​RSFLDAT

MG

Search Object Result Field Attribute

CI_​MD_​SRC_​TYPE

RF

Source Type

CI_​MD_​SRC_​TYPE_​L

RF

Source Type Language

CI_​MD_​SVC

MG

MD Service

CI_​MD_​SVC_​L

MG

MD Service Language

CI_​MD_​SVC_​PRG

MG

MD Service Program

CI_​MD_​TAB_​MOD

MG

UI Tab Module

CI_​MD_​TBL

MG

MD Table

CI_​MD_​TBL_​FLD

MG

MD Table Field

CI_​MD_​TBL_​FLD_​L

MG

MD Table Field Language

CI_​MD_​TBL_​L

MG

MD Table Language

CI_​MD_​TMPL

RF

Template

CI_​MD_​TMPL_​ELTY

RF

Template Element Types

CI_​MD_​TMPL_​L

RF

Template Language

CI_​MD_​TMPL_​VAR

RF

Template Variable

CI_​MD_​TMPL_​VAR_​L

RF

Template Variable Language

CI_​MD_​VAR

RF

Variable

CI_​MD_​VAR_​DTL

RF

Variable Detail

CI_​MD_​VAR_​DTL_​L

RF

Variable Detail Language

CI_​MD_​WRK_​TBL

MG

Work Table

CI_​MD_​WRK_​TBLFLD

MG

Work Table Field

CI_​MD_​WRK_​TBL_​L

MG

Work Table Language

CI_​MSG

MG

Message

CI_​MSG_​CATEGORY

MG

Message Category

CI_​MSG_​CATEGORY_​L

MG

Message Category Language

CI_​MSG_​L

MG

Message Language

CI_​NAV_​OPT

MG

Navigation Option

CI_​NAV_​OPT_​CTXT

MG

Navigation Option Context

CI_​NAV_​OPT_​L

MG

Navigation Option Language

CI_​NAV_​OPT_​USG

MG

Navigation Option Usage

CI_​PORTAL

MG

Portal Page

CI_​PORTAL_​L

MG

Portal Page Language

CI_​PORTAL_​ZONE

MG

Portal Zone

CI_​SCR

MG

Script

CI_​SCR_​CRT

MG

Script Criteria

CI_​SCR_​CRT_​GRP

MG

Script Criteria Group

CI_​SCR_​CRT_​GRP_​L

MG

Script Criteria Group Language

CI_​SCR_​DA

MG

Script Data Area

CI_​SCR_​FLD_​MAP

MG

Script Field Mapping

CI_​SCR_​L

MG

Script Language

CI_​SCR_​PRMPT

MG

Script Prompt

CI_​SCR_​PRMPT_​L

MG

Script Prompt Language

CI_​SCR_​STEP

MG

Script Step

CI_​SCR_​STEP_​L

MG

Script Step Language

CI_​SEQ

MG

Sequence

CI_​TD_​DRLKEY_​TY

MG

To Do Type Drill Key

CI_​TD_​SRTKEY_​TY

MG

To Do Type Sort Key

CI_​TD_​SRTKEY_​TY_​L

MG

To Do Type Sort Key Language

CI_​TD_​TYPE

MG

To Do Type

CI_​TD_​TYPE_​L

MG

To Do Type Language

CI_​XAI_​ADAPTER

MG

XAI Adapter

CI_​XAI_​ADAPTER_​L

MG

XAI Adapter Lang

CI_​XAI_​CLASS

MG

XAI Class

CI_​XAI_​CLASS_​L

MG

XAI Class Language

CI_​XAI_​ENV_​HNDL

MG

XAI Envelope Handler

CI_​XAI_​ENV_​HNDL_​L

MG

XAI Envelope Handler Language

CI_​XAI_​EXECUTER

RF

XAI Executer

CI_​XAI_​EXECUTER_​L

RF

XAI Executer Language

CI_​XAI_​FORMAT

RF

XAI Format

CI_​XAI_​FORMAT_​L

RF

XAI Format Language

CI_​XAI_​IN_​SVC

MG

XAI Inbound Service

CI_​XAI_​IN_​SVC_​L

MG

XAI Inbound Service Language

CI_​XAI_​SVC_​PARM

MG

XAI Inbound Service Parameters

CI_​XAI_​SVC_​VERS

MG

XAI Inbound Service Version

CI_​XAI_​SVC_​VERS_​L

MG

XAI Inbound Service Version Language

CI_​ZONE

MG

Zone

CI_​ZONE_​HDL

MG

Zone Type

CI_​ZONE_​HDL_​L

MG

Zone Type Language

CI_​ZONE_​HDL_​PRM

MG

Zone Type Parameters

CI_​ZONE_​HDL_​PRM_​L

MG

Zone Type Parameters Language

CI_​ZONE_​L

MG

Zone Language

CI_​ZONE_​PRM

MG

Zone Parameters

F1_​BUS_​OBJ

MG

Business Object

F1_​BUS_​OBJ_​ALG

MG

Business Object Algorithm

F1_​BUS_​OBJ_​L

MG

Business Object Language

F1_​BUS_​OBJ_​OPT

MG

Business Object Option

F1_​BUS_​OBJ_​STATUS

MG

Business Object Status

F1_​BUS_​OBJ_​STATUS_​ALG

MG

Business Object Status Algorithm

F1_​BUS_​OBJ_​STATUS_​L

MG

Business Object Status Language

F1_​BUS_​OBJ_​STATUS_​OPT

MG

Business Object Status Option

F1_​BUS_​OBJ_​TR_​RULE

MG

Business Object Transition Rule

F1_​BUS_​OBJ_​TR_​RULE_​L

MG

Business Object Transition Rule Language

F1_​BUS_​SVC

MG

Business Service

F1_​BUS_​SVC_​L

MG

Business Service Language

F1_​DATA_​AREA

MG

Data Area

F1_​DATA_​AREA_​L

MG

Data Area Language

F1_​MAP

MG

UI Map

F1_​MAP_​L

MG

UI Map Language

F1_​SCHEMA

MG

Schema

SC_​ACCESS_​CNTL

MG

User Group Access Control

SC_​APP_​SERVICE

MG

Application Service

SC_​APP_​SERVICE_​L

MG

Application Service Language

SC_​USR_​GRP_​PROF

MG

User Group Profile