CSE_SYSTEM_OPTIONS
Entity that holds the system configuration for asset lifecycle management.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_SYSTEM_OPTIONS_PK |
SYSTEM_OPTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SYSTEM_OPTION_ID | NUMBER | 18 | Yes | Unique System generated Primary Key | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| MP_CP_ORGANIZATION_ID | NUMBER | 18 | The central planning organization used to define global work definitions and maintenance programs. | ||
| MP_ALLOW_SUPP_MERGE_ACROSS_WR | VARCHAR2 | 1 | Flag to allow or limit the functionality in the maintenance program to generate work order forecasts, by merging or suppressing work definitions from multiple work requirements. | ||
| MP_ALLOW_FORECAST_GEN_ONLINE | VARCHAR2 | 1 | Flag that controls whether the forecast generation program can be submitted from the maintenance program user interface in an online mode. | ||
| MP_ALLOW_WO_GEN_ONLINE | VARCHAR2 | 1 | Flag that controls whether the work order generation program can be submitted from the maintenance program user interface in an online mode. | ||
| MP_ADJ_FCAST_WITH_LAST_COMPL | VARCHAR2 | 1 | Flag that controls whether forecast should be adjusted to a future date based on the last completion option. | ||
| ORG_REL_CONSIDERED_AT_WO_FLAG | VARCHAR2 | 1 | Flag that controls whether the org relationship based checks are applied during the work order creation process. | ||
| DFLT_MASTER_ORGANIZATION_ID | NUMBER | 18 | The default master inventory organization used in the various maintenance processes. | ||
| CA_VLD_ORGANIZATION_ID | NUMBER | 18 | The inventory organization used to validate items in the creation of customer assets. | ||
| USE_RESOURCE_QUAL_FLAG | VARCHAR2 | 1 | Flag indicating whether qualified resources are to be considered in the execution of the work. | ||
| USE_RESOURCE_INST_FLAG | VARCHAR2 | 1 | Flag indicating whether qualified resource instances are to be considered in the execution of the work. | ||
| IOT_INTEGRATION_FLAG | VARCHAR2 | 1 | Yes | Flag indicating whether the integration to the IoT Asset Monitoring Application is enabled or not. | |
| IOT_CONFIDENCE_THRESHOLD | NUMBER | The confidence threshold with which we should consider recommendations from IoT Analytics as valid. Any recommendations below this value will be automatically rejected. | |||
| IOT_ASSET_API | VARCHAR2 | 240 | The specific asset api string to be appended to the URL to construct the complete url for making an interaction with IoT asset monitoring application. | ||
| IOT_EVENT_CODE_API | VARCHAR2 | 240 | The specific event code api string to be appended to the URL to construct the complete url for making an interaction with IoT asset monitoring application. | ||
| IOT_LEARNING_DIRECTOR_API | VARCHAR2 | 240 | The specific learning director api string to be appended to the URL to construct the complete url for making an interaction with IoT asset monitoring application. | ||
| IOT_INCIDENT_API | VARCHAR2 | 240 | The IoT incident api string to be appended to the URL to construct the complete url for making an interaction with IoT asset monitoring application. | ||
| FA_AT_RECEIPT_CUT_OFF_DATE | TIMESTAMP | The cut off date to be used when the feature to create fixed assets at receipt is turned on for expense items. | |||
| FA_AT_RECEIPT_INV_CUT_OFF_DATE | TIMESTAMP | The cut off date to be used when the feature to create fixed assets at receipt is turned on for inventory items. | |||
| USE_PS_FOR_SCHED_AND_ASSIGN | VARCHAR2 | 1 | Flag that controls whether fusion production scheduler is to be used in the scheduling and assignment program. | ||
| DFLT_ASSET_ITEM_CAT_FOR_PS | NUMBER | 18 | The catalog category that is to be used as default for asset items in production scheduler, from the scheduling and assignment program. | ||
| DFLT_COMP_ITEM_CAT_FOR_PS | NUMBER | 18 | The catalog category that is to be used as default for component items in production scheduler, from the scheduling and assignment program. | ||
| DFLT_HORIZON_IN_DAYS_FOR_PS | NUMBER | The number of days to be used as horizon in the production scheduling and assignment program. This would be defaulted in the program and user can override that in the program. | |||
| MAX_LAB_INST_CAP_FOR_ASSIGN | NUMBER | The assumed labor instance capacity that is to be used when auto assignment is performed by the assignment program. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| EXTN_ATTRIBUTE_CHAR001 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR002 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR003 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR004 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR005 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR006 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR007 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR008 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR009 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR010 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR011 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR012 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR013 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR014 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR015 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR016 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR017 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR018 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR019 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR020 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR021 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR022 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR023 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR024 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR025 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR026 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR027 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR028 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR029 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR030 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR031 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR032 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR033 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR034 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR035 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR036 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR037 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR038 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR039 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR040 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR041 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR042 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR043 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR044 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR045 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR046 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR047 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR048 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR049 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR050 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR051 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR052 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR053 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR054 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR055 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR056 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR057 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR058 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR059 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR060 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR061 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR062 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR063 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR064 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR065 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR066 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR067 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR068 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR069 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR070 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR071 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR072 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR073 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR074 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR075 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR076 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR077 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR078 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR079 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR080 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR081 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR082 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR083 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR084 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR085 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR086 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR087 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR088 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR089 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR090 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR091 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR092 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR093 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR094 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR095 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR096 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR097 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR098 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR099 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_CHAR100 | VARCHAR2 | 1500 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB001 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB002 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB003 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB004 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_CLOB005 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | currency code for the extensibility | ||
| CORP_CURRENCY_CODE | VARCHAR2 | 15 | corporate currency code for extensibility | ||
| CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | currency conversion rate type for extensibility | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| 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 |
|---|---|---|---|
| CSE_SYSTEM_OPTIONS_U01 | Unique | Default | SYSTEM_OPTION_ID |