FFS_BUSINESS_PARAM
Contains named parameters configured on company level.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_BUSINESS_PARAM_PK |
PARAM_CD |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PARAM_CD | VARCHAR2 | 64 | Yes | It is an unique code of the company parameters. |
| PARAM_DESC | VARCHAR2 | 255 | Short and meaningfull description of the parameter. | |
| PARAM_TYPE | VARCHAR2 | 1 | Yes | Type of parameter: N - number, D - Date, C - Characters. |
| PARAM_VALUE_N | NUMBER | Number Value. Used in case of numeric value of the parameter. | ||
| PARAM_VALUE_C | VARCHAR2 | 4000 | String Value. Used in case of string value of the parameter. | |
| PARAM_VALUE_D | DATE | Date Value. Used in case parameter value is a date. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_BUSINESS_PARAM_PK | Unique | DATA | PARAM_CD |