INVOICE_AGGREGATE_LINES
Groups
INVOICE_AGGREGATE_LINES
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|---|
1 | ID | NUMBER | 22 | N | Â | Â |
2 | INVOICE_ID | NUMBER | 22 | Y | Â | Â |
3 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Â | Â |
4 | CALLER | VARCHAR2 | 20 | Y | Â | Â |
5 | SORT_SEQUENCE | NUMBER | 22 | Y | Â | Â |
6 | INVOICE_LEVEL | NUMBER | 22 | Y | Â | Â |
7 | DESCRIPTION | VARCHAR2 | 100 | Y | Â | Â |
8 | NBR_OF_CALLS | NUMBER | 22 | Y | Â | Â |
9 | TOTAL_TIME | NUMBER | 22 | Y | Â | Â |
10 | EX_VAT | NUMBER | 22 | Y | Â | Â |
11 | VAT | NUMBER | 22 | Y | Â | Â |
12 | TOTAL_NO_VAT | NUMBER | 22 | Y | Â | Â |
13 | USAGE_TYPE | VARCHAR2 | 10 | Y | Â | Â |
14 | CHARGE_ITEM_ID | NUMBER | 22 | Y | Â | Â |
15 | CATEGORY | VARCHAR2 | 20 | Y | Â | Â |
16 | VAT_METHOD_NAME | VARCHAR2 | 80 | Y | Â | Â |
17 | BONUS | NUMBER | 22 | Y | Â | Â |
18 | BONUS_VAT | NUMBER | 22 | Y | Â | Â |
19 | CHARGED_UNITS | NUMBER | 22 | Y | Â | Â |
20 | CHARGED_UNIT_TYPE | VARCHAR2 | 60 | Y | Â | Â |