Groups
GENERIC_ORDER_LINE
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments | |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | GENERIC_ORDER_ID | NUMBER | 22 | N | Reference to GENERIC_ORDER | |
| 3 | STATUS_ID | NUMBER | 22 | N | ||
| 4 | ORDER_LINE_NUMBER | VARCHAR2 | 80 | N | ||
| 5 | TYPE | VARCHAR2 | 80 | N | ||
| 6 | PRODUCT_NUMBER | VARCHAR2 | 200 | N | ||
| 7 | DESCRIPTION | VARCHAR2 | 400 | N | ||
| 8 | PARAMETERS | VARCHAR2 | 2000 | Y | ||
| 9 | TOTAL_EXCL_VAT | NUMBER | 22 | N | ||
| 10 | TOTAL_VAT | NUMBER | 22 | N | ||
| 11 | RESPONSE_PARAMETERS | VARCHAR2 | 2000 | Y | ||
| 12 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION | |
| 13 | WORKFLOW_ID | NUMBER | 22 | Y | Reference to WF_WORKFLOW | |
| 14 | CA_EXTERNAL_REF | VARCHAR2 | 400 | Y |