WIS_SETUP_OBJECT_DEFAULTS
This table stores the default values for the simplified setups for common work setup business objects. The defaults for the following business objects are contained in this table. 1. Work Area 2. Work Center 3. Equipment Resource 4. Labor Resource Using the quick setup functionality, an application implementation consultant will be able to create setup business objects when a new plant is configured.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
WIS_SETUP_OBJECT_DEFAULTS_PK |
SETUP_OBJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SETUP_OBJECT_ID | NUMBER | 18 | Yes | The unique identifier of a setup object default. Its value is an application generated unique id. | |
| SETUP_OBJECT_NAME | VARCHAR2 | 30 | Yes | Represents the name of the setup business object. | |
| CODE | VARCHAR2 | 30 | The unique user key to the respective setup business object. | ||
| NAME | VARCHAR2 | 120 | The alternate translatable key to the respective setup business object. | ||
| DESCRIPTION | VARCHAR2 | 240 | The description of the respective setup business object entity. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Yes | Flag used to indicate whether the setup business object record is seeded or not. Default is 'Y'. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIS_SETUP_OBJECT_DEFAULTS_N01 | Non Unique | Default | SETUP_OBJECT_NAME |
| WIS_SETUP_OBJECT_DEFAULTS_U01 | Unique | Default | SETUP_OBJECT_ID, ORA_SEED_SET1 |
| WIS_SETUP_OBJECT_DEFAULTS_U011 | Unique | Default | SETUP_OBJECT_ID, ORA_SEED_SET2 |