Important links · Flexcube reference
Flexcube naming conventions
Every Flexcube database object name follows the same pattern. Once you can read it, a name like
SMTB_ROLE_DETAIL tells you the module, the kind of object and what it holds.
Anatomy of a table name
Read a name position by position:
Classic name (up to 12.x, and the synonym in 14.x)
Physical table in 14.x
Module
Two-letter module code, e.g. SM = security management.
Object type
TM maintenance, TB internal, TW work table, VW view. In 14.x tables use Z in position 3.
Separator
Always an underscore _.
Content
What the object holds, e.g. ROLE_DETAIL, CUSTOMER, CONTRACT.
What changed in Flexcube 14.x
From release 14.x the physical table carries Z as its third character, and the familiar name with T still exists as a synonym pointing to it:
| Synonym (classic name) | Physical table (14.x) | |
|---|---|---|
| ACTB_DAILY_LOG | → | ACZB_DAILY_LOG |
| CSTB_CONTRACT | → | CSZB_CONTRACT |
| SMTB_ROLE_DETAIL | → | SMZB_ROLE_DETAIL |
| SMTB_USER | → | SMZB_USER |
| STTM_BRANCH | → | STZM_BRANCH |
Existing SQL, reports and scripts that use the classic names keep working through the synonyms.
When you look at table structures, grants or storage (for example in ALL_TABLES),
search for the Z name.
Check it in your own schema
-- Which table does a classic name point to?
SELECT synonym_name, table_owner, table_name
FROM all_synonyms
WHERE synonym_name = 'SMTB_ROLE_DETAIL';
-- All physical security tables in 14.x
SELECT table_name
FROM all_tables
WHERE table_name LIKE 'SMZ%'
ORDER BY table_name;
-- Every object of one module (tables, views, packages…)
SELECT object_name, object_type
FROM all_objects
WHERE object_name LIKE 'CS%'
ORDER BY object_type, object_name;Object type codes
| Code | Meaning | Example |
|---|---|---|
| TM | Maintenance table: static / master data set up through maintenance screens | STTM_BRANCH |
| TB | Internal table: data the system writes while processing (contracts, logs, balances) | CSTB_CONTRACT |
| TW | Work / temporary table used during processing | ICTW_IS_VALS |
| VW | View built over one or more tables | ACVW_ALL_AC_ENTRIES |
| ZM · ZB · ZW | 14.x physical tables; the TM / TB / TW names are synonyms | SMZB_ROLE_DETAIL |
| PKS | Server-side PL/SQL package | CSPKS_… |
| PKCS | Client-side package | …PKCS_… |
Reading real names
-
STTM_CUSTOMER
ST Static / core maintenance · TM Maintenance table · Customer master data
-
CSTB_CONTRACT
CS Core services · TB Internal table · Contracts across modules
-
ICTW_IS_VALS
IC Interest & charges · TW Work table · Interest calculation values during processing
-
SMTB_ROLE_DETAIL
SM Security management · TB Internal table · Functions mapped to each role (SMZB_ROLE_DETAIL in 14.x)
-
ACVW_ALL_AC_ENTRIES
AC Accounting · VW View · All accounting entries: daily log + history
Module codes (positions 1–2)
The most common prefixes you will meet in the schema.