FFS_LAYOUT_ITEM
Contains items added to particular layouts.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_LAYOUT_ITEM_PK |
ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITEM_ID | NUMBER | 10 | Yes | PK.It is an ID of this layout item. | |
| LAYOUT_ID | NUMBER | 10 | Yes | It is a reference to the layout this item belongs to. | |
| LAYOUT_GROUP | VARCHAR2 | 13 | Group of the layout item ('main', 'actions', 'buttons'). | ||
| TYPE | VARCHAR2 | 14 | Type of the layout item ('main', 'action', 'button', 'field', 'property', 'menu_item', 'tab', 'text'). | ||
| PARENT | NUMBER | 10 | Yes | It is a reference to a parent 'section' or 'tab' item ('main' group only). | |
| SORTING_ORDER | NUMBER | 5 | Yes | It is an item sorting order inside of the same group. | |
| ENTITY | NUMBER | 8 | Yes | It is a type of the entity this object belongs to. | |
| FIELD | VARCHAR2 | 320 | It is the name of the field to be shown (if type = 'field' or 'marker'). | ||
| PROPERTY_ID | NUMBER | 5 | Yes | It is a reference to property (if type = 'field' or 'property'). | |
| ACTION_LINK_ID | NUMBER | 10 | Yes | It is a reference to action link (if type = 'action'). | |
| PRIVILEGE_OBJECT_ID | NUMBER | 8 | Yes | It is a reference to security module (if type = 'menu_item'). | |
| DEFAULT_VISIBILITY | VARCHAR2 | 9 | It is a default visibility of this item. | ||
| FONT_STYLE | NUMBER | 10 | Font feight for an item in GUI, mask : 0 - BOLD, 1 - ITALIC. | ||
| FONT_SIZE | NUMBER | 10 | Font size for an item in GUI: 1 - Small, 2 - Big. | ||
| TEXT_COLOR | VARCHAR2 | 6 | Font hex color for an Item In gui. Value without # symbol. Example: 170FFF. | ||
| FORM_ID | NUMBER | 10 | Unique identifier of the form. Form Id. | ||
| IS_SCANNER | NUMBER | 1 | Is this element allow scanning. 0 or null -> not allow, 1 -> allow. | ||
| MIN_NUM_IMAGES | NUMBER | 2 | Min number of images for multi-image property for an item in GUI. | ||
| MAX_NUM_IMAGES | NUMBER | 2 | Max number of images for multi-image property for an item in GUI. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_LAYOUT_ITEM_N1 | Non Unique | DATA | LAYOUT_ID |
| FFS_LAYOUT_ITEM_N2 | Non Unique | DATA | PARENT |
| FFS_LAYOUT_ITEM_PK | Unique | DATA | ITEM_ID, ORA_SEED_SET1 |
| FFS_LAYOUT_ITEM_PK1 | Unique | DATA | ITEM_ID, ORA_SEED_SET2 |