Groups
PRODUCT_OPTION_PARAMETER
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N |
| |
| 2 | NAME | VARCHAR2 | 256 | Y |
| |
| 3 | LABEL | VARCHAR2 | 256 | Y |
| |
| 4 | TYPE_ID | NUMBER | 22 | Y |
| |
| 5 | PRODUCT_OPTION_ID | NUMBER | 22 | Y |
| |
| 6 | PARAMETER_TYPE | VARCHAR2 | 10 | Y |
| |
| 7 | PARAMETER_CODE | VARCHAR2 | 50 | Y |
| |
| 8 | DEFAULT_VALUE | VARCHAR2 | 220 | Y |
| |
| 9 | STATUS_ID | NUMBER | 22 | Y |
| |
| 10 | TAG | VARCHAR2 | 20 | Y |
| |
| 11 | VALIDATION_RUTINE_ID | NUMBER | 22 | Y |
| |
| 12 | PARAMETER_KEY | VARCHAR2 | 25 | Y |
| |
| 13 | DEFAULT_VALUE_METHOD | VARCHAR2 | 50 | Y |
| |
| 14 | VALIDATION_METHOD | VARCHAR2 | 50 | Y |
| |
| 15 | COMPLETE_IT_METHOD | VARCHAR2 | 100 | Y |
| |
| 16 | PARAMETERS | VARCHAR2 | 300 | Y |
|