GENERIC_ORDER_LINE
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 |
All Sales Order Lines