Table | Name | Description |
D1_DYN_OPT_USG_GRP* | Dynamic Option Usage Group | This table is used to define relationships between a Dynamic Option and a Usage Calculation Group. When used with Oracle Utilities Digital Asset Cloud Service this is used to define relationships between Programs and Event Settlement Calculation Groups related to the Customer Settlement feature introduced in release 23B. |
Table_Name | Index_Name |
D1_DYN_OPT_USG_GRP* | D1M652P0 |
Table_Name | Column_Name | Data Type | Data Length |
D1_DYN_OPT_EVENT* | DYN_OPT_EXT_EVT_ID_VALUE | VARCHAR2 | 120 |
D1_SP* | D1_SERVICE_AREA_CD | VARCHAR2 | 30 |
D1_USAGE* | EVT_SETT_REQ_TYPE_FLG | CHAR | 4 |
D1_USAGE_PERIOD_SQ* | D1_AMOUNT | NUMBER | 15,2 |
D1_USAGE_PERIOD_SQ* | DYN_OPT_EVENT_ID | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | D1_QUANTITY1 | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | D1_QUANTITY2 | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | D1_QUANTITY3 | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | D1_QUANTITY4 | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | D1_QUANTITY5 | CHAR | 14 |
D1_USAGE_PERIOD_SQ* | LINE_DESCR | VARCHAR2 | 254 |
D1_USAGE_PERIOD_SQ* | D1_CURRENCY_CD | CHAR | 3 |
D1_USAGE_PERIOD_SQ* | DYN_OPT_ID | CHAR | 12 |
D1_USAGE_PERIOD_SQ_DATA* | D1_PRICE | NUMBER | 19,8 |
D1_USAGE_PERIOD_SQ_DATA* | D1_AMOUNT | NUMBER | 15,2 |
D1_USG_RULE_L* | LINE_DESCR | VARCHAR2 | 254 |
D1_US_TYPE* | EVT_SETT_BO_CD | CHAR | 30 |
Table_Name | Column_Name | Old Length | New Length |
D1_USAGE_SCALAR_DTL | USE_PERCENT | NUMBER(3,0) | NUMBER(9,6) |
D1_US_SP | USE_PERCENT | NUMBER(3,0) | NUMBER(9,6) |